java/testing/org/apache/derbyTesting/functionTests/master/dml068.out

ij> AUTOCOMMIT OFF;
ij> -- MODULE DML068 

-- SQL Test Suite, V6.0, Interactive SQL, dml068.sql
-- 59-byte ID
-- TEd Version #

-- AUTHORIZATION HU 
   set schema HU;
0 rows inserted/updated/deleted
ij> --O   SELECT USER FROM HU.ECCO;
  VALUES USER;
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
HU                                                                                                                              
ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment

-- date_time print

-- TEST:0389 95-character graphic subset of ASCII!
-- NOTE:  OPTIONAL test
-- NOTE:0389 Collating sequence is implementor defined

     DELETE FROM AA;
0 rows inserted/updated/deleted
WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
ij> -- Making sure the table is empty

-- setup
     INSERT INTO AA VALUES('@ at');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('`-qt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('!exc');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('"dqt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('#pou');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('$dol');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('%pct');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('&amp');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('''+qt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('(lpr');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES(')rpr');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('*ast');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('bbbb');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES(':col');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('+plu');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES(';sem');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('[lbk');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('{lbc');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES(',com');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('< lt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('\bsl');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('|dvt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('-hyp');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('=equ');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES(']rbk');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('}rbc');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('.per');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('> gt');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('^hat');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('~til');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('/ sl');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('?que');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('_und');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('BBBB');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('0000');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('9999');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('zzzz');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('  sp');
1 row inserted/updated/deleted
ij> INSERT INTO AA VALUES('ZZZZ');
1 row inserted/updated/deleted
ij> SELECT * FROM AA
          ORDER BY CHARTEST;
CHARTEST            
--------------------
  sp                
!exc                
"dqt                
#pou                
$dol                
%pct                
&amp                
'+qt                
(lpr                
)rpr                
*ast                
+plu                
,com                
-hyp                
.per                
/ sl                
0000                
9999                
:col                
;sem                
< lt                
=equ                
> gt                
?que                
@ at                
BBBB                
ZZZZ                
[lbk                
\bsl                
]rbk                
^hat                
_und                
`-qt                
bbbb                
zzzz                
{lbc                
|dvt                
}rbc                
~til                
ij> -- PASS:0389 If character in 1st position matches                 ?
-- PASS:0389    description in positions 2-4                      ?
-- PASS:0389 If ASCII, then ORDER is: space followed by characters?
-- PASS:0389    !"#$%&'()*+,-./09:;<=>?@AZ[\]^_`az{|}~            ?


--O     SELECT COUNT(*)
     SELECT *
          FROM AA;
CHARTEST            
--------------------
@ at                
`-qt                
!exc                
"dqt                
#pou                
$dol                
%pct                
&amp                
'+qt                
(lpr                
)rpr                
*ast                
bbbb                
:col                
+plu                
;sem                
[lbk                
{lbc                
,com                
< lt                
\bsl                
|dvt                
-hyp                
=equ                
]rbk                
}rbc                
.per                
> gt                
^hat                
~til                
/ sl                
?que                
_und                
BBBB                
0000                
9999                
zzzz                
  sp                
ZZZZ                
ij> -- PASS:0389 If count = 39? 

-- restore
     ROLLBACK WORK;
ij> -- END TEST >>> 0389 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>