Page 1 of 1

Bug with field named MIN or MAX

Posted: Tue 12 Feb 2008 12:43
by ricolebo
Hi,

I test the last version of the driver and I have found a bug.
I use Delphi 7 and firebird 2.1.

To reproduce it you must have a field named MIN in your table.

Command text is by example : select id,"MIN" from myTable;

On update the query is : update myTable set id = ? and min = ?
=> SQL error because MIN is not quoted and uppercase like that : "MIN"

This error doesn't exist with the standard Borland driver because all the fields are quoted

Note : The field become case sensitive when quoted

Thank you
Eric

Re: Bug with field named MIN or MAX

Posted: Tue 12 Feb 2008 13:19
by ricolebo
The better I can do in my case is to raname the field if you can't do anything.

Posted: Wed 13 Feb 2008 09:25
by Plash
In our tests the table cannot be updated also with the standard Borland driver. Please send to dbxida*crlab*com a complete small sample that demonstrates the situation when the standard driver woks and Core Lab driver does not, and include script to create database objects.

Posted: Wed 13 Feb 2008 10:16
by ricolebo
I have send a little project ...