db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r476616 - in /db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master: ibm15/dcl.out j9_13/dcl.out j9_13/dml119.out j9_22/dml160.out j9_foundation/dml160.out
Date Sat, 18 Nov 2006 21:55:22 GMT
Author: myrnavl
Date: Sat Nov 18 13:55:20 2006
New Revision: 476616

URL: http://svn.apache.org/viewvc?view=rev&rev=476616
Log:
DERBY-2080 - dml119, dml160 and dcl.sql have outdated canons

There were jvm-specific output files for these tests that somehow missed getting the apache license info.


Modified:
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dml119.out
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/dml160.out
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dml160.out

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out?view=diff&rev=476616&r1=476615&r2=476616
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm15/dcl.out Sat Nov 18 13:55:20 2006
@@ -289,7 +289,23 @@
 -- first using the jar protocol and then the classpath option.
 connect 'jdbc:derby:jar:(ina.jar)db7' AS DB7;
 ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- common tests for read-only jarred database
 select * from EMC.CONTACTS;
 ID         |E_MAIL                        |OK    
 -------------------------------------------------
@@ -358,7 +374,23 @@
 ij> disconnect;
 ij> connect 'jdbc:derby:classpath:db7' AS DB7CL;
 ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- common tests for read-only jarred database
 select * from EMC.CONTACTS;
 ID         |E_MAIL                        |OK    
 -------------------------------------------------

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out?view=diff&rev=476616&r1=476615&r2=476616
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out Sat Nov 18 13:55:20 2006
@@ -289,7 +289,23 @@
 -- first using the jar protocol and then the classpath option.
 connect 'jdbc:derby:jar:(ina.jar)db7' AS DB7;
 ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- common tests for read-only jarred database
 select * from EMC.CONTACTS;
 ID         |E_MAIL                        |OK    
 -------------------------------------------------
@@ -358,7 +374,23 @@
 ij> disconnect;
 ij> connect 'jdbc:derby:classpath:db7' AS DB7CL;
 ij> run resource '/org/apache/derbyTesting/functionTests/tests/lang/dcl_readOnly.sql';
