Bug #11968 Selecting records from a non current schema does not work through ODBC 3.51
Submitted: 15 Jul 2005 14:00 Modified: 28 Jul 2005 11:54
Reporter: Castor Byrd Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:4.1 OS:Windows (XP Prof.)
Assigned to: CPU Architecture:Any

[15 Jul 2005 14:00] Castor Byrd
Description:
I am using Visual Foxpro 7 as a front end and has tried to SELECT records from a non current Schema and a get blank record set.  I am using the ODBC 3.51 driver for connection.

Here is the line:

? SQLEXEC(nConnectionHandle,"SELECT * FROM `NotCurrentDB`.`mytable`")

How to repeat:
Create two schemas in Mysql.  Through Visual Foxpro 7 make one current with

? SQLEXEC(nConnectionHandle,"USE db1")
?SQLEXEC(nConnectionHandle,"SELECT * FROM `db2`.`mytable`")
[16 Jul 2005 8:02] Vasily Kishkin
Could you please write here table definitions and simple test case on c ?
[27 Jul 2005 9:16] Vasily Kishkin
Could you please write here table definition and some data ? I want to reproduce the bug from "C" test case.
[28 Jul 2005 11:54] Vasily Kishkin
I created and tested your example on c test case and found that myODBC works right. I guess You have problem with Visual FoxPro. Sorry. I attached my test case.
[28 Jul 2005 11:55] Vasily Kishkin
Test case

Attachment: test.c (text/plain), 4.43 KiB.