Repository: incubator-trafodion
Updated Branches:
refs/heads/master 7230c7b50 -> cb5030446
[TRAFODION-2298] Update expected results for test compGeneral/TEST023
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/dbc0fed4
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/dbc0fed4
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/dbc0fed4
Branch: refs/heads/master
Commit: dbc0fed4767b2bebc79555d2e0bc1d05c5e7f466
Parents: 8d8adf1
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Oct 26 22:47:14 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Oct 26 22:47:14 2016 +0000
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED023 | 50 ++++++++++++++-------------
1 file changed, 26 insertions(+), 24 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dbc0fed4/core/sql/regress/compGeneral/EXPECTED023
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED023 b/core/sql/regress/compGeneral/EXPECTED023
index e65debb..38dec55 100644
--- a/core/sql/regress/compGeneral/EXPECTED023
+++ b/core/sql/regress/compGeneral/EXPECTED023
@@ -119,7 +119,7 @@ STEST_EMPTY
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_01_1474483126_801601 M
+STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_82_1477517948_682882 M
--- 1 row(s) selected.
>>-- should see one row
@@ -135,7 +135,7 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_01_1474483126_801601
+TRAF_SAMPLE_82_1477517948_682882
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a sample table
@@ -159,7 +159,7 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_1_1474483161_60841
+TRAF_SAMPLE_18_1477517986_660218
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + a different sample table
@@ -169,7 +169,7 @@ TRAF_SAMPLE_1_1474483161_60841
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_1_1474483161_60841 M
+STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_18_1477517986_660218 M
--- 1 row(s) selected.
>>-- should see one row
@@ -216,7 +216,7 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_67_1474483187_693567
+TRAF_SAMPLE_69_1477518014_950969
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
@@ -226,7 +226,7 @@ TRAF_SAMPLE_67_1474483187_693567
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_67_1474483187_693567 I
+STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_69_1477518014_950969 I
--- 1 row(s) selected.
>>-- should see one row
@@ -250,7 +250,7 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
--- SQL operation complete.
>> -- should be stest, stest_empty, stestc, sb_* tables + another sample table
@@ -260,7 +260,7 @@ TRAF_SAMPLE_85_1474483214_345185
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_85_1474483214_345185 I
+STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_36_1477518046_834836 I
--- 1 row(s) selected.
>>-- should see one row
@@ -321,7 +321,7 @@ STEST
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_85_1474483214_345185 I c1 >= 100000
+STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_36_1477518046_834836 I c1 >= 100000
--- 1 row(s) selected.
>>
@@ -378,8 +378,8 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_06_1474483266_729006
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
+TRAF_SAMPLE_92_1477518106_421392
--- SQL operation complete.
>>
@@ -388,7 +388,7 @@ TRAF_SAMPLE_85_1474483214_345185
OBJECT_NAME SAMPLE_NAME REASON LAST_WHERE_PREDICATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_06_1474483266_729006 I c1 >= 'naaaa'
+STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_92_1477518106_421392 I c1 >= 'naaaa'
--- 1 row(s) selected.
>>
@@ -413,8 +413,8 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_06_1474483266_729006
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
+TRAF_SAMPLE_92_1477518106_421392
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -426,7 +426,9 @@ TRAF_SAMPLE_85_1474483214_345185
>>
>>update statistics for table stest_empty on every column sample random 10 percent persistent;
---- SQL operation complete.
+*** WARNING[9220] The table is empty, so no persistent sample table was created.
+
+--- SQL operation completed with warnings.
>>
>>get tables;
@@ -439,8 +441,8 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_06_1474483266_729006
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
+TRAF_SAMPLE_92_1477518106_421392
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -468,8 +470,8 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_06_1474483266_729006
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
+TRAF_SAMPLE_92_1477518106_421392
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -481,7 +483,7 @@ TRAF_SAMPLE_85_1474483214_345185
*** ERROR[15001] A syntax error occurred at or before:
SELECT "C1", "C2", "C3", "_SALT_" FROM TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
-E_85_1474483214_345185 WHERE 1 FOR READ UNCOMMITTED ACCESS;
+E_36_1477518046_834836 WHERE 1 FOR READ UNCOMMITTED ACCESS;
^ (120 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
@@ -499,8 +501,8 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_06_1474483266_729006
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
+TRAF_SAMPLE_92_1477518106_421392
--- SQL operation complete.
>> -- should be the same as previous "get tables"
@@ -510,7 +512,7 @@ TRAF_SAMPLE_85_1474483214_345185
*** ERROR[9219] Incremental UPDATE STATISTICS: An operation failed, possibly due to an invalid WHERE clause.
-*** ERROR[4001] Column BADCOL is not found. Tables in scope: TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_85_1474483214_345185. Default schema: TRAFODION.SCH.
+*** ERROR[4001] Column BADCOL is not found. Tables in scope: TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_36_1477518046_834836. Default schema: TRAFODION.SCH.
*** ERROR[8822] The statement was not prepared.
@@ -551,7 +553,7 @@ SB_PERSISTENT_SAMPLES
STEST
STESTC
STEST_EMPTY
-TRAF_SAMPLE_85_1474483214_345185
+TRAF_SAMPLE_36_1477518046_834836
--- SQL operation complete.
>> -- should be the same as previous "get tables" except only one sample table
Merge [TRAFODION-2298] PR-790 Update expected results for test compGeneral/TEST023 Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/cb503044 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/cb503044 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/cb503044 Branch: refs/heads/master Commit: cb50304460322cc65138e871416700a92fdd1299 Parents: 7230c7b dbc0fed Author: Suresh Subbiah <su...@apache.org> Authored: Thu Oct 27 15:08:38 2016 +0000 Committer: Suresh Subbiah <su...@apache.org> Committed: Thu Oct 27 15:08:38 2016 +0000 ---------------------------------------------------------------------- core/sql/regress/compGeneral/EXPECTED023 | 50 ++++++++++++++------------- 1 file changed, 26 insertions(+), 24 deletions(-) ----------------------------------------------------------------------