I have a table containing the column names 'Min' and 'Max' when these are defined in a SELECT statement then the driver seems to confuse them with the functions Min() and Max().
I have tried the following SQL incarnations but an SQL exception is still raised:
SELECT Min, Max FROM MyTable
SELECT MyTable.Min, MyTable.Max FROM MyTable
SELECT MyTable.Min as MinValue, MyTable.Max as MaxValue FROM MyTable
SELECT "Min", "Max" FROM MyTable
SELECT "MyTable.Min", "MyTable.Max" FROM MyTable
I accept that it was probably not a good idea to name these columns Min and Max, but I am attempting to use this driver on an existing database design so changing column names is not really an option. By using SELECT * FROM MyTable I can workaround it, but I just thought it was still worth informing you of a possibility of a bug with this version of the driver.