Informix

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Hmmm, that's an interesting problem.

This value looks like a serial or interger value that has wrapped.  I don't see how it could happen.

Are there perhaps in-place alters on the table?

------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Hi Mike, Thanks for the comment.
There were no in-place alters.

(oncheck -pT)
...
Version Count

0 (current) 191286


Maybe it's because the Informix version is 11.10.FC3W2?

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Fri November 26, 2021 01:03 PM
From: Mike Walker
Subject: decimal type data input error (-1226)

Hmmm, that's an interesting problem.

This value looks like a serial or interger value that has wrapped.  I don't see how it could happen.

Are there perhaps in-place alters on the table?

------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Your number of -21474840 looks very similar to -2^31 or -2147483648.  I think that this is how Informix represents a NULL value internally for a 32 bit integer, for example.  In the case of a decimal type I expect something similar.  So this value you see is related to a NULL I believe, although something is messed up obviously.

------------------------------
Gary McNair
------------------------------

Original Message:
Sent: Fri November 26, 2021 01:03 PM
From: Mike Walker
Subject: decimal type data input error (-1226)

Hmmm, that's an interesting problem.

This value looks like a serial or interger value that has wrapped.  I don't see how it could happen.

Are there perhaps in-place alters on the table?

------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

So you're saying you can select the row, and dbaccess can display it (as -21474840, which might just be what dbaccess makes of what's stored there)?

Could you dump the page containing the row using 'oncheck -pp <db>:<table> <rowid>' and attach here, together with a table schema?
(Get the rowid by adding rowid to your query's projection clause.)

One way of getting 'impossible' values into the database might be ODBC bulk inserts which, as far as I remember, bypass some of the data validation checks.

------------------------------
Andreas Legner
------------------------------

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

@Andreas
Yes, I can see the value -21474840.
Below are the oncheck -pp and dbschema information.
​​

$ dbaccess dbname -
> select rowid, power from stat_cm_qos_raw_800_202111291700 where power < -100;


      rowid     power

     730895 -21474840
     730896 -21474840
     730897 -21474840
     730898 -21474840
     730899 -21474840
     730900 -21474840
     730901 -21474840
     730902 -21474840

8 row(s) retrieved.

> select * from stat_cm_qos_raw_800_202111291700 where rowid = 730895;



gendatetime   202111291700
socode        800
tpo_cd        N01008
cmtsname      WB573011
cmtsid        172.23.0.80
cellno        5
slot          2/0/1
port          B
cm_mac        0002.0031.AE4B
cm_ip         10.92.119.245
ds_id         DS2
mod           QAM256
frequency     530
power         -21474840
snr           44.7
power_result  ****
snr_result    ****
sysuptime     46 days, 17 hours, 10 minutes, 44 seconds.


$ dbschema -d dbname -t stat_cm_qos_raw_800_202111291700

DBSCHEMA Schema Utility       INFORMIX-SQL Version 11.10.FC3W2





create table "hfc".stat_cm_qos_raw_800_202111291700
  (
    gendatetime char(12),
    socode char(3),
    tpo_cd char(6),
    cmtsname char(8),
    cmtsid varchar(15),
    cellno varchar(50),
    slot varchar(8),
    port varchar(4),
    cm_mac char(14),
    cm_ip char(14),
    ds_id char(4),
    mod varchar(10),
    frequency integer,
    power decimal(7,1),
    snr decimal(7,1),
    power_result varchar(10),
    snr_result varchar(10),
    sysuptime varchar(64)
  );



:informix>/informix]oncheck -p dbname:stat_cm_qos_raw_800_202111291700 730895
addr             stamp    chksum nslots flag type         frptr frcnt next     prev
38:1591020       -1708595576 3a72   24     801  DATA         3792  204   0        0
        slot ptr   len   flg
        1    24    157   0
        2    181   157   0
        3    338   157   0
        4    495   157   0
        5    652   157   0
        6    809   157   0
        7    966   157   0
        8    1123  157   0
        9    1280  157   0
        10   1437  157   0
        11   1594  157   0
        12   1751  157   0
        13   1908  157   0
        14   2065  157   0
        15   2222  157   0
        16   2379  157   0
        17   2536  157   0
        18   2693  157   0
        19   2850  157   0
        20   3007  157   0
        21   3164  157   0
        22   3321  157   0
        23   3478  157   0
        24   3635  157   0
