|
From: John H. <jh...@im...> - 2015-02-26 21:17:42
|
On Thu, 26 Feb 2015, Thomas Lenarz wrote:
> The problem can be reproduced easily using the following steps (in my
> case with HSQL-DB):
>
> create table test ( "test-1" char(10) )
> insert into test values ('1111111111')
>
> SELECT test-1 FROM "PUBLIC"."TEST"; --> won't work (which is correct)
By "won't work" do you mean it displays a syntax error from the database
engine?
> SELECT "test-1" FROM "PUBLIC"."TEST" --> will work
>
> Contents-Tab stays empty.
By that do you mean no syntax error, the results tab is created, but
nothing is displayed in it?
> I consider this a bug in SQuirreL. It should double-quote columns
> containing invalid characters when generating
> the SELECT-Statement for the contents tab.
Squirrel isn't generating that SQL, it's sending what you typed in.
Expecting SQuirrel to add quotes you should have added isn't (IMO)
reasonable. What if you'd typed this:
create table test ( test int, "test-1" char(10) )
insert into test values (0, '1111111111')
SELECT test-1 FROM "PUBLIC"."TEST";
?
Can you trace and determine what SQL is actually being sent to the
database server?
--
John Hardin KA7OHZ http://www.impsec.org/~jhardin/
jh...@im... FALaholic #11174 pgpk -a jh...@im...
key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
The difference is that Unix has had thirty years of technical
types demanding basic functionality of it. And the Macintosh has
had fifteen years of interface fascist users shaping its progress.
Windows has the hairpin turns of the Microsoft marketing machine
and that's all. -- Red Drag Diva
-----------------------------------------------------------------------
8 days until Dawn reaches Ceres
|
