with HSQLDB (version 220.127.116.11) as Database:
CREATE TABLE test (nr NUMERIC);
CREATE TABLE test (nr DECIMAL);
INSERT INTO test (nr) VALUES (2.4);
SELECT * FROM test;
will show a wrong result: 2
=> The scale seems to be lost.
Selecting it with a little Java program (Connection,
Statement, ResultSet...) will end up in the correct
result: 2.4 as BigDecimal (HSQLDB data type NUMERIC and
DECIMAL map to BigDecimal).
The database script file shows the correct value: 2.4
So, I think, it's a bug in SQuirreL SQL Client!?!
I would appreciate a bugfix in 2.3 final.
Thank you very much for that great JDBC-Client!