[mdb-dev] [ mdbtools-Bugs-1463036 ] mdb-sql treats columns case sensitive

[SourceForge.net <no...@so...>]

Bugs item #1463036, was opened at 2006-04-02 15:23
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1463036&group_id=2294

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: cmd line utils
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: micha137 (micha137)
Assigned to: Nobody/Anonymous (nobody)
Summary: mdb-sql treats columns case sensitive

Initial Comment:
I was desparate about mdb-sql returning emtpy records
for a selection of a column subset, but working
properly when selecting all columns using "*". It
turned out that it treats the column names case
sensitive. Say "table1" has two columns, "Column1" and
"Column2".

This didn't work:

SELECT column1 FROM table1

Resulted in empty records.

This worked:

SELECT * FROM table1

This is the corrected first query:

SELECT Column1 FROM table1

mdb-sql should either treat the column names as case
insensitive (I don't know what SQL says here) or report
an error like "column 'column1' does not exist". In no
case may it return empty records.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1463036&group_id=2294