[TRAFODION-1920] add test cases for not nullable column
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e15da4e5 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e15da4e5 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e15da4e5 Branch: refs/heads/master Commit: e15da4e511f2a04445d3eaa2d3df5acec82c70eb Parents: 67b89f8 Author: Liu Ming <[email protected]> Authored: Wed May 4 02:48:33 2016 +0000 Committer: Liu Ming <[email protected]> Committed: Wed May 4 02:48:33 2016 +0000 ---------------------------------------------------------------------- core/sql/regress/hive/EXPECTED005 | 42 ++++++++++++++++++++++++++++++++++ core/sql/regress/hive/TEST005 | 18 +++++++++++++++ 2 files changed, 60 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e15da4e5/core/sql/regress/hive/EXPECTED005 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED005 b/core/sql/regress/hive/EXPECTED005 index 10e7121..eff0c42 100644 --- a/core/sql/regress/hive/EXPECTED005 +++ b/core/sql/regress/hive/EXPECTED005 @@ -580,12 +580,54 @@ C1 C2 C3 C4 C *** ERROR[8413] The string argument contains characters that cannot be converted. --- 0 row(s) loaded. +>>insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; + +*** ERROR[8413] The string argument contains characters that cannot be converted. + +--- 0 row(s) inserted. +>>upsert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; + +*** ERROR[8413] The string argument contains characters that cannot be converted. + +--- 0 row(s) inserted. >>cqd HIVE_SCAN_SPECIAL_MODE '2'; --- SQL operation complete. >>load with no output into trafodion.seabase.traf_tbl_bad select * from >>tbl_bad; --- 8 row(s) loaded. +>>insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; + +--- 8 row(s) inserted. +>>upsert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; + +--- 8 row(s) inserted. +>>cqd HIVE_SCAN_SPECIAL_MODE reset; + +--- SQL operation complete. +>>drop table if exists trafodion.seabase.traf_tbl_bad; + +--- SQL operation complete. +>>create table trafodion.seabase.traf_tbl_bad ( ++>c1 int not null, ++>c2 largeint not null, ++>c3 varchar(25), ++>c4 real, ++>c5 smallint, ++>c6 timestamp(6) not null, ++>c7 float(54) not null, ++>c8 smallint ++>); + +--- SQL operation complete. +>>cqd HIVE_SCAN_SPECIAL_MODE '2'; + +--- SQL operation complete. +>>insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; + +*** ERROR[8421] NULL cannot be assigned to a NOT NULL column. + +--- 0 row(s) inserted. >>cqd HIVE_SCAN_SPECIAL_MODE reset; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e15da4e5/core/sql/regress/hive/TEST005 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/TEST005 b/core/sql/regress/hive/TEST005 index cebeff4..ad7cf0e 100644 --- a/core/sql/regress/hive/TEST005 +++ b/core/sql/regress/hive/TEST005 @@ -262,7 +262,25 @@ c7 float(54), c8 smallint ); load with no output into trafodion.seabase.traf_tbl_bad select * from tbl_bad; +insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; +upsert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; cqd HIVE_SCAN_SPECIAL_MODE '2'; load with no output into trafodion.seabase.traf_tbl_bad select * from tbl_bad; +insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; +upsert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; +cqd HIVE_SCAN_SPECIAL_MODE reset; +drop table if exists trafodion.seabase.traf_tbl_bad; +create table trafodion.seabase.traf_tbl_bad ( +c1 int not null, +c2 largeint not null, +c3 varchar(25), +c4 real, +c5 smallint, +c6 timestamp(6) not null, +c7 float(54) not null, +c8 smallint +); +cqd HIVE_SCAN_SPECIAL_MODE '2'; +insert into trafodion.seabase.traf_tbl_bad select * from tbl_bad; cqd HIVE_SCAN_SPECIAL_MODE reset; log;
