Bug #888 Uknown column

• Submitted: 22 Jul 2003 7:27
• Modified: 23 Jul 2003 7:03
• Reporter: Martin Habr
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: about 3.15. or smthing
• OS: Windows (winxp)
• CPU Architecture: Any

[22 Jul 2003 7:27] Martin Habr

Description:
Unknown table column. Im using Delphi6 with komponents from Zeos
If tehre exists a table with kolumns like kontakt_jmeno or kontakt_prijmeni
(contact_firstname, product_lastname) the database told "unknow culumn kontakt_prijeni

select id,kontakt_prijmeni from ....

How to repeat:
select id,kontakt_prijmeni from ....

error unknown column when using mysqllib.dll under winxp

select id,kontakt_prijmeni as kontakt_prijmeni from ....

result data

dunno if it is mysql problem, or mysqlib problem or zeos component problem

Suggested fix:
select id,kontakt_prijmeni from ....

data.....

[23 Jul 2003 7:03] MySQL Verification Team

Not enough information, please verify the syntax applied and
how is handled by the Zeos component, if you are able for
to debug it send us the string send for the server.
On another hand our library is libmysql.dll.