add regression test
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/a08afe49 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/a08afe49 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/a08afe49 Branch: refs/heads/master Commit: a08afe4940b828309e80f91ee0f2c29aaf08f5c6 Parents: fac342d Author: Liu Ming <[email protected]> Authored: Sat May 19 07:56:59 2018 -0400 Committer: Liu Ming <[email protected]> Committed: Sat May 19 07:56:59 2018 -0400 ---------------------------------------------------------------------- core/sql/regress/executor/EXPECTED016.SB | 20 ++++++++++++++++++-- core/sql/regress/executor/TEST016 | 7 +++++-- 2 files changed, 23 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/a08afe49/core/sql/regress/executor/EXPECTED016.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED016.SB b/core/sql/regress/executor/EXPECTED016.SB index 2ef3ea6..effb523 100644 --- a/core/sql/regress/executor/EXPECTED016.SB +++ b/core/sql/regress/executor/EXPECTED016.SB @@ -30,7 +30,9 @@ +>; --- SQL operation complete. ->> +>>create table t3015 (a1 NUMERIC(19,0), a2 int); + +--- SQL operation complete. >>-- MVs not support on seabase >>#ifndef SEABASE_REGRESS >>create MVGroup MVG_016; @@ -216,6 +218,9 @@ CREATE TABLE TRAFODION.SCH.T016T2 >>insert into t016t2 values (11, 22, null); --- 1 row(s) inserted. +>>insert into t3015 values(27380468,27380468); + +--- 1 row(s) inserted. >> >>select * from t016t2; @@ -869,12 +874,23 @@ C1 C2 >>select * from t016_2535_3 where (c1,c2) <= (1234567.3, 0); --- 0 row(s) selected. ->> +>>--JIRA TRAFODION-3015 +>>select * from t3015 where a1='27380468'; + +A1 A2 +---------- + + 27380468 27380468 + +--- 1 row(s) selected. >>drop table t016_2535_2; --- SQL operation complete. >>drop table t016_2535_3; --- SQL operation complete. +>>drop table t3015; + +--- SQL operation complete. >> >>log; http://git-wip-us.apache.org/repos/asf/trafodion/blob/a08afe49/core/sql/regress/executor/TEST016 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/TEST016 b/core/sql/regress/executor/TEST016 index 0d314dd..e3723ff 100644 --- a/core/sql/regress/executor/TEST016 +++ b/core/sql/regress/executor/TEST016 @@ -80,7 +80,7 @@ hash partition by (a,b) #ifNT attribute all mvs allowed ; - +create table t3015 (a1 NUMERIC(19,0), a2 int); -- MVs not support on seabase #ifndef SEABASE_REGRESS create MVGroup MVG_016; @@ -151,6 +151,7 @@ insert into t016t2 values (2234567890123456789012345.123456789012, 1234567890123 insert into t016t2 values (-1234567890123456789012345.123456789012, 22345678901234567890, .000000000000000000001); insert into t016t2 values (10, 20, .30); insert into t016t2 values (11, 22, null); +insert into t3015 values(27380468,27380468); select * from t016t2; @@ -313,9 +314,11 @@ select * from t016_2535_3 where (c1,c2) > (1234568.3, 2); select * from t016_2535_3 where (c1,c2) < (1234568.3, 2); select * from t016_2535_3 where (c1,c2) <= (1234568.3, 2); select * from t016_2535_3 where (c1,c2) <= (1234567.3, 0); - +--JIRA TRAFODION-3015 +select * from t3015 where a1='27380468'; drop table t016_2535_2; drop table t016_2535_3; +drop table t3015; log;
