Repository: incubator-trafodion Updated Branches: refs/heads/master 03ffdb409 -> 0f838633f
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml02 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml02 b/core/sql/regress/qat/qatdml02 index 2c1c40c..d0603ea 100755 --- a/core/sql/regress/qat/qatdml02 +++ b/core/sql/regress/qat/qatdml02 @@ -21,8 +21,8 @@ LOG aqatdml02 Clear; -- testcase A2: select syskey -- testcase A3: select * -- testcase A4: select an expression of a column --- testcase A5: use of browse access, --- stable access and repeatable access +-- testcase A5: use of read committed access, +-- read committed access and repeatable access -- testcase A6: select aggregate functions -- All testcases are documented further below. @@ -442,8 +442,8 @@ LOG aqatdml02 Clear; -- <detail> -- select normal simple test case - this tests the use of --- the for browse access, for stable access, --- and for repeatable access clauses. No actual +-- the for read committed access, for read committed access, +-- and for read committed access clauses. No actual -- tests of the functionality of these clauses is done - this -- is a test of syntax only. Each of these clauses is checked -- for audited tables, non-audited tables, protection views, @@ -455,48 +455,48 @@ LOG aqatdml02 Clear; -- <comment> *** audited tables *** select * from btsel01 - for browse access; + for read committed access; select * from btsel02 - for stable access; + for read committed access; select * from btsel03 - for repeatable access; + for read committed access; -- <comment> *** non-audited table *** select * from btsel05 - for browse access; + for read committed access; select * from btsel05 - for stable access; + for read committed access; select * from btsel05 - for repeatable access; + for read committed access; -- <comment> *** views *** select * from pvsel01 - for browse access; + for read committed access; select * from pvsel01 - for stable access; + for read committed access; select * from pvsel01 - for repeatable access; + for read committed access; --- <comment> svsel15 must be accessed for browse access (mixed view) +-- <comment> svsel15 must be accessed for read committed access (mixed view) select * from svsel15 - for browse access; + for read committed access; select * from svsel14 - for browse access; + for read committed access; select * from svsel13 - for browse access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml03 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml03 b/core/sql/regress/qat/qatdml03 index 5db2fba..ef13a39 100755 --- a/core/sql/regress/qat/qatdml03 +++ b/core/sql/regress/qat/qatdml03 @@ -24,8 +24,8 @@ LOG aqatdml03 Clear; -- testcase A4: SELECT WHERE column is LIKE a constant -- testcase A5: SELECT WHERE column is LIKE a constant, -- using an ESCAPE character --- testcase A6: use of for browse access, for stable access --- and for repeatable access +-- testcase A6: use of for read committed access, for read committed access +-- and for read committed access -- testcase A7: SELECT aggregate functions with where predicate -- All testcases are documented further below. @@ -661,7 +661,7 @@ LOG aqatdml03 Clear; -- <detail> -- select normal test case with where clause - this tests the use --- of the for browse access, for stable access, and for repeatable access +-- of the for read committed access, for read committed access, and for read committed access -- clauses. Only syntax is checked here. -- <switches> @@ -675,52 +675,52 @@ LOG aqatdml03 Clear; -- <ufi-input> select * from btsel06 where col_7 = 100 - for stable access; + for read committed access; -- <ufi-input> select * from btsel04 where medium_int <= 1000 - for browse access; + for read committed access; -- <ufi-input> select * from btsel07 where pic_x_b < 'Q' - for repeatable access; + for read committed access; -- <comment> **** check for locking on non-audited tables **** -- <ufi-input> select * from btsel05 where pic_x_a > 'abe' - for browse access; + for read committed access; -- <ufi-input> select * from btsel05 where pic_x_a > 'abe' - for stable access; + for read committed access; -- <ufi-input> select * from btsel05 where pic_x_a > 'abe' - for repeatable access; + for read committed access; -- <comment> **** check for locking on views **** -- <ufi-input> select * from pvsel04 where pic_comp_1 in (200,300) - for browse access; + for read committed access; -- <ufi-input> select * from pvsel01 where binary_signed > 50 - for stable access; + for read committed access; -- <ufi-input> select * from svsel11 where col_1 > 50 - for stable access; + for read committed access; -- <ufi-input> select * from pvsel02 where pic_x_1 = 'B' - for repeatable access; + for read committed access; -- <ufi-input> select * from svsel13 where medium_int = 1000 - for repeatable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml04 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml04 b/core/sql/regress/qat/qatdml04 index c0501a6..4551356 100755 --- a/core/sql/regress/qat/qatdml04 +++ b/core/sql/regress/qat/qatdml04 @@ -19,7 +19,7 @@ LOG aqatdml04 Clear; -- testcase A1: HAVING -- testcase A2: ORDER BY -- testcase A3: complex queries - combinations of all features --- testcase A4: use of locking clauses (for stable access, for browse access, keep +-- testcase A4: use of locking clauses (for read committed access, for read committed access, keep -- lock) with above clauses -- testcase A5: variation of ordering of WHERE,GROUP BY,HAVING, -- ORDER ,locking clauses @@ -313,7 +313,7 @@ LOG aqatdml04 Clear; group by char_1,decimal_1 having decimal_1 between 2 and 8 order by decimal_1 DESC - for repeatable access; + for read committed access; -- <ufi-input> select distinct var_char,binary_64_s, pic_comp_1 from btsel01 @@ -324,7 +324,7 @@ LOG aqatdml04 Clear; group by binary_64_s,pic_comp_1, var_char having binary_64_s > pic_comp_1 order by binary_64_s, binary_64_s DESC - for repeatable access; + for read committed access; -- <ufi-input> select (new_name_1 * new_name_1),new_name_3 from pvsel03 @@ -335,7 +335,7 @@ LOG aqatdml04 Clear; group by new_name_1,new_name_3 having new_name_1 = 80 order by new_name_3 ASC - for stable access; + for read committed access; -- <ufi-input> select new_name_1,new_name_4 from svsel13 @@ -345,7 +345,7 @@ LOG aqatdml04 Clear; group by new_name_1,new_name_4 having new_name_1 = 80 order by new_name_1 - for browse access; + for read committed access; -- <ufi-input> select medium_int,SYSKEY from btsel04 @@ -383,8 +383,8 @@ LOG aqatdml04 Clear; -- <testcase A4> -- <detail> --- select normal test case - this tests the use of the for browse access, --- for stable access, and for repeatable access clauses with GROUP BY +-- select normal test case - this tests the use of the for read committed access, +-- for read committed access, and for read committed access clauses with GROUP BY -- HAVING, and ORDER BY clauses. This is a test for syntax only - no actual -- checking of the locks obtained is done. @@ -395,59 +395,59 @@ LOG aqatdml04 Clear; -- <ufi-input> select large_int from btsel08 group by large_int - for browse access; + for read committed access; -- <ufi-input> select pic_x_5 from btsel09 group by pic_x_5 having pic_x_5 > 4 - for stable access; + for read committed access; -- <ufi-input> select * from btsel10 order by pic_9_7 - for repeatable access; + for read committed access; -- <comment> ***** non-audited tables ***** -- <ufi-input> select pic_x_b from btsel05 group by pic_x_b - for stable access; + for read committed access; -- <ufi-input> select pic_x_b from btsel05 group by pic_x_b having (pic_x_b = 'D') or (pic_x_b = 'B') - for repeatable access; + for read committed access; -- <ufi-input> select * from btsel05 order by pic_x_b - for browse access; + for read committed access; -- <comment> **** views ***** -- <ufi-input> select new_name_1 from pvsel03 group by new_name_1 - for repeatable access; + for read committed access; -- <ufi-input> select new_name_1 from svsel13 group by new_name_1 - for repeatable access; + for read committed access; -- <ufi-input> select new_name_1 from pvsel03 group by new_name_1 having new_name_1 = 80 - for browse access; + for read committed access; -- <ufi-input> select new_name_1 from svsel13 group by new_name_1 having new_name_1 = 80 - for browse access; + for read committed access; -- <ufi-input> select * from pvsel03 order by new_name_1 - for stable access; + for read committed access; -- <ufi-input> select * from svsel13 order by new_name_1 - for stable access; + for read committed access; -- <end-input> @@ -462,7 +462,7 @@ LOG aqatdml04 Clear; -- All other clauses may appear in any order after that. The following -- tests will have the order of these clauses randomly varied from -- the standard order of SELECT-FROM-WHERE-GROUP BY-HAVING-ORDER BY- --- for browse access or for stable access or for repeatable access. +-- for read committed access or for read committed access or for read committed access. -- <templates> @@ -478,7 +478,7 @@ LOG aqatdml04 Clear; group by char_1,decimal_1 having decimal_1 between 2 and 8 order by decimal_1 DESC - for repeatable access; + for read committed access; @@ -492,7 +492,7 @@ LOG aqatdml04 Clear; group by binary_64_s,pic_comp_1, var_char having binary_64_s > pic_comp_1 order by binary_64_s, binary_64_s DESC - for stable access; + for read committed access; @@ -617,7 +617,7 @@ LOG aqatdml04 Clear; by decimal_1 DESC - repeatable + read committed access ; -- <ufi-input> @@ -642,7 +642,7 @@ LOG aqatdml04 Clear; order by binary_64_s, 2 DESC - for repeatable access + for read committed access ; @@ -657,7 +657,7 @@ group by new_name_1,new_name_3 having new_name_1=80 order by new_name_3 ASC - stable access; + for read committed access; -- <ufi-input> SELECT new_name_1,new_name_4 FROM svsel13 @@ -672,7 +672,7 @@ group by FOR - broWSE + read committed @@ -987,7 +987,7 @@ order by decimal_10; group by pic_comp_1 having sum(binary_signed) > 5000 order by pic_comp_1, 2 - for repeatable access; + for read committed access; -- <ufi-input> select new_name_1, count(distinct var_char) from svsel13 @@ -995,7 +995,7 @@ order by decimal_10; group by new_name_1 having avg(new_name_2) in (5,6) order by 1, 2 ASC - for stable access; + for read committed access; -- <ufi-input> select pic_comp_1, avg(ALL binary_32_u + pic_comp_1) from btsel01 @@ -1017,7 +1017,7 @@ order by decimal_10; group by medium_int having max(pic_x_1) <> 'E' order by medium_int - for browse access; + for read committed access; -- <comment> select having aggregate(SYSKEY) -- <ufi-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml05 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml05 b/core/sql/regress/qat/qatdml05 index 6e4ec0d..7644b81 100755 --- a/core/sql/regress/qat/qatdml05 +++ b/core/sql/regress/qat/qatdml05 @@ -30,7 +30,7 @@ LOG aqatdml05 Clear; -- A2: select SYSKEY -- A3: select * -- A4: select expressions of columns --- A5: use of for browse access,for stable access,for repeatable access +-- A5: use of for read committed access,for read committed access,for read committed access -- A6: select aggregate functions -- All testcases are documented further below. @@ -524,13 +524,13 @@ LOG aqatdml05 Clear; -- <detail> -- select joins simple test case - this tests the use --- of the for browse access,for stable access, --- for repeatable access clauses. No actual +-- of the for read committed access,for read committed access, +-- for read committed access clauses. No actual -- tests of the functionality of these clauses is done -- this is -- a test of syntax only. Each of these clauses is checked for -- the following combinations: -- audited base table / audited base table --- audited base table / non-audited base table (browse access only) +-- audited base table / non-audited base table (read committed access only) -- bt/bt -- bt/pv -- bt/sv @@ -550,143 +550,143 @@ LOG aqatdml05 Clear; -- <ufi-input> select pic_x_1, pic_x_7 from btsel02,btsel03 - for browse access; + for read committed access; -- <ufi-input> select pic_x_1, pic_x_7 from btsel02,btsel03 - for stable access; + for read committed access; -- <ufi-input> select pic_x_1, pic_x_7 from btsel02,btsel03 - for repeatable access; + for read committed access; -- <comment> **** audited table, non-audited table **** --- <comment> **** must specify for browse access for this test **** +-- <comment> **** must specify for read committed access for this test **** -- <ufi-input> select pic_x_7, pic_x_a from btsel03,btsel05 - for browse access; + for read committed access; -- <ufi-input> select binary_32_u , binary_signed from btsel03,pvsel01 - for browse access; + for read committed access; -- <ufi-input> select binary_32_u , binary_signed from btsel03,pvsel01 - for stable access; + for read committed access; -- <ufi-input> select binary_32_u , binary_signed from btsel03,pvsel01 - for repeatable access; + for read committed access; -- <ufi-input> select new_name_1, medium_int from btsel03,svsel13 - for browse access; + for read committed access; -- <ufi-input> select new_name_1, medium_int from btsel03,svsel13 - for stable access; + for read committed access; -- <ufi-input> select new_name_1, medium_int from btsel03,svsel13 - for repeatable access; + for read committed access; -- <ufi-input> select binary_signed, new_name_1 from pvsel01,pvsel03 - for browse access; + for read committed access; -- <ufi-input> select binary_signed, new_name_1 from pvsel01,pvsel03 - for stable access; + for read committed access; -- <ufi-input> select binary_signed, new_name_1 from pvsel01,pvsel03 - for repeatable access; + for read committed access; -- <ufi-input> select pic_comp_1 from pvsel01,svsel13 - for browse access; + for read committed access; -- <ufi-input> select pic_comp_1 from pvsel01,svsel13 - for stable access; + for read committed access; -- <ufi-input> select pic_comp_1 from pvsel01,svsel13 - for repeatable access; + for read committed access; -- <ufi-input> select var_char, col_2 from svsel13,svsel11 - for browse access; + for read committed access; -- <ufi-input> select var_char, col_2 from svsel13,svsel11 - for stable access; + for read committed access; -- <ufi-input> select var_char, col_2 from svsel13,svsel11 - for repeatable access; + for read committed access; -- <ufi-input> select firstt.small_int, secondd.small_int from btsel01 firstt,btsel01 secondd - for browse access; + for read committed access; -- <ufi-input> select firstt.small_int, secondd.small_int from btsel01 firstt,btsel01 secondd - for stable access; + for read committed access; -- <ufi-input> select firstt.small_int, secondd.small_int from btsel01 firstt,btsel01 secondd - for repeatable access; + for read committed access; -- <ufi-input> select firstt.new_name_2 from pvsel03 firstt,pvsel03 secondd - for browse access; + for read committed access; -- <ufi-input> select firstt.new_name_2 from pvsel03 firstt,pvsel03 secondd - for stable access; + for read committed access; -- <ufi-input> select firstt.new_name_2 from pvsel03 firstt,pvsel03 secondd - for repeatable access; + for read committed access; -- <ufi-input> select firstt.new_name_1, secondd.medium_int from svsel13 firstt,svsel13 secondd - for browse access; + for read committed access; -- <ufi-input> select firstt.new_name_1, secondd.medium_int from svsel13 firstt,svsel13 secondd - for stable access; + for read committed access; -- <ufi-input> select firstt.new_name_1, secondd.medium_int from svsel13 firstt,svsel13 secondd - for repeatable access; + for read committed access; -- <ufi-input> select firstt.col_1, secondd.col_10 from btsel05 firstt,btsel05 secondd - for browse access; + for read committed access; -- <ufi-input> select firstt.col_1, secondd.col_10 from btsel05 firstt,btsel05 secondd - for stable access; + for read committed access; -- <ufi-input> select firstt.col_1, secondd.col_10 from btsel05 firstt,btsel05 secondd - for repeatable access; + for read committed access; -- <ufi-input> select char_1, btsel02.pic_x_1, pic_9_7 from btsel01,btsel02,btsel03 - for browse access; + for read committed access; -- <ufi-input> select char_1, btsel02.pic_x_1, pic_9_7 from btsel01,btsel02,btsel03 - for stable access; + for read committed access; -- <ufi-input> select char_1, btsel02.pic_x_1, pic_9_7 from btsel01,btsel02,btsel03 - for repeatable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml06 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml06 b/core/sql/regress/qat/qatdml06 index c66afa9..a482b92 100755 --- a/core/sql/regress/qat/qatdml06 +++ b/core/sql/regress/qat/qatdml06 @@ -30,8 +30,8 @@ LOG aqatdml06 Clear; -- expression list -- A3: SELECT WHERE <predicate>, where <predicate> contains -- AND, OR, NOT --- A4: use of SELECT WHERE ... for browse access,for stable access --- , for repeatable access +-- A4: use of SELECT WHERE ... for read committed access,for read committed access +-- , for read committed access -- A5: SELECT aggregate functions with WHERE predicate -- All testcases are documented further below. @@ -317,7 +317,7 @@ LOG aqatdml06 Clear; -- <detail> -- select joins where clause test case - this tests the use --- of the for browse access, for stable access , and for repeatable access +-- of the for read committed access, for read committed access , and for read committed access -- clauses. Only syntax is checked here. -- <templates> @@ -327,177 +327,177 @@ LOG aqatdml06 Clear; select * from btsel02,btsel03 where pic_x_1 = 'c' - for browse access; + for read committed access; -- <ufi-input> select * from btsel02,btsel03 where pic_x_1 = 'c' - for stable access; + for read committed access; -- <ufi-input> select * from btsel02,btsel03 where pic_x_1 = 'c' - for repeatable access; + for read committed access; -- <comment> **** audited table, non-audited table **** --- <comment> **** must specify for browse access for this test **** +-- <comment> **** must specify for read committed access for this test **** -- <ufi-input> select * from btsel03,btsel05 where pic_x4_a = pic_x_a - for browse access; + for read committed access; -- <ufi-input> select * from btsel03,pvsel01 where pvsel01.small_int = btsel03.binary_64_s - for browse access; + for read committed access; -- <ufi-input> select * from btsel03,pvsel01 where pvsel01.small_int = btsel03.binary_64_s - for stable access; + for read committed access; -- <ufi-input> select * from btsel03,pvsel01 where pvsel01.small_int = btsel03.binary_64_s - for repeatable access; + for read committed access; -- <ufi-input> select * from btsel03,svsel13 where binary_64_s = medium_int - for browse access; + for read committed access; -- <ufi-input> select * from btsel03,svsel13 where binary_64_s = medium_int - for stable access; + for read committed access; -- <ufi-input> select * from btsel03,svsel13 where binary_64_s = medium_int - for repeatable access; + for read committed access; -- <ufi-input> select * from pvsel03,pvsel04 where new_name_3 = pic_x_7 - for browse access; + for read committed access; -- <ufi-input> select * from pvsel03,pvsel04 where new_name_3 = pic_x_7 - for stable access; + for read committed access; -- <ufi-input> select * from pvsel03,pvsel04 where new_name_3 = pic_x_7 - for repeatable access; + for read committed access; -- <ufi-input> select * from pvsel01,svsel13 where pvsel01.small_int = svsel13.medium_int - for browse access; + for read committed access; -- <ufi-input> select * from pvsel01,svsel13 where pvsel01.small_int = svsel13.medium_int - for stable access; + for read committed access; -- <ufi-input> select * from pvsel01,svsel13 where pvsel01.small_int = svsel13.medium_int - for repeatable access; + for read committed access; -- <ufi-input> select * from svsel13,svsel11 where new_name_1 = col_7 - for browse access; + for read committed access; -- <ufi-input> select * from svsel13,svsel11 where new_name_1 = col_7 - for stable access; + for read committed access; -- <ufi-input> select * from svsel13,svsel11 where new_name_1 = col_7 - for repeatable access; + for read committed access; -- <ufi-input> select * from btsel03 firstt,btsel03 secondd where firstt.binary_64_s = secondd.binary_64_s - for browse access; + for read committed access; -- <ufi-input> select * from btsel03 firstt,btsel03 secondd where firstt.binary_64_s = secondd.binary_64_s - for stable access; + for read committed access; -- <ufi-input> select * from btsel03 firstt,btsel03 secondd where firstt.binary_64_s = secondd.binary_64_s - for repeatable access; + for read committed access; -- <ufi-input> select * from pvsel03 firstt,pvsel03 secondd where firstt.new_name_1 = secondd.new_name_1 - for browse access; + for read committed access; -- <ufi-input> select * from pvsel03 firstt,pvsel03 secondd where firstt.new_name_1 = secondd.new_name_1 - for stable access; + for read committed access; -- <ufi-input> select * from pvsel03 firstt,pvsel03 secondd where firstt.new_name_1 = secondd.new_name_1 - for repeatable access; + for read committed access; -- <ufi-input> select * from svsel13 firstt,svsel13 secondd where firstt.pic_comp_1 = secondd.pic_comp_1 - for browse access; + for read committed access; -- <ufi-input> select * from svsel13 firstt,svsel13 secondd where firstt.pic_comp_1 = secondd.pic_comp_1 - for stable access; + for read committed access; -- <ufi-input> select * from svsel13 firstt,svsel13 secondd where firstt.pic_comp_1 = secondd.pic_comp_1 - for repeatable access; + for read committed access; -- <ufi-input> select * from btsel05 firstt,btsel05 secondd where firstt.col_1 = secondd.col_1 - for browse access; + for read committed access; -- <ufi-input> select * from btsel05 firstt,btsel05 secondd where firstt.col_1 = secondd.col_1 - for stable access; + for read committed access; -- <ufi-input> select * from btsel05 firstt,btsel05 secondd where firstt.col_1 = secondd.col_1 - for repeatable access; + for read committed access; -- <ufi-input> select * from btsel02,btsel03,btsel04 where pic_x_1 = btsel04.pic_x_7 - for browse access; + for read committed access; -- <ufi-input> select * from btsel02,btsel03,btsel04 where pic_x_1 = btsel04.pic_x_7 - for stable access; + for read committed access; -- <ufi-input> select * from btsel02,btsel03,btsel04 where pic_x_1 = btsel04.pic_x_7 - for repeatable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml07 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml07 b/core/sql/regress/qat/qatdml07 index a9e69c6..f427b0a 100755 --- a/core/sql/regress/qat/qatdml07 +++ b/core/sql/regress/qat/qatdml07 @@ -29,8 +29,8 @@ LOG aqatdml07 Clear; -- A1: HAVING -- A2: ORDER BY -- A3: complex queries - combinations of all features --- A4: use of locking clauses (for stable access, for browse access, --- for repeatable access) with above clauses +-- A4: use of locking clauses (for read committed access, for read committed access, +-- for read committed access) with above clauses -- A5: SELECT aggregate functions with GROUP BY -- A6: SELECT aggregate functions with aggregates in HAVING clause -- and complex queries with aggregates @@ -293,7 +293,7 @@ LOG aqatdml07 Clear; group by pic_9_7,medium_int having (pic_9_7 * 2) <> medium_int order by pic_9_7,2 DESC - for browse access; + for read committed access; -- <ufi-input> select pic_x_1,pic_9_7,medium_int from btsel02,btsel03,btsel04 @@ -304,7 +304,7 @@ LOG aqatdml07 Clear; group by pic_x_1,pic_9_7,medium_int having pic_x_1 like 'Q' order by pic_x_1,pic_9_7,medium_int ASC - for stable access; + for read committed access; -- <ufi-input> select decimal_1,new_name_1 from btsel01,pvsel03 @@ -313,7 +313,7 @@ LOG aqatdml07 Clear; group by decimal_1,new_name_1 having new_name_1 in (80,100) order by decimal_1,new_name_1 DESC - for repeatable access; + for read committed access; -- <ufi-input> select decimal_1,new_name_1 from btsel01,svsel13 @@ -356,8 +356,8 @@ LOG aqatdml07 Clear; -- <testcase A4> -- <detail> --- select join test case - this tests the use of the for browse access, --- for stable access, and for repeatable access clauses with GROUP BY, +-- select join test case - this tests the use of the for read committed access, +-- for read committed access, and for read committed access clauses with GROUP BY, -- HAVING, and ORDER BY clauses. This is a test of syntax only - no actual -- checking of the locks obtained is done. @@ -368,55 +368,55 @@ LOG aqatdml07 Clear; select pic_9_7 from btsel03,btsel04 group by pic_9_7 - for browse access; + for read committed access; -- <ufi-input> select decimal_1,new_name_1 from btsel01,pvsel03 group by decimal_1,new_name_1 having new_name_1 in (80,100) - for stable access; + for read committed access; -- <ufi-input> select * from btsel01,svsel13 order by decimal_1,new_name_1 - for repeatable access; + for read committed access; -- <ufi-input> select pic_x_1,pic_9_7,medium_int from btsel02,btsel03,btsel04 group by pic_x_1,pic_9_7,medium_int - for repeatable access; + for read committed access; -- <ufi-input> select pvsel01.medium_int from pvsel01,svsel13 group by pvsel01.medium_int having pvsel01.medium_int between 2000 and 10000 - for browse access; + for read committed access; -- <ufi-input> select * from svsel13,svsel11 order by new_name_3,col_3 - for stable access; + for read committed access; -- <ufi-input> select pvsel01.medium_int, pvsel04.medium_int from pvsel01,pvsel04 group by pvsel01.medium_int, pvsel04.medium_int - for stable access; + for read committed access; -- <ufi-input> select secondd.medium_int from pvsel01 firstt,pvsel01 secondd group by secondd.medium_int having secondd.medium_int <> 5000 - for repeatable access; + for read committed access; -- <ufi-input> select * from svsel13 firstt,svsel13 secondd order by firstt.new_name_1,firstt.new_name_3 - for browse access; + for read committed access; -- <ufi-input> select secondd.char_1,firstt.medium_int from btsel01 firstt, btsel01 secondd group by secondd.char_1,firstt.medium_int - for repeatable access; + for read committed access; -- <end-input> @@ -653,7 +653,7 @@ LOG aqatdml07 Clear; having sum( btsel01.small_int) > sum(decimal_2_signed * 100) order by large_int - for repeatable access; + for read committed access; -- <ufi-input> select svsel13.pic_comp_1, avg(decimal_1) from svsel13, btsel01 @@ -661,7 +661,7 @@ LOG aqatdml07 Clear; group by svsel13.pic_comp_1 having min(ALL pic_decimal_3) < 5 order by 1 DESC ,2 DESC - for stable access; + for read committed access; -- <ufi-input> select pvsel01.medium_int, avg(distinct pvsel04.medium_int) @@ -670,7 +670,7 @@ LOG aqatdml07 Clear; group by pvsel01.medium_int having avg(pic_decimal_3 * pvsel04.medium_int) < 7500 order by 2 - for browse access; + for read committed access; -- <ufi-input> select pic_9_7, sum(binary_32_u + pic_comp_1) from btsel03, btsel04 @@ -678,7 +678,7 @@ LOG aqatdml07 Clear; group by pic_9_7 having sum(distinct binary_32_u) <> 5 order by pic_9_7 ASC - for repeatable access; + for read committed access; -- <ufi-input> select pic_comp_1, avg(col_7) * sum(pic_comp_1) from svsel13, svsel11 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml08 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml08 b/core/sql/regress/qat/qatdml08 index a31659f..7aa1da7 100755 --- a/core/sql/regress/qat/qatdml08 +++ b/core/sql/regress/qat/qatdml08 @@ -36,8 +36,8 @@ LOG aqatdml08 Clear; -- testcase A2: quantified comparison operators: >=ANY,=ALL,etc. -- testcase A3: multiple nested subqueries and multiple subqueries -- connected with AND,OR --- testcase A4: subqueries with for browse access, for stable access, --- for repeatable access +-- testcase A4: subqueries with for read committed access, for read committed access, +-- for read committed access -- testcase A5: SELECT aggregate functions with aggregates in -- subquery @@ -961,8 +961,8 @@ LOG aqatdml08 Clear; -- <detail> -- uncorrelated subquery in where clause test - this tests the use of --- for browse access, for stable access, and --- for repeatable access in uncorrelated subqueries. +-- for read committed access, for read committed access, and +-- for read committed access in uncorrelated subqueries. -- <templates> -- US00 @@ -976,9 +976,9 @@ LOG aqatdml08 Clear; (select Y.partnum from fromsup Y where suppnum = 15 - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get salesman numbers and order numbers for salesman -- <comment> who have orders for parts costing > 50000 @@ -990,7 +990,7 @@ LOG aqatdml08 Clear; from odetail,parts where odetail.partnum = parts.partnum and price > 50000 - for repeatable access + for read committed access ); -- <comment> get supplier numbers for suppliers who are in the same state @@ -1002,9 +1002,9 @@ LOG aqatdml08 Clear; (select Y.state from supplier Y where suppnum = 1 - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get customer names for customers who have not ordered parts -- <comment> stored at location 'V67' @@ -1015,7 +1015,7 @@ LOG aqatdml08 Clear; (select col_12 from partsfor where col_2 = 'V67' - for browse access + for read committed access ); -- <comment> same as above, only use a join instead of the view partsfor @@ -1028,7 +1028,7 @@ LOG aqatdml08 Clear; where ( orders.ordernum = odetail.ordernum) and ( odetail.partnum = parts.partnum) and (location = 'V67') - for repeatable access + for read committed access ); -- <comment> get supplier names for suppliers who supply part 4102 @@ -1040,13 +1040,13 @@ LOG aqatdml08 Clear; (select suppnum from fromsup where partnum = 4102 - for browse access + for read committed access ) and suppnum =ANY (select suppnum from fromsup where partnum = 5504 - for stable access + for read committed access ); @@ -1062,11 +1062,11 @@ LOG aqatdml08 Clear; (select partnum from parts where inventory < 0 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get age of those employees whose salary is less than or -- <comment> equal to the salary of the youngest employee (use aliases) @@ -1079,11 +1079,11 @@ LOG aqatdml08 Clear; where Y.age <= ALL (select Z.age from employee Z - for repeatable access + for read committed access ) - for stable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get salesman names who have orders for parts priced < 8000 -- <comment> (eliminate duplicate salesman names,order numbers, and @@ -1099,11 +1099,11 @@ LOG aqatdml08 Clear; (select distinct price from parts where price = 8000 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get salesman names and their customer names for salesman -- <comment> who work in the Central region @@ -1117,11 +1117,11 @@ LOG aqatdml08 Clear; (select regnum from region where regname = 'Central' - for stable access + for read committed access ) - for repeatable access + for read committed access ) - for browse access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml09 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml09 b/core/sql/regress/qat/qatdml09 index 07289db..264f0f3 100755 --- a/core/sql/regress/qat/qatdml09 +++ b/core/sql/regress/qat/qatdml09 @@ -37,8 +37,8 @@ LOG aqatdml09 Clear; -- connected with AND,OR, and SELECTs with subqueries -- (uncorrelated) in both the WHERE clause and HAVING -- clause --- testcase A4: subqueries with for browse access, --- for stable access, for repeatable access +-- testcase A4: subqueries with for read committed access, +-- for read committed access, for read committed access -- testcase A5: SELECT aggregate functions with aggregates in -- subquery @@ -1118,8 +1118,8 @@ LOG aqatdml09 Clear; -- <detail> -- uncorrelated subquery in having clause test - this tests the use of --- for browse access, for stable access, --- and for repeatable access in uncorrelated subqueries. +-- for read committed access, for read committed access, +-- and for read committed access in uncorrelated subqueries. -- <templates> @@ -1136,9 +1136,9 @@ LOG aqatdml09 Clear; (select partnum from fromsup where suppnum = 15 - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get salesman numbers and order numbers for salesman @@ -1152,7 +1152,7 @@ LOG aqatdml09 Clear; from odetail,parts where odetail.partnum = parts.partnum and price > 50000 - for repeatable access + for read committed access ); -- <comment> get supplier numbers for suppliers who are in the same state @@ -1164,9 +1164,9 @@ LOG aqatdml09 Clear; (select Y.state from supplier Y where suppnum = 1 - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get customer numbers for customers who have not ordered parts -- <comment> stored at location 'V67' @@ -1178,7 +1178,7 @@ LOG aqatdml09 Clear; (select col_12 from partsfor where col_2 = 'V67' - for browse access + for read committed access ); -- <comment> same as above, only use a join instead of the view partsfor @@ -1192,7 +1192,7 @@ LOG aqatdml09 Clear; where ( orders.ordernum = odetail.ordernum) and ( odetail.partnum = parts.partnum) and (location = 'V67') - for repeatable access + for read committed access ); -- <comment> get supplier numbers for suppliers who supply part 4102 @@ -1205,13 +1205,13 @@ LOG aqatdml09 Clear; (select suppnum from fromsup where partnum = 4102 - for browse access) + for read committed access) ) and (suppnum =ANY (select suppnum from fromsup where partnum = 5504 - for stable access) + for read committed access) ); @@ -1229,11 +1229,11 @@ LOG aqatdml09 Clear; (select partnum from parts where inventory < 0 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get age of those employees whose salary is less than or -- <comment> equal to the salary of the youngest employee @@ -1248,11 +1248,11 @@ LOG aqatdml09 Clear; having Y.age <= ALL (select Z.age from employee Z - for repeatable access + for read committed access ) - for stable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get salesman names who have orders for parts priced < 8000 -- <comment> (eliminate duplicate salesman names,order numbers, and @@ -1271,11 +1271,11 @@ LOG aqatdml09 Clear; (select distinct price from parts where price = 8000 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get salesman names for salesman who work in the Central region -- <ufi-input> @@ -1290,11 +1290,11 @@ LOG aqatdml09 Clear; (select regnum from region where regname = 'CENTRAL' - for stable access + for read committed access ) - for repeatable access + for read committed access ) - for browse access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml10 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml10 b/core/sql/regress/qat/qatdml10 index b490c08..4f45b45 100755 --- a/core/sql/regress/qat/qatdml10 +++ b/core/sql/regress/qat/qatdml10 @@ -39,8 +39,8 @@ LOG aqatdml10 Clear; -- EXISTS/NOT EXISTS -- testcase A4: multiple nesting,multiple subqueries connected with -- and/or,mixed correlated/uncorrelated nested subqueries --- testcase A5: use of for browse access, --- for stable access,for repeatable access +-- testcase A5: use of for read committed access, +-- for read committed access,for read committed access -- testcase A6: SELECT aggregate functions with aggregates in -- subquery @@ -1613,8 +1613,8 @@ LOG aqatdml10 Clear; -- <detail> -- correlated subquery in where clause test - this tests the use of --- for browse access, for stable access, --- and for repeatable access inside of subqueries. +-- for read committed access, for read committed access, +-- and for read committed access inside of subqueries. -- <templates> -- US00 @@ -1627,9 +1627,9 @@ LOG aqatdml10 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for browse access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1639,9 +1639,9 @@ LOG aqatdml10 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1651,9 +1651,9 @@ LOG aqatdml10 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for repeatable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part names whose cost is greater than 10000 and whose -- <comment> price is equal to its' cost from at least one supplier @@ -1665,7 +1665,7 @@ LOG aqatdml10 Clear; (select partcost from expfroms where parts.partnum = expfroms.partnum - for repeatable access + for read committed access ); -- <comment> get part names for parts whose price is less than 2000 @@ -1678,7 +1678,7 @@ LOG aqatdml10 Clear; from fromsup where parts.partnum = fromsup.partnum group by partcost - for browse access + for read committed access ); -- <comment> get part names for parts who have the same price as at @@ -1690,9 +1690,9 @@ LOG aqatdml10 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for browse access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1703,9 +1703,9 @@ LOG aqatdml10 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for stable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1716,9 +1716,9 @@ LOG aqatdml10 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for repeatable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than @@ -1731,7 +1731,7 @@ LOG aqatdml10 Clear; from fromsup Y where Y.suppnum <> X.suppnum and X.partnum = Y.partnum - for repeatable access + for read committed access ); -- <comment> get supplier numbers for suppliers who supply at least @@ -1748,11 +1748,11 @@ LOG aqatdml10 Clear; from fromsup Z where X.suppnum = Z.suppnum and Z.partnum = Y.partnum - for browse access + for read committed access ) - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers for parts supplied to all customers -- <comment> in California @@ -1769,11 +1769,11 @@ LOG aqatdml10 Clear; from odetail Y where Y.partnum = X.partnum and orders.ordernum = Y.ordernum - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get supplier names for suppliers who supply part 4102 -- <comment> and part 5504 @@ -1784,13 +1784,13 @@ LOG aqatdml10 Clear; (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for repeatable access + for read committed access ) and 5504 =ANY (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for stable access + for read committed access ); -- <comment> get part numbers for all parts supplied by more than @@ -1807,11 +1807,11 @@ LOG aqatdml10 Clear; from fromsup Z where Z.suppnum <> Y.suppnum and Z.suppnum <> X.suppnum - for stable access + for read committed access ) - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> same as above, use view fsdetail instead -- <ufi-input> @@ -1826,11 +1826,11 @@ LOG aqatdml10 Clear; from fsdetail Z where Z.col_2 <> Y.col_2 and Z.col_2 <> X.col_2 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml11 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml11 b/core/sql/regress/qat/qatdml11 index 0b768e1..6132db2 100755 --- a/core/sql/regress/qat/qatdml11 +++ b/core/sql/regress/qat/qatdml11 @@ -43,8 +43,8 @@ LOG aqatdml11 Clear; -- EXISTS/NOT EXISTS -- testcase A4: multiple nesting,multiple subqueries connected with -- and/or,mixed correlated/uncorrelated nested subqueries --- testcase A5: use of for browse access, --- for stable access,for repeatable access +-- testcase A5: use of for read committed access, +-- for read committed access,for read committed access -- testcase A6: SELECT aggregate functions with aggregates in -- subquery @@ -1668,8 +1668,8 @@ LOG aqatdml11 Clear; -- <detail> -- correlated subquery in where clause test - this tests the use of --- for browse access, for stable access, --- and for repeatable access inside of subqueries. +-- for read committed access, for read committed access, +-- and for read committed access inside of subqueries. -- <templates> -- US00 @@ -1682,9 +1682,9 @@ LOG aqatdml11 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for browse access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1694,9 +1694,9 @@ LOG aqatdml11 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1706,9 +1706,9 @@ LOG aqatdml11 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for repeatable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part names whose cost is greater than 10000 and whose -- <comment> price is equal to its' cost from at least one supplier @@ -1720,7 +1720,7 @@ LOG aqatdml11 Clear; (select partcost from expfroms where parts.partnum = expfroms.partnum - for repeatable access + for read committed access ); -- <comment> get part names for parts whose price is less than 2000 @@ -1734,7 +1734,7 @@ LOG aqatdml11 Clear; from fromsup where parts.partnum = fromsup.partnum group by partcost - for browse access + for read committed access ); -- <comment> get part names for parts who have the same price as at @@ -1746,9 +1746,9 @@ LOG aqatdml11 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for browse access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1759,9 +1759,9 @@ LOG aqatdml11 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for stable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1772,9 +1772,9 @@ LOG aqatdml11 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for repeatable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than @@ -1787,7 +1787,7 @@ LOG aqatdml11 Clear; from fromsup Y where Y.suppnum <> X.suppnum and X.partnum = Y.partnum - for repeatable access + for read committed access ); -- <comment> get supplier numbers for suppliers who supply at least @@ -1805,11 +1805,11 @@ LOG aqatdml11 Clear; from fromsup Z where X.suppnum = Z.suppnum and Z.partnum = Y.partnum - for browse access + for read committed access ) - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers for parts supplied to all customers -- <comment> in California @@ -1826,11 +1826,11 @@ LOG aqatdml11 Clear; from odetail Y where Y.partnum = X.partnum and orders.ordernum = Y.ordernum - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get supplier names for suppliers who supply part 4102 -- <comment> and part 5504 @@ -1844,13 +1844,13 @@ LOG aqatdml11 Clear; (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for repeatable access + for read committed access ) and ?p1 =ANY (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for stable access + for read committed access ); -- <comment> get part numbers for all parts supplied by more than @@ -1867,11 +1867,11 @@ LOG aqatdml11 Clear; from fromsup Z where Z.suppnum <> Y.suppnum and Z.suppnum <> X.suppnum - for stable access + for read committed access ) - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> same as above, use view fsdetail instead -- <ufi-input> @@ -1886,11 +1886,11 @@ LOG aqatdml11 Clear; from fsdetail Z where Z.col_2 <> Y.col_2 and Z.col_2 <> X.col_2 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml14 ---------------------------------------------------------------------- diff --git a/core/sql/regress/qat/qatdml14 b/core/sql/regress/qat/qatdml14 index 31517ef..d2e0753 100755 --- a/core/sql/regress/qat/qatdml14 +++ b/core/sql/regress/qat/qatdml14 @@ -37,8 +37,8 @@ LOG aqatdml14 Clear; -- NOT EXISTS -- testcase A3: multiple nesting,multiple subqueries connected with -- and/or,mixed correlated/uncorrelated nested subqueries --- testcase A4: use of for browse access, --- for stable access,for repeatable access +-- testcase A4: use of for read committed access, +-- for read committed access,for read committed access -- testcase A5: SELECT aggregate functions with aggregates in -- subquery @@ -1396,8 +1396,8 @@ LOG aqatdml14 Clear; -- <detail> -- correlated subquery in having clause test - this tests the use of --- for browse access, for stable access, --- and for repeatable access inside of subqueries. +-- for read committed access, for read committed access, +-- and for read committed access inside of subqueries. -- <templates> -- US00 @@ -1411,9 +1411,9 @@ LOG aqatdml14 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for browse access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1424,9 +1424,9 @@ LOG aqatdml14 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than one supplier -- <ufi-input> @@ -1437,9 +1437,9 @@ LOG aqatdml14 Clear; (select distinct Y.partnum from fromsup Y where Y.suppnum <> X.suppnum - for repeatable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get part numbers whose cost is greater than 10000 and whose -- <comment> price is equal to its' cost from at least one supplier @@ -1452,7 +1452,7 @@ LOG aqatdml14 Clear; (select partcost from expfroms where parts.partnum = expfroms.partnum - for repeatable access + for read committed access ); -- <comment> get part numbers for parts whose price is less than 2000 @@ -1466,7 +1466,7 @@ LOG aqatdml14 Clear; from fromsup where parts.partnum = fromsup.partnum group by partcost - for browse access + for read committed access ); -- <comment> get part names for parts who have the same price as at @@ -1479,9 +1479,9 @@ LOG aqatdml14 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for browse access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1493,9 +1493,9 @@ LOG aqatdml14 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for stable access + for read committed access ) - for stable access; + for read committed access; -- <comment> get part names for parts who have the same price as at -- <comment> least one other part @@ -1507,9 +1507,9 @@ LOG aqatdml14 Clear; (select Y.col_3 from partsfor Y where X.col_1 <> Y.col_1 - for repeatable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than -- <comment> one supplier @@ -1522,7 +1522,7 @@ LOG aqatdml14 Clear; from fromsup Y where Y.suppnum <> X.suppnum and X.partnum = Y.partnum - for repeatable access + for read committed access ); @@ -1536,13 +1536,13 @@ LOG aqatdml14 Clear; (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for repeatable access + for read committed access ) and 5504 =ANY (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for stable access + for read committed access ); -- <comment> get supplier numbers for suppliers who supply part 4102 @@ -1555,14 +1555,14 @@ LOG aqatdml14 Clear; (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for repeatable access + for read committed access ) group by suppnum having 5504 =ANY (select partnum from fromsup where fromsup.suppnum = supplier.suppnum - for browse access + for read committed access ); -- <comment> get employee names for employees who do not work at branches @@ -1582,11 +1582,11 @@ LOG aqatdml14 Clear; (select location from region where region.regnum = employee.regnum - for browse access + for read committed access ) - for stable access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> get employee names for employees who do not work at branches -- <comment> which are in the same city as the regional headquarters @@ -1604,11 +1604,11 @@ LOG aqatdml14 Clear; (select location from region where region.regnum = employee.regnum - for repeatable access + for read committed access ) - for stable access + for read committed access ) - for browse access; + for read committed access; -- <comment> get part numbers for all parts supplied by more than -- <comment> two suppliers @@ -1627,11 +1627,11 @@ LOG aqatdml14 Clear; from fromsup Z where Z.suppnum <> Y.suppnum and Z.suppnum <> X.suppnum - for stable access + for read committed access ) - for browse access + for read committed access ) - for repeatable access; + for read committed access; -- <comment> same as above, use view fsdetail instead -- <ufi-input> @@ -1648,11 +1648,11 @@ LOG aqatdml14 Clear; from fsdetail Z where Z.col_2 <> Y.col_2 and Z.col_2 <> X.col_2 - for browse access + for read committed access ) - for repeatable access + for read committed access ) - for stable access; + for read committed access; -- <comment> same as above, except use table fromsup instead of fsdetail -- <comment> for one of the fsdetail occurences @@ -1670,11 +1670,11 @@ LOG aqatdml14 Clear; from fsdetail Z where Z.col_2 <> Y.col_2 and Z.col_2 <> fromsup.suppnum - for repeatable access + for read committed access ) - for repeatable access + for read committed access ) - for repeatable access; + for read committed access; -- <end-input> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/seabase/EXPECTED011 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011 index 7b54686..a35bcfd 100644 --- a/core/sql/regress/seabase/EXPECTED011 +++ b/core/sql/regress/seabase/EXPECTED011 @@ -7,7 +7,7 @@ >>invoke T011T1; -- Definition of Trafodion table TRAFODION.SCH.T011T1 --- Definition current Wed Dec 6 19:43:45 2017 +-- Definition current Mon Sep 18 16:13:32 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -143,7 +143,7 @@ A B ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... NOT NAMED -PLAN_ID .................. 212379349426943450 +PLAN_ID .................. 212372511214096121 ROWS_OUT ................. 7 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t011t1 where a >= 3 and a < 5; @@ -182,7 +182,7 @@ DESCRIPTION QUERY_CACHE ............ 0 TRAF_ALIGNED_ROW_FORMAT OFF GENERATE_EXPLAIN ....... ON - ObjectUIDs ............. 3014744217526141194 + ObjectUIDs ............. 2068981457564705177 select_list ............ TRAFODION.SCH.T011T1.A, TRAFODION.SCH.T011T1.B @@ -1300,7 +1300,7 @@ METRIC_TEXT_TABLE >>invoke trafodion."_REPOS_".metric_query_table; -- Definition of Trafodion table TRAFODION."_REPOS_".METRIC_QUERY_TABLE --- Definition current Wed Dec 6 19:46:03 2017 +-- Definition current Mon Sep 18 16:15:51 2017 ( INSTANCE_ID INT UNSIGNED NO DEFAULT NOT NULL NOT @@ -1488,7 +1488,7 @@ METRIC_TEXT_TABLE >>-- get qid for the prepared stmt >>get qid for statement explstmt; -MXID11000005355212379349395122217000000000206U3333300_2289_EXPLSTMT +MXID11000003675212372511181547316000000000206U3333300_2377_EXPLSTMT --- SQL operation complete. >> @@ -1540,7 +1540,7 @@ SEQ_NUM OPERATOR --- SQL command prepared. >>get qid for statement explstmt2; -MXID11000005355212379349395122217000000000206U3333300_2300_EXPLSTMT2 +MXID11000003675212372511181547316000000000206U3333300_2388_EXPLSTMT2 --- SQL operation complete. >>set qid MXID123456 for explstmt2; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/seabase/FILTER034 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/FILTER034 b/core/sql/regress/seabase/FILTER034 new file mode 100755 index 0000000..cd1e2ec --- /dev/null +++ b/core/sql/regress/seabase/FILTER034 @@ -0,0 +1,33 @@ +#! /bin/sh +# @@@ START COPYRIGHT @@@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# +# @@@ END COPYRIGHT @@@ + +# Like the pattern-masking of QACOMP, here we filter out such stuff as +# transaction id. Called by the runregr script before doing diff. + +fil=$1 +sed " +s/^\([ ]*RegionServer:[ ]*[\.]*\) .*/\1 RegionServer removed/g +s/^\([ ]*RegionName:[ ]*[\.]*\) .*/\1 RegionName removed/g +#s/\(RegionName:[ ]*TRAFODION.[A-Z0-9._]*\/\)[A-Za-z0-9]*/\1REGION-NAME/g +s/Table ID: *[0-9]*/Table ID: <ID removed>/g +s:^[ ]\{0,9\}[0-9]\{1,10\}:0000000000: +" $fil http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/seabase/TEST025 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/TEST025 b/core/sql/regress/seabase/TEST025 index aa02507..55c0d0f 100644 --- a/core/sql/regress/seabase/TEST025 +++ b/core/sql/regress/seabase/TEST025 @@ -38,6 +38,7 @@ drop table T025T010; drop table T025T010s; ?section prep +cqd TRAF_USE_REGION_XN 'OFF'; create schema S025; set schema S025; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/tools/runregr_privs1.ksh ---------------------------------------------------------------------- diff --git a/core/sql/regress/tools/runregr_privs1.ksh b/core/sql/regress/tools/runregr_privs1.ksh index b1cade3..5836754 100755 --- a/core/sql/regress/tools/runregr_privs1.ksh +++ b/core/sql/regress/tools/runregr_privs1.ksh @@ -286,8 +286,10 @@ for ix in $testfiles; do efile=$REGRTSTDIR/$exp fi - sqlci -i $scriptsdir/tools/reg_users.sql; - echo "Authorization has been enabled" + if [ $diffsonly -eq 0 ]; then + sqlci -i $scriptsdir/tools/reg_users.sql; + echo "Authorization has been enabled" + fi #-------------------------------------------------- # Run test if the -diff option not specified -- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/tools/runregr_privs2.ksh ---------------------------------------------------------------------- diff --git a/core/sql/regress/tools/runregr_privs2.ksh b/core/sql/regress/tools/runregr_privs2.ksh index 364decd..d13503a 100755 --- a/core/sql/regress/tools/runregr_privs2.ksh +++ b/core/sql/regress/tools/runregr_privs2.ksh @@ -286,8 +286,10 @@ for ix in $testfiles; do efile=$REGRTSTDIR/$exp fi - sqlci -i $scriptsdir/tools/reg_users.sql; - echo "Authorization has been enabled" + if [ $diffsonly -eq 0 ]; then + sqlci -i $scriptsdir/tools/reg_users.sql; + echo "Authorization has been enabled" + fi #-------------------------------------------------- # Run test if the -diff option not specified -- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/sqlcomp/CmpSeabaseDDLindex.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/CmpSeabaseDDLindex.cpp b/core/sql/sqlcomp/CmpSeabaseDDLindex.cpp index 29844c2..2e4c5a0 100644 --- a/core/sql/sqlcomp/CmpSeabaseDDLindex.cpp +++ b/core/sql/sqlcomp/CmpSeabaseDDLindex.cpp @@ -1138,7 +1138,7 @@ short CmpSeabaseDDL::populateSeabaseIndexFromTable( else query += tableName.getExternalName(TRUE); - query += " for read uncommitted access; "; + query += " ; "; UInt32 savedCliParserFlags = 0; SQL_EXEC_GetParserFlagsForExSqlComp_Internal(savedCliParserFlags); http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/ustat/hs_globals.cpp ---------------------------------------------------------------------- diff --git a/core/sql/ustat/hs_globals.cpp b/core/sql/ustat/hs_globals.cpp index 04ca770..5fc1ce5 100644 --- a/core/sql/ustat/hs_globals.cpp +++ b/core/sql/ustat/hs_globals.cpp @@ -8528,7 +8528,7 @@ Lng32 HSGlobalsClass::groupListFromTable(HSColGroupStruct*& groupList, sprintf(sbuf, PF64, objID); qry.append(sbuf); qry.append( " ORDER BY TABLE_UID, HISTOGRAM_ID, COL_POSITION "); - qry.append( " FOR SERIALIZABLE ACCESS"); + qry.append( " FOR READ COMMITTED ACCESS"); HSCursor cursor103; retcode = cursor103.prepareQuery(qry.data(), 0, 6);
