You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2014/05/13 13:12:15 UTC

[jira] [Commented] (DERBY-6575) LangScript.floattypes gets REAL instead of expected DOUBLE

    [ https://issues.apache.org/jira/browse/DERBY-6575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13996267#comment-13996267 ] 

Knut Anders Hatlen commented on DERBY-6575:
-------------------------------------------

The test expects this output:

{noformat}
ij> select columnname, columndatatype 
from sys.syscolumns c, sys.systables t
where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T';
COLUMNNAME                                                                                                                      |COLUMNDATATYPE 
------------------------------------------------------------------------------------------------------------------------------------------------
D                                                                                                                               |DOUBLE         
F                                                                                                                               |DOUBLE         
F1                                                                                                                              |REAL           
F23                                                                                                                             |REAL           
F24                                                                                                                             |DOUBLE         
F53                                                                                                                             |DOUBLE         
R                                                                                                                               |REAL           
{noformat}

In the failed test run, it got this:

{noformat}
ij> select columnname, columndatatype 
from sys.syscolumns c, sys.systables t
where c.referenceid = t.tableid and CAST(t.tablename AS VARCHAR(128)) ='T';
COLUMNNAME                                                                                                                      |COLUMNDATATYPE 
------------------------------------------------------------------------------------------------------------------------------------------------
D                                                                                                                               |DOUBLE         
R                                                                                                                               |REAL           
F                                                                                                                               |DOUBLE         
F1                                                                                                                              |REAL           
F23                                                                                                                             |REAL           
F24                                                                                                                             |DOUBLE         
F53                                                                                                                             |DOUBLE         
{noformat}

Looks like the order of the rows is the only difference, so adding an ORDER BY clause to the query would probably fix the test.

> LangScript.floattypes gets REAL instead of expected DOUBLE
> ----------------------------------------------------------
>
>                 Key: DERBY-6575
>                 URL: https://issues.apache.org/jira/browse/DERBY-6575
>             Project: Derby
>          Issue Type: Bug
>         Environment: suites.All on ia32_jdk6 
>            Reporter: Dag H. Wanvik
>
> Tinderbox test of trunk:
> http://download.java.net/javadesktop/derby/request_5590862/javadb-task-3858021.html
> {code}
>     junit.framework.ComparisonFailure: Output at line 1633 expected:<[F                                                                                                                               |DOUBLE]         > but was:<[R                                                                                                                               |REAL  ]         >
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:110)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:203)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)