[Haskelldb-users] [ haskelldb-Bugs-1123625 ] Multiple errors generating SELECT

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

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