dml134.out

derby database source code.good for you.

-- PASS:0690 If view is created?
--O   COMMIT;
--O   INSERT INTO PORGRAM VALUES (
--O  1, TIME( '12:00:00'),
--O  CAST ('10:00' AS INTERVAL MINUTE TO SECOND),
--O  'Monologue');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  2, TIME( '12:10:00'),
--O  CAST ('04:30' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  3, TIME( '12:14:30'),
--O  CAST ('12:30' AS INTERVAL MINUTE TO SECOND),
--O  'Braunschweiger, plug Explosion Man II');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  4, TIME( '12:27:00'),
--O  CAST ('03:00' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  5, TIME( '12:30:00'),
--O  CAST ('00:10' AS INTERVAL MINUTE TO SECOND),
--O  'Tease');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  6, TIME( '12:30:10'),
--O  CAST ('03:50' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials, local news');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  7, TIME( '12:34:00'),
--O  CAST ('11:00' AS INTERVAL MINUTE TO SECOND),
--O  'Spinal Tap, plug Asexual Harassment');
--O-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  8, TIME( '12:45:00'),
--O  CAST ('05:00' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  9, TIME( '12:50:00'),
--O  CAST ('05:00' AS INTERVAL MINUTE TO SECOND),
--O  'Spinal Tap, play Ode du Toilette');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  10, TIME( '12:55:00'),
--O  CAST ('03:00' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  11, TIME( '12:58:00'),
--O  CAST ('00:10' AS INTERVAL MINUTE TO SECOND),
--O  'Credits');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  12, TIME( '12:58:10'),
--O  CAST ('01:50' AS INTERVAL MINUTE TO SECOND),
--O  'Stupid commercials');
-- PASS:0690 If 1 row is inserted?
--O   INSERT INTO PORGRAM VALUES (
--O  13, TIME( '13:00:00'),
--O  CAST ('00:00' AS INTERVAL MINUTE TO SECOND),
--O  'END');
-- PASS:0690 If 1 row is inserted?
--O   SELECT COUNT(*) FROM GAPS;
-- PASS:0690 If count = 0?
--O   UPDATE PORGRAM
--O  SET STARTS = TIME( '12:14:30')
--O  WHERE SEGNO = 7;
-- PASS:0690 If 1 row is updated?
--O   UPDATE PORGRAM SET STARTS = STARTS -
--O  CAST ('01:30' AS INTERVAL MINUTE TO SECOND)
--O  WHERE SEGNO >= 4 AND SEGNO <= 6;
-- PASS:0690 If 3 rows are updated?
--O   UPDATE PORGRAM SET STARTS = TIME( '12:28:40') +
--O  CAST ('03:50' AS INTERVAL MINUTE TO SECOND)
--O  WHERE SEGNO = 3;
-- PASS:0690 If 1 row is updated?
--O   SELECT COUNT(*) FROM GAPS;
-- PASS:0690 If count = 0?
--O  SELECT SEGNO FROM PORGRAM ORDER BY STARTS;
-- PASS:0690 If 13 rows selected with SEGNO in the following order?
-- PASS:0690      1
-- PASS:0690      2
-- PASS:0690      7
-- PASS:0690      4
-- PASS:0690      5
-- PASS:0690      6
-- PASS:0690      3
-- PASS:0690      8
-- PASS:0690      9
-- PASS:0690     10
-- PASS:0690     11
-- PASS:0690     12
-- PASS:0690     13
--O   UPDATE PORGRAM SET LASTS = LASTS -
--O  CAST (30 AS INTERVAL SECOND) WHERE SEGNO
--O  = 10;
-- PASS:0690 If 1 row is updated?
--O   SELECT SEGNO FROM GAPS;
-- PASS:0690 If 1 row selected and SEGNO = 10?
--O   UPDATE PORGRAM SET LASTS = LASTS +
--O  CAST ('30' AS INTERVAL SECOND) WHERE
--O  SEGNO = 9;
-- PASS:0690 If 1 row is updated?
--O   UPDATE PORGRAM SET STARTS = STARTS +
--O  CAST (30. AS INTERVAL SECOND) WHERE
--O  SEGNO = 10;
-- PASS:0690 If 1 row is updated?
--O   SELECT COUNT(*) FROM GAPS;
-- PASS:0690 If count = 0?
--O   COMMIT;
--O   DROP TABLE PORGRAM CASCADE;
-- PASS:0690 If table and view are dropped?
--O   COMMIT;
-- END TEST >>> 0690 <<< END TEST
-- *********************************************
-- TEST:0691 INFO_SCHEM:  SQLSTATEs for length overruns!
   CREATE TABLE LONG1 (
  C1 INT,
  CHECK (
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL));
0 rows inserted/updated/deleted
ij> -- PASS:0691 If WARNING:  search condition too long for information schema?
-- PASS:0691 OR successful completion?
   ROLLBACK WORK;
ij> CREATE VIEW LONG2 AS
  SELECT * FROM USIG WHERE
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL AND
C1 IS NOT NULL AND C1 IS NOT NULL AND C1 IS NOT NULL;
0 rows inserted/updated/deleted
ij> -- PASS:0691 If WARNING:  query expression too long for information schema?
-- PASS:0691 OR successful completion?
   ROLLBACK WORK;
ij> -- END TEST >>> 0691 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>