slot   1:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 33 34  5 32 2f 30   2.23.0.80.34.2/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 41   /4.B0002.0031.AA
   64: 45 46 31 30 2e 39 32 2e 31 31 32 2e 31 33 32 20   EF10.92.112.132
   80: 44 53 31 20  6 51 41 4d 32 35 36  0  0  2 62 3e   DS1 .QAM256...b>
   96: 61 46  0  0 c1 2a 14  0  0  4 be e7 c8 a3  4 be   aF..A*....>gH#.>
  112: e7 c8 a3 29 39 30 20 64 61 79 73 2c 20 31 34 20   gH#)90 days, 14
  128: 68 6f 75 72 73 2c 20 34 39 20 6d 69 6e 75 74 65   hours, 49 minute
  144: 73 2c 20 37 20 73 65 63 6f 6e 64 73 2e            s, 7 seconds....
slot   2:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 31 39  5 31 2f 30   2.23.0.80.19.1/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43   /4.B0002.0031.AC
   64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20   9F10.92.118.59
   80: 44 53 32 20  6 51 41 4d 32 35 36  0  0  2 12 3f   DS2 .QAM256....?
   96: 28  0  0  0 c1 2a 28  0  0  4 be e7 c8 a3  4 be   (...A*(...>gH#.>
  112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20   gH#)25 days, 10
  128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73   hours, 3 minutes
  144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e            , 11 seconds....
slot   3:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 31 39  5 31 2f 30   2.23.0.80.19.1/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43   /4.B0002.0031.AC
   64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20   9F10.92.118.59
   80: 44 53 33 20  6 51 41 4d 32 35 36  0  0  2 1a 3f   DS3 .QAM256....?
   96:  a  0  0  0 c1 24 5a  0  0  4 be e7 c8 a3  4 be   ....A$Z...>gH#.>
  112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20   gH#)25 days, 10
  128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73   hours, 3 minutes
  144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e            , 11 seconds....
slot   4:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 31 39  5 31 2f 30   2.23.0.80.19.1/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43   /4.B0002.0031.AC
   64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20   9F10.92.118.59
   80: 44 53 34 20  6 51 41 4d 32 35 36  0  0  2 22 3f   DS4 .QAM256..."?
   96: 14  0  0  0 c1 2a 14  0  0  4 be e7 c8 a3  4 be   ....A*....>gH#.>
  112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20   gH#)25 days, 10
  128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73   hours, 3 minutes
  144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e            , 11 seconds....
slot   5:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 31 39  5 31 2f 30   2.23.0.80.19.1/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43   /4.B0002.0031.AC
   64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20   9F10.92.118.59
   80: 44 53 35 20  6 51 41 4d 32 35 36  0  0  2 e2 3e   DS5 .QAM256...b>
   96: 5e  0  0  0 c1 21  a  0  0  4 be e7 c8 a3  4 be   ^...A!....>gH#.>
  112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20   gH#)25 days, 10
  128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73   hours, 3 minutes
  144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e            , 11 seconds....
slot   6:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  2 31 39  5 31 2f 30   2.23.0.80.19.1/0
   48: 2f 34  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43   /4.B0002.0031.AC
   64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20   9F10.92.118.59
   80: 44 53 31 20  6 51 41 4d 32 35 36  0  0  2 6a 3e   DS1 .QAM256...j>
   96: 5f  a  0  0 c1 26 32  0  0  4 be e7 c8 a3  4 be   _...A&2...>gH#.>
  112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20   gH#)25 days, 10
  128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73   hours, 3 minutes
  144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e            , 11 seconds....
slot   7:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 32 20  6 51 41 4d 32 35 36  0  0  2 12 c1  8   S2 .QAM256....A.
   96:  0  0  0 c1 2c  a  0  0  4 be e7 c8 a3  4 be e7   ...A,....>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot   8:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 33 20  6 51 41 4d 32 35 36  0  0  2 1a c1  7   S3 .QAM256....A.
   96: 46  0  0 c1 28 1e  0  0  4 be e7 c8 a3  4 be e7   F..A(....>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot   9:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 34 20  6 51 41 4d 32 35 36  0  0  2 22 c1  7   S4 .QAM256..."A.
   96: 3c  0  0 c1 2b 3c  0  0  4 be e7 c8 a3  4 be e7   <..A+<...>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  10:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 35 20  6 51 41 4d 32 35 36  0  0  2 2a c1  7   S5 .QAM256...*A.
   96: 32  0  0 c1 2b 32  0  0  4 be e7 c8 a3  4 be e7   2..A+2...>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  11:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 36 20  6 51 41 4d 32 35 36  0  0  2 32 c1  7   S6 .QAM256...2A.
   96: 14  0  0 c1 2b 1e  0  0  4 be e7 c8 a3  4 be e7   ...A+....>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  12:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 37 20  6 51 41 4d 32 35 36  0  0  2 3a c1  6   S7 .QAM256...:A.
   96: 32  0  0 c1 2b  0  0  0  4 be e7 c8 a3  4 be e7   2..A+....>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  13:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 38 20  6 51 41 4d 32 35 36  0  0  2 42 c1  6   S8 .QAM256...BA.
   96: 1e  0  0 c1 2a 50  0  0  4 be e7 c8 a3  4 be e7   ...A*P...>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  14:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 31  5 31 2f 30 2f   2.23.0.80.1.1/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46   1.B0002.0031.ACF
   64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44   A10.92.119.44  D
   80: 53 31 20  6 51 41 4d 32 35 36  0  0  2 7a c1  7   S1 .QAM256...zA.
   96: 1e  0  0 c1 2a 5a  0  0  4 be e7 c8 a3  4 be e7   ...A*Z...>gH#.>g
  112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68   H#*89 days, 19 h
  128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73   ours, 48 minutes
  144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e            , 43 seconds....
slot  15:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 32 20  6 51 41 4d 32 35 36  0  0  2 12 3b 4e   S2 .QAM256....;N
   96: 34 33 3c c1 2c 46  0  0  4 ba d2 b7 ae  4 be e7   43<A,F...:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  16:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 33 20  6 51 41 4d 32 35 36  0  0  2 1a 3b 4e   S3 .QAM256....;N
   96: 34 33 3c c1 28 50  0  0  4 ba d2 b7 ae  4 be e7   43<A(P...:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  17:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 34 20  6 51 41 4d 32 35 36  0  0  2 22 3b 4e   S4 .QAM256...";N
   96: 34 33 3c c1 2c 50  0  0  4 ba d2 b7 ae  4 be e7   43<A,P...:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  18:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 35 20  6 51 41 4d 32 35 36  0  0  2 2a 3b 4e   S5 .QAM256...*;N
   96: 34 33 3c c1 2c 1e  0  0  4 ba d2 b7 ae  4 be e7   43<A,....:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  19:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 36 20  6 51 41 4d 32 35 36  0  0  2 32 3b 4e   S6 .QAM256...2;N
   96: 34 33 3c c1 2c 3c  0  0  4 ba d2 b7 ae  4 be e7   43<A,<...:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  20:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 37 20  6 51 41 4d 32 35 36  0  0  2 3a 3b 4e   S7 .QAM256...:;N
   96: 34 33 3c c1 2d  0  0  0  4 ba d2 b7 ae  4 be e7   43<A-....:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  21:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 38 20  6 51 41 4d 32 35 36  0  0  2 42 3b 4e   S8 .QAM256...B;N
   96: 34 33 3c c1 2d  0  0  0  4 ba d2 b7 ae  4 be e7   43<A-....:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  22:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 35  5 32 2f 30 2f   2.23.0.80.5.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34   1.B0002.0031.AE4
   64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44   B10.92.119.245 D
   80: 53 31 20  6 51 41 4d 32 35 36  0  0  2 6a 3b 4e   S1 .QAM256...j;N
   96: 34 33 3c c1 2c 3c  0  0  4 ba d2 b7 ae  4 be e7   43<A,<...:R7..>g
  112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68   H#*46 days, 17 h
  128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73   ours, 10 minutes
  144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e            , 44 seconds....
slot  23:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 39  5 32 2f 30 2f   2.23.0.80.9.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 42 32 46   1.B0002.0031.B2F
   64: 45 31 30 2e 39 32 2e 31 31 32 2e 31 39 34 20 44   E10.92.112.194 D
   80: 53 32 20  6 51 41 4d 32 35 36  0  0  2 12 c1  2   S2 .QAM256....A.
   96: 50  0  0 c1 2a 14  0  0  4 be e7 c8 a3  4 be e7   P..A*....>gH#.>g
  112: c8 a3 2a 33 30 20 64 61 79 73 2c 20 32 31 20 68   H#*30 days, 21 h
  128: 6f 75 72 73 2c 20 31 33 20 6d 69 6e 75 74 65 73   ours, 13 minutes
  144: 2c 20 32 35 20 73 65 63 6f 6e 64 73 2e            , 25 seconds....
slot  24:
    0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e   202111291700800N
   16: 30 31 30 30 38 57 42 35 37 33 30 31 31  b 31 37   01008WB573011.17
   32: 32 2e 32 33 2e 30 2e 38 30  1 39  5 32 2f 30 2f   2.23.0.80.9.2/0/
   48: 31  1 42 30 30 30 32 2e 30 30 33 31 2e 42 32 46   1.B0002.0031.B2F
   64: 45 31 30 2e 39 32 2e 31 31 32 2e 31 39 34 20 44   E10.92.112.194 D
   80: 53 33 20  6 51 41 4d 32 35 36  0  0  2 1a c1  3   S3 .QAM256....A.
   96:  a  0  0 c1 27 32  0  0  4 be e7 c8 a3  4 be e7   ...A'2...>gH#.>g
  112: c8 a3 2a 33 30 20 64 61 79 73 2c 20 32 31 20 68   H#*30 days, 21 h
  128: 6f 75 72 73 2c 20 31 33 20 6d 69 6e 75 74 65 73   ours, 13 minutes
  144: 2c 20 32 35 20 73 65 63 6f 6e 64 73 2e            , 25 seconds....
​​

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Mon November 29, 2021 03:23 AM
From: Andreas Legner
Subject: decimal type data input error (-1226)

So you're saying you can select the row, and dbaccess can display it (as -21474840, which might just be what dbaccess makes of what's stored there)?

Could you dump the page containing the row using 'oncheck -pp <db>:<table> <rowid>' and attach here, together with a table schema?
(Get the rowid by adding rowid to your query's projection clause.)

One way of getting 'impossible' values into the database might be ODBC bulk inserts which, as far as I remember, bypass some of the data validation checks.

------------------------------
Andreas Legner

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix

Original Message:
Sent: 11/26/2021 12:30:00 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Thanks for your reply, Jacob.
It was not searched with a null condition for that column.

> select first 10 rowid, power from stat_cm_pwr_bad_800_11 where power < -100;


      rowid     power

    2577922 -21474840
    2577923 -21474840
    2577924 -21474840
    2577925 -21474840
    2577926 -21474840
    2577927 -21474840
    2577928 -21474840
    2577929 -21474840
    2583811 -21474840
    2583812 -21474840

10 row(s) retrieved.

> select * from stat_cm_pwr_bad_800_11 where power is null;



No rows found.

> select first 10 rowid, power from stat_cm_pwr_bad_800_11 where power = -21474840;


      rowid     power

    2577922 -21474840
    2577923 -21474840
    2577924 -21474840
    2577925 -21474840
    2577926 -21474840
    2577927 -21474840
    2577928 -21474840
    2577929 -21474840
    2583811 -21474840
    2583812 -21474840

10 row(s) retrieved.
​

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Mon November 29, 2021 10:10 AM
From: Jacob Salomon
Subject: decimal type data input error (-1226)

Sang,

I wonder if that is the null value for the data type.  Just curious.

+----- Jacob Salomon -- jakesalomon@yahoo.com -------------------------+

| The first lesson of economics is scarcity: there is never enough of  |

| anything to fully satisfy all those who want it. The first lesson of |

| politics is to disregard the first lesson of economics.              |

+------------------------------ Thomas Sowell (Is Reality Optional?) --+

Original Message:
Sent: 11/26/2021 12:30:00 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Hello!

I would write a little ESQL/C program, to fetch the value of the "power" column into a dec_t structure, and inspect the content of the dec_t variable.
Maybe it will give some hint...
Check dec_t definition in $INFORMIXDIR/incl/esql/decimal.h

Also, is the DBMONEY environment variable defined?

Seb

------------------------------
Sebastien FLAESCH
------------------------------

Original Message:
Sent: Fri November 26, 2021 12:30 PM
From: SangGyu Jeong
Subject: decimal type data input error (-1226)

Hello,

The table has a column defined as decimal (7,1) .
When I look up the table, there is a record in which the value -21474840 was entered. How is this possible?

If I create a new table in the same instance and insert -21474840 , I get an error -1226.

Any advice would be appreciated. Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix