Listing a table contents generates queries without quoting the fields. Not really a problem until you hit a table with a field named with a reserved word. Yeah, really daft, but there y'go.
My system is MySQL under Linux (Fedora 18).
I couldn't see a way to create a ticket for this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Listing a table contents generates queries without quoting the fields. Not really a problem until you hit a table with a field named with a reserved word. Yeah, really daft, but there y'go.
My system is MySQL under Linux (Fedora 18).
I couldn't see a way to create a ticket for this.
Ok, I now see the configuration setting for quoting fields.
I, too, hate all those back ticks in queries, but surely it shouldn't be allowed to generate illegal SQL?
there are really few cases where quoting fields is mandatory. I prefer not to quote by default, but just when needed.
Regards
PAscal