Hi,
This patch has some updates to outdated j9 canons for the tests lang/dcl.sql, floattypes.sql and groupBy.sql.
If a committer can pick this up please?
Thx,
Myrna
Index:
java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
(revision 328866)
+++ java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
(working copy)
@@ -248,11 +248,7 @@
NULL
ij> -- grouping by long varchar [for bit data] cols should fail in db2 mode
select lbv from t group by lbv order by lbv;
-LBV
---------------------------------------------------------------------------------------------------------------------------------
-1234
-abcd
-NULL
+ERROR X0X67: Columns of type 'LONG VARCHAR FOR BIT DATA' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
ij> -- multicolumn grouping
select i, dt, b from t where 1=1 group by i, dt, b order by i,dt,b;
I |DT |B
Index:
java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
(revision 328866)
+++
java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
(working copy)
@@ -2483,6 +2483,14 @@
1
---------
ERROR 22018: Invalid character string format for type DECIMAL.
+ij> values cast ('-1e+-1' as DECIMAL(6,2));
+1
+---------
+ERROR 22018: Invalid character string format for type DECIMAL.
+ij> values cast ('-1e+-1' as DECIMAL(6,2));
+1
+---------
+ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1.0e' as DECIMAL(6,2));
1
---------
Index: java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out
(revision 328866)
+++ java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dcl.out
(working copy)
@@ -194,10 +194,14 @@
CALL SQLJ.REPLACE_JAR('file:extin/dcl_emc2s.jar', 'EMC.MAIL_APP');
0 rows inserted/updated/deleted
ij> VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.emc');
-ERROR XJ001: Java exception: 'java.security.NoSuchAlgorithmException:
SHA1PRNG: java.lang.Error'.
+1
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+CN=EMC CTO,O=Easy Mail Company,OU=EMC APP,C=US
ij> -- other jar should not be signed
VALUES
EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.addon.vendor.util');
-ERROR 40XT0: An internal error was identified by RawStore module.
+1
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+NULL
ij> -- Jar up this database (wombat) for use in database in a jar testing
-- at the end of this script.
disconnect;
@@ -300,7 +304,7 @@
VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.emc');
1
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL
+CN=EMC CTO,O=Easy Mail Company,OU=EMC APP,C=US
ij> -- not signed
VALUES
EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.addon.vendor.util');
1
@@ -369,7 +373,7 @@
VALUES EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.emc');
1
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-NULL
+CN=EMC CTO,O=Easy Mail Company,OU=EMC APP,C=US
ij> -- not signed
VALUES
EMC.GETSIGNERS('org.apache.derbyTesting.databaseclassloader.addon.vendor.util');
1
Index:
java/testing/org/apache/derbyTesting/functionTests/master/j9_22/groupBy.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/j9_22/groupBy.out
(revision 328866)
+++ java/testing/org/apache/derbyTesting/functionTests/master/j9_22/groupBy.out
(working copy)
@@ -248,11 +248,7 @@
NULL
ij> -- grouping by long varchar [for bit data] cols should fail in db2 mode
select lbv from t group by lbv order by lbv;
-LBV
---------------------------------------------------------------------------------------------------------------------------------
-1234
-abcd
-NULL
+ERROR X0X67: Columns of type 'LONG VARCHAR FOR BIT DATA' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
ij> -- multicolumn grouping
select i, dt, b from t where 1=1 group by i, dt, b order by i,dt,b;
I |DT |B
