This bug is related to #1183:
Empty Contents Tab in SQuirreL when Column-Names contain dashes.
I retested this against SQuirreL Snapshot Release SQL Client snapshot-20150623_2101
Running the following test-case against a HSQL-DB now works as expected:
Execute the following SQL-Statements in the SQL-Window:
create table test ( "test-1" char(10) )
insert into test values ('1111111111')
Examine the contents of the table test in the object-browser -> contents-tab.
The value 1111111111 is shown.
However: Running the same test-case against a H2-DB does not work properly.
The following SQL-Statements work fine:
create table test ( "test-1" char(10) )
insert into test values ('1111111111')
However: object-browser -> contents-tab shows an empty panel.
The feature surrounding all table-names with non-standard characters by double quotes should be used for all databases, not just for HSQL-DB.
IMHO: SQL-Standard says something like: Identifiers must consist of a special set of characters (_ <underscore> for example belongs to it. - <dash> not). However, you can use non standard characters, if you surround the identifier by "". In this case it is database-vendor dependend which additional characters are actually supported.</dash></underscore>
We would appreciate this bug resolved at least in HSQL, H2, DB2 and Oracle.
Thanks a lot,
Thomas
Is fixed in our Git repository. WIll be available in future snapshots and versions.