You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2013/04/10 04:02:46 UTC
svn commit: r1466316 [2/3] - in /db/derby/code/branches/10.8.3.1_testcompat:
./ java/testing/org/apache/derbyTesting/functionTests/master/
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/
java/testing/org/apache/derbyTesting/functionTe...
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out Wed Apr 10 02:02:45 2013
@@ -90,11 +90,11 @@ ij> values cast (1.1 as smallint);
1
ij> values cast (1.1 as real);
1
--------------
+---------------
1.1
ij> values cast (1.1 as float);
1
-----------------------
+------------------------
1.1
ij> values cast (1.1 as char(10));
1
@@ -151,20 +151,20 @@ ij> select cast(d as bigint) from tmp;
ERROR 22003: The resulting value is outside the range for the data type BIGINT.
ij> select cast(d as float) from tmp;
1
-----------------------
+------------------------
1.0E29
ij> select cast(d as real) from tmp;
1
--------------
+---------------
1.0E29
ij> select cast(d as double precision) from tmp;
1
-----------------------
+------------------------
1.0E29
ij> -- test alternative syntax
select cast(d as double) from tmp;
1
-----------------------
+------------------------
1.0E29
ij> insert into tmp values (+1.79769E+308);
ERROR 22003: The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,0).
@@ -397,17 +397,17 @@ ij> select cast(d as bigint) from tmp;
1
ij> select cast(d as float) from tmp;
1
-----------------------
+------------------------
1.0
1.0
ij> select cast(d as real) from tmp;
1
--------------
+---------------
1.0
1.0
ij> select cast(d as double precision) from tmp;
1
-----------------------
+------------------------
1.0
1.0
ij> select cast(d as dec(10,2)) from tmp;
@@ -466,28 +466,28 @@ NULL
0.00
ij> select dc + i, dc + s, dc + r, dc + dc from t;
1 |2 |3 |4
-------------------------------------------------------------
+--------------------------------------------------------------
NULL |NULL |NULL |NULL
20.00 |20.00 |20.0 |20.00
-20.00 |-20.00 |-20.0 |-20.00
0.00 |0.00 |0.0 |0.00
ij> select dc - i, dc - s, dc - r, dc - dc from t;
1 |2 |3 |4
-------------------------------------------------------------
+--------------------------------------------------------------
NULL |NULL |NULL |NULL
0.00 |0.00 |0.0 |0.00
0.00 |0.00 |0.0 |0.00
0.00 |0.00 |0.0 |0.00
ij> select dc * i, dc * s, dc * r, dc * dc from t;
1 |2 |3 |4
---------------------------------------------------------------------------------
+----------------------------------------------------------------------------------
NULL |NULL |NULL |NULL
100.00 |100.00 |100.0 |100.0000
100.00 |100.00 |100.0 |100.0000
0.00 |0.00 |0.0 |0.0000
ij> select dc / i, dc / s, dc / r, dc / dc from t;
1 |2 |3 |4
-----------------------------------------------------------------------------------------------------------------------
+------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL
1.00000000000000000000000 |1.00000000000000000000000 |1.0 |1.000000000000000000000
1.00000000000000000000000 |1.00000000000000000000000 |1.0 |1.000000000000000000000
@@ -495,7 +495,7 @@ ERROR 22012: Attempt to divide by zero.
ij> -- try unary minus, plus
select -(dc * 100 / 100e0 ), +(dc * 100e0 / 100 ) from t;
1 |2
----------------------------------------------
+-------------------------------------------------
NULL |NULL
-10.0 |10.0
10.0 |-10.0
@@ -503,7 +503,7 @@ NULL |NULL
ij> -- test null/null, constant/null, null/constant
select dc, i / dc, 10 / dc, dc / 10e0 from t;
DC |2 |3 |4
----------------------------------------------------------------------------------------------------------
+-----------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL
10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0
-10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0
@@ -518,7 +518,7 @@ NULL
ERROR 22012: Attempt to divide by zero.
ij> select 20e0 / 5e0 / 4e0, 20e0 / 4e0 / 5 from t;
1 |2
----------------------------------------------
+-------------------------------------------------
1.0 |1.0
1.0 |1.0
1.0 |1.0
@@ -534,7 +534,7 @@ ERROR 22012: Attempt to divide by zero.
ij> -- test some "more complex" expressions
select dc, dc + 10e0, dc - (10 - 20e0), dc - 10, dc - (20 - 10) from t;
DC |2 |3 |4 |5
---------------------------------------------------------------------------------------------
+------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL
10.00 |20.0 |20.0 |0.00 |0.00
-10.00 |0.0 |0.0 |-20.00 |-20.00
@@ -1153,38 +1153,38 @@ ij> insert into t values (-1, -100, 'goo
1 row inserted/updated/deleted
ij> select d + d, i + d, s + d from t;
1 |2 |3
---------------------------------------------------------------------
+--------------------------------------------------------------------------
NULL |NULL |NULL
400.0 |200.0 |300.0
-400.0 |-201.0 |-300.0
ij> select d + d + d, d + 100 + 432e0 from t;
1 |2
----------------------------------------------
+-------------------------------------------------
NULL |NULL
600.0 |732.0
-600.0 |332.0
ij> select d - i, i - d, d - s, s - d from t;
1 |2 |3 |4
--------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL
200.0 |-200.0 |100.0 |-100.0
-199.0 |199.0 |-100.0 |100.0
ij> select d - d - d, d - 100 - 432e0 from t;
1 |2
----------------------------------------------
+-------------------------------------------------
NULL |NULL
-200.0 |-332.0
200.0 |-732.0
ij> select i, d, i * d, d * i, d * d, d * 2, d * 2.0e0 from t;
I |D |3 |4 |5 |6 |7
------------------------------------------------------------------------------------------------------------------------------------------------------
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL |NULL |NULL
0 |200.0 |0.0 |0.0 |40000.0 |400.0 |400.0
-1 |-200.0 |200.0 |200.0 |40000.0 |-400.0 |-400.0
ij> -- try unary minus, plus
select -(d * 100 / 100e0 ), +(d * 100e0 / 100 ) from t;
1 |2
----------------------------------------------
+-------------------------------------------------
NULL |NULL
-200.0 |200.0
200.0 |-200.0
@@ -1194,40 +1194,40 @@ ij> -- test null/null, constant/null, nu
-- either 0.005 or 0.0050 (both valid formats for Double.toString(double)
select i, d, CAST (i / d AS DECIMAL(6,5)), 10 / d, d / 10e0 from t;
I |D |3 |4 |5
------------------------------------------------------------------------------------------
+-----------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL
0 |200.0 |0.00000 |0.05 |20.0
-1 |-200.0 |0.00500 |-0.05 |-20.0
ij> -- test for divide by 0
select d / i from t;
1
-----------------------
+------------------------
NULL
ERROR 22012: Attempt to divide by zero.
ij> select 20e0 / 5e0 / 4e0, 20e0 / 4e0 / 5 from t;
1 |2
----------------------------------------------
+-------------------------------------------------
1.0 |1.0
1.0 |1.0
1.0 |1.0
ij> -- test positive/negative, negative/positive and negative/negative
select d, d / -d, (-d) / d, (-d) / -d from t;
D |2 |3 |4
--------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL
200.0 |-1.0 |-1.0 |1.0
-200.0 |-1.0 |-1.0 |1.0
ij> -- test some "more complex" expressions
select d, d + 10e0, d - (10 - 20e0), d - 10, d - (20 - 10) from t;
D |2 |3 |4 |5
-------------------------------------------------------------------------------------------------------------------
+----------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL
200.0 |210.0 |210.0 |190.0 |190.0
-200.0 |-190.0 |-190.0 |-210.0 |-210.0
ij> -- show that decimals will go into doubles:
select d+1.1 from t;
1
-----------------------
+------------------------
NULL
201.1
-198.9
@@ -1235,7 +1235,7 @@ ij> insert into t (d) values(1.1);
1 row inserted/updated/deleted
ij> select d from t where d=1.1;
D
-----------------------
+------------------------
1.1
ij> drop table t;
0 rows inserted/updated/deleted
@@ -1251,7 +1251,7 @@ ij> insert into s values (1, 101);
1 row inserted/updated/deleted
ij> select d + 1.7e+308 from s;
1
-----------------------
+------------------------
NULL
1.7E308
1.7E308
@@ -1264,37 +1264,37 @@ ERROR 22003: The resulting value is outs
ij> -- these are far enough from the infinities to work
select 1.797e+308, - 1.797e+308, 'This query should work' from s;
1 |2 |3
---------------------------------------------------------------------
+------------------------------------------------------------------------
1.797E308 |-1.797E308 |This query should work
1.797E308 |-1.797E308 |This query should work
1.797E308 |-1.797E308 |This query should work
ij> select 1.6e+308, - 1.6e+308, 'This query should work' from s;
1 |2 |3
---------------------------------------------------------------------
+------------------------------------------------------------------------
1.6E308 |-1.6E308 |This query should work
1.6E308 |-1.6E308 |This query should work
1.6E308 |-1.6E308 |This query should work
ij> -- the null row will still get returned
select d - 1.6e+308 - 0, 'This query should work' from s;
1 |2
----------------------------------------------
+-----------------------------------------------
NULL |This query should work
-1.6E308 |This query should work
-1.6E308 |This query should work
ij> select d - 1.6e+308 - 1.6e+308, 'This query should fail' from s;
1 |2
----------------------------------------------
+-----------------------------------------------
NULL |This query should fail
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> -- these should fail
select p * 1.6e+308 from s;
1
-----------------------
+------------------------
NULL
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> select p * -1.6e+308 from s;
1
-----------------------
+------------------------
NULL
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> -- these work
@@ -1310,7 +1310,7 @@ ERROR 22003: The resulting value is outs
ij> -- see two more rows
select -d from s;
1
-----------------------
+------------------------
NULL
0.0
-1.0
@@ -1349,25 +1349,25 @@ ij> insert into c values (1956475, 1956,
ij> -- select each one in turn
select d from c where d = 0e0;
D
-----------------------
+------------------------
0.0
ij> select d from c where d = 1e0;
D
-----------------------
+------------------------
1.0
ij> select d from c where d = 1956475e0;
D
-----------------------
+------------------------
1956475.0
ij> -- now look for a value that isn't in the table
select d from c where p = 2e0;
D
-----------------------
+------------------------
1.0
ij> -- now test null = null semantics
select d from c where d = d;
D
-----------------------
+------------------------
0.0
5.0
1.0
@@ -1375,96 +1375,96 @@ D
ij> -- now test <>, <, >
select d from c where d <> 0e0;
D
-----------------------
+------------------------
5.0
1.0
1956475.0
ij> select d from c where d <> 1e0;
D
-----------------------
+------------------------
0.0
5.0
1956475.0
ij> select d from c where d < 1956475e0;
D
-----------------------
+------------------------
0.0
5.0
1.0
ij> select d from c where d < 2e0;
D
-----------------------
+------------------------
0.0
1.0
ij> select d from c where d > d;
D
-----------------------
+------------------------
ij> select d from c where d > p;
D
-----------------------
+------------------------
ij> -- now test <=, >=
select d from c where d <= 0e0;
D
-----------------------
+------------------------
0.0
ij> select d from c where d <= 1e0;
D
-----------------------
+------------------------
0.0
1.0
ij> select d from c where d <= 2e0;
D
-----------------------
+------------------------
0.0
1.0
ij> select d from c where d >= 1956475e0;
D
-----------------------
+------------------------
1956475.0
ij> select d from c where d >= d;
D
-----------------------
+------------------------
0.0
5.0
1.0
1956475.0
ij> select d from c where d >= p;
D
-----------------------
+------------------------
0.0
1956475.0
ij> -- test comparisons with int and smallint
select d from c where d <= i;
D
-----------------------
+------------------------
0.0
1.0
1956475.0
ij> select d from c where d < s;
D
-----------------------
+------------------------
ij> select d from c where d > i;
D
-----------------------
+------------------------
ij> select d from c where d >= s;
D
-----------------------
+------------------------
0.0
1.0
1956475.0
ij> select d from c where d <> i;
D
-----------------------
+------------------------
ij> select d from c where d = s;
D
-----------------------
+------------------------
0.0
1.0
ij> -- test that the smallint gets promoted to double, and not vice versa. 65537
-- when converted to short becomes 1
select d from c where s = 65537e0;
D
-----------------------
+------------------------
ij> -- test =SQ
-- this gets cardinality error
select d from c where d = (select d from c);
@@ -1472,7 +1472,7 @@ ERROR 21000: Scalar subquery is only all
ij> -- this works
select d from c where d = (select d from c where d=5);
D
-----------------------
+------------------------
5.0
ij> -- show that double is comparable to real
@@ -1480,7 +1480,7 @@ create table o (c char(10), v varchar(30
0 rows inserted/updated/deleted
ij> select d from c,o where d <> dc;
D
-----------------------
+------------------------
ij> -- clean up
drop table c;
0 rows inserted/updated/deleted
@@ -1530,7 +1530,7 @@ ERROR 23502: Column 'P' cannot accept a
ij> -- expect 4 rows in target: 1, 2, 5, and 1:
select * from target;
P
-----------------------
+------------------------
1.0
2.0
5.0
@@ -1538,7 +1538,7 @@ ij> update target set p = p + 1;
3 rows inserted/updated/deleted
ij> select * from target;
P
-----------------------
+------------------------
2.0
3.0
6.0
@@ -1546,7 +1546,7 @@ ij> update target set p = p - 1;
3 rows inserted/updated/deleted
ij> select * from target;
P
-----------------------
+------------------------
1.0
2.0
5.0
@@ -1554,7 +1554,7 @@ ij> update target set p = p / 10;
3 rows inserted/updated/deleted
ij> select * from target;
P
-----------------------
+------------------------
0.1
0.2
0.5
@@ -1562,7 +1562,7 @@ ij> update target set p = p * 10;
3 rows inserted/updated/deleted
ij> select * from target;
P
-----------------------
+------------------------
1.0
2.0
5.0
@@ -1600,7 +1600,7 @@ ij> insert into abcfloat values (1234567
1 row inserted/updated/deleted
ij> select * from abcfloat;
NUMTEST
--------------
+---------------
1.2345679
0.12345679
-0.12345679
@@ -1640,9 +1640,9 @@ ij> -- invalid float values
insert into t(r) values 'NaN';
ERROR 42821: Columns of type 'REAL' cannot hold values of type 'CHAR'.
ij> insert into t(r) values +3.4021E+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into t(r) values -3.4021E+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> create table tt(c char(254));
0 rows inserted/updated/deleted
ij> insert into tt values -3.402E+38;
@@ -1654,11 +1654,9 @@ ERROR 42821: Columns of type 'REAL' cann
ij> update t set r = NaN;
ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
ij> update t set r = +3.4021E+38;
-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.
+2 rows inserted/updated/deleted
ij> update t set r = -3.4021E+38;
-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.
+2 rows inserted/updated/deleted
ij> drop table t;
0 rows inserted/updated/deleted
ij> drop table tt;
@@ -1707,38 +1705,38 @@ ij> insert into t values (-1, -100, 'goo
1 row inserted/updated/deleted
ij> select r + r, d + r, i + r, s + r, r + i from t;
1 |2 |3 |4 |5
-------------------------------------------------------------------------------
+----------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL
400.0 |400.0 |200.0 |300.0 |200.0
-400.0 |-400.0 |-201.0 |-300.0 |-201.0
ij> select r + r + r, r + 100 + 432e0 from t;
1 |2
-------------------------------------
+----------------------------------------
NULL |NULL
600.0 |732.0
-600.0 |332.0
ij> select r - r, r - d, d - r, r - i, i - r, r - s, s - r from t;
1 |2 |3 |4 |5 |6 |7
--------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL |NULL |NULL
0.0 |0.0 |0.0 |200.0 |-200.0 |100.0 |-100.0
0.0 |0.0 |0.0 |-199.0 |199.0 |-100.0 |100.0
ij> select r - r - r, r - 100 - 432e0 from t;
1 |2
-------------------------------------
+----------------------------------------
NULL |NULL
-200.0 |-332.0
200.0 |-732.0
ij> select i, d, s, r, i * r, r * i, s * r, d * r, r * r, r * 2, r * 2.0e0 from t;
I |D |S |R |5 |6 |7 |8 |9 |10 |11
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
0 |200.0 |100 |200.0 |0.0 |0.0 |20000.0 |40000.0 |40000.0 |400.0 |400.0
-1 |-200.0 |-100 |-200.0 |200.0 |200.0 |20000.0 |40000.0 |40000.0 |-400.0 |-400.0
ij> -- try unary minus, plus
select -(r * 100 / 100e0 ), +(r * 100e0 / 100 ) from t;
1 |2
----------------------------------------------
+-------------------------------------------------
NULL |NULL
-200.0 |200.0
200.0 |-200.0
@@ -1748,27 +1746,27 @@ ij> -- test null/null, constant/null, nu
-- either 0.005 or 0.0050 (both valid formats for Double.toString(double)
select i, d, r, d / r, CAST (i / r AS DECIMAL(6,5)), 10 / r, r / d, r / 10e0 from t;
I |D |R |4 |5 |6 |7 |8
---------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
0 |200.0 |200.0 |1.0 |0.00000 |0.05 |1.0 |20.0
-1 |-200.0 |-200.0 |1.0 |0.00500 |-0.05 |1.0 |-20.0
ij> -- test for divide by 0
select r / i from t;
1
--------------
+---------------
NULL
ERROR 22012: Attempt to divide by zero.
ij> -- test positive/negative, negative/positive and negative/negative
select r, r / -r, (-r) / r, (-r) / -r from t;
R |2 |3 |4
--------------------------------------------------------
+---------------------------------------------------------------
NULL |NULL |NULL |NULL
200.0 |-1.0 |-1.0 |1.0
-200.0 |-1.0 |-1.0 |1.0
ij> -- test some "more complex" expressions
select r, r + 10e0, r - (10 - 20e0), r - 10, r - (20 - 10) from t;
R |2 |3 |4 |5
----------------------------------------------------------------------------------------
+-------------------------------------------------------------------------------------------------
NULL |NULL |NULL |NULL |NULL
200.0 |210.0 |210.0 |190.0 |190.0
-200.0 |-190.0 |-190.0 |-210.0 |-210.0
@@ -1786,7 +1784,7 @@ ij> insert into s values (1, 101);
1 row inserted/updated/deleted
ij> select d + 3.4e+38 from s;
1
-----------------------
+------------------------
NULL
3.4E38
3.4E38
@@ -1802,7 +1800,7 @@ ij> insert into s values(- 1.8e+100, - 1
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select * from s;
D |P
----------------------------
+-------------------------------
NULL |NULL
0.0 |100.0
1.0 |101.0
@@ -1815,16 +1813,16 @@ ij> -- these show that math is promoted
-- literals. If it was real math, it would fail
select d - 3.3e+38 - 3.3e+38, p * 3.3e+38, p * -3.3e+38 from s;
1 |2 |3
---------------------------------------------------------------------
+--------------------------------------------------------------------------
NULL |NULL |NULL
-6.6E38 |3.3E40 |-3.3E40
-6.6E38 |3.333E40 |-3.333E40
--3.1979999994446195E38|-1.1226600001832754E77|1.1226600001832754E77
--3.3000000345172877E38|-1.088999988609295E77 |1.088999988609295E77
+-3.1979999994446195E38 |-1.1226600001832754E77 |1.1226600001832754E77
+-3.3000000345172877E38 |-1.088999988609295E77 |1.088999988609295E77
ij> -- see two more rows
select -d from s;
1
--------------
+---------------
NULL
0.0
-1.0
@@ -1838,15 +1836,15 @@ ij> insert into s values (1,3.3e+38);
ij> -- these will fail, because the math is done as reals
select d - p - p from s;
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select p * p from s;
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select p * -p from s;
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> delete from s;
1 row inserted/updated/deleted
@@ -1857,7 +1855,7 @@ ij> insert into s values (0.222, 0.222);
1 row inserted/updated/deleted
ij> select * from s;
D |P
----------------------------
+-------------------------------
0.111 |0.1
0.222 |0.222
ij> delete from s;
@@ -1869,13 +1867,13 @@ update s set d=d*1.4e-55, p=p*1.4e-45;
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select d, p from s;
D |P
----------------------------
+-------------------------------
10.0 |1.0E-10
ij> update s set d=d + 1.4e-46;
1 row inserted/updated/deleted
ij> select d from s;
D
--------------
+---------------
10.0
ij> drop table s;
0 rows inserted/updated/deleted
@@ -1911,98 +1909,98 @@ ij> insert into c values (1956475, 1956,
ij> -- select each one in turn
select r from c where r = 0e0;
R
--------------
+---------------
0.0
ij> select r from c where r = 1e0;
R
--------------
+---------------
ij> select r from c where r = 1956475e0;
R
--------------
+---------------
1956475.0
ij> -- now look for a value that isn't in the table
select r from c where l = 2e0;
R
--------------
+---------------
ij> -- now test null = null semantics
select r from c where r = r;
R
--------------
+---------------
0.0
2.0
1956475.0
ij> -- now test <>, <, >, <=, >=
select r from c where r <> 0e0;
R
--------------
+---------------
2.0
1956475.0
ij> select r from c where r <> 1e0;
R
--------------
+---------------
0.0
2.0
1956475.0
ij> select r from c where r < 1956475e0;
R
--------------
+---------------
0.0
2.0
ij> select r from c where r < 2e0;
R
--------------
+---------------
0.0
ij> select r from c where r > d;
R
--------------
+---------------
2.0
ij> select r from c where r <= l;
R
--------------
+---------------
0.0
2.0
1956475.0
ij> select r from c where r >= r;
R
--------------
+---------------
0.0
2.0
1956475.0
ij> -- test comparisons with int and smallint and double
select r from c where r <= i;
R
--------------
+---------------
0.0
1956475.0
ij> select r from c where r < s;
R
--------------
+---------------
ij> select r from c where r > i;
R
--------------
+---------------
2.0
ij> select r from c where r >= s;
R
--------------
+---------------
0.0
2.0
1956475.0
ij> select r from c where r <> i;
R
--------------
+---------------
2.0
ij> select r from c where r = s;
R
--------------
+---------------
0.0
ij> select r from c where r = d;
R
--------------
+---------------
0.0
1956475.0
ij> select r from c where r >= d;
R
--------------
+---------------
0.0
2.0
1956475.0
@@ -2012,7 +2010,7 @@ create table o (c char(10), v varchar(30
0 rows inserted/updated/deleted
ij> select r from c,o where r <> dc;
R
--------------
+---------------
ij> -- clean up
drop table c;
0 rows inserted/updated/deleted
@@ -2059,7 +2057,7 @@ ERROR 23502: Column 'T' cannot accept a
ij> -- expect 5 rows in target: 1, 2, 5, 6, and 1:
select * from target;
T
--------------
+---------------
1.0
2.0
5.0
@@ -2068,7 +2066,7 @@ ij> update target set t = t + 1;
4 rows inserted/updated/deleted
ij> select * from target;
T
--------------
+---------------
2.0
3.0
6.0
@@ -2077,7 +2075,7 @@ ij> update target set t = t - 1;
4 rows inserted/updated/deleted
ij> select * from target;
T
--------------
+---------------
1.0
2.0
5.0
@@ -2086,7 +2084,7 @@ ij> update target set t = t / 10;
4 rows inserted/updated/deleted
ij> select * from target;
T
--------------
+---------------
0.1
0.2
0.5
@@ -2095,7 +2093,7 @@ ij> update target set t = t * 10;
4 rows inserted/updated/deleted
ij> select * from target;
T
--------------
+---------------
1.0
2.0
5.0
@@ -2107,7 +2105,7 @@ ij> update source set i = r, s=r, d=r;
2 rows inserted/updated/deleted
ij> select i, s, d from source where i=1.4e4 or s=1.4e4 or d=1.4e4;
I |S |D
------------------------------------------
+-------------------------------------------
14000 |14000 |14000.0
14000 |14000 |14000.0
ij> -- just curious, do columns see the before or after values, and
@@ -2116,7 +2114,7 @@ update source set i = r, r = 0, s = r;
2 rows inserted/updated/deleted
ij> select i, r, s from source where r = 0;
I |R |S
---------------------------------
+----------------------------------
14000 |0.0 |14000
14000 |0.0 |14000
ij> -- these should get overflow
@@ -2140,7 +2138,9 @@ ij> -- =================================
values 5e-325;
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values 5e-324;
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1
+------------------------
+4.9E-324
ij> -- --- TEST SPECIAL VALUES
-- DB2 (should succed)
@@ -2158,15 +2158,15 @@ ij> insert into fake values -2;
1 row inserted/updated/deleted
ij> -- CS (should fail)
insert into fake values( -3.4028235E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +3.4028235E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -3;
1 row inserted/updated/deleted
ij> insert into fake values( -1.4E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +1.4E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -4;
1 row inserted/updated/deleted
ij> -- ============================================================
@@ -2183,11 +2183,11 @@ ij> insert into fake values (+0.0E-500);
1 row inserted/updated/deleted
ij> values (+0.0E-500);
1
-----------------------
+------------------------
0.0
ij> values (+1.0E-300);
1
-----------------------
+------------------------
1.0E-300
ij> -- approx ZERO (java rounds to zero, but not DB2)
insert into fake values (+1.0E-300);
@@ -2206,84 +2206,88 @@ ij> insert into fake values -11;
1 row inserted/updated/deleted
ij> -- ============================================================
--- DB2 MAX_VALUES (first succeed, second fail)
+-- DB2 MAX_VALUES (first succeed, second used to fail)
insert into fake values( -3.4019E+38 );
1 row inserted/updated/deleted
ij> insert into fake values( -3.4021E+38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -21;
1 row inserted/updated/deleted
ij> insert into fake values( +3.4019E+38 );
1 row inserted/updated/deleted
ij> insert into fake values( +3.4021E+38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -22;
1 row inserted/updated/deleted
-ij> -- DB2 MIN_VALUES (first fail, second succeed)
+ij> -- DB2 MIN_VALUES (first used to fail, second succeed)
insert into fake values( -1.1749E-37 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -1.1751E-37 );
1 row inserted/updated/deleted
ij> insert into fake values -23;
1 row inserted/updated/deleted
ij> insert into fake values( +1.1749E-37 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +1.1751E-37 );
1 row inserted/updated/deleted
ij> insert into fake values -24;
1 row inserted/updated/deleted
-ij> -- CS (fail)
+ij> -- CS (used to fail pre DERBY-3398)
insert into fake values( -3.4028234E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -3.40282349E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -3.40282351E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -3.4028236E38 );
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> insert into fake values -25;
1 row inserted/updated/deleted
ij> insert into fake values( +3.4028234E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +3.40282349E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +3.40282351E38 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +3.4028236E38 );
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> insert into fake values -26;
1 row inserted/updated/deleted
ij> insert into fake values( -1.39E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -1.399E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -1.401E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( -1.41E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -27;
1 row inserted/updated/deleted
ij> insert into fake values( +1.39E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +1.399E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +1.401E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values( +1.41E-45 );
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values -28;
1 row inserted/updated/deleted
ij> -- checkpoint
select * from fake;
R
--------------
+---------------
-3.402E38
3.402E38
-1.0
-1.175E-37
1.175E-37
-2.0
+-3.4028235E38
+3.4028235E38
-3.0
+-1.4E-45
+1.4E-45
-4.0
0.0
0.0
@@ -2292,16 +2296,34 @@ R
0.0
-11.0
-3.4019E38
+-3.4021E38
-21.0
3.4019E38
+3.4021E38
-22.0
+-1.1749E-37
-1.1751E-37
-23.0
+1.1749E-37
1.1751E-37
-24.0
+-3.4028235E38
+-3.4028235E38
+-3.4028235E38
-25.0
+3.4028235E38
+3.4028235E38
+3.4028235E38
-26.0
+-1.4E-45
+-1.4E-45
+-1.4E-45
+-1.4E-45
-27.0
+1.4E-45
+1.4E-45
+1.4E-45
+1.4E-45
-28.0
ij> drop table fake;
0 rows inserted/updated/deleted
@@ -2314,27 +2336,27 @@ ij> -- =================================
-- ok
values cast(5e-37/1e0 as real);
1
--------------
+---------------
5.0E-37
ij> -- fail
values cast(5e-37/1e1 as real);
1
--------------
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+---------------
+5.0E-38
ij> values cast(5e-37/1e300 as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values cast(5e-37 as real)/cast(1e10 as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> -- ok
insert into fake values 5e-37/1e0;
1 row inserted/updated/deleted
ij> -- fail
insert into fake values 5e-37/1e1;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into fake values 5e-37/1e300;
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> insert into fake values cast(5e-37 as real)/cast(1e10 as real);
@@ -2344,75 +2366,79 @@ ij> drop table fake;
ij> -- makes double to small, so java double rounds to 0. need to catch (fail)
values 5e-37 / 1e300;
1
-----------------------
+------------------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values cast(5e-37 / 1e300 as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> -- ok, zero result (succeed)
values cast(cast(0.0e0 as real) - cast(0.0e0 as real) as real);
1
--------------
+---------------
0.0
ij> values cast(cast(1.0e-30 as real) - cast(1.0e-30 as real) as real);
1
--------------
+---------------
0.0
-ij> -- java (and CS previously) rounded result to zero, but now gives errors like DB2 (fail)
+ij> -- used to fail pre DERBY-3398
values cast(cast(5e-37 as real) - cast(4e-37 as real) as real);
1
--------------
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+---------------
+1.0000002E-37
ij> values cast(5e-37 - 4e-37 as real);
1
--------------
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+---------------
+1.0E-37
ij> values cast(5e-37 - 4.99e-37 as real);
1
--------------
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+---------------
+1.0E-39
ij> values cast(5e-308 - 4e-308 as real);
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1
+---------------
+ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> values cast(5e-37 + -4e-37 as real);
1
--------------
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+---------------
+1.0E-37
ij> values cast(5e-324 - 4e-324 as real);
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
+1
+---------------
+0.0
ij> values cast(5e-37 * 4e-37 as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> values cast(cast(5e-37 as real) * cast(4e-37 as real) as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> -- double trouble, underflow detection (fail)
values cast(5e-300 * 4e-300 as real);
1
--------------
+---------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> -- underflow aritmetic DOUBLE (fail)
values -3e-305/1e100;
1
-----------------------
+------------------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values -3e-305/1e100;
1
-----------------------
+------------------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> -- negative zeros not allowed (succeed)
values 0.0e5/-1;
1
-----------------------
+------------------------
0.0
ij> -- 30 characters limit to be enforced ) (first fail, second ok)
values 01234567890123456789012345678e1;
ERROR 42820: The floating point literal '01234567890123456789012345678e1' contains more than 30 characters.
ij> values 0123456789012345678901234567e1;
1
-----------------------
+------------------------
1.2345678901234569E27
ij> -- ============================================================
@@ -2429,16 +2455,18 @@ ij> insert into t1 values +1.40129846432
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select * from t1;
C1
--------------
-ij> -- these 2 insert statements should raise an error msg in compat mode
--- because the values are greater db2's limits (fail)
+---------------
+ij> -- these 2 insert statements used to raise error pre DERBY-3398
+-- because the values were greater than db2's limits
insert into t1 values 3.40282346638528860e+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into t1 values -3.40282346638528860e+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> select * from t1;
C1
--------------
+---------------
+3.4028235E38
+-3.4028235E38
ij> drop table t1;
0 rows inserted/updated/deleted
ij> -- Examples in DB2 UDB for LUW 8.1.4:
@@ -2452,16 +2480,18 @@ ij> insert into t1 values +1.40129846432
ERROR 22003: The resulting value is outside the range for the data type REAL.
ij> select * from t1;
C1
--------------
-ij> -- these 2 insert statements raise ERROR 22003 because
--- the values are greater db2's limits (fail)
+---------------
+ij> -- these 2 insert statements used to raise error pre DERBY-3398
+-- because the values were greater than db2's limits
insert into t1 values 3.40282346638528860e+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> insert into t1 values -3.40282346638528860e+38;
-ERROR 22003: The resulting value is outside the range for the data type REAL.
+1 row inserted/updated/deleted
ij> select * from t1;
C1
--------------
+---------------
+3.4028235E38
+-3.4028235E38
ij> drop table t1;
0 rows inserted/updated/deleted
ij> -- ============================================================
@@ -2583,4 +2613,4 @@ ij> values cast ('' as DECIMAL(6,2));
1
--------
ERROR 22018: Invalid character string format for type DECIMAL.
-ij>
+ij>
\ No newline at end of file
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out Wed Apr 10 02:02:45 2013
@@ -257,7 +257,7 @@ ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (
0 rows inserted/updated/deleted
ij> select * from t3;
C1 |C2 |C3 |C4
---------------------------------------------------------------
+----------------------------------------------------------------
1 |3.5 |8 |test strings
2 |3.5 |8 |test strings
3 |3.5 |8 |test strings
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out Wed Apr 10 02:02:45 2013
@@ -2220,7 +2220,7 @@ C_TI|SI |C_SI |I |C_I
-----------------------------------------------------------------
ij> select li, c_li, r, c_r, dp, c_dp from all1, all_c1;
LI |C_LI |R |C_R |DP |C_DP
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ij> select dc, c_dc, num, c_num, c_bool from all1, all_c1;
DC |C_DC |NUM |C_NUM |C_BO&
-----------------------------------------------------------------------------------
@@ -2243,7 +2243,7 @@ C_TI|SI |C_SI |I |C_I
-----------------------------------------------------------------
ij> select li, c_li, r, c_r, dp, c_dp from all1, all_c1;
LI |C_LI |R |C_R |DP |C_DP
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ij> select dc, c_dc, num, c_num, c_bool from all1, all_c1;
DC |C_DC |NUM |C_NUM |C_BO&
-----------------------------------------------------------------------------------
@@ -2276,7 +2276,7 @@ ij> alter table all1 add column lvc2 lon
0 rows inserted/updated/deleted
ij> select * from all1;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |C30 |VC30 |LVC2
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.5 |6.6 |7.7 |8.8 |0020|0020|0020 |1996-09-09|12:12:12|1996-09-09 12:12:12.5 |1 |2 |33333333 |NULL |NULL |NULL
ij> update all1 set si = '11';
ERROR 42821: Columns of type 'SMALLINT' cannot hold values of type 'CHAR'.
@@ -2308,7 +2308,7 @@ ij> update all1 set lvc = '44444444';
1 row inserted/updated/deleted
ij> select * from all1;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |C30 |VC30 |LVC2
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.5 |6.6 |7.7 |8.8 |2120|21 |21 |1900-01-01|08:08:08|1990-01-01 08:08:08.6 |1 |2 |44444444 |NULL |NULL |NULL
ij> select c30, vc30, lvc2 from all1;
C30 |VC30 |LVC2
@@ -3872,12 +3872,12 @@ ERROR 42818: Comparisons between 'SMALLI
ij> select * from all1 a, all1 b
where a.dt = b.c;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
ij> select * from all1 a, all1 b
where a.dt = b.vc;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
ij> select * from all1 a, all1 b
where a.dt = b.lvc;
@@ -3885,12 +3885,12 @@ ERROR 42818: Comparisons between 'DATE'
ij> select * from all1 a, all1 b
where b.dt = a.c;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
ij> select * from all1 a, all1 b
where b.dt = a.vc;
SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC |SI |I |LI |R |DP |DC |NUM |B |BV |LBV |DT |TM |TMS |C |VC |LVC
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
ij> select * from all1 a, all1 b
where b.dt = a.lvc;
@@ -3899,4 +3899,4 @@ ij> -- clean up
drop table all1;
0 rows inserted/updated/deleted
ij> commit;
-ij>
+ij>
\ No newline at end of file
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/insert.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/insert.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/insert.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/insert.out Wed Apr 10 02:02:45 2013
@@ -323,7 +323,7 @@ ij> insert into i2 select dc, dc, dc, dc
2 rows inserted/updated/deleted
ij> select * from i2;
I |T |S |L |R |DP |DC
------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------
1 |1 |1 |1 |1.0 |1.0 |1
NULL |NULL |NULL |NULL |NULL |NULL |NULL
2 |2 |2 |2 |2.0 |2.0 |2
@@ -344,7 +344,7 @@ ij> insert into i2 select i, t, s, l, r,
2 rows inserted/updated/deleted
ij> select * from i2;
I |T |S |L |R |DP |DC
------------------------------------------------------------------------------------------------
+---------------------------------------------------------------------------------------------------
1 |2 |3 |4 |5.5 |6.6 |7
NULL |NULL |NULL |NULL |NULL |NULL |NULL
ij> -- get the rest
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out?rev=1466316&r1=1466315&r2=1466316&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out Wed Apr 10 02:02:45 2013
@@ -614,7 +614,7 @@ ij> insert into d values 1e-300,2e-300;
2 rows inserted/updated/deleted
ij> select d,d/1e5 as dd from d order by dd,d;
D |DD
----------------------------------------------
+-------------------------------------------------
1.0E-300 |1.0E-305
2.0E-300 |2.0E-305
ij> rollback ;
@@ -667,7 +667,7 @@ S
2
ij> select r from missed order by r;
R
--------------
+---------------
10000.0
10000.0
12000.0
@@ -793,7 +793,7 @@ ij> insert into tab1 values (2, cast(2 a
1 row inserted/updated/deleted
ij> select * from tab1 order by 1;
I |TN |S |L |C |V |LVC |D |R |DT |T |TS |DC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |1 |1 |1 |1 |1 |1 |1.1 |1.1 |1996-01-01|11:11:11|1996-01-01 11:10:10.1 |1.1
2 |2 |2 |2 |2 |2 |2 |2.2 |2.2 |1995-02-02|12:12:12|1996-02-02 12:10:10.1 |2.2
ij> rollback;
@@ -2091,14 +2091,14 @@ ID |C3_BIGINT
4 |NULL
ij> select id, c4_real from d2887_types order by c4_real desc;
ID |C4_REAL
--------------------------
+---------------------------
4 |NULL
3 |3.0
2 |2.0
1 |1.0
ij> select id, c5_float from d2887_types order by c5_float asc nulls last;
ID |C5_FLOAT
-----------------------------------
+------------------------------------
1 |1.0
2 |2.0
3 |3.0
@@ -2321,4 +2321,4 @@ ij> drop table d3303;
ij> -- See also Derby5005.java which should be merged with this test when
-- it gets converted to JUnit.
;
-ij>
+ij>
\ No newline at end of file