Bug #9946 HYT00:Unknown field '<table>' in field list" when leading spaces in query...
Submitted: 15 Apr 2005 23:39 Modified: 8 Mar 2007 1:08
Reporter: Kate Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.5.1 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[15 Apr 2005 23:39] Kate
Description:
This is similar to bug 6609, but is on Windows and is more serious as I am receiving an error.

The problem occurs When I set MaxNRows and then  perform a query with a leading space.  Please see bug 6609 for repro steps.

I recieve the following error:
HYT00:Unknown field '<table>' in field list" 

This is using 3.5.1 on Windows.  I was able to reproduce it using odbctest.

Thanks

How to repeat:
See bug 6609

Suggested fix:
Trim leading spaces?
[16 Apr 2005 0:38] Jorge del Conde
Verified w/3.5.11
[8 Mar 2007 1:08] Jim Winstead
This is a duplicate of Bug #6609, which will be fixed in 3.51.14.