Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQLGetTypeInfo() bug [ODBC210] #193

Closed
firebird-automations opened this issue Aug 29, 2018 · 3 comments
Closed

SQLGetTypeInfo() bug [ODBC210] #193

firebird-automations opened this issue Aug 29, 2018 · 3 comments
Assignees
@alexpotapchenko
Labels
affect-version: 2.0.5 fix-version: 2.0.6 priority: major resolution: wontfix type: bug

Comments

@firebird-automations
Copy link

Submitted by: Greg Wittmeyer (gammad)

SQLGetTypeInfo() returns incorrect information for date, time, and timestamp columns. The incorrect information is in columns 4 and 5, the literal prefix and literal suffix. For example, it says for dates, the literal prefix is "{d'" and the literal suffix is "'}". In fact, both should be a single tick mark. If a program obeyed this information, it would produce a date literal like this:

UPDATE foo SET my_date={d'2018-08-28'} WHERE tid=1

which results in a syntax error. The correct syntax is:

UPDATE foo SET my_date='2018-08-28' WHERE tid=1
@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

If SQL_ATTR_NOSCAN = SQL_NOSCAN_OFF then UPDATE foo SET my_date={d'2018-08-28'} WHERE tid=1is the correct syntax.

Example for Employee.fdb with ODBC Log:

IBExpert 184-99c ENTER SQLPrepare
HSTMT 0x02A13470
UCHAR * 0x042ADD68 [ -3] "UPDATE SALES SET date_needed ={d'2019-08-28'} WHERE PO_NUMBER = 'V91E0210'\ d\ a\ 0"
SDWORD -3

IBExpert 184-99c EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 0x02A13470
UCHAR * 0x042ADD68 [ -3] "UPDATE SALES SET date_needed ={d'2019-08-28'} WHERE PO_NUMBER = 'V91E0210'\ d\ a\ 0"
SDWORD -3

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

Fix Version: 2.0.6 [ 10851 ]

@firebird-automations
Copy link
Author

Commented by: Greg Wittmeyer (gammad)

{d'2018-08-28'} works with SQL_NOSCAN_OFF because that is the escape format, and the ODBC driver translates it. SQLGetTypeInfo() should advertise what firebird expects natively, not the escape format.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@alexpotapchenko alexpotapchenko

Labels
affect-version: 2.0.5 fix-version: 2.0.6 priority: major resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alexpotapchenko @firebird-automations