#1041 NUMERIC column not generated properly

3.3.0
open
Core (462)
5
2012-12-29
2012-08-11
Roger Hill
No

On IBM AS400/iSeries/System i/IBM i - call it what you will - there is a distinction in the way a DECIMAL column is stored internally, and the way a NUMERIC column is stored. So although the external representation is the same (e.g. 12.34 is what would be displayed for either of a numeric(4,2) or a decimal(4,2) column) the internal representation, number of bytes used etc is different.

Squirrel at 3.3.0 generates the wrong 'Create table' entries for a NUMERIC column.

If I create my table:
CREATE TABLE sqtest
(
Goodcol decimal(12,5) DEFAULT 0 NOT NULL,
Badcol numeric (12,5) DEFAULT 0 NOT NULL
)
;

Then use Squirrel to generate a new create table script, I get:
CREATE TABLE SQTEST
(
GOODCOL decimal(12,5) DEFAULT 0 NOT NULL,
BADCOL bigint DEFAULT 0 NOT NULL
)
;

That is the NUMERIC column has been reported as BIGINT - definitely wrong!

I have tried this on I/OS versions 5.4, 6.1 and 7.1 - all are the same.

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks