ODBC GetSchema("Views") bug with Views
Sebastian Talamoni <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Hallo,
I hope this is the correct place to explain a problem with the odbc
driver. If it's not please apologize.
Applies to : ODBC 5.00.11 (latest from website) and 3.54.14 shows same
behaviour.
Server version : 5.0.22
Having an odbc connection with catalog/database set to a specific
database when executing this commands :
_connection.GetSchema("Tables") --> returns tables + views (should have
been only tables)
If this was expected behaviour it would have been handy that
"TABLE_TYPE" could be set as view.. (currently set as TABLE)
_connection.GetSchema("Views") --> returns null.
ODBC TRACE (just partial...)
When requesting VIEW ( _connection.GetSchema("Tables") ) --> 15 are
returned instead of 14 (1 is a view)
----------------------------------------------------------------
GenWise.IDE.vsh d44-1574 ENTER SQLTablesW
HSTMT 009FFCA0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x017691E4 [ 18] "TABLE,SYSTEM TABLE"
SWORD 18
GenWise.IDE.vsh d44-1574 EXIT SQLTablesW with return code 0
(SQL_SUCCESS)
HSTMT 009FFCA0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x017691E4 [ 18] "TABLE,SYSTEM TABLE"
SWORD 18
GenWise.IDE.vsh d44-1574 ENTER SQLRowCount
HSTMT 009FFCA0
SQLLEN * 0x0F0DE694
GenWise.IDE.vsh d44-1574 EXIT SQLRowCount with return code 0
(SQL_SUCCESS)
HSTMT 009FFCA0
* SQLLEN * 0x0F0DE694 (15)*
When requesting VIEW ( _connection.GetSchema("Views") )
----------------------------------------------------------------
GenWise.IDE.vsh d44-1574 ENTER SQLTablesW
HSTMT 009FFCA0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x0176921C [ 4] "VIEW"
SWORD 4
GenWise.IDE.vsh d44-1574 EXIT SQLTablesW with return code 0
(SQL_SUCCESS)
HSTMT 009FFCA0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x0176921C [ 4] "VIEW"
SWORD 4
GenWise.IDE.vsh d44-1574 ENTER SQLRowCount
HSTMT 009FFCA0
SQLLEN * 0x0F0DE694
GenWise.IDE.vsh d44-1574 EXIT SQLRowCount with return code 0
(SQL_SUCCESS)
HSTMT 009FFCA0
Is this a known bug ? (could not find it..)
NOTE: When INFORMATION_SCHEMA (at the server ) shows correct / expected
result
SELECT * FROM information_schema.VIEWS V;
Thanks in advance,
---------------------------------------
Sebastian Talamoni
GenWise Team
(www.genwise.com)
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/[email protected]