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 [1/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/ ...
Author: djd
Date: Fri Jul 14 09:04:03 2006
New Revision: 421932
URL: http://svn.apache.org/viewvc?rev=421932&view=rev
Log:
DERBY-836 Fix metadata information for DECIMAL columns.
There are 3 possible cases with respect to finding the correct maximum width for DECIMAL type.
1. If scale = 0, only sign should be added to precision to compute max width.
2. scale = precision, in this case 3 should be added to precision for sign, decimal and an additional char '0'.
3. precision > scale > 0, 2 shoud be added to precision for sign and decimal.
Patch submitted by Mayuresh Nirhali - Mayuresh.Nirhali@Sun.COM
Modified:
db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java
db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lojreorder.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/partdml.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/specjPlans.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerRefClause.out
Modified: db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java (original)
+++ db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java Fri Jul 14 09:04:03 2006
@@ -292,7 +292,13 @@
return 22;
case Types.DECIMAL:
case java.sql.Types.NUMERIC:
- return getPrecision(column) + 2; // add 1 for sign and 1 for decimal
+ // There are 3 possible cases with respect to finding the correct max width for DECIMAL type.
+ // 1. If scale = 0, only sign should be added to precision.
+ // 2. scale = precision, 3 should be added to precision for sign, decimal and an additional char '0'.
+ // 3. precision > scale > 0, 2 should be added to precision for sign and decimal.
+ int scale = getScale(column);
+ int precision = getPrecision(column);
+ return (scale == 0) ? (precision + 1) : ((scale == precision) ? (precision + 3) : (precision + 2));
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataTypeUtilities.java Fri Jul 14 09:04:03 2006
@@ -218,7 +218,12 @@
*/
public static int computeMaxWidth( int precision, int scale)
{
- return (scale == 0) ? (precision + 1) : (precision + 3);
+ // There are 3 possible cases with respect to finding the correct max
+ // width for DECIMAL type.
+ // 1. If scale = 0, only sign should be added to precision.
+ // 2. scale=precision, 3 should be added to precision for sign, decimal and an additional char '0'.
+ // 3. precision > scale > 0, 2 should be added to precision for sign and decimal.
+ return (scale ==0) ? (precision +1) : ((scale == precision) ? (precision + 3) : (precision + 2));
}
}
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out Fri Jul 14 09:04:03 2006
@@ -7,8 +7,8 @@
double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out Fri Jul 14 09:04:03 2006
@@ -7,8 +7,8 @@
double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out Fri Jul 14 09:04:03 2006
@@ -37,8 +37,8 @@
double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
-DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
-DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
+DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
+DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out Fri Jul 14 09:04:03 2006
@@ -19,24 +19,24 @@
0 rows inserted/updated/deleted
ij> -- localized display is off
select * from tab1;
-C1 |C2 |C3
-----------------------------------------
-12.345 |2000-05-25|test row 1
-32.432 |2000-01-14|test row 2
-54.846 |2000-08-21|test row 3
-98.214 |2000-12-08|test row 4
-77.406 |2000-10-19|test row 5
-50.395 |2000-11-29|test row 6
+C1 |C2 |C3
+---------------------------------------
+12.345 |2000-05-25|test row 1
+32.432 |2000-01-14|test row 2
+54.846 |2000-08-21|test row 3
+98.214 |2000-12-08|test row 4
+77.406 |2000-10-19|test row 5
+50.395 |2000-11-29|test row 6
ij> LOCALIZEDDISPLAY ON;
ij> select * from tab1;
-C1 |C2 |C3
-------------------------------------------------
-12.345 |May 25, 2000 |test row 1
-32.432 |January 14, 2000 |test row 2
-54.846 |August 21, 2000 |test row 3
-98.214 |December 8, 2000 |test row 4
-77.406 |October 19, 2000 |test row 5
-50.395 |November 29, 2000 |test row 6
+C1 |C2 |C3
+-----------------------------------------------
+12.345 |May 25, 2000 |test row 1
+32.432 |January 14, 2000 |test row 2
+54.846 |August 21, 2000 |test row 3
+98.214 |December 8, 2000 |test row 4
+77.406 |October 19, 2000 |test row 5
+50.395 |November 29, 2000 |test row 6
ij> drop table tab1;
0 rows inserted/updated/deleted
ij> create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
@@ -47,22 +47,22 @@
ij> -- localized display is off
LOCALIZEDDISPLAY OFF;
ij> select * from tab1;
-C1 |C2 |C3
-----------------------------------------
-12.345 |2000-05-25|test row 1
-32.432 |2000-01-14|test row 2
-54.846 |2000-08-21|test row 3
-98.214 |2000-12-08|test row 4
-77.406 |2000-10-19|test row 5
-50.395 |2000-11-29|test row 6
+C1 |C2 |C3
+---------------------------------------
+12.345 |2000-05-25|test row 1
+32.432 |2000-01-14|test row 2
+54.846 |2000-08-21|test row 3
+98.214 |2000-12-08|test row 4
+77.406 |2000-10-19|test row 5
+50.395 |2000-11-29|test row 6
ij> LOCALIZEDDISPLAY ON;
ij> select * from tab1;
-C1 |C2 |C3
-------------------------------------------------
-12.345 |May 25, 2000 |test row 1
-32.432 |January 14, 2000 |test row 2
-54.846 |August 21, 2000 |test row 3
-98.214 |December 8, 2000 |test row 4
-77.406 |October 19, 2000 |test row 5
-50.395 |November 29, 2000 |test row 6
+C1 |C2 |C3
+-----------------------------------------------
+12.345 |May 25, 2000 |test row 1
+32.432 |January 14, 2000 |test row 2
+54.846 |August 21, 2000 |test row 3
+98.214 |December 8, 2000 |test row 4
+77.406 |October 19, 2000 |test row 5
+50.395 |November 29, 2000 |test row 6
ij>
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_2.out Fri Jul 14 09:04:03 2006
@@ -716,7 +716,7 @@
complete caseTriggerVTI - passed true
Test metadata starting
Union Result -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
-dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
real -- precision: 7 scale: 0 display size: 13 type name: REAL
double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL
@@ -725,7 +725,7 @@
result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
-DECIMAL(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
@@ -2171,7 +2171,7 @@
complete caseTriggerVTI - passed true
Test metadata starting
Union Result -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
-dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
real -- precision: 7 scale: 0 display size: 13 type name: REAL
double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL
@@ -2180,7 +2180,7 @@
result row: 11.10 3.3 4.4 14.4 -6.699999999999999 6.699999999999999
DECIMAL(10,0) -- precision: 10 scale: 0 display size: 11 type name: DECIMAL
DECIMAL(10,10) -- precision: 10 scale: 10 display size: 13 type name: DECIMAL
-DECIMAL(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL
+DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggbuiltin.out Fri Jul 14 09:04:03 2006
@@ -1880,9 +1880,9 @@
----------------
NULL
ij> select max(dc) from empty;
-1
---------
-NULL
+1
+-------
+NULL
ij> -- variations
select max(i), max(b), max(i), max(s) from empty;
1 |2 |3 |4
@@ -1930,8 +1930,8 @@
1
----------------
ij> select max(dc) from empty group by dc;
-1
---------
+1
+-------
ij> --------------------------------
-- BASIC ACCEPTANCE TESTS
--------------------------------
@@ -1996,9 +1996,9 @@
1111111111111111
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select max(dc) from t;
-1
---------
-222.22
+1
+-------
+222.22
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select max(i) from t group by i;
1
@@ -2085,11 +2085,11 @@
NULL
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select max(dc) from t group by dc;
-1
---------
-111.11
-222.22
-NULL
+1
+-------
+111.11
+222.22
+NULL
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> -- constants
select max(1) from t;
@@ -2101,9 +2101,9 @@
-----
hello
ij> select max(1.1) from t;
-1
------
-1.1
+1
+----
+1.1
ij> select max(1e1) from t;
1
----------------------
@@ -2137,11 +2137,11 @@
hello
hello
ij> select max(1.1) from t group by dc;
-1
------
-1.1
-1.1
-1.1
+1
+----
+1.1
+1.1
+1.1
ij> select max(1e1) from t group by d;
1
----------------------
@@ -2409,9 +2409,9 @@
----------------
NULL
ij> select min(dc) from empty;
-1
---------
-NULL
+1
+-------
+NULL
ij> -- variations
select min(i), min(b), min(i), min(s) from empty;
1 |2 |3 |4
@@ -2459,8 +2459,8 @@
1
----------------
ij> select min(dc) from empty group by dc;
-1
---------
+1
+-------
ij> --------------------------------
-- BASIC ACCEPTANCE TESTS
--------------------------------
@@ -2525,9 +2525,9 @@
0000111100001111
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select min(dc) from t;
-1
---------
-111.11
+1
+-------
+111.11
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select min(i) from t group by i;
1
@@ -2614,11 +2614,11 @@
NULL
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> select min(dc) from t group by dc;
-1
---------
-111.11
-222.22
-NULL
+1
+-------
+111.11
+222.22
+NULL
WARNING 01003: Null values were eliminated from the argument of a column function.
ij> -- constants
select min(1) from t;
@@ -2630,9 +2630,9 @@
-----
hello
ij> select min(1.1) from t;
-1
------
-1.1
+1
+----
+1.1
ij> select min(1e1) from t;
1
----------------------
@@ -2666,11 +2666,11 @@
hello
hello
ij> select min(1.1) from t group by dc;
-1
------
-1.1
-1.1
-1.1
+1
+----
+1.1
+1.1
+1.1
ij> select min(1e1) from t group by d;
1
----------------------
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out Fri Jul 14 09:04:03 2006
@@ -639,10 +639,10 @@
ij> insert into bd values(0.2);
1 row inserted/updated/deleted
ij> select * from bd;
-I
-----------------------------------
-0.100000000000000000000000000000
-0.200000000000000000000000000000
+I
+---------------------------------
+0.100000000000000000000000000000
+0.200000000000000000000000000000
ij> -- should be the same
select avg(i), sum(i)/count(i) from bd;
1 |2
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out Fri Jul 14 09:04:03 2006
@@ -232,13 +232,13 @@
----------------------
1.1
ij> values (cast (1.1 as numeric(2,1)));
-1
------
-1.1
+1
+----
+1.1
ij> values (cast (1.1 as decimal(2,1)));
-1
------
-1.1
+1
+----
+1.1
ij> values (cast (1.1 as numeric(2,0)));
1
----
@@ -272,13 +272,13 @@
----------------------
1.9
ij> values (cast (1.9 as numeric(2,1)));
-1
------
-1.9
+1
+----
+1.9
ij> values (cast (1.9 as decimal(2,1)));
-1
------
-1.9
+1
+----
+1.9
ij> values (cast (1.9 as numeric(2,0)));
1
----
@@ -303,184 +303,184 @@
cast (
cast (9223372036854775807 as DECIMAL(24,1)) as BIGINT)
);
-1 |2 |3
----------------------------------------------------------------------
-9223372036854775807 |9223372036854775807.0 |9223372036854775807
+1 |2 |3
+--------------------------------------------------------------------
+9223372036854775807 |9223372036854775807.0 |9223372036854775807
ij> values (
cast ('9223372036854775807' as DECIMAL(24,1)),
cast (cast ('9223372036854775807' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
-9223372036854775807.0 |9223372036854775807
+1 |2
+-----------------------------------------------
+9223372036854775807.0 |9223372036854775807
ij> values (
cast ('9223372036854775806' as DECIMAL(24,1)),
cast (cast ('9223372036854775806' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
-9223372036854775806.0 |9223372036854775806
+1 |2
+-----------------------------------------------
+9223372036854775806.0 |9223372036854775806
ij> -- only this should fail
values (
cast ('9223372036854775808' as DECIMAL(24,1)),
cast (cast ('9223372036854775808' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
+1 |2
+-----------------------------------------------
ERROR 22003: The resulting value is outside the range for the data type BIGINT.
ij> values (
cast ('9223372036854775807.9' as DECIMAL(24,1)),
cast (cast ('9223372036854775807.9' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
-9223372036854775807.9 |9223372036854775807
+1 |2
+-----------------------------------------------
+9223372036854775807.9 |9223372036854775807
ij> -- -9223372036854775808 is Long::MIN_VALUE
values (
cast ('-9223372036854775808' as DECIMAL(24,1)),
cast (cast ('-9223372036854775808' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
--9223372036854775808.0 |-9223372036854775808
+1 |2
+-----------------------------------------------
+-9223372036854775808.0 |-9223372036854775808
ij> values (
cast ('-9223372036854775807' as DECIMAL(24,1)),
cast (cast ('-9223372036854775807' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
--9223372036854775807.0 |-9223372036854775807
+1 |2
+-----------------------------------------------
+-9223372036854775807.0 |-9223372036854775807
ij> -- only this should fail
values (
cast ('-9223372036854775809' as DECIMAL(24,1)),
cast (cast ('-9223372036854775809' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
+1 |2
+-----------------------------------------------
ERROR 22003: The resulting value is outside the range for the data type BIGINT.
ij> values (
cast ('-9223372036854775808.9' as DECIMAL(24,1)),
cast (cast ('-9223372036854775808.9' as DECIMAL(24,1)) as BIGINT)
);
-1 |2
-------------------------------------------------
--9223372036854775808.9 |-9223372036854775808
+1 |2
+-----------------------------------------------
+-9223372036854775808.9 |-9223372036854775808
ij> values (
cast ('32767' as DECIMAL(24,1)),
cast (cast ('32767' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
-32767.0 |32767
+1 |2
+---------------------------------
+32767.0 |32767
ij> values (
cast ('32766' as DECIMAL(24,1)),
cast (cast ('32766' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
-32766.0 |32766
+1 |2
+---------------------------------
+32766.0 |32766
ij> values (
cast ('32768' as DECIMAL(24,1)),
cast (cast ('32768' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
+1 |2
+---------------------------------
ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
ij> -- only this should fail
values (
cast ('32767.9' as DECIMAL(24,1)),
cast (cast ('32767.9' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
-32767.9 |32767
+1 |2
+---------------------------------
+32767.9 |32767
ij> values (
cast ('-32768' as DECIMAL(24,1)),
cast (cast ('-32768' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
--32768.0 |-32768
+1 |2
+---------------------------------
+-32768.0 |-32768
ij> values (
cast ('-32767' as DECIMAL(24,1)),
cast (cast ('-32767' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
--32767.0 |-32767
+1 |2
+---------------------------------
+-32767.0 |-32767
ij> -- only this should fail
values (
cast ('-32769' as DECIMAL(24,1)),
cast (cast ('-32769' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
+1 |2
+---------------------------------
ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
ij> values (
cast ('-32768.9' as DECIMAL(24,1)),
cast (cast ('-32768.9' as DECIMAL(24,1)) as SMALLINT)
);
-1 |2
-----------------------------------
--32768.9 |-32768
+1 |2
+---------------------------------
+-32768.9 |-32768
ij> values (
cast ('2147483647' as DECIMAL(24,1)),
cast (cast ('2147483647' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
-2147483647.0 |2147483647
+1 |2
+--------------------------------------
+2147483647.0 |2147483647
ij> values (
cast ('2147483646' as DECIMAL(24,1)),
cast (cast ('2147483646' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
-2147483646.0 |2147483646
+1 |2
+--------------------------------------
+2147483646.0 |2147483646
ij> -- only this should fail
values (
cast ('2147483648' as DECIMAL(24,1)),
cast (cast ('2147483648' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
+1 |2
+--------------------------------------
ERROR 22003: The resulting value is outside the range for the data type INTEGER.
ij> values (
cast ('2147483647.9' as DECIMAL(24,1)),
cast (cast ('2147483647.9' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
-2147483647.9 |2147483647
+1 |2
+--------------------------------------
+2147483647.9 |2147483647
ij> values (
cast ('-2147483647' as DECIMAL(24,1)),
cast (cast ('-2147483647' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
--2147483647.0 |-2147483647
+1 |2
+--------------------------------------
+-2147483647.0 |-2147483647
ij> values (
cast ('-2147483646' as DECIMAL(24,1)),
cast (cast ('-2147483646' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
--2147483646.0 |-2147483646
+1 |2
+--------------------------------------
+-2147483646.0 |-2147483646
ij> -- only this should fail
values (
cast ('-2147483649' as DECIMAL(24,1)),
cast (cast ('-2147483649' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
+1 |2
+--------------------------------------
ERROR 22003: The resulting value is outside the range for the data type INTEGER.
ij> values (
cast ('-2147483648.9' as DECIMAL(24,1)),
cast (cast ('-2147483648.9' as DECIMAL(24,1)) as INTEGER)
);
-1 |2
----------------------------------------
--2147483648.9 |-2147483648
+1 |2
+--------------------------------------
+-2147483648.9 |-2147483648
ij> --numbers to char
values (cast (1.1 as char(10)));
1
@@ -556,13 +556,13 @@
ij> values (cast ('123.45' as real));
ERROR 42846: Cannot convert types 'CHAR' to 'REAL'.
ij> values (cast ('123.45' as numeric(5,1)));
-1
---------
-123.4
+1
+-------
+123.4
ij> values (cast ('123.45' as decimal(5,1)));
-1
---------
-123.4
+1
+-------
+123.4
ij> values (cast ('123.99' as smallint));
1
------
@@ -582,13 +582,13 @@
ij> values (cast ('123.99' as real));
ERROR 42846: Cannot convert types 'CHAR' to 'REAL'.
ij> values (cast ('123.99' as numeric(5,1)));
-1
---------
-123.9
+1
+-------
+123.9
ij> values (cast ('123.99' as decimal(5,1)));
-1
---------
-123.9
+1
+-------
+123.9
ij> --bad
values (cast (1 as char(2) for bit data));
ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
@@ -1410,8 +1410,8 @@
ij> values cast('asdf' as double precision);
ERROR 42846: Cannot convert types 'CHAR' to 'DOUBLE'.
ij> values cast('asdf' as decimal(5,4));
-1
---------
+1
+-------
ERROR 22018: Invalid character string format for type DECIMAL.
ij> values cast('asdf' as date);
ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
@@ -1615,8 +1615,8 @@
----------------------
ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.catalog.types.RoutineAliasInfo' into a data value of type 'DOUBLE'.
ij> select cast (aliasinfo as DECIMAL(5,4)) from sys.sysaliases;
-1
---------
+1
+-------
ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.catalog.types.RoutineAliasInfo' into a data value of type 'DECIMAL'.
ij> select cast (aliasinfo as CHAR(30) FOR BIT DATA) from sys.sysaliases;
1
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/casting.out Fri Jul 14 09:04:03 2006
@@ -1073,9 +1073,9 @@
NULL
Test #4
VALUES CAST (CAST (NULL AS SMALLINT) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #5
VALUES CAST (CAST (NULL AS SMALLINT) AS REAL )
1
@@ -1138,9 +1138,9 @@
0
Test #21
VALUES CAST (CAST (0 AS SMALLINT) AS DECIMAL(10,5) )
-1
--------------
-0.00000
+1
+------------
+0.00000
Test #22
VALUES CAST (CAST (0 AS SMALLINT) AS REAL )
1
@@ -1203,9 +1203,9 @@
NULL
Test #38
VALUES CAST (CAST (NULL AS INTEGER) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #39
VALUES CAST (CAST (NULL AS INTEGER) AS REAL )
1
@@ -1268,9 +1268,9 @@
11
Test #55
VALUES CAST (CAST (11 AS INTEGER) AS DECIMAL(10,5) )
-1
--------------
-11.00000
+1
+------------
+11.00000
Test #56
VALUES CAST (CAST (11 AS INTEGER) AS REAL )
1
@@ -1333,9 +1333,9 @@
NULL
Test #72
VALUES CAST (CAST (NULL AS BIGINT) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #73
VALUES CAST (CAST (NULL AS BIGINT) AS REAL )
1
@@ -1398,9 +1398,9 @@
22
Test #89
VALUES CAST (CAST (22 AS BIGINT) AS DECIMAL(10,5) )
-1
--------------
-22.00000
+1
+------------
+22.00000
Test #90
VALUES CAST (CAST (22 AS BIGINT) AS REAL )
1
@@ -1463,9 +1463,9 @@
NULL
Test #106
VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #107
VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS REAL )
1
@@ -1528,9 +1528,9 @@
3
Test #123
VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS DECIMAL(10,5) )
-1
--------------
-3.30000
+1
+------------
+3.30000
Test #124
VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS REAL )
1
@@ -1593,9 +1593,9 @@
NULL
Test #140
VALUES CAST (CAST (NULL AS REAL) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #141
VALUES CAST (CAST (NULL AS REAL) AS REAL )
1
@@ -1656,9 +1656,9 @@
4
Test #157
VALUES CAST (CAST (4.4 AS REAL) AS DECIMAL(10,5) )
-1
--------------
-4.40000
+1
+------------
+4.40000
Test #158
VALUES CAST (CAST (4.4 AS REAL) AS REAL )
1
@@ -1719,9 +1719,9 @@
NULL
Test #174
VALUES CAST (CAST (NULL AS DOUBLE) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #175
VALUES CAST (CAST (NULL AS DOUBLE) AS REAL )
1
@@ -1782,9 +1782,9 @@
5
Test #191
VALUES CAST (CAST (5.5 AS DOUBLE) AS DECIMAL(10,5) )
-1
--------------
-5.50000
+1
+------------
+5.50000
Test #192
VALUES CAST (CAST (5.5 AS DOUBLE) AS REAL )
1
@@ -1845,9 +1845,9 @@
NULL
Test #208
VALUES CAST (CAST (NULL AS CHAR(60)) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #209
VALUES CAST (CAST (NULL AS CHAR(60)) AS REAL )
EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'.
@@ -1918,9 +1918,9 @@
22
Test #225
VALUES CAST (CAST ('3.3' AS CHAR(60)) AS DECIMAL(10,5) )
-1
--------------
-3.30000
+1
+------------
+3.30000
Test #226
VALUES CAST (CAST ('4.4' AS CHAR(60)) AS REAL )
EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'.
@@ -1991,9 +1991,9 @@
NULL
Test #242
VALUES CAST (CAST (NULL AS VARCHAR(60)) AS DECIMAL(10,5) )
-1
--------------
-NULL
+1
+------------
+NULL
Test #243
VALUES CAST (CAST (NULL AS VARCHAR(60)) AS REAL )
EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'.
@@ -2064,9 +2064,9 @@
22
Test #259
VALUES CAST (CAST ('3.3' AS VARCHAR(60)) AS DECIMAL(10,5) )
-1
--------------
-3.30000
+1
+------------
+3.30000
Test #260
VALUES CAST (CAST ('4.4' AS VARCHAR(60)) AS REAL )
EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'.
@@ -3181,9 +3181,9 @@
--------------------
22
SELECT distinct c FROM DECIMAL_TAB WHERE c = 3.3
-C
--------------
-3.30000
+C
+------------
+3.30000
SELECT distinct c FROM REAL_TAB WHERE c = 4.4
C
-------------
@@ -3238,8 +3238,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS SMALLINT)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS SMALLINT)
C
-------------
@@ -3278,8 +3278,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS INTEGER)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS INTEGER)
C
-------------
@@ -3318,8 +3318,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS BIGINT)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS BIGINT)
C
-------------
@@ -3358,8 +3358,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5))
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5))
C
-------------
@@ -3398,8 +3398,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS REAL)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS REAL)
C
-------------
@@ -3438,8 +3438,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(NULL AS DOUBLE)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(NULL AS DOUBLE)
C
-------------
@@ -3875,8 +3875,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(0 AS SMALLINT)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(0 AS SMALLINT)
C
-------------
@@ -3915,8 +3915,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(11 AS INTEGER)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(11 AS INTEGER)
C
-------------
@@ -3955,8 +3955,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(22 AS BIGINT)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(22 AS BIGINT)
C
-------------
@@ -3995,8 +3995,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5))
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5))
C
-------------
@@ -4035,8 +4035,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(4.4 AS REAL)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(4.4 AS REAL)
C
-------------
@@ -4075,8 +4075,8 @@
C
--------------------
select c from DECIMAL_TAB WHERE c = CAST(5.5 AS DOUBLE)
-C
--------------
+C
+------------
select c from REAL_TAB WHERE c = CAST(5.5 AS DOUBLE)
C
-------------
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out Fri Jul 14 09:04:03 2006
@@ -58,8 +58,8 @@
-----------
1
ij> select * from noindexes;
-C1 |C2 |C3
----------------------------------------------------
+C1 |C2 |C3
+--------------------------------------------------
ij> -- do consistency check on scans, etc.
values ConsistencyChecker();
1
@@ -74,15 +74,15 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
ij> insert into noindexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
(10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
(14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -90,51 +90,51 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
ij> insert into noindexes values (17, '17', 17.17), (18, '18', 18.18);
2 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
-17 |17 |17.17
-18 |18 |18.18
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
+17 |17 |17.17
+18 |18 |18.18
ij> -- do consistency check on scans, etc.
values ConsistencyChecker();
1
@@ -168,8 +168,8 @@
-----------
6
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
+C1 |C2 |C3
+--------------------------------------------------
ij> -- do consistency check on scans, etc.
values ConsistencyChecker();
1
@@ -184,15 +184,15 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
(10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
(14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -200,51 +200,51 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
2 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 0);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
-17 |17 |17.17
-18 |18 |18.18
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
+17 |17 |17.17
+18 |18 |18.18
ij> -- do consistency check on scans, etc.
values ConsistencyChecker();
1
@@ -392,8 +392,8 @@
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from v_noindexes;
-C1 |C2 |C3
----------------------------------------------------
+C1 |C2 |C3
+--------------------------------------------------
ij> -- full table
insert into noindexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
(4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -401,15 +401,15 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from v_noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
ij> insert into noindexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
(10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
(14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -417,51 +417,51 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from v_noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
ij> insert into noindexes values (17, '17', 17.17), (18, '18', 18.18);
2 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'NOINDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from v_noindexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
-17 |17 |17.17
-18 |18 |18.18
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
+17 |17 |17.17
+18 |18 |18.18
ij> rollback;
ij> -- 1 index
drop index i_c2;
@@ -476,8 +476,8 @@
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
+C1 |C2 |C3
+--------------------------------------------------
ij> -- full table
insert into indexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
(4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -485,15 +485,15 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
(10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
(14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -501,59 +501,59 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
2 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
-17 |17 |17.17
-18 |18 |18.18
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
+17 |17 |17.17
+18 |18 |18.18
ij> rollback;
ij> -- multiple indexes
-- empty table
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
+C1 |C2 |C3
+--------------------------------------------------
ij> -- full table
insert into indexes values (1, '1', 1.1), (2, '2', 2.2), (3, '3', 3.3),
(4, '4', 4.4), (5, '5', 5.5), (6, '6', 6.6), (7, '7', 7.7);
@@ -561,15 +561,15 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
ij> insert into indexes values (8, '8', 8.8), (8, '8', 8.8), (9, '9', 9.9),
(10, '10', 10.10), (11, '11', 11.11), (12, '12', 12.12), (13, '13', 13.13),
(14, '14', 14.14), (15, '15', 15.15), (16, '16', 16.16);
@@ -577,51 +577,51 @@
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
ij> insert into indexes values (17, '17', 17.17), (18, '18', 18.18);
2 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'INDEXES', 1);
0 rows inserted/updated/deleted
ij> select * from indexes;
-C1 |C2 |C3
----------------------------------------------------
-1 |1 |1.10
-2 |2 |2.20
-3 |3 |3.30
-4 |4 |4.40
-5 |5 |5.50
-6 |6 |6.60
-7 |7 |7.70
-8 |8 |8.80
-8 |8 |8.80
-9 |9 |9.90
-10 |10 |10.10
-11 |11 |11.11
-12 |12 |12.12
-13 |13 |13.13
-14 |14 |14.14
-15 |15 |15.15
-16 |16 |16.16
-17 |17 |17.17
-18 |18 |18.18
+C1 |C2 |C3
+--------------------------------------------------
+1 |1 |1.10
+2 |2 |2.20
+3 |3 |3.30
+4 |4 |4.40
+5 |5 |5.50
+6 |6 |6.60
+7 |7 |7.70
+8 |8 |8.80
+8 |8 |8.80
+9 |9 |9.90
+10 |10 |10.10
+11 |11 |11.11
+12 |12 |12.12
+13 |13 |13.13
+14 |14 |14.14
+15 |15 |15.15
+16 |16 |16.16
+17 |17 |17.17
+18 |18 |18.18
ij> rollback;
ij> --table with multiple indexes, indexes share columns
--table has more than 4 rows
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/consistencyChecker.out Fri Jul 14 09:04:03 2006
@@ -141,21 +141,21 @@
1
ij> -- set 1st row from heap to all nulls
select * from t1;
-I |S |C10 |VC10 |DC
--------------------------------------------------
-2 |22 |2 2 |2 2 2 |222.22
-3 |33 |3 3 |3 3 3 |333.33
-4 |44 |4 4 |4 4 4 |444.44
-1 |11 |1 1 |1 1 1 |111.11
+I |S |C10 |VC10 |DC
+------------------------------------------------
+2 |22 |2 2 |2 2 2 |222.22
+3 |33 |3 3 |3 3 3 |333.33
+4 |44 |4 4 |4 4 4 |444.44
+1 |11 |1 1 |1 1 1 |111.11
ij> call NFHR('APP', 'T1');
0 rows inserted/updated/deleted
ij> select * from t1;
-I |S |C10 |VC10 |DC
--------------------------------------------------
-NULL |NULL |NULL |NULL |NULL
-3 |33 |3 3 |3 3 3 |333.33
-4 |44 |4 4 |4 4 4 |444.44
-1 |11 |1 1 |1 1 1 |111.11
+I |S |C10 |VC10 |DC
+------------------------------------------------
+NULL |NULL |NULL |NULL |NULL
+3 |33 |3 3 |3 3 3 |333.33
+4 |44 |4 4 |4 4 4 |444.44
+1 |11 |1 1 |1 1 1 |111.11
ij> values SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'T1');
1
-----------
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=421932&r1=421931&r2=421932&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Fri Jul 14 09:04:03 2006
@@ -1633,13 +1633,13 @@
-----------
4
ij> values absval( 4.4 );
-1
------
-4.4
+1
+----
+4.4
ij> values absval( -4.4 );
-1
------
-4.4
+1
+----
+4.4
ij> values {fn abs( 4 )};
1
-----------
@@ -1649,17 +1649,17 @@
-----------
4
ij> values {fn abs( 4.4 )};
-1
------
-4.4
+1
+----
+4.4
ij> values {fn abs( -4.4 )};
-1
------
-4.4
+1
+----
+4.4
ij> values {fn abs( -4.44444444444444444444444 )};
-1
----------------------------
-4.44444444444444444444444
+1
+--------------------------
+4.44444444444444444444444
ij> autocommit on;
ij> drop table myint;
0 rows inserted/updated/deleted