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 dj...@apache.org on 2006/07/14 18:04:05 UTC
svn commit: r421932 [2/5] - in /db/derby/code/trunk/java:
client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/types/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ ...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out Fri Jul 14 09:04:03 2006
@@ -50,13 +50,13 @@
------
1
ij> values cast (1.1 as dec(5,3));
-1
---------
-1.100
+1
+-------
+1.100
ij> values cast (1.1 as numeric(5,3));
-1
---------
-1.100
+1
+-------
+1.100
ij> -- cast to all valid types
values cast (1.1 as int);
1
@@ -393,15 +393,15 @@
1.0
1.0
ij> select cast(d as dec(10,2)) from tmp;
-1
--------------
-1.00
-1.00
+1
+------------
+1.00
+1.00
ij> select cast(d as dec(10,8)) from tmp;
-1
--------------
-1.00000000
-1.00000000
+1
+------------
+1.00000000
+1.00000000
ij> drop table tmp;
0 rows inserted/updated/deleted
ij> drop table t;
@@ -440,12 +440,12 @@
);
1 row inserted/updated/deleted
ij> select dc from t;
-DC
--------------
-NULL
-10.00
--10.00
-0.00
+DC
+------------
+NULL
+10.00
+-10.00
+0.00
ij> select dc + i, dc + s, dc + r, dc + dc from t;
1 |2 |3 |4
------------------------------------------------------------
@@ -484,11 +484,11 @@
0.0 |0.0
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
+DC |2 |3 |4
+---------------------------------------------------------------------------------------------------------
+NULL |NULL |NULL |NULL
+10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0
+-10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0
ERROR 22012: Attempt to divide by zero.
ij> -- test for divide by 0
select dc / i from t;
@@ -507,20 +507,20 @@
1.0 |1.0
ij> -- test positive/negative, negative/positive and negative/negative
select dc, dc / -dc, (-dc) / dc, (-dc) / -dc from t;
-DC |2 |3 |4
-----------------------------------------------------------------------------------------------------------------------
-NULL |NULL |NULL |NULL
-10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000
--10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000
+DC |2 |3 |4
+---------------------------------------------------------------------------------------------------------------------
+NULL |NULL |NULL |NULL
+10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000
+-10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000
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
-0.00 |10.0 |10.0 |-10.00 |-10.00
+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
+0.00 |10.0 |10.0 |-10.00 |-10.00
ij> -- make sure we get the right scale/precision during arithmetic
values (9.0 + 9.0);
1
@@ -621,9 +621,9 @@
-- cast(1.7e308 as dec(2147483647))));
--
values cast(1 as dec(31, 20));
-1
-----------------------------------
-1.00000000000000000000
+1
+---------------------------------
+1.00000000000000000000
ij> -- test the arithmetic operators on a type we know they don't work on
create table w (x dec, y long varchar);
0 rows inserted/updated/deleted
@@ -651,314 +651,314 @@
1 row inserted/updated/deleted
ij> -- test =
select dc from t where dc is null;
-DC
--------------
-NULL
+DC
+------------
+NULL
ij> select dc from t where dc = 10;
-DC
--------------
-10.00
+DC
+------------
+10.00
ij> select dc from t where dc = -10;
-DC
--------------
--10.00
+DC
+------------
+-10.00
ij> select dc from t where dc = 0;
-DC
--------------
-0.00
+DC
+------------
+0.00
ij> select dc from t where dc = 1234.45;
-DC
--------------
+DC
+------------
ij> select dc from t where dc = i;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc = l;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc = s;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc = r;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc = d;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc = dc;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> -- test >
select dc from t where dc > 10;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc > -10;
-DC
--------------
-10.00
-0.00
-1234.56
+DC
+------------
+10.00
+0.00
+1234.56
ij> select dc from t where dc > 0;
-DC
--------------
-10.00
-1234.56
+DC
+------------
+10.00
+1234.56
ij> select dc from t where dc > 1234.45;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc > i;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc > l;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc > s;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc > r;
-DC
--------------
+DC
+------------
ij> select dc from t where dc > d;
-DC
--------------
+DC
+------------
ij> select dc from t where dc > dc;
-DC
--------------
+DC
+------------
ij> -- test >=
select dc from t where dc >= 10;
-DC
--------------
-10.00
-1234.56
+DC
+------------
+10.00
+1234.56
ij> select dc from t where dc >= -10;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= 0;
-DC
--------------
-10.00
-0.00
-1234.56
+DC
+------------
+10.00
+0.00
+1234.56
ij> select dc from t where dc >= 1234.45;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc >= i;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= l;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= s;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= r;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= d;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc >= dc;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> -- test <
select dc from t where dc < 10;
-DC
--------------
--10.00
-0.00
+DC
+------------
+-10.00
+0.00
ij> select dc from t where dc < -10;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < 0;
-DC
--------------
--10.00
+DC
+------------
+-10.00
ij> select dc from t where dc < 1234.45;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc < i;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < l;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < s;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < r;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < d;
-DC
--------------
+DC
+------------
ij> select dc from t where dc < dc;
-DC
--------------
+DC
+------------
ij> -- test <=
select dc from t where dc <= 10;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc <= -10;
-DC
--------------
--10.00
+DC
+------------
+-10.00
ij> select dc from t where dc <= 0;
-DC
--------------
--10.00
-0.00
+DC
+------------
+-10.00
+0.00
ij> select dc from t where dc <= 1234.45;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc <= i;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc <= l;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc <= s;
-DC
--------------
-10.00
--10.00
-0.00
+DC
+------------
+10.00
+-10.00
+0.00
ij> select dc from t where dc <= r;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc <= d;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc <= dc;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> -- test <>
select dc from t where dc <> 10;
-DC
--------------
--10.00
-0.00
-1234.56
+DC
+------------
+-10.00
+0.00
+1234.56
ij> select dc from t where dc <> -10;
-DC
--------------
-10.00
-0.00
-1234.56
+DC
+------------
+10.00
+0.00
+1234.56
ij> select dc from t where dc <> 0;
-DC
--------------
-10.00
--10.00
-1234.56
+DC
+------------
+10.00
+-10.00
+1234.56
ij> select dc from t where dc <> 1234.45;
-DC
--------------
-10.00
--10.00
-0.00
-1234.56
+DC
+------------
+10.00
+-10.00
+0.00
+1234.56
ij> select dc from t where dc <> i;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc <> l;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc <> s;
-DC
--------------
-1234.56
+DC
+------------
+1234.56
ij> select dc from t where dc <> r;
-DC
--------------
+DC
+------------
ij> select dc from t where dc <> d;
-DC
--------------
+DC
+------------
ij> select dc from t where dc <> dc;
-DC
--------------
+DC
+------------
ij> --
-- test a variety of inserts and updates
--
@@ -982,65 +982,65 @@
update t2 set dc = dc + 1.1;
5 rows inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--8.90
-1.10
-11.10
-1235.66
-NULL
+DC
+------------
+-8.90
+1.10
+11.10
+1235.66
+NULL
ij> update t2 set dc = dc - 1.1;
5 rows inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--10.00
-0.00
-10.00
-1234.56
-NULL
+DC
+------------
+-10.00
+0.00
+10.00
+1234.56
+NULL
ij> update t2 set dc = dc / 1.1;
5 rows inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--9.09
-0.00
-9.09
-1122.32
-NULL
+DC
+------------
+-9.09
+0.00
+9.09
+1122.32
+NULL
ij> update t2 set dc = dc * 1.1;
5 rows inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--9.99
-0.00
-9.99
-1234.55
-NULL
+DC
+------------
+-9.99
+0.00
+9.99
+1234.55
+NULL
ij> -- try some deletes
delete from t2 where dc > 0;
2 rows inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--9.99
-0.00
-NULL
+DC
+------------
+-9.99
+0.00
+NULL
ij> delete from t2 where dc = 0;
1 row inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
--9.99
-NULL
+DC
+------------
+-9.99
+NULL
ij> delete from t2 where dc < 0;
1 row inserted/updated/deleted
ij> select dc from t2;
-DC
--------------
-NULL
+DC
+------------
+NULL
ij> drop table t2;
0 rows inserted/updated/deleted
ij> drop table t;
@@ -1074,33 +1074,33 @@
ij> insert into t values ('a', 9.123, 'Z');
1 row inserted/updated/deleted
ij> select * from t;
-C1 |D |C2
----------------------------------
-a |1.1230 |Z
-a |11111.1230 |Z
-a |11111111.1230 |Z
-a |6.1230 |Z
-a |666.1230 |Z
-a |0.6000 |Z
-a |0.0000 |Z
-a |666666.1230 |Z
-a |99999999999999.1230 |Z
-a |9.1230 |Z
+C1 |D |C2
+--------------------------------
+a |1.1230 |Z
+a |11111.1230 |Z
+a |11111111.1230 |Z
+a |6.1230 |Z
+a |666.1230 |Z
+a |0.6000 |Z
+a |0.0000 |Z
+a |666666.1230 |Z
+a |99999999999999.1230 |Z
+a |9.1230 |Z
ij> update t set d = d + .0007;
10 rows inserted/updated/deleted
ij> select * from t;
-C1 |D |C2
----------------------------------
-a |1.1237 |Z
-a |11111.1237 |Z
-a |11111111.1237 |Z
-a |6.1237 |Z
-a |666.1237 |Z
-a |0.6007 |Z
-a |0.0007 |Z
-a |666666.1237 |Z
-a |99999999999999.1237 |Z
-a |9.1237 |Z
+C1 |D |C2
+--------------------------------
+a |1.1237 |Z
+a |11111.1237 |Z
+a |11111111.1237 |Z
+a |6.1237 |Z
+a |666.1237 |Z
+a |0.6007 |Z
+a |0.0007 |Z
+a |666666.1237 |Z
+a |99999999999999.1237 |Z
+a |9.1237 |Z
ij> drop table tmp;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TMP' because it does not exist.
ij> drop table bad;
@@ -2444,87 +2444,87 @@
ij> insert into tiger values (0.00000001234);
1 row inserted/updated/deleted
ij> select d from tiger order by 1;
-D
----------------
-0.00000001234
-0.00000001234
-0.00000012340
-0.00000123400
-0.00001234000
-0.00012340000
-0.00123400000
-0.00123400000
-0.01234000000
-0.12340000000
-1.23400000000
+D
+--------------
+0.00000001234
+0.00000001234
+0.00000012340
+0.00000123400
+0.00001234000
+0.00012340000
+0.00123400000
+0.00123400000
+0.01234000000
+0.12340000000
+1.23400000000
ij> -- =====================================================
-- some formatting tests
values cast ('1e+0' as DECIMAL(6,2));
-1
----------
-1.00
+1
+--------
+1.00
ij> values cast ('+-1e+1' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('-1e+1' as DECIMAL(6,2));
-1
----------
--10.00
+1
+--------
+-10.00
ij> values cast ('-1e-1' as DECIMAL(6,2));
-1
----------
--0.10
+1
+--------
+-0.10
ij> values cast ('-1e-+1' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('-1e--1' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('-1e+-1' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('-1e+-1' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1.0e' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1.0e+' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1.0e-' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1.0ee' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('123.' as DECIMAL(6,2));
-1
----------
-123.00
+1
+--------
+123.00
ij> values cast ('1e' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('1e1.0' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast ('.3' as DECIMAL(6,2));
-1
----------
-0.30
+1
+--------
+0.30
ij> values cast ('' as DECIMAL(6,2));
-1
----------
+1
+--------
ERROR 22018: Invalid character string format for type DECIMAL.
ij>
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out Fri Jul 14 09:04:03 2006
@@ -551,36 +551,36 @@
0 rows inserted/updated/deleted
ij> -- Test cases for DERBY-479
VALUES CAST( RN_COS(RN_RADIANS(null)) AS DECIMAL(3,2));
-1
-------
-NULL
+1
+-----
+NULL
ij> VALUES CAST( RN_COS(RN_RADIANS(90.0)) AS DECIMAL(3,2));
-1
-------
-0.00
+1
+-----
+0.00
ij> VALUES CAST( CALL_COS(CALL_RADIANS(90.0)) AS DECIMAL(3,2));
-1
-------
-0.00
+1
+-----
+0.00
ij> VALUES CAST( CALL_COS(CALL_RADIANS(null)) AS DECIMAL(3,2));
-1
-------
+1
+-----
ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
ij> VALUES CAST( CALL_COS(RN_RADIANS(null)) AS DECIMAL(3,2));
-1
-------
+1
+-----
ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
ij> VALUES CAST( CALL_COS(RN_RADIANS(90.0)) AS DECIMAL(3,2));
-1
-------
-0.00
+1
+-----
+0.00
ij> VALUES CAST( RN_COS(CALL_RADIANS(90.0)) AS DECIMAL(3,2));
-1
-------
-0.00
+1
+-----
+0.00
ij> VALUES CAST( RN_COS(CALL_RADIANS(null)) AS DECIMAL(3,2));
-1
-------
+1
+-----
ERROR 39004: A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
ij> DROP FUNCTION RN_COS;
0 rows inserted/updated/deleted
@@ -609,96 +609,96 @@
----------------------
3.141592653589793
ij> select cast (ACOS(d) as DECIMAL(6,3)) AS ACOS FROM SYSFUN_MATH_TEST;
-ACOS
----------
-NULL
-0.836
+ACOS
+--------
+NULL
+0.836
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> select cast (ASIN(d) as DECIMAL(6,3)) AS ASIN FROM SYSFUN_MATH_TEST;
-ASIN
----------
-NULL
-0.734
+ASIN
+--------
+NULL
+0.734
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> select cast (ATAN(d) as DECIMAL(6,3)) AS ATAN FROM SYSFUN_MATH_TEST;
-ATAN
----------
-NULL
-0.590
-0.929
+ATAN
+--------
+NULL
+0.590
+0.929
ij> select cast (COS(d) as DECIMAL(6,3)) AS COS FROM SYSFUN_MATH_TEST;
-COS
----------
-NULL
-0.783
-0.228
+COS
+--------
+NULL
+0.783
+0.228
ij> select cast (SIN(d) as DECIMAL(6,3)) AS SIN FROM SYSFUN_MATH_TEST;
-SIN
----------
-NULL
-0.620
-0.973
+SIN
+--------
+NULL
+0.620
+0.973
ij> select cast (TAN(d) as DECIMAL(6,3)) AS TAN FROM SYSFUN_MATH_TEST;
-TAN
----------
-NULL
-0.792
-4.255
+TAN
+--------
+NULL
+0.792
+4.255
ij> select cast (DEGREES(d) as DECIMAL(6,3)) AS DEGREES FROM SYSFUN_MATH_TEST;
-DEGREES
----------
-NULL
-38.388
-76.776
+DEGREES
+--------
+NULL
+38.388
+76.776
ij> select cast (RADIANS(d) as DECIMAL(6,3)) AS RADIANS FROM SYSFUN_MATH_TEST;
-RADIANS
----------
-NULL
-0.011
-0.023
+RADIANS
+--------
+NULL
+0.011
+0.023
ij> select cast (LN(d) as DECIMAL(6,3)) AS LN,
cast (LOG(d) as DECIMAL(6,3)) AS LOG
FROM SYSFUN_MATH_TEST;
-LN |LOG
--------------------
-NULL |NULL
--0.400 |-0.400
-0.292 |0.292
+LN |LOG
+-----------------
+NULL |NULL
+-0.400 |-0.400
+0.292 |0.292
ij> select cast (EXP(d) as DECIMAL(6,3)) AS EXP FROM SYSFUN_MATH_TEST;
-EXP
----------
-NULL
-1.954
-3.819
+EXP
+--------
+NULL
+1.954
+3.819
ij> select cast (LOG10(d) as DECIMAL(6,3)) AS LOG10 FROM SYSFUN_MATH_TEST;
-LOG10
----------
-NULL
--0.173
-0.127
+LOG10
+--------
+NULL
+-0.173
+0.127
ij> select cast (CEIL(d) as DECIMAL(6,3)) AS CEIL FROM SYSFUN_MATH_TEST;
-CEIL
----------
-NULL
-1.000
-2.000
+CEIL
+--------
+NULL
+1.000
+2.000
ij> select cast (CEILING(d) as DECIMAL(6,3)) AS CEILING FROM SYSFUN_MATH_TEST;
-CEILING
----------
-NULL
-1.000
-2.000
+CEILING
+--------
+NULL
+1.000
+2.000
ij> select cast (FLOOR(d) as DECIMAL(6,3)) AS FLOOR FROM SYSFUN_MATH_TEST;
-FLOOR
----------
-NULL
-0.000
-1.000
+FLOOR
+--------
+NULL
+0.000
+1.000
ij> select cast (SYSFUN.ACOS(d) as DECIMAL(6,3)) AS SYSFUN_ACOS FROM SYSFUN_MATH_TEST;
-SYSFUN_A&
----------
-NULL
-0.836
+SYSFUN_&
+--------
+NULL
+0.836
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> drop table SYSFUN_MATH_TEST;
0 rows inserted/updated/deleted
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Fri Jul 14 09:04:03 2006
@@ -49,32 +49,32 @@
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from ex_emp;
-ID |NAME |SKILLS |SALARY
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99 |smith |tennis"p,l,ayer" |190.55
-100 |smith |tennis"player" |190.55
-101 |smith |tennis"player |190.55
-102 |smith |"tennis"player |190.55
-103 |smith |"tennis"player" |190.55
-104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
-105 |smith |"" |190.55
-106 |smith |""""""""""""""""""" |190.55
-107 |smith" |NULL |190.55
-108 |NULL |NULL |NULL
+ID |NAME |SKILLS |SALARY
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
ij> select * from imp_emp;
-ID |NAME |SKILLS |SALARY
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99 |smith |tennis"p,l,ayer" |190.55
-99 |smith |tennis"p,l,ayer" |190.55
-100 |smith |tennis"player" |190.55
-101 |smith |tennis"player |190.55
-102 |smith |"tennis"player |190.55
-103 |smith |"tennis"player" |190.55
-104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
-105 |smith |"" |190.55
-106 |smith |""""""""""""""""""" |190.55
-107 |smith" |NULL |190.55
-108 |NULL |NULL |NULL
+ID |NAME |SKILLS |SALARY
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99 |smith |tennis"p,l,ayer" |190.55
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
ij> --checking query
select count(*) from imp_emp, ex_emp
where ex_emp.id = imp_emp.id and
@@ -149,18 +149,18 @@
null, '''', null, 1) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp ;
-ID |NAME |SKILLS |SALARY
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99 |smith |tennis"p,l,ayer" |190.55
-100 |smith |tennis"player" |190.55
-101 |smith |tennis"player |190.55
-102 |smith |"tennis"player |190.55
-103 |smith |"tennis"player" |190.55
-104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
-105 |smith |"" |190.55
-106 |smith |""""""""""""""""""" |190.55
-107 |smith" |NULL |190.55
-108 |NULL |NULL |NULL
+ID |NAME |SKILLS |SALARY
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
ij> -- single quote(') as column delimiter
call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
'''',null, null) ;
@@ -171,18 +171,18 @@
'''', null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp;
-ID |NAME |SKILLS |SALARY
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99 |smith |tennis"p,l,ayer" |190.55
-100 |smith |tennis"player" |190.55
-101 |smith |tennis"player |190.55
-102 |smith |"tennis"player |190.55
-103 |smith |"tennis"player" |190.55
-104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
-105 |smith |"" |190.55
-106 |smith |""""""""""""""""""" |190.55
-107 |smith" |NULL |190.55
-108 |NULL |NULL |NULL
+ID |NAME |SKILLS |SALARY
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
'*', '%', null) ;
0 rows inserted/updated/deleted
@@ -190,18 +190,18 @@
'*', '%', null, 1) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp ;
-ID |NAME |SKILLS |SALARY
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-99 |smith |tennis"p,l,ayer" |190.55
-100 |smith |tennis"player" |190.55
-101 |smith |tennis"player |190.55
-102 |smith |"tennis"player |190.55
-103 |smith |"tennis"player" |190.55
-104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
-105 |smith |"" |190.55
-106 |smith |""""""""""""""""""" |190.55
-107 |smith" |NULL |190.55
-108 |NULL |NULL |NULL
+ID |NAME |SKILLS |SALARY
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
ij> --cases for identity columns
--create table emp1(id int generated always as identity (start with 100), name char(7),
-- skills varchar(200), salary decimal(10,2),skills varchar(200));
@@ -540,14 +540,14 @@
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from alltypes ;
-CHARTYPE |BIGINTTYPE |DATETYPE |DECIMALTYPE |DOUBLETYPE |INTTYPE |LVARTYPE |REALTYPE |SMINT&|TIMETYPE|TSTAMPTYPE |VARTYPE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-chartype string |9223372036854775807 |1993-10-29|12345.54321 |1.0E308 |2147483647 |long varchar testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
-chartype string |-9223372036854775808|1993-10-29|0.00000 |-1.0E308 |-2147483647|long varchar testing |-10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
-"chartype" string |9223372036854775807 |1993-10-29|-12345.54321 |1.0E308 |2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing
-chartype string |9223372036854775807 |1993-10-29|12345.54321 |1.0E308 |2147483647 |long varchar testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
-chartype string |-9223372036854775808|1993-10-29|0.00000 |-1.0E308 |-2147483647|long varchar testing |-10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
-"chartype" string |9223372036854775807 |1993-10-29|-12345.54321 |1.0E308 |2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing
+CHARTYPE |BIGINTTYPE |DATETYPE |DECIMALTYPE |DOUBLETYPE |INTTYPE |LVARTYPE |REALTYPE |SMINT&|TIMETYPE|TSTAMPTYPE |VARTYPE
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+chartype string |9223372036854775807 |1993-10-29|12345.54321 |1.0E308 |2147483647 |long varchar testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
+chartype string |-9223372036854775808|1993-10-29|0.00000 |-1.0E308 |-2147483647|long varchar testing |-10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
+"chartype" string |9223372036854775807 |1993-10-29|-12345.54321|1.0E308 |2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing
+chartype string |9223372036854775807 |1993-10-29|12345.54321 |1.0E308 |2147483647 |long varchar testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
+chartype string |-9223372036854775808|1993-10-29|0.00000 |-1.0E308 |-2147483647|long varchar testing |-10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|varchar testing
+"chartype" string |9223372036854775807 |1993-10-29|-12345.54321|1.0E308 |2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43|xxxxxxFILTERED-TIMESTAMPxxxxx|"varchar" testing
ij> delete from alltypes;
6 rows inserted/updated/deleted
ij> --import should work with trigger enabled on append and should not work on replace
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out Fri Jul 14 09:04:03 2006
@@ -2205,8 +2205,8 @@
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&
--------------------------------------------------------------------------------------
+DC |C_DC |NUM |C_NUM |C_BO&
+-----------------------------------------------------------------------------------
ij> select b, c_b, bv, vc_bv, lbv, vc_lbv, dt, c_dt from all1, all_c1;
B |C_B |BV |VC_BV |LBV |VC_LBV |DT |C_DT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2228,8 +2228,8 @@
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&
--------------------------------------------------------------------------------------
+DC |C_DC |NUM |C_NUM |C_BO&
+-----------------------------------------------------------------------------------
ij> select b, c_b, bv, vc_bv, lbv, vc_lbv, dt, c_dt from all1, all_c1;
B |C_B |BV |VC_BV |LBV |VC_LBV |DT |C_DT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -2247,8 +2247,8 @@
insert into t5_2 values ('11.95', '95.11');
ERROR 42821: Columns of type 'DECIMAL' cannot hold values of type 'CHAR'.
ij> select * from t5_2;
-DC |NUM
------------------
+DC |NUM
+---------------
ij> rollback;
ij> -- update tests
alter table all1 add column c30 char(30) ;
@@ -2258,9 +2258,9 @@
ij> alter table all1 add column lvc2 long varchar ;
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|xxxxxxFILTERED-TIMESTAMPxxxxx|1 |2 |33333333 |NULL |NULL |NULL
+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|xxxxxxFILTERED-TIMESTAMPxxxxx|1 |2 |33333333 |NULL |NULL |NULL
ij> update all1 set si = '11';
ERROR 42821: Columns of type 'SMALLINT' cannot hold values of type 'CHAR'.
ij> update all1 set i = '11';
@@ -2290,9 +2290,9 @@
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|xxxxxxFILTERED-TIMESTAMPxxxxx|1 |2 |44444444 |NULL |NULL |NULL
+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|xxxxxxFILTERED-TIMESTAMPxxxxx|1 |2 |44444444 |NULL |NULL |NULL
ij> select c30, vc30, lvc2 from all1;
C30 |VC30 |LVC2
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -3860,26 +3860,26 @@
ERROR 42818: Comparisons between 'SMALLINT' and 'LONG VARCHAR' are not supported.
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
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+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 datetime 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
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+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 datetime value is incorrect.
ij> select * from all1 a, all1 b
where a.dt = b.lvc;
ERROR 42818: Comparisons between 'DATE' and 'LONG VARCHAR' are not supported.
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
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+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 datetime 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
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+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 datetime value is incorrect.
ij> select * from all1 a, all1 b
where b.dt = a.lvc;