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 ka...@apache.org on 2014/05/13 13:24:34 UTC
svn commit: r1594196 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/floattypes.out tests/lang/floattypes.sql
Author: kahatlen
Date: Tue May 13 11:24:33 2014
New Revision: 1594196
URL: http://svn.apache.org/r1594196
Log:
DERBY-6575: LangScript.floattypes gets REAL instead of expected DOUBLE
Add ORDER BY to query to make the results stable.
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql
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=1594196&r1=1594195&r2=1594196&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 Tue May 13 11:24:33 2014
@@ -1626,7 +1626,8 @@ create table t (d double precision, r re
0 rows inserted/updated/deleted
ij> select columnname, columndatatype
from sys.syscolumns c, sys.systables t
-where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T';
+where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T'
+order by columnname;
COLUMNNAME |COLUMNDATATYPE
------------------------------------------------------------------------------------------------------------------------------------------------
D |DOUBLE
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql?rev=1594196&r1=1594195&r2=1594196&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes.sql Tue May 13 11:24:33 2014
@@ -742,7 +742,8 @@ create table t (d double precision, r re
select columnname, columndatatype
from sys.syscolumns c, sys.systables t
-where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T';
+where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T'
+order by columnname;
-- invalid float values
insert into t(r) values 'NaN';