SQL command completion / quoting of column names

[GoogleCodeExporter]

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. Use table with column names having spaces, e.g. from CSVread.
2. Enter Select * From <table> Where 
3. Column list pops up
4. select column name with space
5. Quotes are missing

What is the expected output? What do you see instead?
- column name with quotes

What version of the product are you using? On what operating system, file
system, and virtual machine?
- WinXP Pro SP 3
- Parallels 3 on Mac OS X 10.4
- H2 1.2.132 (2010-03-21)

Do you know a workaround?
- manual add quotes to SQL command

How important/urgent is the problem for you?
- minor

In your view, is this a defect or a feature request?
- defect

Please provide any additional information below.
- when adding a column name from the popup add something like:

String text = getPopupText();
if (isColumnName() && needsQuoting(text))
    text = quotedName(text);
addText(text);

Sincerely
Dirk

Original issue reported on code.google.com by Dirk.Zoe...@googlemail.com on 8 Apr 2010 at 9:06

[GoogleCodeExporter]

I will fix this in the next release.

Original comment by thomas.t...@gmail.com on 16 Apr 2010 at 6:38

• Changed state: Accepted

[GoogleCodeExporter]

Fixed in version 1.2.134

Original comment by thomas.t...@gmail.com on 23 Apr 2010 at 5:25

• Changed state: Fixed