STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?

[Laurence Sanford]

Jarosław Staniek wrote:
> Drew Sanford said the following, On 2007-05-14 20:42:
>> Jarosław Staniek wrote:
>>> Drew said the following, On 2007-05-14 14:52:
>>>> As promised, I'm attaching a database I just threw together. It 
>>>> only has
>>>> four entries, and one query, but clearly the query should list 
>>>> everything in
>>>> table1.
>>>
>>> SELECT * FROM table1 ORDER BY "key"
>>>                                ^^^^
>>>
>>> A quick note: "key" is reservered word in sql and kexi cannot deal 
>>> with it yet properly by adding "" or by displayng appropriate warning.
>>>
>>> Could you change the column name to something neutral and try again 
>>> and let me know?
>>>
>>
>> Sorry. There's a new table called table11 in there with basically the 
>> same data.
>
> There is _still_ a column called "key" in table11 you have sent me. 
> Remove the column and our query should work.
>
> Also queries that do not use the column work with table11, e.g.:
>
> SELECT vacation, users, date, vacation, id FROM table11 ORDER BY id;
>
I see where this is going. Actually, in the original db that I created, 
there is no conflict with "key" rather it appears to be start. However, 
I can specify that and get (correct) output from the queries. It looks 
like the problem is related specifically to using * in the select 
statement. Kexi keeps dropping the *.