Bugs item #1123625, was opened at 2005-02-15 21:30
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=629040&aid=1123625&group_id=101095
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: John Goerzen (jgoerzen)
Assigned to: Nobody/Anonymous (nobody)
Summary: Multiple errors generating SELECT
Initial Comment:
I am using HSQL ODBC backend.
First, the space before FROM is sometimes omitted:
eu_mod_userid,eu_mod_dateFROM eu_mstr as T1
This query generated with:
do t <- table eu_mstr
return t
Second, space before WHERE is also omitted at times:
teFROM eu_mstr as T1WHERE (eu_cm_nbr = 'xxxxxx')
This query generated with:
do t <- table eu_mstr
restrict (t!eu_cm_nbr .==. constJust dealer)
return t
Third, sorting causes invalid column names to be selected:
SELECT DISTINCT eu_addr1 as eu_addr,eu_rsb1 as eu_rsb,
....
There is no eu_addr1 column; eu_addr only.
This query generated by:
do t <- table eu_mstr
restrict (t!eu_cm_nbr .==. constJust dealer)
order [asc t eu_sort]
return t
All SQL dumps were obtained using the database's own
logging facility, which captures exactly the text sent
to it.
Finally, if I add a project statement to the end of all
of this, to reduce server load and gather only the
columns I want, it makes no difference to the generated
query; it still does the eu_addr1 thing and selects all
of the several dozen columns in the table. I only care
about 2.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=629040&aid=1123625&group_id=101095
|
