You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2017/12/13 19:02:24 UTC
[02/12] incubator-trafodion git commit: JIRA TRAFODION-2834
Streamline supported xn access modes
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml11
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml11 b/core/sql/regress/qat/eqatdml11
index 23722c0..9aa5d51 100755
--- a/core/sql/regress/qat/eqatdml11
+++ b/core/sql/regress/qat/eqatdml11
@@ -42,8 +42,8 @@
>>-- 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
>>
@@ -82,12 +82,12 @@
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -101,12 +101,12 @@ MAGNETICS CORP
+> from fromsup
+> where supplier.suppnum = fromsup.suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -120,13 +120,13 @@ MAGNETICS CORP
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DISPLAY INC
-STEELWORK INC
-TANDEM COMPUTERS
+DATA TERMINAL CO
+DISPLAY INC
+STEELWORK INC
+TANDEM COMPUTERS
--- 4 row(s) selected.
>>
@@ -140,12 +140,12 @@ TANDEM COMPUTERS
+> from fromsup
+> where X.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -161,24 +161,24 @@ MAGNETICS CORP
+> group by partcost
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -195,24 +195,24 @@ ASYNC EXTENSION
+> having partcost <> ?p
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -227,24 +227,24 @@ ASYNC EXTENSION
+> where parts.partnum = fromsup.partnum
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -258,10 +258,10 @@ ASYNC EXTENSION
+> from empone
+> where empone.empnum = region.manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -274,10 +274,10 @@ HEADQUARTERS
+> from empone
+> where empnum = manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -291,17 +291,17 @@ HEADQUARTERS
+> where Y.suppnum <> X.suppnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -316,17 +316,17 @@ PARTNUM
+> where Y.suppnum <> X.suppnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -341,17 +341,17 @@ PARTNUM
+> group by Y.partnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -367,17 +367,17 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -393,17 +393,17 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -421,16 +421,16 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -448,16 +448,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> (?p + 3);
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -475,16 +475,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> (?p + 3);
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -500,17 +500,17 @@ PARTNUM
+> where ( odetail.partnum = parts.partnum)
+> and ( orders.ordernum = odetail.ordernum) );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -524,17 +524,17 @@ SALESMAN ORDERNUM
+> where ( odetail.partnum = parts.partnum)
+> and ( orders.ordernum = odetail.ordernum) );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -550,17 +550,17 @@ SALESMAN ORDERNUM
+> and ( orders.ordernum = odetail.ordernum)
+> group by parts.location );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -575,17 +575,17 @@ SALESMAN ORDERNUM
+> and ( orders.ordernum = odetail.ordernum) )
+> order by ordernum;
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 222 30
+ 204 32
+ 218 38
+ 207 41
+ 212 45
+ 225 48
+ 205 66
+ 221 122
--- 8 row(s) selected.
>>
@@ -601,13 +601,13 @@ SALESMAN ORDERNUM
+> where parts.partnum = expfroms.partnum
+> );
-PARTNAME
-------------------
+PARTNAME
+------------------
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DISC CONT DUAL
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DISC CONT DUAL
--- 4 row(s) selected.
>>
@@ -623,11 +623,11 @@ DISC CONT DUAL
+> where Y.ordernum < X.ordernum
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -644,28 +644,28 @@ SALESMAN
+> group by branchnum
+> );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -678,28 +678,28 @@ DAVE CLARK
+> from branch
+> where employee.branchnum = branch.branchnum );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -715,28 +715,28 @@ DAVE CLARK
+> having branchnum = employee.branchnum
+> );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -752,13 +752,13 @@ DAVE CLARK
+> where Y.partnum = X.partnum
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 2
- 6
- 8
- 15
+ 6
+ 15
+ 8
+ 2
--- 4 row(s) selected.
>>
@@ -774,13 +774,13 @@ SUPPNUM
+> where Y.state = X.state
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -796,20 +796,20 @@ SUPPNUM
+> where custnum = col_12
+> );
-CUSTNAME
-------------------
+CUSTNAME
+------------------
-BROWN MEDICAL CO
-CENTRAL UNIVERSITY
-DATASPEED
-DEUTSCHE STAHL
-FRESNO STATE BANK
-METALL-AG.
-MOTOR DISTRIBUTING
-PREMIER INSURANCE
-SLEEPWELL HOTELS
-STEVENS SUPPLY
-VEREINIGTE CHEMIE
+BROWN MEDICAL CO
+CENTRAL UNIVERSITY
+DATASPEED
+DEUTSCHE STAHL
+FRESNO STATE BANK
+METALL-AG.
+MOTOR DISTRIBUTING
+PREMIER INSURANCE
+SLEEPWELL HOTELS
+STEVENS SUPPLY
+VEREINIGTE CHEMIE
--- 11 row(s) selected.
>>
@@ -839,10 +839,10 @@ VEREINIGTE CHEMIE
+> from region
+> where manager = empnum);
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
+JACK RAYMOND
--- 1 row(s) selected.
>>
@@ -856,10 +856,10 @@ JACK RAYMOND
+> from region
+> where region.manager = employee.empnum);
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
+JACK RAYMOND
--- 1 row(s) selected.
>>
@@ -874,19 +874,19 @@ JACK RAYMOND
+> where customer.custnum = partsfor.col_12
+> );
-CUSTNAME
-------------------
+CUSTNAME
+------------------
-BESTFOOD MARKETS
-BROWN MEDICAL CO
-CENTRAL UNIVERSITY
-DATASPEED
-DEUTSCHE STAHL
-FRESNO STATE BANK
-METALL-AG.
-MOTOR DISTRIBUTING
-STEVENS SUPPLY
-VEREINIGTE CHEMIE
+BESTFOOD MARKETS
+BROWN MEDICAL CO
+CENTRAL UNIVERSITY
+DATASPEED
+DEUTSCHE STAHL
+FRESNO STATE BANK
+METALL-AG.
+MOTOR DISTRIBUTING
+STEVENS SUPPLY
+VEREINIGTE CHEMIE
--- 10 row(s) selected.
>>
@@ -901,19 +901,19 @@ VEREINIGTE CHEMIE
+> ( odetail.partnum = parts.partnum) and
+> ( customer.custnum = orders.custnum) );
-CUSTNAME
-------------------
+CUSTNAME
+------------------
-BESTFOOD MARKETS
-BROWN MEDICAL CO
-CENTRAL UNIVERSITY
-DATASPEED
-DEUTSCHE STAHL
-FRESNO STATE BANK
-METALL-AG.
-MOTOR DISTRIBUTING
-STEVENS SUPPLY
-VEREINIGTE CHEMIE
+BESTFOOD MARKETS
+BROWN MEDICAL CO
+CENTRAL UNIVERSITY
+DATASPEED
+DEUTSCHE STAHL
+FRESNO STATE BANK
+METALL-AG.
+MOTOR DISTRIBUTING
+STEVENS SUPPLY
+VEREINIGTE CHEMIE
--- 10 row(s) selected.
>>
@@ -930,30 +930,30 @@ VEREINIGTE CHEMIE
+> group by partcost
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-MAG TAPE DR 800BPI
-MAG TAPE DR 8/16
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
-TERM CRT CHAR
-TERM CRT PAGE
-TERM HARD COPY
-POWER MODULE
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
+TERM CRT CHAR
+TERM CRT PAGE
+TERM HARD COPY
+POWER MODULE
--- 21 row(s) selected.
>>
@@ -968,36 +968,36 @@ POWER MODULE
+> where X.col_1 <> Y.col_1
+> );
-COL_1
-------------------
-
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-MAG TAPE CONT 8/16
-DISC 10MB
-DISC 10MB
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-TERM CRT CHAR
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
+COL_1
+------------------
+
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+MAG TAPE CONT 8/16
+DISC 10MB
+DISC 10MB
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+TERM CRT CHAR
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
--- 27 row(s) selected.
>>
@@ -1015,21 +1015,21 @@ TERM CRT PAGE
+> and X.partnum = Y.partnum
+> );
-SUPPNUM PARTNUM
-------- -------
+SUPPNUM PARTNUM
+------- -------
- 6 4101
- 15 4101
- 6 4102
- 15 4102
- 8 4103
- 15 4103
- 8 5101
- 8 5103
- 2 5504
- 6 5504
- 3 6401
- 2 6402
+ 6 4101
+ 15 4101
+ 6 4102
+ 15 4102
+ 8 4103
+ 15 4103
+ 8 5101
+ 8 5103
+ 2 5504
+ 6 5504
+ 3 6401
+ 2 6402
--- 12 row(s) selected.
>>
@@ -1044,21 +1044,21 @@ SUPPNUM PARTNUM
+> and X.partnum = Y.partnum
+> );
-SUPPNUM PARTNUM
-------- -------
+SUPPNUM PARTNUM
+------- -------
- 6 4101
- 15 4101
- 6 4102
- 15 4102
- 8 4103
- 15 4103
- 8 5101
- 8 5103
- 2 5504
- 6 5504
- 3 6401
- 2 6402
+ 6 4101
+ 15 4101
+ 6 4102
+ 15 4102
+ 8 4103
+ 15 4103
+ 8 5101
+ 8 5103
+ 2 5504
+ 6 5504
+ 3 6401
+ 2 6402
--- 12 row(s) selected.
>>
@@ -1073,36 +1073,36 @@ SUPPNUM PARTNUM
+> and X.partnum = Y.partnum
+> );
-SUPPNUM PARTNUM
-------- -------
-
- 1 212
- 1 244
- 1 1403
- 1 2001
- 1 2002
- 1 2003
- 1 2402
- 1 2403
- 1 3102
- 1 3103
- 1 3201
- 1 3302
- 6 4102
- 8 4103
- 8 5101
- 8 5103
- 2 5502
- 6 5504
- 15 5505
- 1 6201
- 1 6301
- 1 6302
- 3 6401
- 2 6402
- 2 6603
- 10 7102
- 1 7301
+SUPPNUM PARTNUM
+------- -------
+
+ 1 212
+ 1 244
+ 1 1403
+ 1 2001
+ 1 2002
+ 1 2003
+ 1 2402
+ 1 2403
+ 1 3102
+ 1 3103
+ 1 3201
+ 1 3302
+ 6 4102
+ 8 4103
+ 8 5101
+ 8 5103
+ 2 5502
+ 6 5504
+ 15 5505
+ 1 6201
+ 1 6301
+ 1 6302
+ 3 6401
+ 2 6402
+ 2 6603
+ 10 7102
+ 1 7301
--- 27 row(s) selected.
>>
@@ -1120,12 +1120,12 @@ SUPPNUM PARTNUM
+> and (Y.suppnum = ?p)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 2
- 6
- 8
+ 6
+ 8
+ 2
--- 3 row(s) selected.
>>
@@ -1140,13 +1140,13 @@ SUPPNUM
+> where X.state = Y.state
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -1160,12 +1160,12 @@ SUPPNUM
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1178,12 +1178,12 @@ MAGNETICS CORP
+> from fromsup
+> where supplier.suppnum = fromsup.suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1196,16 +1196,16 @@ MAGNETICS CORP
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DATADRIVE
-DISPLAY INC
-INFOMATION STORAGE
-MAGNETICS CORP
-STEELWORK INC
-TANDEM COMPUTERS
+DATA TERMINAL CO
+DATADRIVE
+DISPLAY INC
+INFOMATION STORAGE
+MAGNETICS CORP
+STEELWORK INC
+TANDEM COMPUTERS
--- 7 row(s) selected.
>>
@@ -1218,12 +1218,12 @@ TANDEM COMPUTERS
+> from fromsup
+> where X.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1239,24 +1239,24 @@ MAGNETICS CORP
+> group by partcost
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -1273,24 +1273,24 @@ ASYNC EXTENSION
+> having partcost <> ?p
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -1305,24 +1305,24 @@ ASYNC EXTENSION
+> where parts.partnum = fromsup.partnum
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
--- 15 row(s) selected.
>>
@@ -1337,10 +1337,10 @@ ASYNC EXTENSION
+> from empone
+> where empone.empnum = region.manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1353,10 +1353,10 @@ HEADQUARTERS
+> from empone
+> where empnum = manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1370,17 +1370,17 @@ HEADQUARTERS
+> where Y.suppnum <> X.suppnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -1395,17 +1395,17 @@ PARTNUM
+> where Y.suppnum <> X.suppnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -1420,17 +1420,17 @@ PARTNUM
+> group by Y.partnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -1446,17 +1446,17 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -1472,17 +1472,17 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -1500,16 +1500,16 @@ PARTNUM
+> )
+> group by X.partnum;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -1527,16 +1527,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> ?p;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -1554,16 +1554,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> ?p;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -1579,17 +1579,17 @@ PARTNUM
+> where ( odetail.partnum = parts.partnum)
+> and ( orders.ordernum = odetail.ordernum) );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -1603,17 +1603,17 @@ SALESMAN ORDERNUM
+> where ( odetail.partnum = parts.partnum)
+> and ( orders.ordernum = odetail.ordernum) );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -1629,17 +1629,17 @@ SALESMAN ORDERNUM
+> and ( orders.ordernum = odetail.ordernum)
+> group by parts.location );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -1654,17 +1654,17 @@ SALESMAN ORDERNUM
+> and ( orders.ordernum = odetail.ordernum) )
+> order by ordernum;
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 222 30
+ 204 32
+ 218 38
+ 207 41
+ 212 45
+ 225 48
+ 205 66
+ 221 122
--- 8 row(s) selected.
>>
@@ -1680,13 +1680,13 @@ SALESMAN ORDERNUM
+> where parts.partnum = expfroms.partnum
+> );
-PARTNAME
-------------------
+PARTNAME
+------------------
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DISC CONT DUAL
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DISC CONT DUAL
--- 4 row(s) selected.
>>
@@ -1702,11 +1702,11 @@ DISC CONT DUAL
+> where Y.ordernum < X.ordernum
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -1723,28 +1723,28 @@ SALESMAN
+> group by branchnum
+> );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -1757,28 +1757,28 @@ DAVE CLARK
+> from branch
+> where employee.branchnum = branch.branchnum );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -1794,28 +1794,28 @@ DAVE CLARK
+> having branchnum = employee.branchnum
+> );
-EMPNAME
-------------------
-
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+EMPNAME
+------------------
+
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -1831,14 +1831,14 @@ DAVE CLARK
+> where empone.empnum = region.manager
+> );
-REGNAME
-------------
+REGNAME
+------------
-EAST
-WEST
-GERMANY
-ENGLAND
-HEADQUARTERS
+EAST
+WEST
+GERMANY
+ENGLAND
+HEADQUARTERS
--- 5 row(s) selected.
>>
@@ -1854,21 +1854,21 @@ HEADQUARTERS
+> where custnum = col_12
+> );
-CUSTNAME
-------------------
+CUSTNAME
+------------------
-BESTFOOD MARKETS
-BROWN MEDICAL CO
-CENTRAL UNIVERSITY
-DATASPEED
-DEUTSCHE STAHL
-FRESNO STATE BANK
-METALL-AG.
-MOTOR DISTRIBUTING
-PREMIER INSURANCE
-SLEEPWELL HOTELS
-STEVENS SUPPLY
-VEREINIGTE CHEMIE
+BESTFOOD MARKETS
+BROWN MEDICAL CO
+CENTRAL UNIVERSITY
+DATASPEED
+DEUTSCHE STAHL
+FRESNO STATE BANK
+METALL-AG.
+MOTOR DISTRIBUTING
+PREMIER INSURANCE
+SLEEPWELL HOTELS
+STEVENS SUPPLY
+VEREINIGTE CHEMIE
--- 12 row(s) selected.
>>
@@ -1898,12 +1898,12 @@ VEREINIGTE CHEMIE
+> and partnum = ?p
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1918,12 +1918,12 @@ MAGNETICS CORP
+> and partnum = ?p
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1938,13 +1938,13 @@ MAGNETICS CORP
+> and partnum = ?p
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DISPLAY INC
-STEELWORK INC
-TANDEM COMPUTERS
+DATA TERMINAL CO
+DISPLAY INC
+STEELWORK INC
+TANDEM COMPUTERS
--- 4 row(s) selected.
>>
@@ -1961,10 +1961,10 @@ TANDEM COMPUTERS
+> and empnum = ?p
+> );
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1980,17 +1980,17 @@ HEADQUARTERS
+> and X.partnum = Y.partnum
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -2007,17 +2007,17 @@ PARTNUM
+> and ( orders.ordernum = odetail.ordernum) and
+> ( parts.location = ?p) );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 222 30
- 204 32
- 218 38
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 204 32
+ 205 66
+ 207 41
+ 212 45
+ 218 38
+ 221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -2033,13 +2033,13 @@ SALESMAN ORDERNUM
+> and (price = partcost)
+> );
-PARTNAME
-------------------
+PARTNAME
+------------------
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DISC CONT DUAL
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DISC CONT DUAL
--- 4 row(s) selected.
>>
@@ -2055,11 +2055,11 @@ DISC CONT DUAL
+> and (X.salesman = Y.salesman)
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -2077,28 +2077,28 @@ SALESMAN
+> group by branchnum
+> );
-EMPNAME
+EMPNAME
------------------
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -2116,28 +2116,28 @@ DAVE CLARK
+> having branchnum = ?p
+> );
-EMPNAME
+EMPNAME
------------------
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PETER SMITH
+DONALD TAYLOR
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+GEORGE FORSTER
+RICHARD BARTON
+JIMMY SCHNEIDER
+WALTER LANCASTER
+JOHN JONES
+MARLENE BONNY
+GEORGE FRENCHMAN
+DAVID TERRY
+KARL HELMSTED
+HEIDI WEIGL
+XAVER SEDLMEYER
+DAVE CLARK
--- 19 row(s) selected.
>>
@@ -2154,13 +2154,13 @@ DAVE CLARK
+> and (suppnum = ?p)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
- 8
- 2
+ 6
+ 15
+ 8
+ 2
--- 4 row(s) selected.
>>
@@ -2177,13 +2177,13 @@ SUPPNUM
+> and (suppnum = ?p)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -2200,20 +2200,20 @@ SUPPNUM
+> and (col_2 = ?p)
+> );
-CUSTNAME
-------------------
+CUSTNAME
+------------------
-BROWN MEDICAL CO
-CENTRAL UNIVERSITY
-DATASPEED
-DEUTSCHE STAHL
-FRESNO STATE BANK
-METALL-AG.
-MOTOR DISTRIBUTING
-PREMIER INSURANCE
-SLEEPWELL HOTELS
-STEVENS SUPPLY
-VEREINIGTE CHEMIE
+BROWN MEDICAL CO
+CENTRAL UNIVERSITY
+DATASPEED
+DEUTSCHE STAHL
+FRESNO STATE BANK
+METALL-AG.
+MOTOR DISTRIBUTING
+PREMIER INSURANCE
+SLEEPWELL HOTELS
+STEVENS SUPPLY
+VEREINIGTE CHEMIE
--- 11 row(s) selected.
>>
@@ -2249,10 +2249,10 @@ VEREINIGTE CHEMIE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2273,10 +2273,10 @@ DATADRIVE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2296,10 +2296,10 @@ DATADRIVE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2321,11 +2321,11 @@ DATADRIVE
+> )
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
+ 6
+ 15
--- 2 row(s) selected.
>>
@@ -2348,11 +2348,11 @@ SUPPNUM
+> )
+> group by suppnum;
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
+ 6
+ 15
--- 2 row(s) selected.
>>
@@ -2383,21 +2383,21 @@ SUPPNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 1234
- 7777
- 926
- 21
- 543
- 123
- 7654
- 324
- 3333
- 143
- 3210
- 5635
+ 21
+ 123
+ 143
+ 324
+ 543
+ 926
+ 1234
+ 3210
+ 3333
+ 5635
+ 7654
+ 7777
--- 12 row(s) selected.
>>
@@ -2424,21 +2424,21 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 1234
- 7777
- 926
- 21
- 543
- 123
- 7654
- 324
- 3333
- 143
- 3210
- 5635
+ 21
+ 123
+ 143
+ 324
+ 543
+ 926
+ 1234
+ 3210
+ 3333
+ 5635
+ 7654
+ 7777
--- 12 row(s) selected.
>>
@@ -2460,38 +2460,38 @@ CUSTNUM
+> )
+> );
-PARTNUM
--------
-
- 244
- 2001
- 2403
- 4103
- 5103
- 6301
- 6402
- 2002
- 2003
- 3102
- 4101
- 6302
- 2402
- 3202
- 3302
- 4102
- 5504
- 6201
- 3103
- 5503
- 5502
- 1403
- 7301
- 212
- 7102
- 5505
- 5101
- 6401
- 3201
+PARTNUM
+-------
+
+ 212
+ 244
+ 1403
+ 2001
+ 2002
+ 2003
+ 2402
+ 2403
+ 3102
+ 3103
+ 3201
+ 3202
+ 3302
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5502
+ 5503
+ 5504
+ 5505
+ 6201
+ 6301
+ 6302
+ 6401
+ 6402
+ 7102
+ 7301
--- 29 row(s) selected.
>>
@@ -2515,38 +2515,38 @@ PARTNUM
+> )
+> );
-PARTNUM
--------
-
- 244
- 2001
- 2403
- 4103
- 5103
- 6301
- 6402
- 2002
- 2003
- 3102
- 4101
- 6302
- 2402
- 3202
- 3302
- 4102
- 5504
- 6201
- 3103
- 5503
- 5502
- 1403
- 7301
- 212
- 7102
- 5505
- 5101
- 6401
- 3201
+PARTNUM
+-------
+
+ 212
+ 244
+ 1403
+ 2001
+ 2002
+ 2003
+ 2402
+ 2403
+ 3102
+ 3103
+ 3201
+ 3202
+ 3302
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5502
+ 5503
+ 5504
+ 5505
+ 6201
+ 6301
+ 6302
+ 6401
+ 6402
+ 7102
+ 7301
--- 29 row(s) selected.
>>
@@ -2566,10 +2566,10 @@ PARTNUM
+> and orders.ordernum = odetail.ordernum )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2593,10 +2593,10 @@ CUSTNUM
+> and orders.ordernum = odetail.ordernum )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2622,10 +2622,10 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2647,13 +2647,13 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 1234
- 926
- 7654
- 324
+ 324
+ 926
+ 1234
+ 7654
--- 4 row(s) selected.
>>
@@ -2674,11 +2674,11 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 143
- 3210
+ 143
+ 3210
--- 2 row(s) selected.
>>
@@ -2702,11 +2702,11 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 143
- 3210
+ 143
+ 3210
--- 2 row(s) selected.
>>
@@ -2746,32 +2746,32 @@ CUSTNUM
+> )
+> );
-SUPPNUM
--------
-
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 15
- 15
- 15
- 15
- 15
- 15
- 15
- 1
- 1
- 1
- 1
+SUPPNUM
+-------
+
+ 1
+ 1
+ 1
+ 1
+ 15
+ 15
+ 15
+ 15
+ 1
+ 1
+ 1
+ 1
+ 1
+ 15
+ 15
+ 1
+ 1
+ 1
+ 1
+ 1
+ 15
+ 1
+ 1
--- 23 row(s) selected.
>>
@@ -2807,11 +2807,11 @@ SUPPNUM
+> where fromsup.suppnum = supplier.suppnum
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+DATADRIVE
+INFOMATION STORAGE
--- 2 row(s) selected.
>>
@@ -2832,11 +2832,11 @@ INFOMATION STORAGE
+> where partnum = ?p1
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+DATADRIVE
+INFOMATION STORAGE
--- 2 row(s) selected.
>>
@@ -2858,13 +2858,13 @@ INFOMATION STORAGE
+> where fromsup.suppnum = supplier.suppnum
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+MAGNETICS CORP
+DATA TERMINAL CO
+INFOMATION STORAGE
--- 4 row(s) selected.
>>
@@ -2883,13 +2883,13 @@ MAGNETICS CORP
+> where partnum = ?p1
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+DATA TERMINAL CO
+MAGNETICS CORP
+INFOMATION STORAGE
--- 4 row(s) selected.
>>
@@ -2909,12 +2909,12 @@ MAGNETICS CORP
+> where partnum = ?p1
+> ));
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DISPLAY INC
-STEELWORK INC
-TANDEM COMPUTERS
+DISPLAY INC
+STEELWORK INC
+TANDEM COMPUTERS
--- 3 row(s) selected.
>>
@@ -2941,10 +2941,10 @@ TANDEM COMPUTERS
+> where partnum = ?p2
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2964,14 +2964,14 @@ DATADRIVE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DATADRIVE
-DISPLAY INC
-INFOMATION STORAGE
-TANDEM COMPUTERS
+DATA TERMINAL CO
+DATADRIVE
+DISPLAY INC
+INFOMATION STORAGE
+TANDEM COMPUTERS
--- 5 row(s) selected.
>>
@@ -3010,28 +3010,28 @@ TANDEM COMPUTERS
+> )
+> );
-EMPNAME JOB
------------------- ------------
-
-THOMAS RUDLOFF MANAGER
-KLAUS SAFFERT MANAGER
-PETER SMITH MANAGER
-DONALD TAYLOR MANAGER
-STEVE COOK MANAGER
-SHERRIE WONG MANAGER
-TONY CRAFT MANAGER
-GEORGE FORSTER SALESMAN
-RICHARD BARTON SALESMAN
-JIMMY SCHNEIDER SYS.-ANAL.
-WALTER LANCASTER SALESMAN
-JOHN JONES SYS.-ANAL.
-MARLENE BONNY SYS.-ANAL.
-GEORGE FRENCHMAN SALESMAN
-DAVID TERRY PROGRAMMER
-KARL HELMSTED SALESMAN
-HEIDI WEIGL SECRETARY
-XAVER SEDLMEYER SYST.-ANAL
-DAVE CLARK MANAGER
+EMPNAME JOB
+------------------ ------------
+
+THOMAS RUDLOFF MANAGER
+KLAUS SAFFERT MANAGER
+PETER SMITH MANAGER
+DONALD TAYLOR MANAGER
+STEVE COOK MANAGER
+SHERRIE WONG MANAGER
+TONY CRAFT MANAGER
+GEORGE FORSTER SALESMAN
+RICHARD BARTON SALESMAN
+JIMMY SCHNEIDER SYS.-ANAL.
+WALTER LANCASTER SALESMAN
+JOHN JONES SYS.-ANAL.
+MARLENE BONNY SYS.-ANAL.
+GEORGE FRENCHMAN SALESMAN
+DAVID TERRY PROGRAMMER
+KARL HELMSTED SALESMAN
+HEIDI WEIGL SECRETARY
+XAVER SEDLMEYER SYST.-ANAL
+DAVE CLARK MANAGER
--- 19 row(s) selected.
>>
@@ -3052,12 +3052,12 @@ DAVE CLARK MANAGER
+> )
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5504
+ 4102
+ 4103
+ 5504
--- 3 row(s) selected.
>>
@@ -3077,10 +3077,10 @@ PARTNUM
+> )
+> );
-COL_1
------
+COL_1
+-----
- 4103
+ 4103
--- 1 row(s) selected.
>>
@@ -3101,10 +3101,10 @@ COL_1
+> )
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4103
+ 4103
--- 1 row(s) selected.
>>
@@ -3129,14 +3129,14 @@ PARTNUM
+> )
+> );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 205 66
+ 207 41
+ 212 45
+ 221 122
+ 225 48
--- 5 row(s) selected.
>>
@@ -3159,14 +3159,14 @@ SALESMAN ORDERNUM
+> )
+> );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 205 66
+ 207 41
+ 212 45
+ 221 122
+ 225 48
--- 5 row(s) selected.
>>
@@ -3190,14 +3190,14 @@ SALESMAN ORDERNUM
+> )
+> );
-SALESMAN ORDERNUM
--------- --------
+SALESMAN ORDERNUM
+-------- --------
- 207 41
- 212 45
- 225 48
- 205 66
- 221 122
+ 205 66
+ 207 41
+ 212 45
+ 221 122
+ 225 48
--- 5 row(s) selected.
>>
@@ -3209,8 +3209,8 @@ SALESMAN ORDERNUM
>>
>>-- <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
@@ -3223,21 +3223,21 @@ SALESMAN ORDERNUM
+> (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;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -3249,21 +3249,21 @@ PARTNUM
+> (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;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -3275,21 +3275,21 @@ PARTNUM
+> (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;
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -3303,16 +3303,16 @@ PARTNUM
+> (select partcost
+> from expfroms
+> where parts.partnum = expfroms.partnum
-+> for repeatable access
++> for read committed access
+> );
-PARTNAME
-------------------
+PARTNAME
+------------------
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DISC CONT DUAL
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DISC CONT DUAL
--- 4 row(s) selected.
>>
@@ -3327,33 +3327,33 @@ DISC CONT DUAL
+> from fromsup
+> where parts.partnum = fromsup.partnum
+> group by partcost
-+> for browse access
-+> );
-
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-MAG TAPE DR 800BPI
-MAG TAPE DR 8/16
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
-TERM CRT CHAR
-TERM CRT PAGE
-TERM HARD COPY
-POWER MODULE
++> for read committed access
++> );
+
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
+TERM CRT CHAR
+TERM CRT PAGE
+TERM HARD COPY
+POWER MODULE
--- 21 row(s) selected.
>>
@@ -3366,40 +3366,40 @@ POWER MODULE
+> (select Y.col_3
+> from partsfor Y
+> where X.col_1 <> Y.col_1
-+> for browse access
++> for read committed access
+> )
-+> for browse access;
-
-COL_1
-------------------
-
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-MAG TAPE CONT 8/16
-DISC 10MB
-DISC 10MB
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-TERM CRT CHAR
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
++> for read committed access;
+
+COL_1
+------------------
+
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+MAG TAPE CONT 8/16
+DISC 10MB
+DISC 10MB
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+TERM CRT CHAR
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
--- 27 row(s) selected.
>>
@@ -3412,40 +3412,40 @@ TERM CRT PAGE
+> (select Y.col_3
+> from partsfor Y
+> where X.col_1 <> Y.col_1
-+> for stable access
++> for read committed access
+> )
-+> for stable access;
-
-COL_1
-------------------
-
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-MAG TAPE CONT 8/16
-DISC 10MB
-DISC 10MB
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-TERM CRT CHAR
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
++> for read committed access;
+
+COL_1
+------------------
+
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+MAG TAPE CONT 8/16
+DISC 10MB
+DISC 10MB
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+TERM CRT CHAR
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
--- 27 row(s) selected.
>>
@@ -3458,40 +3458,40 @@ TERM CRT PAGE
+> (select Y.col_3
+> from partsfor Y
+> where X.col_1 <> Y.col_1
-+> for repeatable access
++> for read committed access
+> )
-+> for browse access;
-
-COL_1
-------------------
-
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DECIMAL ARITH
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-DISC CONT SINGLE
-MAG TAPE CONT 8/16
-DISC 10MB
-DISC 10MB
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-MAG TAPE DR 8/16
-TERM CRT CHAR
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
-TERM CRT PAGE
++> for read committed access;
+
+COL_1
+------------------
+
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DECIMAL ARITH
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+DISC CONT SINGLE
+MAG TAPE CONT 8/16
+DISC 10MB
+DISC 10MB
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+MAG TAPE DR 8/16
+TERM CRT CHAR
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
+TERM CRT PAGE
--- 27 row(s) selected.
>>
@@ -3506,20 +3506,20 @@ TERM CRT PAGE
+> from fromsup Y
+> where Y.suppnum <> X.suppnum
+> and X.partnum = Y.partnum
-+> for repeatable access
++> for read committed access
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4101
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4101
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 8 row(s) selected.
>>
@@ -3538,17 +3538,17 @@ PARTNUM
+> 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;
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
+ 6
+ 15
--- 2 row(s) selected.
>>
@@ -3567,44 +3567,44 @@ SUPPNUM
+> 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;
-
-PARTNUM
--------
-
- 244
- 2001
- 2403
- 4103
- 5103
- 6301
- 6402
- 2002
- 2003
- 3102
- 4101
- 6302
- 2402
- 3202
- 3302
- 4102
- 5504
- 6201
- 3103
- 5503
- 5502
- 1403
- 7301
- 212
- 7102
- 5505
- 5101
- 6401
- 3201
++> for read committed access;
+
+PARTNUM
+-------
+
+ 244
+ 2001
+ 2403
+ 4103
+ 5103
+ 6301
+ 6402
+ 2002
+ 2003
+ 3102
+ 4101
+ 6302
+ 2402
+ 3202
+ 3302
+ 4102
+ 5504
+ 6201
+ 3103
+ 5503
+ 5502
+ 1403
+ 7301
+ 212
+ 7102
+ 5505
+ 5101
+ 6401
+ 3201
--- 29 row(s) selected.
>>
@@ -3620,20 +3620,20 @@ PARTNUM
+> (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
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+DATADRIVE
+INFOMATION STORAGE
--- 2 row(s) selected.
>>
@@ -3651,18 +3651,18 @@ INFOMATION STORAGE
+> 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;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5504
+ 4102
+ 4103
+ 5504
--- 3 row(s) selected.
>>
@@ -3679,16 +3679,16 @@ PARTNUM
+> 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;
-COL_1
------
+COL_1
+-----
- 4103
+ 4103
--- 1 row(s) selected.
>>
@@ -3718,30 +3718,30 @@ COL_1
+> where partnum = parts.partnum
+> );
-PARTNAME
-------------------
-
-SYSTEM 192KB CORE
-SYSTEM 192KB SEMI
-PROC 96KB SEMI
-DECIMAL ARITH
-ENSCRIBE MICRO
-COBOL MICRO
-MEM MOD 64K MOS
-MEM MOD 96K MOS
-DISC CONT SINGLE
-DISC CONT DUAL
-MAG TAPE CONT 8/16
-LINE PRINTER CONT
-MAG TAPE DR 800BPI
-MAG TAPE DR 8/16
-SYNC CONTROLLER
-ASYNC CONTROLLER
-ASYNC EXTENSION
-TERM CRT CHAR
-TERM CRT PAGE
-TERM HARD COPY
-POWER MODULE
+PARTNAME
+------------------
+
+SYSTEM 192KB CORE
+SYSTEM 192KB SEMI
+PROC 96KB SEMI
+DECIMAL ARITH
+ENSCRIBE MICRO
+COBOL MICRO
+MEM MOD 64K MOS
+MEM MOD 96K MOS
+DISC CONT SINGLE
+DISC CONT DUAL
+MAG TAPE CONT 8/16
+LINE PRINTER CONT
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16
+SYNC CONTROLLER
+ASYNC CONTROLLER
+ASYNC EXTENSION
+TERM CRT CHAR
+TERM CRT PAGE
+TERM HARD COPY
+POWER MODULE
--- 21 row(s) selected.
>>
@@ -3761,13 +3761,13 @@ POWER MODULE
+> having sum(salary) > ?p
+> );
-BRANCHNAME
---------------
+BRANCHNAME
+--------------
-CHICAGO
-DALLAS
-FRANKFURT
-CUPERTINO
+CHICAGO
+DALLAS
+FRANKFURT
+CUPERTINO
--- 4 row(s) selected.
>>
@@ -3783,38 +3783,38 @@ CUPERTINO
+> and Y.regnum = X.regnum
+> );
-EMPNAME
-------------------
-
-ROGER GREEN
-JERRY HOWARD
-JACK RAYMOND
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PAUL WINTER
-GLENN THOMAS
-TIM WALKER
-ERIC BROWN
-PETER SMITH
-DAVID STRAND
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-MANFRED CONRAD
-TOM HALL
-JULIA KELLY
-GEORGE FRENCHMAN
-JOHANN HUBER
-OTTO SCHNABL
-MARTIN SCHAEFER
-KARL HELMSTED
-PETE WELLINGTON
-GEORGE STRICKER
-HERB ALBERT
-THOMAS SPINNER
-TED MCDONNALDS
-DAVE CLARK
-ALAN TERRY
+EMPNAME
+------------------
+
+ROGER GREEN
+JERRY HOWARD
+JACK RAYMOND
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PAUL WINTER
+GLENN THOMAS
+TIM WALKER
+ERIC BROWN
+PETER SMITH
+DAVID STRAND
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+MANFRED CONRAD
+TOM HALL
+JULIA KELLY
+GEORGE FRENCHMAN
+JOHANN HUBER
+OTTO SCHNABL
+MARTIN SCHAEFER
+KARL HELMSTED
+PETE WELLINGTON
+GEORGE STRICKER
+HERB ALBERT
+THOMAS SPINNER
+TED MCDONNALDS
+DAVE CLARK
+ALAN TERRY
--- 29 row(s) selected.
>>
@@ -3832,38 +3832,38 @@ ALAN TERRY
+> and Y.regnum = X.regnum
+> );
-EMPNAME
-------------------
-
-ROGER GREEN
-JERRY HOWARD
-JACK RAYMOND
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PAUL WINTER
-TIM WALKER
-ERIC BROWN
-PETER SMITH
-DAVID STRAND
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-MANFRED CONRAD
-LARRY CLARK
-TOM HALL
-JULIA KELLY
-GEORGE FRENCHMAN
-JOHANN HUBER
-OTTO SCHNABL
-MARTIN SCHAEFER
-KARL HELMSTED
-PETE WELLINGTON
-GEORGE STRICKER
-HERB ALBERT
-THOMAS SPINNER
-TED MCDONNALDS
-DAVE CLARK
-ALAN TERRY
+EMPNAME
+------------------
+
+ROGER GREEN
+JERRY HOWARD
+JACK RAYMOND
+THOMAS RUDLOFF
+KLAUS SAFFERT
+PAUL WINTER
+TIM WALKER
+ERIC BROWN
+PETER SMITH
+DAVID STRAND
+STEVE COOK
+SHERRIE WONG
+TONY CRAFT
+MANFRED CONRAD
+LARRY CLARK
+TOM HALL
+JULIA KELLY
+GEORGE FRENCHMAN
+JOHANN HUBER
+OTTO SCHNABL
+MARTIN SCHAEFER
+KARL HELMSTED
+PETE WELLINGTON
+GEORGE STRICKER
+HERB ALBERT
+THOMAS SPINNER
+TED MCDONNALDS
+DAVE CLARK
+ALAN TERRY
--- 29 row(s) selected.
>>
@@ -3886,21 +3886,21 @@ ALAN TERRY
+> )
+> );
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
-SUSAN HENDERSON
-STEVE COOK
-SHERRIE WONG
-LINDA JONES
-GEORGE FORSTER
-SUE CRAMER
-RICHARD BARTON
-WALTER LANCASTER
-HEIDI WEIGL
-PETE WELLINGTON
-HERB ALBERT
+JACK RAYMOND
+SUSAN HENDERSON
+STEVE COOK
+SHERRIE WONG
+LINDA JONES
+GEORGE FORSTER
+SUE CRAMER
+RICHARD BARTON
+WALTER LANCASTER
+HEIDI WEIGL
+PETE WELLINGTON
+HERB ALBERT
--- 12 row(s) selected.
>>
@@ -3923,21 +3923,21 @@ HERB ALBERT
+> )
+> );
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
-SUSAN HENDERSON
-STEVE COOK
-SHERRIE WONG
-LINDA JONES
-GEORGE FORSTER
-SUE CRAMER
-RICHARD BARTON
-WALTER LANCASTER
-HEIDI WEIGL
-PETE WELLINGTON
-HERB ALBERT
+JACK RAYMOND
+SUSAN HENDERSON
+STEVE COOK
+SHERRIE WONG
+LINDA JONES
+GEORGE FORSTER
+SUE CRAMER
+RICHARD BARTON
+WALTER LANCASTER
+HEIDI WEIGL
+PETE WELLINGTON
+HERB ALBERT
--- 12 row(s) selected.
>>
@@ -3956,39 +3956,39 @@ HERB ALBERT
+> and X.branchnum = Y.branchnum
+> );
-EMPNAME
-------------------
-
-ROGER GREEN
-JERRY HOWARD
-JACK RAYMOND
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PAUL WINTER
-GLENN THOMAS
-TIM WALKER
-PETER SMITH
-DAVID STRAND
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-MANFRED CONRAD
-LARRY CLARK
-TOM HALL
-DAVE FISHER
-JULIA KELLY
-WALTER LANCASTER
-GEORGE FRENCHMAN
-JOHANN HUBER
-OTTO SCHNABL
-MARTIN SCHAEFER
-KARL HELMSTED
-PETE WELLINGTON
-GEORGE STRICKER
-HERB ALBERT
-THOMAS SPINNER
-TED MCDONNALDS
-DAVE CLARK
+EMPNAME
+------------------
+
+PAUL WINTER
+MARTIN SCHAEFER
+OTTO SCHNABL
+JOHANN HUBER
+MANFRED CONRAD
+TONY CRAFT
+JACK RAYMOND
+TOM HALL
+LARRY CLARK
+TIM WALKER
+STEVE COOK
+SHERRIE WONG
+WALTER LANCASTER
+DAVE CLARK
+PETER SMITH
+GEORGE FRENCHMAN
+KLAUS SAFFERT
+KARL HELMSTED
+THOMAS RUDLOFF
+ROGER GREEN
+TED MCDONNALDS
+THOMAS SPINNER
+HERB ALBERT
+GEORGE STRICKER
+PETE WELLINGTON
+GLENN THOMAS
+JULIA KELLY
+JERRY HOWARD
+DAVE FISHER
+DAVID STRAND
--- 30 row(s) selected.
>>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml14
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml14 b/core/sql/regress/qat/eqatdml14
index fa5ec7c..5c3ec42 100755
--- a/core/sql/regress/qat/eqatdml14
+++ b/core/sql/regress/qat/eqatdml14
@@ -36,8 +36,8 @@
>>-- 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
>>
@@ -80,9 +80,9 @@
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -99,9 +99,9 @@ SUPPNUM
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -118,10 +118,10 @@ SUPPNUM
SUPPNUM
-------
- 1
2
3
10
+ 1
--- 4 row(s) selected.
>>
@@ -138,10 +138,10 @@ SUPPNUM
SUPPNUM
-------
- 1
2
3
10
+ 1
--- 4 row(s) selected.
>>
@@ -375,14 +375,14 @@ PARTNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -400,14 +400,14 @@ SALESMAN ORDERNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -428,14 +428,14 @@ SALESMAN ORDERNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -738,16 +738,16 @@ JACK RAYMOND
CUSTNUM
-------
- 3210
123
+ 3210
+ 926
+ 7654
+ 5635
21
+ 543
1234
3333
- 543
- 926
- 7654
143
- 5635
--- 10 row(s) selected.
>>
@@ -767,16 +767,16 @@ CUSTNUM
CUSTNUM
-------
- 3210
123
+ 3210
+ 926
+ 7654
+ 5635
21
+ 543
1234
3333
- 543
- 926
- 7654
143
- 5635
--- 10 row(s) selected.
>>
@@ -836,12 +836,12 @@ COL_1
------------------
DECIMAL ARITH
+MAG TAPE DR 8/16
+TERM CRT PAGE
DISC CONT SINGLE
-MAG TAPE CONT 8/16
DISC 10MB
-MAG TAPE DR 8/16
TERM CRT CHAR
-TERM CRT PAGE
+MAG TAPE CONT 8/16
--- 7 row(s) selected.
>>
@@ -967,9 +967,9 @@ SUPPNUM PARTNUM
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -986,9 +986,9 @@ SUPPNUM
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -1005,13 +1005,13 @@ SUPPNUM
SUPPNUM
-------
- 1
2
+ 15
3
6
8
10
- 15
+ 1
--- 7 row(s) selected.
>>
@@ -1028,13 +1028,13 @@ SUPPNUM
SUPPNUM
-------
- 1
2
+ 15
3
6
8
10
- 15
+ 1
--- 7 row(s) selected.
>>
@@ -1268,14 +1268,14 @@ PARTNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -1294,14 +1294,14 @@ SALESMAN ORDERNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -1322,14 +1322,14 @@ SALESMAN ORDERNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>-- <comment> same as first, except order by ordernum
@@ -1566,18 +1566,18 @@ DAVE CLARK
CUSTNUM
-------
- 21
+ 3210
123
- 143
- 324
- 543
- 926
+ 21
1234
- 3210
3333
- 5635
+ 543
+ 926
7654
+ 324
7777
+ 143
+ 5635
--- 12 row(s) selected.
>>
@@ -1610,9 +1610,9 @@ CUSTNUM
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -1631,9 +1631,9 @@ SUPPNUM
SUPPNUM
-------
+ 15
6
8
- 15
--- 3 row(s) selected.
>>
@@ -1703,14 +1703,14 @@ PARTNUM
SALESMAN ORDERNUM
-------- --------
- 222 30
204 32
- 218 38
+ 205 66
207 41
212 45
- 225 48
- 205 66
+ 218 38
221 122
+ 222 30
+ 225 48
--- 8 row(s) selected.
>>
@@ -2055,10 +2055,10 @@ SUPPNUM
SUPPNUM
-------
+ 8
2
- 15
6
- 8
+ 15
--- 4 row(s) selected.
>>
@@ -2082,8 +2082,8 @@ SUPPNUM
-------
2
- 15
6
+ 15
8
--- 4 row(s) selected.
@@ -2108,9 +2108,9 @@ SUPPNUM
SUPPNUM
-------
- 1
3
10
+ 1
--- 3 row(s) selected.
>>
@@ -2135,10 +2135,10 @@ SUPPNUM
SUPPNUM
-------
- 1
2
3
10
+ 1
--- 4 row(s) selected.
>>
@@ -2192,11 +2192,11 @@ SUPPNUM
SUPPNUM
-------
- 1
2
+ 15
3
6
- 15
+ 1
--- 5 row(s) selected.
>>
@@ -2220,11 +2220,11 @@ SUPPNUM
SUPPNUM
-------
- 1
2
+ 15
3
6
- 15
+ 1
--- 5 row(s) selected.
>>
@@ -2248,11 +2248,11 @@ SUPPNUM
SUPPNAME
------------------
-TANDEM COMPUTERS
DATA TERMINAL CO
+DATADRIVE
DISPLAY INC
INFOMATION STORAGE
-DATADRIVE
+TANDEM COMPUTERS
--- 5 row(s) selected.
>>
@@ -2278,8 +2278,8 @@ SUPPNUM
-------
2
- 6
15
+ 6
--- 3 row(s) selected.
>>
@@ -2303,8 +2303,8 @@ SUPPNUM
-------
2
- 6
15
+ 6
--- 3 row(s) selected.
>>
@@ -2328,8 +2328,8 @@ SUPPNAME
------------------
DATA TERMINAL CO
-INFOMATION STORAGE
DATADRIVE
+INFOMATION STORAGE
--- 3 row(s) selected.
>>
@@ -2684,11 +2684,11 @@ PARTNUM
SALESMAN ORDERNUM
-------- --------
+ 205 66
207 41
212 45
- 225 48
- 205 66
221 122
+ 225 48
--- 5 row(s) selected.
>>
@@ -2700,8 +2700,8 @@ SALESMAN ORDERNUM
>>
>>-- <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
@@ -2715,9 +2715,9 @@ SALESMAN ORDERNUM
+> (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;
PARTNUM
-------
@@ -2742,9 +2742,9 @@ PARTNUM
+> (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;
PARTNUM
-------
@@ -2769,9 +2769,9 @@ PARTNUM
+> (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;
PARTNUM
-------
@@ -2798,7 +2798,7 @@ PARTNUM
+> (select partcost
+> from expfroms
+> where parts.partnum = expfroms.partnum
-+> for repeatable access
++> for read committed access
+> );
PARTNUM
@@ -2822,7 +2822,7 @@ PARTNUM
+> from fromsup
+> where parts.partnum = fromsup.partnum
+> group by partcost
-+> for browse access
++> for read committed access
+> );
PARTNUM
@@ -2862,20 +2862,20 @@ PARTNUM
+> (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;
COL_1
------------------
DECIMAL ARITH
+MAG TAPE DR 8/16
+TERM CRT PAGE
DISC CONT SINGLE
-MAG TAPE CONT 8/16
DISC 10MB
-MAG TAPE DR 8/16
TERM CRT CHAR
-TERM CRT PAGE
+MAG TAPE CONT 8/16
--- 7 row(s) selected.
>>
@@ -2889,20 +2889,20 @@ TERM CRT PAGE
+> (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;
COL_1
------------------
DECIMAL ARITH
+MAG TAPE DR 8/16
+TERM CRT PAGE
DISC CONT SINGLE
-MAG TAPE CONT 8/16
DISC 10MB
-MAG TAPE DR 8/16
TERM CRT CHAR
-TERM CRT PAGE
+MAG TAPE CONT 8/16
--- 7 row(s) selected.
>>
@@ -2916,20 +2916,20 @@ TERM CRT PAGE
+> (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;
COL_1
------------------
DECIMAL ARITH
+MAG TAPE DR 8/16
+TERM CRT PAGE
DISC CONT SINGLE
-MAG TAPE CONT 8/16
DISC 10MB
-MAG TAPE DR 8/16
TERM CRT CHAR
-TERM CRT PAGE
+MAG TAPE CONT 8/16
--- 7 row(s) selected.
>>
@@ -2944,7 +2944,7 @@ TERM CRT PAGE
+> from fromsup Y
+> where Y.suppnum <> X.suppnum
+> and X.partnum = Y.partnum
-+> for repeatable access
++> for read committed access
+> );
PARTNUM
@@ -2972,13 +2972,13 @@ PARTNUM
+> (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
+> );
SUPPNUM
@@ -2999,14 +2999,14 @@ SUPPNUM
+> (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
+> );
SUPPNUM
@@ -3034,11 +3034,11 @@ SUPPNUM
+> (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;
EMPNAME
------------------
@@ -3081,11 +3081,11 @@ DAVE CLARK
+> (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;
EMPNAME
------------------
@@ -3129,11 +3129,11 @@ DAVE CLARK
+> 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;
PARTNUM
-------
@@ -3159,11 +3159,11 @@ PARTNUM
+> 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;
COL_1
-----
@@ -3188,11 +3188,11 @@ COL_1
+> 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;
PARTNUM
-------
@@ -3309,8 +3309,8 @@ REGNUM BRANCHNUM (EXPR)
REGNUM BRANCHNUM
------ ---------
- 2 1
3 1
+ 2 1
3 3
3 2
@@ -3336,8 +3336,8 @@ REGNUM BRANCHNUM
------ ---------
2 1
- 3 1
3 3
+ 3 1
3 2
--- 4 row(s) selected.
@@ -3361,18 +3361,18 @@ REGNUM BRANCHNUM
REGNUM BRANCHNUM
------ ---------
- 1 1
5 3
5 2
- 5 1
6 1
- 3 1
+ 1 1
3 3
4 2
2 2
2 3
1 2
4 1
+ 5 1
+ 3 1
3 2
--- 13 row(s) selected.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/qatdml01
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/qatdml01 b/core/sql/regress/qat/qatdml01
index 19dbcc2..6a28f0f 100755
--- a/core/sql/regress/qat/qatdml01
+++ b/core/sql/regress/qat/qatdml01
@@ -48,26 +48,26 @@ LOG aqatdml01 Clear;
---------------------------------------------------------------------
-- SELECT data base - checking the SHORTHAND VIEWs.
---------------------------------------------------------------------
- SELECT * FROM svsel01 BROWSE ACCESS ;
- SELECT * FROM svsel02 BROWSE ACCESS ;
- SELECT * FROM svsel03 BROWSE ACCESS ;
- SELECT * FROM svsel04 BROWSE ACCESS ;
- SELECT new_name_ks_s, new_name_ks_x, new_name_es_x FROM svsel05 BROWSE ACCESS ;
- SELECT * FROM svsel06 BROWSE ACCESS ;
- SELECT * FROM svsel07 BROWSE ACCESS ;
- SELECT * FROM svsel08 BROWSE ACCESS ;
- SELECT * FROM svsel09 BROWSE ACCESS ;
- SELECT * FROM svsel10 BROWSE ACCESS ;
- SELECT * FROM svsel11 BROWSE ACCESS ;
- SELECT * FROM svsel12 BROWSE ACCESS ;
- SELECT * FROM svsel13 BROWSE ACCESS ;
+ SELECT * FROM svsel01 read committed access ;
+ SELECT * FROM svsel02 read committed access ;
+ SELECT * FROM svsel03 read committed access ;
+ SELECT * FROM svsel04 read committed access ;
+ SELECT new_name_ks_s, new_name_ks_x, new_name_es_x FROM svsel05 read committed access ;
+ SELECT * FROM svsel06 read committed access ;
+ SELECT * FROM svsel07 read committed access ;
+ SELECT * FROM svsel08 read committed access ;
+ SELECT * FROM svsel09 read committed access ;
+ SELECT * FROM svsel10 read committed access ;
+ SELECT * FROM svsel11 read committed access ;
+ SELECT * FROM svsel12 read committed access ;
+ SELECT * FROM svsel13 read committed access ;
- SELECT * FROM svsel14 BROWSE ACCESS ;
- SELECT * FROM svsel15 BROWSE ACCESS ;
+ SELECT * FROM svsel14 read committed access ;
+ SELECT * FROM svsel15 read committed access ;
control query default optimization_level '0';
-SELECT * FROM svsel16 BROWSE ACCESS ;
-SELECT * FROM svsel17 BROWSE ACCESS ;
+SELECT * FROM svsel16 read committed access ;
+SELECT * FROM svsel17 read committed access ;
control query default optimization_level '3';
---------------------------------------------------------------------