MySQL version problem: "Partition" is now reserved

[Rhys Lewis]

From version 5.6 of MySQL the word "Partition" is a reserved word - see here: http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html compared to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

Unfortunately the table t_xref has a column called "Partition", so whenever you interact with a diagram in a model that is hosted on a MySQL database that is version 5.6 you will get an SQL error as it doesn't recognise Partition as a column name unless it is quoted.

Any chance you could go through and quote all those SQL statements?

[Geert Bellekens]

I hope you've sent this to Sparx as well, because we (EA - users) can't help you much with this.
You can use the Report a buglinks on the bottom of the page.


Geert

[Paolo F Cantoni]

There's PILE of columns in various tables that will break some database technologies.

I recall trying to setup EA many years ago for an unsupported RDBMS  and being shocked at the number of column names that were reserved words.

Paolo

[g.makulik]

Maybe this could be solved with a MySQL adapted database scheme and an 'alias' for the particular column names (calling in qwerty ...)?

Just my 0.02 EUR,
Günther

[qwerty]

Unfortunately I'm not a DBA, so I'm out

q.

[Rhys Lewis]

I emailed it to Sparx yesterday, so I assume they are looking at it.

The workaround is to use version 5.5 or below.

[Ian Mitchell]

This is also a problem for me. Any chance of Sparx looking at this?
I thought that the Sparx devs mostly use MySQL: how are they managing this ?
There should at least be a warning in BIG LETTERS that more recent versions of mySQL are not supported by EA. I wasted a day discovering this....

[Eve]

We were made aware of this problem recently and have support for 5.6 in the works and it will be included in a future version.

In the mean time I would recommend using 5.5 or below.