Table with column names Min and Max

Report PGNP bugs.

Table with column names Min and Max

Postby paulsk » Wed Apr 15, 2009 4:52 am

PGNP32-1.2.8.1110

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.
paulsk
 
Posts: 8
Joined: Wed Apr 15, 2009 4:42 am

Re: Table with column names Min and Max

Postby Moderator » Wed Apr 15, 2009 9:23 am

Thank you for letting us know about the bug. We'll try to fix it and let you know.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Table with column names Min and Max

Postby Moderator » Sun May 03, 2009 11:46 pm

The defect is fixed in build 1120.
Here are the links to installation modules:
http://www.pgoledb.com/downloads/PGNP32-1.2.8.1120.exe (32-bit)
http://www.pgoledb.com/downloads/PGNP64-1.2.8.1120.exe (64-bit)

Let us know if you will have any questions.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest