Error when using quoted column names in MySQL

peolsson · Post by **peolsson** » Fri 13 Jan 2012 15:03

Hello, I've been using UniDAC for quite some time, and I think I've found a problem in the latest UniDAC version.

Sometimes I use quoting around column names, since I sometimes need to quote a column name that is a reserved word (this is a problem due to converting från MySQL -> PostgreSQL).

Anyway, in version 4.1.4 this doesn't seem to work for the MySQL provider.

Example - this used to work:

UPDATE table_x SET "end" = CURRENT_TIMESTAMP WHERE id = 1;

This still works for the PostgreSQL provider, but not anymore for MySQL - instead an error of bad syntax i raised. Is this a bug, or is there a setting that must be enabled in later versions?

In the 3.70.0.17 version this worked, but not anymore in 4.1.4.

I'm using Delphi 2006.

/Peter

AndreyZ · Post by **AndreyZ** » Mon 16 Jan 2012 15:23

Hello,

Thank you for the information. We have reproduced and fixed this problem. This fix will be included in the next UniDAC build.

peolsson · Post by **peolsson** » Mon 16 Jan 2012 17:12

Thanks for the reply. Is it possible to get a source diff for the fix, so I cen get it implemented right now? I do have UniDAC with source, so I would appreciate if this is possible.

/Peter

AndreyZ · Post by **AndreyZ** » Tue 17 Jan 2012 10:59

Please send me an email to andreyz*devart*com with your UniDAC license number. I will send you source files with needed corrections.