fix sql regressions
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/e18bab4d Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/e18bab4d Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/e18bab4d Branch: refs/heads/master Commit: e18bab4d79c7eb6059bebbb78be7ddeeb05bfd1f Parents: 591e0fa Author: Liu Ming <ovis_p...@sina.com> Authored: Mon Jun 25 02:47:42 2018 -0400 Committer: Liu Ming <ovis_p...@sina.com> Committed: Mon Jun 25 02:47:42 2018 -0400 ---------------------------------------------------------------------- core/sql/executor/ExExeUtilGet.cpp | 1 - core/sql/regress/core/EXPECTED116 | 5 +++++ core/sql/regress/hive/EXPECTED009 | 5 +++++ core/sql/regress/seabase/EXPECTED011 | 1 + core/sql/regress/seabase/EXPECTED022 | 9 +++++++++ core/sql/regress/seabase/EXPECTED031 | 1 + 6 files changed, 21 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/executor/ExExeUtilGet.cpp ---------------------------------------------------------------------- diff --git a/core/sql/executor/ExExeUtilGet.cpp b/core/sql/executor/ExExeUtilGet.cpp index 5bb4793..27064e2 100644 --- a/core/sql/executor/ExExeUtilGet.cpp +++ b/core/sql/executor/ExExeUtilGet.cpp @@ -949,7 +949,6 @@ short ExExeUtilGetMetadataInfoTcb::displayHeading() { if (getMItdb().noHeader()) { -printf("LMDBG noheader is true\n"); return 0; } // make sure there is enough space to move header http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/core/EXPECTED116 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116 index fcce935..fed4995 100644 --- a/core/sql/regress/core/EXPECTED116 +++ b/core/sql/regress/core/EXPECTED116 @@ -739,6 +739,7 @@ T116T1 Summary info of get: Get 1 rows. + --- SQL operation complete. >>drop table t116t1; @@ -756,6 +757,7 @@ SB_PERSISTENT_SAMPLES Summary info of get: Get 3 rows. + --- SQL operation complete. >>create table t116t2 (a int); @@ -774,6 +776,7 @@ T116T2 Summary info of get: Get 4 rows. + --- SQL operation complete. >>drop schema t116sch1 cascade; @@ -785,6 +788,7 @@ Get 4 rows. Summary info of get: Get 0 rows. + --- SQL operation complete. >>select count(*) from "_MD_".objects where schema_name = 'T116SCH1' +> for read uncommitted access; @@ -812,6 +816,7 @@ T116T1 Summary info of get: Get 4 rows. + --- SQL operation complete. >> >>set schema sch; http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/hive/EXPECTED009 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED009 b/core/sql/regress/hive/EXPECTED009 index fad737c..29f6d75 100644 --- a/core/sql/regress/hive/EXPECTED009 +++ b/core/sql/regress/hive/EXPECTED009 @@ -430,6 +430,11 @@ Tables in Schema TRAFODION._HV_SCH_T009_ T009T1 T009T2 +======================= +Summary info of get: +Get 2 rows. + + --- SQL operation complete. >>invoke hive.sch_t009.t009t1; http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED011 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011 index b09633a..b69abc2 100644 --- a/core/sql/regress/seabase/EXPECTED011 +++ b/core/sql/regress/seabase/EXPECTED011 @@ -1299,6 +1299,7 @@ METRIC_TEXT_TABLE Summary info of get: Get 4 rows. + --- SQL operation complete. >>invoke trafodion."_REPOS_".metric_query_table; http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED022 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022 index c89b2bd..1a30599 100644 --- a/core/sql/regress/seabase/EXPECTED022 +++ b/core/sql/regress/seabase/EXPECTED022 @@ -1268,6 +1268,8 @@ HBase Registered Tables in Catalog TRAFODION ======================= Summary info of get: Get 2 rows. + + --- SQL operation complete. >>unregister hbase table t022hbm2; @@ -1286,6 +1288,8 @@ HBase Registered Tables in Catalog TRAFODION ======================= Summary info of get: Get 2 rows. + + --- SQL operation complete. >>showddl hbase."_CELL_".t022hbm2; @@ -1344,6 +1348,7 @@ REGISTER HBASE TABLE T022HBM2; Summary info of get: Get 0 rows. + --- SQL operation complete. >>showddl hbase."_CELL_".t022hbm2; @@ -1398,6 +1403,8 @@ HBase Registered Tables in Catalog TRAFODION ======================= Summary info of get: Get 1 rows. + + --- SQL operation complete. >>showddl hbase."_CELL_".t022hbm2; @@ -1466,6 +1473,8 @@ HBase Registered Tables in Catalog TRAFODION ======================= Summary info of get: Get 1 rows. + + --- SQL operation complete. >>showddl hbase."_CELL_".t022hbm2; http://git-wip-us.apache.org/repos/asf/trafodion/blob/e18bab4d/core/sql/regress/seabase/EXPECTED031 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED031 b/core/sql/regress/seabase/EXPECTED031 index ea7a11c..c6e3562 100644 --- a/core/sql/regress/seabase/EXPECTED031 +++ b/core/sql/regress/seabase/EXPECTED031 @@ -1076,6 +1076,7 @@ HIVE Summary info of get: Get 2 rows. + --- SQL operation complete. >> >>-- external and hive table mismatch on hive 'string' datatype