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:25 UTC
[03/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/eqatdml08
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml08 b/core/sql/regress/qat/eqatdml08
index a6e9e08..ef51159 100755
--- a/core/sql/regress/qat/eqatdml08
+++ b/core/sql/regress/qat/eqatdml08
@@ -35,8 +35,8 @@
>>-- 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
>>
@@ -1778,8 +1778,8 @@ AGE
>>
>>-- <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
@@ -1793,9 +1793,9 @@ AGE
+> (select Y.partnum
+> from fromsup Y
+> where suppnum = 15
-+> for browse access
++> for read committed access
+> )
-+> for repeatable access;
++> for read committed access;
SUPPNUM
-------
@@ -1817,7 +1817,7 @@ SUPPNUM
+> from odetail,parts
+> where odetail.partnum = parts.partnum
+> and price > 50000
-+> for repeatable access
++> for read committed access
+> );
SALESMAN ORDERNUM
@@ -1847,9 +1847,9 @@ SALESMAN ORDERNUM
+> (select Y.state
+> from supplier Y
+> where suppnum = 1
-+> for browse access
++> for read committed access
+> )
-+> for repeatable access;
++> for read committed access;
SUPPNUM
-------
@@ -1870,7 +1870,7 @@ SUPPNUM
+> (select col_12
+> from partsfor
+> where col_2 = 'V67'
-+> for browse access
++> for read committed access
+> );
CUSTNAME
@@ -1900,7 +1900,7 @@ VEREINIGTE CHEMIE
+> where ( orders.ordernum = odetail.ordernum) and
+> ( odetail.partnum = parts.partnum) and
+> (location = 'V67')
-+> for repeatable access
++> for read committed access
+> );
CUSTNAME
@@ -1929,13 +1929,13 @@ VEREINIGTE CHEMIE
+> (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
+> );
SUPPNAME
@@ -1959,11 +1959,11 @@ DATADRIVE
+> (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;
SUPPNAME
------------------
@@ -1987,11 +1987,11 @@ TANDEM COMPUTERS
+> 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;
AGE
---
@@ -2018,11 +2018,11 @@ AGE
+> (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;
SALESMAN
--------
@@ -2052,11 +2052,11 @@ SALESMAN
+> (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;
--- 0 row(s) selected.
>>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml09
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml09 b/core/sql/regress/qat/eqatdml09
index 04c6e71..e24a4e4 100755
--- a/core/sql/regress/qat/eqatdml09
+++ b/core/sql/regress/qat/eqatdml09
@@ -36,8 +36,8 @@
>>-- 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
>>
@@ -1905,10 +1905,10 @@ SUPPNUM
SUPPNUM
-------
- 1
+ 15
3
6
- 15
+ 1
--- 4 row(s) selected.
>>
@@ -1950,8 +1950,8 @@ AGE
>>
>>-- <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>
@@ -1968,9 +1968,9 @@ AGE
+> (select partnum
+> from fromsup
+> where suppnum = 15
-+> for browse access
++> for read committed access
+> )
-+> for repeatable access;
++> for read committed access;
PARTNUM
-------
@@ -1996,7 +1996,7 @@ PARTNUM
+> from odetail,parts
+> where odetail.partnum = parts.partnum
+> and price > 50000
-+> for repeatable access
++> for read committed access
+> );
SALESMAN ORDERNUM
@@ -2026,9 +2026,9 @@ SALESMAN ORDERNUM
+> (select Y.state
+> from supplier Y
+> where suppnum = 1
-+> for browse access
++> for read committed access
+> )
-+> for repeatable access;
++> for read committed access;
SUPPNUM
-------
@@ -2050,7 +2050,7 @@ SUPPNUM
+> (select col_12
+> from partsfor
+> where col_2 = 'V67'
-+> for browse access
++> for read committed access
+> );
CUSTNUM
@@ -2081,7 +2081,7 @@ CUSTNUM
+> where ( orders.ordernum = odetail.ordernum) and
+> ( odetail.partnum = parts.partnum) and
+> (location = 'V67')
-+> for repeatable access
++> for read committed access
+> );
CUSTNUM
@@ -2111,13 +2111,13 @@ CUSTNUM
+> (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)
+> );
SUPPNUM
@@ -2143,11 +2143,11 @@ SUPPNUM
+> (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;
SUPPNUM
-------
@@ -2173,11 +2173,11 @@ SUPPNUM
+> 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;
AGE
---
@@ -2207,11 +2207,11 @@ AGE
+> (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;
SALESMAN
--------
@@ -2242,11 +2242,11 @@ SALESMAN
+> (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;
EMPNAME
------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml10
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml10 b/core/sql/regress/qat/eqatdml10
index 8a85e8f..9f0195a 100755
--- a/core/sql/regress/qat/eqatdml10
+++ b/core/sql/regress/qat/eqatdml10
@@ -38,8 +38,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
>>
@@ -77,12 +77,12 @@
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -95,12 +95,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.
>>
@@ -113,13 +113,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.
>>
@@ -132,12 +132,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.
>>
@@ -153,24 +153,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.
>>
@@ -186,24 +186,24 @@ ASYNC EXTENSION
+> having partcost <> 20100
+> );
-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.
>>
@@ -218,24 +218,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.
>>
@@ -249,10 +249,10 @@ ASYNC EXTENSION
+> from empone
+> where empone.empnum = region.manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -265,10 +265,10 @@ HEADQUARTERS
+> from empone
+> where empnum = manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -282,17 +282,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.
>>
@@ -307,17 +307,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.
>>
@@ -332,17 +332,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.
>>
@@ -358,17 +358,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.
>>
@@ -384,17 +384,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.
>>
@@ -412,16 +412,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.
>>
@@ -438,16 +438,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> 4101;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -465,16 +465,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> 4101;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -489,17 +489,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.
>>
@@ -513,17 +513,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.
>>
@@ -539,17 +539,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.
>>
@@ -564,17 +564,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.
>>
@@ -590,13 +590,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.
>>
@@ -612,11 +612,11 @@ DISC CONT DUAL
+> where Y.ordernum < X.ordernum
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -632,28 +632,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.
>>
@@ -666,28 +666,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.
>>
@@ -703,28 +703,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.
>>
@@ -739,13 +739,13 @@ DAVE CLARK
+> where Y.partnum = X.partnum
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 2
- 6
- 8
- 15
+ 6
+ 15
+ 8
+ 2
--- 4 row(s) selected.
>>
@@ -760,13 +760,13 @@ SUPPNUM
+> where Y.state = X.state
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -781,20 +781,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.
>>
@@ -823,10 +823,10 @@ VEREINIGTE CHEMIE
+> from region
+> where manager = empnum);
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
+JACK RAYMOND
--- 1 row(s) selected.
>>
@@ -840,10 +840,10 @@ JACK RAYMOND
+> from region
+> where region.manager = employee.empnum);
-EMPNAME
-------------------
+EMPNAME
+------------------
-JACK RAYMOND
+JACK RAYMOND
--- 1 row(s) selected.
>>
@@ -857,19 +857,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.
>>
@@ -884,19 +884,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.
>>
@@ -912,30 +912,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.
>>
@@ -950,36 +950,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.
>>
@@ -998,21 +998,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.
>>
@@ -1027,21 +1027,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.
>>
@@ -1056,36 +1056,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.
>>
@@ -1102,12 +1102,12 @@ SUPPNUM PARTNUM
+> and (Y.suppnum = 15)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 2
- 6
- 8
+ 6
+ 8
+ 2
--- 3 row(s) selected.
>>
@@ -1121,13 +1121,13 @@ SUPPNUM
+> where X.state = Y.state
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -1140,12 +1140,12 @@ SUPPNUM
+> from fromsup
+> where supplier.suppnum = suppnum);
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1158,12 +1158,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.
>>
@@ -1176,16 +1176,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.
>>
@@ -1198,12 +1198,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.
>>
@@ -1219,24 +1219,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.
>>
@@ -1252,24 +1252,24 @@ ASYNC EXTENSION
+> having partcost <> 20100
+> );
-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.
>>
@@ -1284,24 +1284,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.
>>
@@ -1315,10 +1315,10 @@ ASYNC EXTENSION
+> from empone
+> where empone.empnum = region.manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1331,10 +1331,10 @@ HEADQUARTERS
+> from empone
+> where empnum = manager);
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1348,17 +1348,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.
>>
@@ -1373,17 +1373,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.
>>
@@ -1398,17 +1398,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.
>>
@@ -1424,17 +1424,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.
>>
@@ -1450,17 +1450,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.
>>
@@ -1478,16 +1478,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.
>>
@@ -1504,16 +1504,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> 4101;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -1531,16 +1531,16 @@ PARTNUM
+> group by X.partnum
+> having X.partnum <> 4101;
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5101
- 5103
- 5504
- 6401
- 6402
+ 4102
+ 4103
+ 5101
+ 5103
+ 5504
+ 6401
+ 6402
--- 7 row(s) selected.
>>
@@ -1555,17 +1555,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.
>>
@@ -1579,17 +1579,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.
>>
@@ -1605,17 +1605,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.
>>
@@ -1630,17 +1630,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.
>>
@@ -1656,13 +1656,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.
>>
@@ -1678,11 +1678,11 @@ DISC CONT DUAL
+> where Y.ordernum < X.ordernum
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -1698,28 +1698,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.
>>
@@ -1732,28 +1732,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.
>>
@@ -1769,28 +1769,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.
>>
@@ -1805,14 +1805,14 @@ DAVE CLARK
+> where empone.empnum = region.manager
+> );
-REGNAME
-------------
+REGNAME
+------------
-EAST
-WEST
-GERMANY
-ENGLAND
-HEADQUARTERS
+EAST
+WEST
+GERMANY
+ENGLAND
+HEADQUARTERS
--- 5 row(s) selected.
>>
@@ -1827,21 +1827,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.
>>
@@ -1870,12 +1870,12 @@ VEREINIGTE CHEMIE
+> and partnum = 4102
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1890,12 +1890,12 @@ MAGNETICS CORP
+> and partnum = 4102
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+INFOMATION STORAGE
+MAGNETICS CORP
--- 3 row(s) selected.
>>
@@ -1910,13 +1910,13 @@ MAGNETICS CORP
+> and partnum = 4102
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DISPLAY INC
-STEELWORK INC
-TANDEM COMPUTERS
+DATA TERMINAL CO
+DISPLAY INC
+STEELWORK INC
+TANDEM COMPUTERS
--- 4 row(s) selected.
>>
@@ -1932,10 +1932,10 @@ TANDEM COMPUTERS
+> and empnum = 1
+> );
-REGNAME
-------------
+REGNAME
+------------
-HEADQUARTERS
+HEADQUARTERS
--- 1 row(s) selected.
>>
@@ -1951,17 +1951,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.
>>
@@ -1977,17 +1977,17 @@ PARTNUM
+> and ( orders.ordernum = odetail.ordernum) and
+> ( parts.location = 'H76') );
-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.
>>
@@ -2003,13 +2003,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.
>>
@@ -2025,11 +2025,11 @@ DISC CONT DUAL
+> and (X.salesman = Y.salesman)
+> );
-SALESMAN
---------
+SALESMAN
+--------
- 212
- 205
+ 205
+ 212
--- 2 row(s) selected.
>>
@@ -2046,28 +2046,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.
>>
@@ -2084,28 +2084,28 @@ DAVE CLARK
+> having branchnum = 1
+> );
-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.
>>
@@ -2121,13 +2121,13 @@ DAVE CLARK
+> and (suppnum = 15)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 2
- 6
- 8
- 15
+ 6
+ 15
+ 8
+ 2
--- 4 row(s) selected.
>>
@@ -2143,13 +2143,13 @@ SUPPNUM
+> and (suppnum = 1)
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 1
- 2
- 3
- 10
+ 1
+ 2
+ 3
+ 10
--- 4 row(s) selected.
>>
@@ -2165,20 +2165,20 @@ SUPPNUM
+> and (col_2 = 'V67')
+> );
-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.
>>
@@ -2212,10 +2212,10 @@ VEREINIGTE CHEMIE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2236,10 +2236,10 @@ DATADRIVE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2260,10 +2260,10 @@ DATADRIVE
+> )
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2284,11 +2284,11 @@ DATADRIVE
+> )
+> );
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
+ 6
+ 15
--- 2 row(s) selected.
>>
@@ -2311,11 +2311,11 @@ SUPPNUM
+> )
+> group by suppnum;
-SUPPNUM
--------
+SUPPNUM
+-------
- 6
- 15
+ 6
+ 15
--- 2 row(s) selected.
>>
@@ -2343,21 +2343,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.
>>
@@ -2384,21 +2384,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.
>>
@@ -2420,38 +2420,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
+-------
+
+ 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.
>>
@@ -2475,38 +2475,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
+-------
+
+ 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.
>>
@@ -2526,10 +2526,10 @@ PARTNUM
+> and orders.ordernum = odetail.ordernum )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2553,10 +2553,10 @@ CUSTNUM
+> and orders.ordernum = odetail.ordernum )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2582,10 +2582,10 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 3210
+ 3210
--- 1 row(s) selected.
>>
@@ -2607,13 +2607,13 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 1234
- 926
- 7654
- 324
+ 324
+ 926
+ 1234
+ 7654
--- 4 row(s) selected.
>>
@@ -2634,11 +2634,11 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 143
- 3210
+ 143
+ 3210
--- 2 row(s) selected.
>>
@@ -2662,11 +2662,11 @@ CUSTNUM
+> )
+> );
-CUSTNUM
--------
+CUSTNUM
+-------
- 143
- 3210
+ 3210
+ 143
--- 2 row(s) selected.
>>
@@ -2706,32 +2706,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
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 15
+ 15
+ 1
--- 23 row(s) selected.
>>
@@ -2765,11 +2765,11 @@ SUPPNUM
+> where fromsup.suppnum = supplier.suppnum
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+INFOMATION STORAGE
+DATADRIVE
--- 2 row(s) selected.
>>
@@ -2788,11 +2788,11 @@ INFOMATION STORAGE
+> where partnum = 5504
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+INFOMATION STORAGE
+DATADRIVE
--- 2 row(s) selected.
>>
@@ -2812,13 +2812,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.
>>
@@ -2837,13 +2837,13 @@ MAGNETICS CORP
+> where partnum = 5504
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATA TERMINAL CO
-DATADRIVE
-INFOMATION STORAGE
-MAGNETICS CORP
+DATADRIVE
+DATA TERMINAL CO
+MAGNETICS CORP
+INFOMATION STORAGE
--- 4 row(s) selected.
>>
@@ -2863,12 +2863,12 @@ MAGNETICS CORP
+> where partnum = 5504
+> ));
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DISPLAY INC
-STEELWORK INC
-TANDEM COMPUTERS
+DISPLAY INC
+STEELWORK INC
+TANDEM COMPUTERS
--- 3 row(s) selected.
>>
@@ -2893,10 +2893,10 @@ TANDEM COMPUTERS
+> where partnum = 5505
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
+DATADRIVE
--- 1 row(s) selected.
>>
@@ -2915,14 +2915,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.
>>
@@ -2959,28 +2959,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.
>>
@@ -3001,12 +3001,12 @@ DAVE CLARK MANAGER
+> )
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4102
- 4103
- 5504
+ 4102
+ 4103
+ 5504
--- 3 row(s) selected.
>>
@@ -3026,10 +3026,10 @@ PARTNUM
+> )
+> );
-COL_1
------
+COL_1
+-----
- 4103
+ 4103
--- 1 row(s) selected.
>>
@@ -3050,10 +3050,10 @@ COL_1
+> )
+> );
-PARTNUM
--------
+PARTNUM
+-------
- 4103
+ 4103
--- 1 row(s) selected.
>>
@@ -3076,14 +3076,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.
>>
@@ -3106,14 +3106,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.
>>-- <comment> subquery
@@ -3135,14 +3135,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.
>>
@@ -3154,8 +3154,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
@@ -3168,21 +3168,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.
>>
@@ -3194,21 +3194,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.
>>
@@ -3220,21 +3220,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.
>>
@@ -3248,16 +3248,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.
>>
@@ -3271,33 +3271,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.
>>
@@ -3310,40 +3310,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.
>>
@@ -3356,40 +3356,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.
>>
@@ -3402,40 +3402,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.
>>
@@ -3450,20 +3450,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.
>>
@@ -3481,17 +3481,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.
>>
@@ -3510,44 +3510,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.
>>
@@ -3560,20 +3560,20 @@ 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
+> );
-SUPPNAME
-------------------
+SUPPNAME
+------------------
-DATADRIVE
-INFOMATION STORAGE
+INFOMATION STORAGE
+DATADRIVE
--- 2 row(s) selected.
>>
@@ -3591,18 +3591,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.
>>
@@ -3619,16 +3619,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.
>>
@@ -3656,30 +3656,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.
>>
@@ -3697,13 +3697,13 @@ POWER MODULE
+> having sum(salary) > 150000
+> );
-BRANCHNAME
---------------
+BRANCHNAME
+--------------
-CHICAGO
-DALLAS
-FRANKFURT
-CUPERTINO
+CHICAGO
+DALLAS
+FRANKFURT
+CUPERTINO
--- 4 row(s) selected.
>>
@@ -3719,38 +3719,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.
>>
@@ -3766,38 +3766,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.
>>
@@ -3820,21 +3820,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.
>>
@@ -3857,21 +3857,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.
>>
@@ -3890,39 +3890,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.
>>