odbc driver compliance: NULL strings or "" in SQLTables and SQLColumns API calls
Stata fixed how they will talk to the MonetDB driver in the future, but they say the MonetDB driver is less standard, so perhaps we should be aware of this:
We were passing a NULL string to the ODBC
api call SQLTables and SQLColumns where the MonetDB driver wants an empty string (""). Some other drivers need a NULL string passed in to work (Oracle being one) so I believe this is a driver bug, but I have patched the problem in Stata. I have added code in -odbc- to check for the MonetDB driver and pass an empty string in that case.
Could you please submit a bug report at bugs.monetdb.org? Then we won't forget.
On 2014-06-17 15:57, László Sándor wrote:
Stata fixed how they will talk to the MonetDB driver in the future, but they say the MonetDB driver is less standard, so perhaps we should be aware of this:
We were passing a NULL string to the ODBC api call SQLTables and SQLColumns where the MonetDB driver wants an empty string (""). Some other drivers need a NULL string passed in to work (Oracle being one) so I believe this is a driver bug, but I have patched the problem in Stata. I have added code in -odbc- to check for the MonetDB driver and pass an empty string in that case.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
László Sándor -
Sjoerd Mullender