C:\Program Files\MySQL\MySQL Server 5.0\data\.log: ################################################################ C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe, Version: 5.0.45-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument 071116 12:57:27 1 Connect root@localhost on dt4ed 1 Query SET SQL_AUTO_IS_NULL = 0 1 Query DROP TABLE IF EXISTS t 1 Query CREATE TABLE t ( Path NVARCHAR(256) ) 1 Query SELECT DISTINCT Path FROM t WHERE Upper(Path) = Upper('\\') 1 Quit C:\Temp\SQL.log (ODBC Trace): ############################# q7 c0-b18 ENTER SQLAllocHandle SQLSMALLINT 1 SQLHANDLE 00000000 SQLHANDLE * 0012FB44 q7 c0-b18 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 00000000 SQLHANDLE * 0x0012FB44 ( 0x003c1788) q7 c0-b18 ENTER SQLSetEnvAttr SQLHENV 003C1788 SQLINTEGER 200 SQLPOINTER 0x00000003 SQLINTEGER -6 q7 c0-b18 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 003C1788 SQLINTEGER 200 SQLPOINTER 0x00000003 (BADMEM) SQLINTEGER -6 q7 c0-b18 ENTER SQLAllocHandle SQLSMALLINT 2 SQLHANDLE 003C1788 SQLHANDLE * 0012FB40 q7 c0-b18 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 003C1788 SQLHANDLE * 0x0012FB40 ( 0x003c1830) q7 c0-b18 ENTER SQLSetConnectAttrW SQLHDBC 003C1830 SQLINTEGER 103 SQLPOINTER 0x00000005 SQLINTEGER 0 q7 c0-b18 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 003C1830 SQLINTEGER 103 SQLPOINTER 0x00000005 (BADMEM) SQLINTEGER 0 q7 c0-b18 ENTER SQLSetConnectAttrW SQLHDBC 003C1830 SQLINTEGER 113 SQLPOINTER 0x00000005 SQLINTEGER 0 q7 c0-b18 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 003C1830 SQLINTEGER 113 SQLPOINTER 0x00000005 (BADMEM) SQLINTEGER 0 q7 c0-b18 ENTER SQLDriverConnectW HDBC 003C1830 HWND 00000000 WCHAR * 0x74329A38 [ -3] "******\ 0" SWORD -3 WCHAR * 0x74329A38 SWORD 2 SWORD * 0x00000000 UWORD 0 q7 c0-b18 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 003C1830 HWND 00000000 WCHAR * 0x74329A38 [ -3] "******\ 0" SWORD -3 WCHAR * 0x74329A38 SWORD 2 SWORD * 0x00000000 UWORD 0 q7 c0-b18 ENTER SQLAllocHandle SQLSMALLINT 3 SQLHANDLE 003C1830 SQLHANDLE * 0012FB3C q7 c0-b18 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 003C1830 SQLHANDLE * 0x0012FB3C ( 0x003c1d08) q7 c0-b18 ENTER SQLExecDirectW HSTMT 003C1D08 WCHAR * 0x00403210 [ -3] "DROP TABLE IF EXISTS t\ 0" SDWORD -3 q7 c0-b18 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS) HSTMT 003C1D08 WCHAR * 0x00403210 [ -3] "DROP TABLE IF EXISTS t\ 0" SDWORD -3 q7 c0-b18 ENTER SQLExecDirectW HSTMT 003C1D08 WCHAR * 0x00403240 [ -3] "CREATE TABLE t ( Path NVARCHAR(256) )\ 0" SDWORD -3 q7 c0-b18 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS) HSTMT 003C1D08 WCHAR * 0x00403240 [ -3] "CREATE TABLE t ( Path NVARCHAR(256) )\ 0" SDWORD -3 q7 c0-b18 ENTER SQLFreeStmt HSTMT 003C1D08 UWORD 1 q7 c0-b18 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 003C1D08 UWORD 1 q7 c0-b18 ENTER SQLAllocHandle SQLSMALLINT 3 SQLHANDLE 003C1830 SQLHANDLE * 0012FB3C q7 c0-b18 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 003C1830 SQLHANDLE * 0x0012FB3C ( 0x003c1d08) q7 c0-b18 ENTER SQLBindParameter HSTMT 003C1D08 UWORD 1 SWORD 1 SWORD -8 SWORD 12 SQLULEN 256 SWORD 0 PTR 0x0040328C SQLLEN 1 SQLLEN * 0x0012FB48 q7 c0-b18 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS) HSTMT 003C1D08 UWORD 1 SWORD 1 SWORD -8 SWORD 12 SQLULEN 256 SWORD 0 PTR 0x0040328C SQLLEN 1 SQLLEN * 0x0012FB48 (-3) q7 c0-b18 ENTER SQLExecDirectW HSTMT 003C1D08 WCHAR * 0x00403290 [ -3] "SELECT DISTINCT Path FROM t WHERE Upper(Path) = Upper(?)\ 0" SDWORD -3 q7 c0-b18 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 003C1D08 WCHAR * 0x00403290 [ -3] "SELECT DISTINCT Path FROM t WHERE Upper(Path) = Upper(?)\ 0" SDWORD -3 q7 c0-b18 ENTER SQLFreeStmt HSTMT 003C1D08 UWORD 1 q7 c0-b18 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 003C1D08 UWORD 1 q7 c0-b18 ENTER SQLEndTran SQLSMALLINT 2 SQLHANDLE 003C1830 SQLSMALLINT 0 q7 c0-b18 EXIT SQLEndTran with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 003C1830 SQLSMALLINT 0 q7 c0-b18 ENTER SQLDisconnect HDBC 003C1830 q7 c0-b18 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 003C1830 q7 c0-b18 ENTER SQLFreeHandle SQLSMALLINT 2 SQLHANDLE 003C1830 q7 c0-b18 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 003C1830 q7 c0-b18 ENTER SQLEndTran SQLSMALLINT 1 SQLHANDLE 003C1788 SQLSMALLINT 0 q7 c0-b18 EXIT SQLEndTran with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 003C1788 SQLSMALLINT 0 q7 c0-b18 ENTER SQLFreeHandle SQLSMALLINT 1 SQLHANDLE 003C1788 q7 c0-b18 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 003C1788