David Wayne Birdsall created TRAFODION-2990:
-----------------------------------------------
Summary: CREATE TABLE LIKE fails with long numeric default value
Key: TRAFODION-2990
URL: https://issues.apache.org/jira/browse/TRAFODION-2990
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.3
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
