[TRAFODION-2990] CREATE TABLE LIKE fails with long numeric default value

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Fix Version/s: 2.3
• Component/s: sql-cmp
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 12/Mar/18 15:25
• Updated: 13/Aug/18 22:28
• Resolved: 13/Mar/18 15:31

Description

The following script reproduces the problem:

drop table if exists t1 cascade;
drop table if exists new_t1 cascade;

create table t1 (
val int,
c1 numeric(128,127) default 1.01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789
);
insert into t1(val) values (1);
select * from t1;
create table new_t1 like t1;

When run, the CREATE TABLE LIKE statement fails as follows:

>>create table new_t1 like t1;

• • • ERROR[15001] A syntax error occurred at or before:
      create table TRAFODION.SEABASE.NEW_T1 ( "VAL"
       INT DEFAULT NULL NOT SERIALIZED , "C1" NUMERIC(12
      8, 127) DEFAULT
            1.
            0123456789012345678901234567890123456789012345678901234567890123456789012
      3456789012345678901234567890123456789
                                          ^ (299 characters from start of SQL statement)

• • • ERROR[8822] The statement was not prepared.

— SQL operation failed with errors.

Issue Links

• links to: GitHub Pull Request #1469