-ij> -- common tests for read-only jarred database
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- common tests for read-only jarred database
 select * from EMC.CONTACTS;
 ID         |E_MAIL                        |OK    
 -------------------------------------------------

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dml119.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dml119.out?view=diff&rev=476616&r1=476615&r2=476616
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dml119.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dml119.out Sat Nov 18 13:55:20 2006
@@ -1,20 +1,4 @@
-ij> --
---   Licensed to the Apache Software Foundation (ASF) under one or more
---   contributor license agreements.  See the NOTICE file distributed with
---   this work for additional information regarding copyright ownership.
---   The ASF licenses this file to You under the Apache License, Version 2.0
---   (the "License"); you may not use this file except in compliance with
---   the License.  You may obtain a copy of the License at
---
---      http://www.apache.org/licenses/LICENSE-2.0
---
---   Unless required by applicable law or agreed to in writing, software
---   distributed under the License is distributed on an "AS IS" BASIS,
---   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
---   See the License for the specific language governing permissions and
---   limitations under the License.
---
-AUTOCOMMIT OFF;
+ij> AUTOCOMMIT OFF;
 ij> -- MODULE  DML119  
 -- SQL Test Suite, V6.0, Interactive SQL, dml119.sql
 -- 59-byte ID

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/dml160.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/dml160.out?view=diff&rev=476616&r1=476615&r2=476616
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/dml160.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/dml160.out Sat Nov 18 13:55:20 2006
@@ -1,307 +1,307 @@
-ij> --
---   Licensed to the Apache Software Foundation (ASF) under one or more
---   contributor license agreements.  See the NOTICE file distributed with
---   this work for additional information regarding copyright ownership.
---   The ASF licenses this file to You under the Apache License, Version 2.0
---   (the "License"); you may not use this file except in compliance with
---   the License.  You may obtain a copy of the License at
---
---      http://www.apache.org/licenses/LICENSE-2.0
---
---   Unless required by applicable law or agreed to in writing, software
---   distributed under the License is distributed on an "AS IS" BASIS,
---   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
---   See the License for the specific language governing permissions and
---   limitations under the License.
---
-AUTOCOMMIT OFF;
-ij> -- MODULE  DML160  
--- SQL Test Suite, V6.0, Interactive SQL, dml160.sql
--- 59-byte ID
--- TEd Version #
--- AUTHORIZATION FLATER
-   set schema FLATER;
-0 rows inserted/updated/deleted
-ij> --O   SELECT USER FROM HU.ECCO;
-  VALUES USER;
-1                                                                                                                               
---------------------------------------------------------------------------------------------------------------------------------
-FLATER                                                                                                                          
-ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
-   ROLLBACK WORK;
-ij> -- date_time print
--- TEST:0859 <joined table> contained in <select list>!
-   SELECT EMPNUM, (SELECT COUNT(*) FROM HU.WORKS JOIN HU.PROJ
-     ON HU.WORKS.PNUM = HU.PROJ.PNUM
-     AND BUDGET > AVG (OSTAFF.GRADE) * 1000
-     WHERE HU.WORKS.EMPNUM = OSTAFF.EMPNUM) FROM HU.STAFF AS OSTAFF
-     ORDER BY 2, 1;
-ERROR 42972: An ON clause associated with a JOIN operator is not valid.
-ij> -- PASS:0859 If 5 rows are returned in the following order?
---               empnum   count
---               ======   =====
--- PASS:0859 If    E5       0  ?
--- PASS:0859 If    E2       1  ?
--- PASS:0859 If    E3       1  ?
--- PASS:0859 If    E4       2  ?
--- PASS:0859 If    E1       4  ?  
-   COMMIT WORK;
-ij> -- END TEST >>> 0859 <<< END TEST
--- *********************************************
--- TEST:0860 Domains over various data types!
---O   CREATE DOMAIN EPOCH_NOT_NORM AS DECIMAL (5, 2);
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN RAD_EPOCH_TYPE FLOAT (20)
---O     CHECK (VALUE BETWEEN 0E0 AND 2E0 * 3.1416E0);
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN RAD_EPOCH_NOT_NORM REAL;
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN TIDEDATE AS DATE
---O    CHECK (VALUE BETWEEN DATE( '1994-01-01') AND DATE( '2025-12-31'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN TIDETIMESTAMP AS TIMESTAMP WITH TIME ZONE
---O    CHECK (VALUE BETWEEN TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00')
---O    AND TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN DINNERTIME AS TIME
---O    CHECK (VALUE BETWEEN TIME( '17:30:00') AND TIME( '19:00:00'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE CONST_NOT_NORM (
---O     LOC_ID DEC (7) NOT NULL,
---O     CONST_ID TIDES.CONST_ID_TYPE NOT NULL,
---O     UNIQUE (LOC_ID, CONST_ID),
---O     AMPLITUDE TIDES.AMPLITUDE_TYPE,
---O     EPOCH EPOCH_NOT_NORM);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CONST_RAD (LOC_ID, CONST_ID,
---O     AMPLITUDE, EPOCH) AS
---O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
---O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_TYPE)
---O     FROM TIDES.CONSTITUENTS;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CONST_RAD_NOT_NORM (LOC_ID, CONST_ID,
---O     AMPLITUDE, EPOCH) AS
---O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
---O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_NOT_NORM)
---O     FROM CONST_NOT_NORM;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE PENDING (
---O     LOC_ID DEC (7) NOT NULL,
---O     FROMTIME TIDETIMESTAMP NOT NULL,
---O     TOTIME TIDETIMESTAMP NOT NULL,
---O     CHECK (FROMTIME <= TOTIME),
---O     JOB_ID INT PRIMARY KEY);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CHECK_PTS (CHECK_DATES, JOB_ID, FLAG) AS
---O     SELECT CAST (FROMTIME AS TIDEDATE), JOB_ID,
---O     CAST (0 AS INT) FROM PENDING
---O       UNION
---O     SELECT CAST (TOTIME AS TIDEDATE), JOB_ID,
---O     CAST (1 AS INT) FROM PENDING;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE DINNER_CLUB (
---O     LOC_ID DEC (7) NOT NULL,
---O     DINNER DINNERTIME);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   SELECT HOUR( MERIDIAN), EXTRACT
---O     (MINUTE FROM MERIDIAN) 
---O     FROM TIDES.LOCATIONS WHERE LOC_NAME LIKE '%Newfound%';
---O-- PASS:0860 If xhour = -3?
---O-- PASS:0860 If xminute = -30?
---O
---O   INSERT INTO TIDES.LOCATIONS VALUES (
---O     300, 'Atlantis', 160.0000, 3.0000, 0, 1.2E0,
---O     INTERVAL -'13:00' HOUR TO MINUTE, 'GMT-13');
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   UPDATE TIDES.CONSTITUENTS
---O     SET AMPLITUDE = - AMPLITUDE
---O     WHERE LOC_ID = 100
---O     AND CONST_ID = 0;
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO TIDES.LOCATIONS VALUES (300,
---O     'Bath, Maine', -69.8133, 43.9183,
---O     1, 3.422E0, INTERVAL '-05:00' HOUR TO MINUTE, ':US/Eastern');
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO TIDES.CONSTITUENTS VALUES (300, 2, 0.134E0, 385.0);
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 0, 0.021E0, 151.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 1, 0.324E0, 144.5);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 2, 0.134E0, 385.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 3, 0.181E0, 40.9);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 4, 0.037E0, 150.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 5, 3.143E0, 352.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 6, 0.000E0, 50.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 7, 0.104E0, 242.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 8, 0.031E0, 158.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 9, 0.000E0, 133.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 10, 0.744E0, 322.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 11, 0.087E0, 307.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 12, 0.260E0, 130.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 13, 0.011E0, 158.7);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 14, 0.107E0, 140.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 15, 0.043E0, 114.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 16, 0.007E0, 116.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 17, 0.004E0, 383.2);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 18, 0.000E0, 17.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 19, 0.488E0, 383.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 20, 0.000E0, 69.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 21, 0.000E0, 103.5);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 22, 0.053E0, 365.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 23, 0.053E0, 37.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 24, 0.023E0, 297.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 25, 0.138E0, 328.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 26, 0.010E0, 124.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 27, 0.000E0, 50.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 28, 0.000E0, 49.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 29, 0.000E0, 66.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 30, 0.000E0, 67.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 31, 0.000E0, 35.7);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 32, 0.073E0, 285.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 33, 0.033E0, 257.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 34, 0.000E0, 0.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 35, 0.056E0, 128.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 36, 0.038E0, 97.7);
---O-- PASS:0860 If 37 rows inserted from previous 37 inserts?
---O
---O   SELECT EPOCH FROM CONST_RAD
---O     WHERE LOC_ID = 100
---O     AND CONST_ID = 0;
---O-- PASS:0860 If EPOCH = 2.11 (+ or - 0.01)?
---O
---O   SELECT COUNT(*) 
---O     FROM CONST_RAD_NOT_NORM
---O     WHERE EPOCH > 6.2831853E0;
---O-- PASS:0860 If COUNT = 4?
---O
---O   INSERT INTO PENDING VALUES (
---O     300, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 0);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO PENDING VALUES (
---O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO PENDING VALUES (
---O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO PENDING VALUES (
---O     102, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O       TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 2);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   SELECT YEAR( CHECK_DATES)
---O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 0;
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   SELECT YEAR( CHECK_DATES)
---O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 1;
---O-- PASS:0860 If xyear = 1994?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (0, TIME( '17:30:00'));
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (1, CAST (TIME( '18:00:00') AS DINNERTIME));
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (2, TIME( '19:30:00'));
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   COMMIT WORK;
---O
---O   DROP DOMAIN EPOCH_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN RAD_EPOCH_TYPE CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN RAD_EPOCH_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN TIDEDATE CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN TIDETIMESTAMP CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN DINNERTIME CASCADE;
---O   COMMIT WORK;
---O-- PASS:0860 If domains dropped successfully in 6 previous drops?
---O
---O   DROP TABLE CONST_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP VIEW CONST_RAD CASCADE;
---O   COMMIT WORK;
---O   DROP TABLE PENDING CASCADE;
---O   COMMIT WORK;
---O   DROP TABLE DINNER_CLUB CASCADE;
---O   COMMIT WORK;
---O-- PASS:0860 If tables and view dropped in 4 previous drops?
---O
---O   DELETE FROM TIDES.LOCATIONS
---O     WHERE LOC_ID = 300;
---O-- PASS:0860 If delete completed successfully?
---O
---O   COMMIT WORK;
---O
---O-- END TEST >>> 0860 <<< END TEST
---O-- *********************************************
---O-- *************************************************////END-OF-MODULE
--- Simple addition to check the test has a security manager installed.
-run resource '/org/apache/derbyTesting/functionTests/util/testRoutines.sql';
-ij> -- Changed to create individual procedures so that this will work with JSR169. 
--- Direct call to 'installRoutines' uses nested connection
-CREATE PROCEDURE TESTROUTINE.SET_SYSTEM_PROPERTY(IN PROPERTY_KEY VARCHAR(32000), IN PROPERTY_VALUE VARCHAR(32000)) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.setSystemProperty' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE PROCEDURE TESTROUTINE.SLEEP(IN SLEEP_TIME_MS BIGINT) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.sleep' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE FUNCTION TESTROUTINE.HAS_SECURITY_MANAGER() RETURNS INT NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.hasSecurityManager' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE FUNCTION TESTROUTINE.READ_FILE(FILE_NAME VARCHAR(60), ENCODING VARCHAR(60)) RETURNS VARCHAR(32000) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.readFile' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> values TESTROUTINE.HAS_SECURITY_MANAGER();
-1          
------------
-0          
-ij> 
+ij> AUTOCOMMIT OFF;
+ij> -- MODULE  DML160  
+-- SQL Test Suite, V6.0, Interactive SQL, dml160.sql
+-- 59-byte ID
+-- TEd Version #
+-- AUTHORIZATION FLATER
+   set schema FLATER;
+0 rows inserted/updated/deleted
+ij> --O   SELECT USER FROM HU.ECCO;
+  VALUES USER;
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+FLATER                                                                                                                          
+ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+   ROLLBACK WORK;
+ij> -- date_time print
+-- TEST:0859 <joined table> contained in <select list>!
+   SELECT EMPNUM, (SELECT COUNT(*) FROM HU.WORKS JOIN HU.PROJ
+     ON HU.WORKS.PNUM = HU.PROJ.PNUM
+     AND BUDGET > AVG (OSTAFF.GRADE) * 1000
+     WHERE HU.WORKS.EMPNUM = OSTAFF.EMPNUM) FROM HU.STAFF AS OSTAFF
+     ORDER BY 2, 1;
+ERROR 42972: An ON clause associated with a JOIN operator is not valid.
+ij> -- PASS:0859 If 5 rows are returned in the following order?
+--               empnum   count
+--               ======   =====
+-- PASS:0859 If    E5       0  ?
+-- PASS:0859 If    E2       1  ?
+-- PASS:0859 If    E3       1  ?
+-- PASS:0859 If    E4       2  ?
+-- PASS:0859 If    E1       4  ?  
+   COMMIT WORK;
+ij> -- END TEST >>> 0859 <<< END TEST
+-- *********************************************
+-- TEST:0860 Domains over various data types!
+--O   CREATE DOMAIN EPOCH_NOT_NORM AS DECIMAL (5, 2);
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN RAD_EPOCH_TYPE FLOAT (20)
+--O     CHECK (VALUE BETWEEN 0E0 AND 2E0 * 3.1416E0);
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN RAD_EPOCH_NOT_NORM REAL;
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN TIDEDATE AS DATE
+--O    CHECK (VALUE BETWEEN DATE( '1994-01-01') AND DATE( '2025-12-31'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN TIDETIMESTAMP AS TIMESTAMP WITH TIME ZONE
+--O    CHECK (VALUE BETWEEN TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00')
+--O    AND TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN DINNERTIME AS TIME
+--O    CHECK (VALUE BETWEEN TIME( '17:30:00') AND TIME( '19:00:00'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE CONST_NOT_NORM (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     CONST_ID TIDES.CONST_ID_TYPE NOT NULL,
+--O     UNIQUE (LOC_ID, CONST_ID),
+--O     AMPLITUDE TIDES.AMPLITUDE_TYPE,
+--O     EPOCH EPOCH_NOT_NORM);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CONST_RAD (LOC_ID, CONST_ID,
+--O     AMPLITUDE, EPOCH) AS
+--O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
+--O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_TYPE)
+--O     FROM TIDES.CONSTITUENTS;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CONST_RAD_NOT_NORM (LOC_ID, CONST_ID,
+--O     AMPLITUDE, EPOCH) AS
+--O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
+--O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_NOT_NORM)
+--O     FROM CONST_NOT_NORM;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE PENDING (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     FROMTIME TIDETIMESTAMP NOT NULL,
+--O     TOTIME TIDETIMESTAMP NOT NULL,
+--O     CHECK (FROMTIME <= TOTIME),
+--O     JOB_ID INT PRIMARY KEY);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CHECK_PTS (CHECK_DATES, JOB_ID, FLAG) AS
+--O     SELECT CAST (FROMTIME AS TIDEDATE), JOB_ID,
+--O     CAST (0 AS INT) FROM PENDING
+--O       UNION
+--O     SELECT CAST (TOTIME AS TIDEDATE), JOB_ID,
+--O     CAST (1 AS INT) FROM PENDING;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE DINNER_CLUB (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     DINNER DINNERTIME);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   SELECT HOUR( MERIDIAN), EXTRACT
+--O     (MINUTE FROM MERIDIAN) 
+--O     FROM TIDES.LOCATIONS WHERE LOC_NAME LIKE '%Newfound%';
+--O-- PASS:0860 If xhour = -3?
+--O-- PASS:0860 If xminute = -30?
+--O
+--O   INSERT INTO TIDES.LOCATIONS VALUES (
+--O     300, 'Atlantis', 160.0000, 3.0000, 0, 1.2E0,
+--O     INTERVAL -'13:00' HOUR TO MINUTE, 'GMT-13');
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   UPDATE TIDES.CONSTITUENTS
+--O     SET AMPLITUDE = - AMPLITUDE
+--O     WHERE LOC_ID = 100
+--O     AND CONST_ID = 0;
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO TIDES.LOCATIONS VALUES (300,
+--O     'Bath, Maine', -69.8133, 43.9183,
+--O     1, 3.422E0, INTERVAL '-05:00' HOUR TO MINUTE, ':US/Eastern');
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO TIDES.CONSTITUENTS VALUES (300, 2, 0.134E0, 385.0);
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 0, 0.021E0, 151.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 1, 0.324E0, 144.5);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 2, 0.134E0, 385.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 3, 0.181E0, 40.9);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 4, 0.037E0, 150.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 5, 3.143E0, 352.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 6, 0.000E0, 50.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 7, 0.104E0, 242.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 8, 0.031E0, 158.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 9, 0.000E0, 133.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 10, 0.744E0, 322.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 11, 0.087E0, 307.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 12, 0.260E0, 130.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 13, 0.011E0, 158.7);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 14, 0.107E0, 140.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 15, 0.043E0, 114.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 16, 0.007E0, 116.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 17, 0.004E0, 383.2);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 18, 0.000E0, 17.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 19, 0.488E0, 383.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 20, 0.000E0, 69.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 21, 0.000E0, 103.5);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 22, 0.053E0, 365.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 23, 0.053E0, 37.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 24, 0.023E0, 297.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 25, 0.138E0, 328.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 26, 0.010E0, 124.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 27, 0.000E0, 50.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 28, 0.000E0, 49.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 29, 0.000E0, 66.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 30, 0.000E0, 67.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 31, 0.000E0, 35.7);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 32, 0.073E0, 285.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 33, 0.033E0, 257.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 34, 0.000E0, 0.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 35, 0.056E0, 128.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 36, 0.038E0, 97.7);
+--O-- PASS:0860 If 37 rows inserted from previous 37 inserts?
+--O
+--O   SELECT EPOCH FROM CONST_RAD
+--O     WHERE LOC_ID = 100
+--O     AND CONST_ID = 0;
+--O-- PASS:0860 If EPOCH = 2.11 (+ or - 0.01)?
+--O
+--O   SELECT COUNT(*) 
+--O     FROM CONST_RAD_NOT_NORM
+--O     WHERE EPOCH > 6.2831853E0;
+--O-- PASS:0860 If COUNT = 4?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     300, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 0);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     102, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O       TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 2);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   SELECT YEAR( CHECK_DATES)
+--O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 0;
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   SELECT YEAR( CHECK_DATES)
+--O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 1;
+--O-- PASS:0860 If xyear = 1994?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (0, TIME( '17:30:00'));
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (1, CAST (TIME( '18:00:00') AS DINNERTIME));
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (2, TIME( '19:30:00'));
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   COMMIT WORK;
+--O
+--O   DROP DOMAIN EPOCH_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN RAD_EPOCH_TYPE CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN RAD_EPOCH_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN TIDEDATE CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN TIDETIMESTAMP CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN DINNERTIME CASCADE;
+--O   COMMIT WORK;
+--O-- PASS:0860 If domains dropped successfully in 6 previous drops?
+--O
+--O   DROP TABLE CONST_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP VIEW CONST_RAD CASCADE;
+--O   COMMIT WORK;
+--O   DROP TABLE PENDING CASCADE;
+--O   COMMIT WORK;
+--O   DROP TABLE DINNER_CLUB CASCADE;
+--O   COMMIT WORK;
+--O-- PASS:0860 If tables and view dropped in 4 previous drops?
+--O
+--O   DELETE FROM TIDES.LOCATIONS
+--O     WHERE LOC_ID = 300;
+--O-- PASS:0860 If delete completed successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O-- END TEST >>> 0860 <<< END TEST
+--O-- *********************************************
+--O-- *************************************************////END-OF-MODULE
+-- Simple addition to check the test has a security manager installed.
+run resource '/org/apache/derbyTesting/functionTests/util/testRoutines.sql';
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- Changed to create individual procedures so that this will work with JSR169. 
+-- Direct call to 'installRoutines' uses nested connection
+CREATE PROCEDURE TESTROUTINE.SET_SYSTEM_PROPERTY(IN PROPERTY_KEY VARCHAR(32000), IN PROPERTY_VALUE VARCHAR(32000)) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.setSystemProperty' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE PROCEDURE TESTROUTINE.SLEEP(IN SLEEP_TIME_MS BIGINT) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.sleep' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION TESTROUTINE.HAS_SECURITY_MANAGER() RETURNS INT NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.hasSecurityManager' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION TESTROUTINE.READ_FILE(FILE_NAME VARCHAR(60), ENCODING VARCHAR(60)) RETURNS VARCHAR(32000) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.readFile' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> values TESTROUTINE.HAS_SECURITY_MANAGER();
+1          
+-----------
+0          
+ij> 

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dml160.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dml160.out?view=diff&rev=476616&r1=476615&r2=476616
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dml160.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dml160.out Sat Nov 18 13:55:20 2006
@@ -1,307 +1,307 @@
-ij> --
---   Licensed to the Apache Software Foundation (ASF) under one or more
---   contributor license agreements.  See the NOTICE file distributed with
---   this work for additional information regarding copyright ownership.
---   The ASF licenses this file to You under the Apache License, Version 2.0
---   (the "License"); you may not use this file except in compliance with
---   the License.  You may obtain a copy of the License at
---
---      http://www.apache.org/licenses/LICENSE-2.0
---
---   Unless required by applicable law or agreed to in writing, software
---   distributed under the License is distributed on an "AS IS" BASIS,
---   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
---   See the License for the specific language governing permissions and
---   limitations under the License.
---
-AUTOCOMMIT OFF;
-ij> -- MODULE  DML160  
--- SQL Test Suite, V6.0, Interactive SQL, dml160.sql
--- 59-byte ID
--- TEd Version #
--- AUTHORIZATION FLATER
-   set schema FLATER;
-0 rows inserted/updated/deleted
-ij> --O   SELECT USER FROM HU.ECCO;
-  VALUES USER;
-1                                                                                                                               
---------------------------------------------------------------------------------------------------------------------------------
-FLATER                                                                                                                          
-ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
-   ROLLBACK WORK;
-ij> -- date_time print
--- TEST:0859 <joined table> contained in <select list>!
-   SELECT EMPNUM, (SELECT COUNT(*) FROM HU.WORKS JOIN HU.PROJ
-     ON HU.WORKS.PNUM = HU.PROJ.PNUM
-     AND BUDGET > AVG (OSTAFF.GRADE) * 1000
-     WHERE HU.WORKS.EMPNUM = OSTAFF.EMPNUM) FROM HU.STAFF AS OSTAFF
-     ORDER BY 2, 1;
-ERROR 42972: An ON clause associated with a JOIN operator is not valid.
-ij> -- PASS:0859 If 5 rows are returned in the following order?
---               empnum   count
---               ======   =====
--- PASS:0859 If    E5       0  ?
--- PASS:0859 If    E2       1  ?
--- PASS:0859 If    E3       1  ?
--- PASS:0859 If    E4       2  ?
--- PASS:0859 If    E1       4  ?  
-   COMMIT WORK;
-ij> -- END TEST >>> 0859 <<< END TEST
--- *********************************************
--- TEST:0860 Domains over various data types!
---O   CREATE DOMAIN EPOCH_NOT_NORM AS DECIMAL (5, 2);
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN RAD_EPOCH_TYPE FLOAT (20)
---O     CHECK (VALUE BETWEEN 0E0 AND 2E0 * 3.1416E0);
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN RAD_EPOCH_NOT_NORM REAL;
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN TIDEDATE AS DATE
---O    CHECK (VALUE BETWEEN DATE( '1994-01-01') AND DATE( '2025-12-31'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN TIDETIMESTAMP AS TIMESTAMP WITH TIME ZONE
---O    CHECK (VALUE BETWEEN TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00')
---O    AND TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE DOMAIN DINNERTIME AS TIME
---O    CHECK (VALUE BETWEEN TIME( '17:30:00') AND TIME( '19:00:00'));
---O-- PASS:0860 If domain created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE CONST_NOT_NORM (
---O     LOC_ID DEC (7) NOT NULL,
---O     CONST_ID TIDES.CONST_ID_TYPE NOT NULL,
---O     UNIQUE (LOC_ID, CONST_ID),
---O     AMPLITUDE TIDES.AMPLITUDE_TYPE,
---O     EPOCH EPOCH_NOT_NORM);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CONST_RAD (LOC_ID, CONST_ID,
---O     AMPLITUDE, EPOCH) AS
---O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
---O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_TYPE)
---O     FROM TIDES.CONSTITUENTS;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CONST_RAD_NOT_NORM (LOC_ID, CONST_ID,
---O     AMPLITUDE, EPOCH) AS
---O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
---O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_NOT_NORM)
---O     FROM CONST_NOT_NORM;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE PENDING (
---O     LOC_ID DEC (7) NOT NULL,
---O     FROMTIME TIDETIMESTAMP NOT NULL,
---O     TOTIME TIDETIMESTAMP NOT NULL,
---O     CHECK (FROMTIME <= TOTIME),
---O     JOB_ID INT PRIMARY KEY);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE VIEW CHECK_PTS (CHECK_DATES, JOB_ID, FLAG) AS
---O     SELECT CAST (FROMTIME AS TIDEDATE), JOB_ID,
---O     CAST (0 AS INT) FROM PENDING
---O       UNION
---O     SELECT CAST (TOTIME AS TIDEDATE), JOB_ID,
---O     CAST (1 AS INT) FROM PENDING;
---O-- PASS:0860 If view created successfully?
---O
---O   COMMIT WORK;
---O
---O   CREATE TABLE DINNER_CLUB (
---O     LOC_ID DEC (7) NOT NULL,
---O     DINNER DINNERTIME);
---O-- PASS:0860 If table created successfully?
---O
---O   COMMIT WORK;
---O
---O   SELECT HOUR( MERIDIAN), EXTRACT
---O     (MINUTE FROM MERIDIAN) 
---O     FROM TIDES.LOCATIONS WHERE LOC_NAME LIKE '%Newfound%';
---O-- PASS:0860 If xhour = -3?
---O-- PASS:0860 If xminute = -30?
---O
---O   INSERT INTO TIDES.LOCATIONS VALUES (
---O     300, 'Atlantis', 160.0000, 3.0000, 0, 1.2E0,
---O     INTERVAL -'13:00' HOUR TO MINUTE, 'GMT-13');
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   UPDATE TIDES.CONSTITUENTS
---O     SET AMPLITUDE = - AMPLITUDE
---O     WHERE LOC_ID = 100
---O     AND CONST_ID = 0;
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO TIDES.LOCATIONS VALUES (300,
---O     'Bath, Maine', -69.8133, 43.9183,
---O     1, 3.422E0, INTERVAL '-05:00' HOUR TO MINUTE, ':US/Eastern');
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO TIDES.CONSTITUENTS VALUES (300, 2, 0.134E0, 385.0);
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 0, 0.021E0, 151.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 1, 0.324E0, 144.5);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 2, 0.134E0, 385.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 3, 0.181E0, 40.9);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 4, 0.037E0, 150.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 5, 3.143E0, 352.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 6, 0.000E0, 50.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 7, 0.104E0, 242.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 8, 0.031E0, 158.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 9, 0.000E0, 133.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 10, 0.744E0, 322.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 11, 0.087E0, 307.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 12, 0.260E0, 130.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 13, 0.011E0, 158.7);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 14, 0.107E0, 140.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 15, 0.043E0, 114.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 16, 0.007E0, 116.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 17, 0.004E0, 383.2);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 18, 0.000E0, 17.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 19, 0.488E0, 383.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 20, 0.000E0, 69.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 21, 0.000E0, 103.5);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 22, 0.053E0, 365.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 23, 0.053E0, 37.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 24, 0.023E0, 297.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 25, 0.138E0, 328.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 26, 0.010E0, 124.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 27, 0.000E0, 50.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 28, 0.000E0, 49.4);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 29, 0.000E0, 66.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 30, 0.000E0, 67.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 31, 0.000E0, 35.7);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 32, 0.073E0, 285.0);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 33, 0.033E0, 257.3);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 34, 0.000E0, 0.6);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 35, 0.056E0, 128.8);
---O   INSERT INTO CONST_NOT_NORM VALUES (300, 36, 0.038E0, 97.7);
---O-- PASS:0860 If 37 rows inserted from previous 37 inserts?
---O
---O   SELECT EPOCH FROM CONST_RAD
---O     WHERE LOC_ID = 100
---O     AND CONST_ID = 0;
---O-- PASS:0860 If EPOCH = 2.11 (+ or - 0.01)?
---O
---O   SELECT COUNT(*) 
---O     FROM CONST_RAD_NOT_NORM
---O     WHERE EPOCH > 6.2831853E0;
---O-- PASS:0860 If COUNT = 4?
---O
---O   INSERT INTO PENDING VALUES (
---O     300, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 0);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO PENDING VALUES (
---O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   INSERT INTO PENDING VALUES (
---O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO PENDING VALUES (
---O     102, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
---O       TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 2);
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   SELECT YEAR( CHECK_DATES)
---O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 0;
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   SELECT YEAR( CHECK_DATES)
---O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 1;
---O-- PASS:0860 If xyear = 1994?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (0, TIME( '17:30:00'));
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (1, CAST (TIME( '18:00:00') AS DINNERTIME));
---O-- PASS:0860 If 1 row inserted successfully?
---O
---O   INSERT INTO DINNER_CLUB VALUES
---O     (2, TIME( '19:30:00'));
---O-- PASS:0860 If ERROR - integrity constraint violation?
---O
---O   COMMIT WORK;
---O
---O   DROP DOMAIN EPOCH_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN RAD_EPOCH_TYPE CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN RAD_EPOCH_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN TIDEDATE CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN TIDETIMESTAMP CASCADE;
---O   COMMIT WORK;
---O   DROP DOMAIN DINNERTIME CASCADE;
---O   COMMIT WORK;
---O-- PASS:0860 If domains dropped successfully in 6 previous drops?
---O
---O   DROP TABLE CONST_NOT_NORM CASCADE;
---O   COMMIT WORK;
---O   DROP VIEW CONST_RAD CASCADE;
---O   COMMIT WORK;
---O   DROP TABLE PENDING CASCADE;
---O   COMMIT WORK;
---O   DROP TABLE DINNER_CLUB CASCADE;
---O   COMMIT WORK;
---O-- PASS:0860 If tables and view dropped in 4 previous drops?
---O
---O   DELETE FROM TIDES.LOCATIONS
---O     WHERE LOC_ID = 300;
---O-- PASS:0860 If delete completed successfully?
---O
---O   COMMIT WORK;
---O
---O-- END TEST >>> 0860 <<< END TEST
---O-- *********************************************
---O-- *************************************************////END-OF-MODULE
--- Simple addition to check the test has a security manager installed.
-run resource '/org/apache/derbyTesting/functionTests/util/testRoutines.sql';
-ij> -- Changed to create individual procedures so that this will work with JSR169. 
--- Direct call to 'installRoutines' uses nested connection
-CREATE PROCEDURE TESTROUTINE.SET_SYSTEM_PROPERTY(IN PROPERTY_KEY VARCHAR(32000), IN PROPERTY_VALUE VARCHAR(32000)) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.setSystemProperty' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE PROCEDURE TESTROUTINE.SLEEP(IN SLEEP_TIME_MS BIGINT) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.sleep' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE FUNCTION TESTROUTINE.HAS_SECURITY_MANAGER() RETURNS INT NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.hasSecurityManager' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> CREATE FUNCTION TESTROUTINE.READ_FILE(FILE_NAME VARCHAR(60), ENCODING VARCHAR(60)) RETURNS VARCHAR(32000) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.readFile' language java parameter style java;
-0 rows inserted/updated/deleted
-ij> values TESTROUTINE.HAS_SECURITY_MANAGER();
-1          
------------
-0          
-ij> 
+ij> AUTOCOMMIT OFF;
+ij> -- MODULE  DML160  
+-- SQL Test Suite, V6.0, Interactive SQL, dml160.sql
+-- 59-byte ID
+-- TEd Version #
+-- AUTHORIZATION FLATER
+   set schema FLATER;
+0 rows inserted/updated/deleted
+ij> --O   SELECT USER FROM HU.ECCO;
+  VALUES USER;
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+FLATER                                                                                                                          
+ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
+   ROLLBACK WORK;
+ij> -- date_time print
+-- TEST:0859 <joined table> contained in <select list>!
+   SELECT EMPNUM, (SELECT COUNT(*) FROM HU.WORKS JOIN HU.PROJ
+     ON HU.WORKS.PNUM = HU.PROJ.PNUM
+     AND BUDGET > AVG (OSTAFF.GRADE) * 1000
+     WHERE HU.WORKS.EMPNUM = OSTAFF.EMPNUM) FROM HU.STAFF AS OSTAFF
+     ORDER BY 2, 1;
+ERROR 42972: An ON clause associated with a JOIN operator is not valid.
+ij> -- PASS:0859 If 5 rows are returned in the following order?
+--               empnum   count
+--               ======   =====
+-- PASS:0859 If    E5       0  ?
+-- PASS:0859 If    E2       1  ?
+-- PASS:0859 If    E3       1  ?
+-- PASS:0859 If    E4       2  ?
+-- PASS:0859 If    E1       4  ?  
+   COMMIT WORK;
+ij> -- END TEST >>> 0859 <<< END TEST
+-- *********************************************
+-- TEST:0860 Domains over various data types!
+--O   CREATE DOMAIN EPOCH_NOT_NORM AS DECIMAL (5, 2);
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN RAD_EPOCH_TYPE FLOAT (20)
+--O     CHECK (VALUE BETWEEN 0E0 AND 2E0 * 3.1416E0);
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN RAD_EPOCH_NOT_NORM REAL;
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN TIDEDATE AS DATE
+--O    CHECK (VALUE BETWEEN DATE( '1994-01-01') AND DATE( '2025-12-31'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN TIDETIMESTAMP AS TIMESTAMP WITH TIME ZONE
+--O    CHECK (VALUE BETWEEN TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00')
+--O    AND TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE DOMAIN DINNERTIME AS TIME
+--O    CHECK (VALUE BETWEEN TIME( '17:30:00') AND TIME( '19:00:00'));
+--O-- PASS:0860 If domain created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE CONST_NOT_NORM (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     CONST_ID TIDES.CONST_ID_TYPE NOT NULL,
+--O     UNIQUE (LOC_ID, CONST_ID),
+--O     AMPLITUDE TIDES.AMPLITUDE_TYPE,
+--O     EPOCH EPOCH_NOT_NORM);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CONST_RAD (LOC_ID, CONST_ID,
+--O     AMPLITUDE, EPOCH) AS
+--O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
+--O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_TYPE)
+--O     FROM TIDES.CONSTITUENTS;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CONST_RAD_NOT_NORM (LOC_ID, CONST_ID,
+--O     AMPLITUDE, EPOCH) AS
+--O     SELECT LOC_ID, CONST_ID, AMPLITUDE,
+--O     CAST (EPOCH * 3.14159265358979E0 / 180E0 AS RAD_EPOCH_NOT_NORM)
+--O     FROM CONST_NOT_NORM;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE PENDING (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     FROMTIME TIDETIMESTAMP NOT NULL,
+--O     TOTIME TIDETIMESTAMP NOT NULL,
+--O     CHECK (FROMTIME <= TOTIME),
+--O     JOB_ID INT PRIMARY KEY);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE VIEW CHECK_PTS (CHECK_DATES, JOB_ID, FLAG) AS
+--O     SELECT CAST (FROMTIME AS TIDEDATE), JOB_ID,
+--O     CAST (0 AS INT) FROM PENDING
+--O       UNION
+--O     SELECT CAST (TOTIME AS TIDEDATE), JOB_ID,
+--O     CAST (1 AS INT) FROM PENDING;
+--O-- PASS:0860 If view created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   CREATE TABLE DINNER_CLUB (
+--O     LOC_ID DEC (7) NOT NULL,
+--O     DINNER DINNERTIME);
+--O-- PASS:0860 If table created successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O   SELECT HOUR( MERIDIAN), EXTRACT
+--O     (MINUTE FROM MERIDIAN) 
+--O     FROM TIDES.LOCATIONS WHERE LOC_NAME LIKE '%Newfound%';
+--O-- PASS:0860 If xhour = -3?
+--O-- PASS:0860 If xminute = -30?
+--O
+--O   INSERT INTO TIDES.LOCATIONS VALUES (
+--O     300, 'Atlantis', 160.0000, 3.0000, 0, 1.2E0,
+--O     INTERVAL -'13:00' HOUR TO MINUTE, 'GMT-13');
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   UPDATE TIDES.CONSTITUENTS
+--O     SET AMPLITUDE = - AMPLITUDE
+--O     WHERE LOC_ID = 100
+--O     AND CONST_ID = 0;
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO TIDES.LOCATIONS VALUES (300,
+--O     'Bath, Maine', -69.8133, 43.9183,
+--O     1, 3.422E0, INTERVAL '-05:00' HOUR TO MINUTE, ':US/Eastern');
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO TIDES.CONSTITUENTS VALUES (300, 2, 0.134E0, 385.0);
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 0, 0.021E0, 151.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 1, 0.324E0, 144.5);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 2, 0.134E0, 385.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 3, 0.181E0, 40.9);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 4, 0.037E0, 150.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 5, 3.143E0, 352.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 6, 0.000E0, 50.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 7, 0.104E0, 242.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 8, 0.031E0, 158.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 9, 0.000E0, 133.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 10, 0.744E0, 322.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 11, 0.087E0, 307.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 12, 0.260E0, 130.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 13, 0.011E0, 158.7);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 14, 0.107E0, 140.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 15, 0.043E0, 114.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 16, 0.007E0, 116.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 17, 0.004E0, 383.2);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 18, 0.000E0, 17.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 19, 0.488E0, 383.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 20, 0.000E0, 69.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 21, 0.000E0, 103.5);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 22, 0.053E0, 365.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 23, 0.053E0, 37.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 24, 0.023E0, 297.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 25, 0.138E0, 328.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 26, 0.010E0, 124.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 27, 0.000E0, 50.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 28, 0.000E0, 49.4);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 29, 0.000E0, 66.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 30, 0.000E0, 67.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 31, 0.000E0, 35.7);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 32, 0.073E0, 285.0);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 33, 0.033E0, 257.3);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 34, 0.000E0, 0.6);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 35, 0.056E0, 128.8);
+--O   INSERT INTO CONST_NOT_NORM VALUES (300, 36, 0.038E0, 97.7);
+--O-- PASS:0860 If 37 rows inserted from previous 37 inserts?
+--O
+--O   SELECT EPOCH FROM CONST_RAD
+--O     WHERE LOC_ID = 100
+--O     AND CONST_ID = 0;
+--O-- PASS:0860 If EPOCH = 2.11 (+ or - 0.01)?
+--O
+--O   SELECT COUNT(*) 
+--O     FROM CONST_RAD_NOT_NORM
+--O     WHERE EPOCH > 6.2831853E0;
+--O-- PASS:0860 If COUNT = 4?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     300, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 0);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     101, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O          TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 1);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO PENDING VALUES (
+--O     102, TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'),
+--O       TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:00'), 2);
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   SELECT YEAR( CHECK_DATES)
+--O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 0;
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   SELECT YEAR( CHECK_DATES)
+--O     FROM CHECK_PTS WHERE JOB_ID = 2 AND FLAG = 1;
+--O-- PASS:0860 If xyear = 1994?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (0, TIME( '17:30:00'));
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (1, CAST (TIME( '18:00:00') AS DINNERTIME));
+--O-- PASS:0860 If 1 row inserted successfully?
+--O
+--O   INSERT INTO DINNER_CLUB VALUES
+--O     (2, TIME( '19:30:00'));
+--O-- PASS:0860 If ERROR - integrity constraint violation?
+--O
+--O   COMMIT WORK;
+--O
+--O   DROP DOMAIN EPOCH_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN RAD_EPOCH_TYPE CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN RAD_EPOCH_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN TIDEDATE CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN TIDETIMESTAMP CASCADE;
+--O   COMMIT WORK;
+--O   DROP DOMAIN DINNERTIME CASCADE;
+--O   COMMIT WORK;
+--O-- PASS:0860 If domains dropped successfully in 6 previous drops?
+--O
+--O   DROP TABLE CONST_NOT_NORM CASCADE;
+--O   COMMIT WORK;
+--O   DROP VIEW CONST_RAD CASCADE;
+--O   COMMIT WORK;
+--O   DROP TABLE PENDING CASCADE;
+--O   COMMIT WORK;
+--O   DROP TABLE DINNER_CLUB CASCADE;
+--O   COMMIT WORK;
+--O-- PASS:0860 If tables and view dropped in 4 previous drops?
+--O
+--O   DELETE FROM TIDES.LOCATIONS
+--O     WHERE LOC_ID = 300;
+--O-- PASS:0860 If delete completed successfully?
+--O
+--O   COMMIT WORK;
+--O
+--O-- END TEST >>> 0860 <<< END TEST
+--O-- *********************************************
+--O-- *************************************************////END-OF-MODULE
+-- Simple addition to check the test has a security manager installed.
+run resource '/org/apache/derbyTesting/functionTests/util/testRoutines.sql';
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+-- Changed to create individual procedures so that this will work with JSR169. 
+-- Direct call to 'installRoutines' uses nested connection
+CREATE PROCEDURE TESTROUTINE.SET_SYSTEM_PROPERTY(IN PROPERTY_KEY VARCHAR(32000), IN PROPERTY_VALUE VARCHAR(32000)) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.setSystemProperty' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE PROCEDURE TESTROUTINE.SLEEP(IN SLEEP_TIME_MS BIGINT) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.sleep' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION TESTROUTINE.HAS_SECURITY_MANAGER() RETURNS INT NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.hasSecurityManager' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION TESTROUTINE.READ_FILE(FILE_NAME VARCHAR(60), ENCODING VARCHAR(60)) RETURNS VARCHAR(32000) NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestRoutines.readFile' language java parameter style java;
+0 rows inserted/updated/deleted
+ij> values TESTROUTINE.HAS_SECURITY_MANAGER();
+1          
+-----------
+0          
+ij> 



Mime
View raw message