Ticket 413

MySQL 5.6 adds the researched word "PARTITION".

http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

This causes a MySQL syntax error when the Slurm daemon attempts to create a field with the same name.

However, reserved words can be used as identifiers in MySQL as long as they are quoted properly (with backtick quotes) as described in the documentation.

http://dev.mysql.com/doc/refman/5.6/en/identifiers.html

I believe part of this behavior can be fixed in src/database/mysql_common.c in the function mysql_db_create_table. 

The following:

	while (fields && fields->name) {
xstrfmtcat(query, ", %s %s", fields->name, fields->options);
fields++;
i++;
}

Should probably change to this:

	while (fields && fields->name) {
xstrfmtcat(query, ", `%s` %s", fields->name, fields->options);
fields++;
i++;
}

However, I'm not sure if the bug is present in other forms in other places.