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. >>
