Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
ODBC GetSchema( "Views ") bug with Views

ODBC GetSchema( "Views ") bug with Views

2007-04-28       - By Sebastian Talamoni

 Back
Reply:     1     2     3  

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/myodbc?unsub=mysql@(protected)