Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3931

GeneratedColumnsTest fails with "'F_MINUS' is not recognized as a function or procedure." on cvm/phoneME

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.1.1
    • Component/s: Test
    • Labels:
      None
    • Environment:
      Product: phoneME Advanced (phoneme_advanced_mr2-b34)
      Profile: Foundation Profile Specification 1.1
      JVM: CVM phoneme_advanced_mr2-b34 (interpreter loop)
    • Bug behavior facts:
      Regression Test Failure

      Description

      See http://dbtg.thresher.com/derby/test/Daily/javaME/testing/Limited/testSummary-708941.html / http://dbtg.thresher.com/derby/test/Daily/javaME/testing/testlog/ubuntu/708941-suitesAll_diff.txt

      3) test_008_basicForeignKeys(org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest)java.sql.SQLException: 'F_MINUS' is not recognized as a function or procedure.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Ljava/lang/String;Ljava/lang/String;Ljava/sql/SQLException;ILjava/lang/Throwable;[Ljava/lang/Object;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Lorg/apache/derby/iapi/error/StandardException;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Ljava/lang/Throwable;ZZ)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)V(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement169.<init>(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)V(Unknown Source)
      at org.apache.derby.jdbc.Driver169.newEmbedPreparedStatement(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Ljava/lang/String;IIII[I[Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.chattyPrepare(Ljava/sql/Connection;Ljava/lang/String;)Ljava/sql/PreparedStatement;(GeneratedColumnsTest.java:991)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.goodStatement(Ljava/sql/Connection;Ljava/lang/String;)V(GeneratedColumnsTest.java:977)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.test_008_basicForeignKeys()V(GeneratedColumnsTest.java:834)
      at org.apache.derbyTesting.junit.BaseTestCase.runBare()V(BaseTestCase.java:105)
      at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
      at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
      at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
      at sun.misc.CVM.runMain()V(CVM.java:514)
      Caused by: ERROR 42Y03: 'F_MINUS' is not recognized as a function or procedure.
      at org.apache.derby.iapi.error.StandardException.newException(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;(Unknown Source)
      at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/JavaValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.GenerationClauseNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.TableElementList.bindAndValidateGenerationClauses(Lorg/apache/derby/impl/sql/compile/FromList;)V(Unknown Source)
      at org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement()V(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;Z[Ljava/lang/Object;Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;Z)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;Z)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;Ljava/lang/String;ZZ)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      ... 32 more
      4) test_007_basicTriggers(org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest)java.sql.SQLException: 'F_MINUS' is not recognized as a function or procedure.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Ljava/lang/String;Ljava/lang/String;Ljava/sql/SQLException;ILjava/lang/Throwable;[Ljava/lang/Object;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Lorg/apache/derby/iapi/error/StandardException;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Ljava/lang/Throwable;ZZ)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)V(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement169.<init>(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)V(Unknown Source)
      at org.apache.derby.jdbc.Driver169.newEmbedPreparedStatement(Lorg/apache/derby/impl/jdbc/EmbedConnection;Ljava/lang/String;ZIIII[I[Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Ljava/lang/String;IIII[I[Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;(Unknown Source)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.chattyPrepare(Ljava/sql/Connection;Ljava/lang/String;)Ljava/sql/PreparedStatement;(GeneratedColumnsTest.java:991)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.goodStatement(Ljava/sql/Connection;Ljava/lang/String;)V(GeneratedColumnsTest.java:977)
      at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.test_007_basicTriggers()V(GeneratedColumnsTest.java:661)
      at org.apache.derbyTesting.junit.BaseTestCase.runBare()V(BaseTestCase.java:105)
      at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
      at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
      at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
      at sun.misc.CVM.runMain()V(CVM.java:514)
      Caused by: ERROR 42Y03: 'F_MINUS' is not recognized as a function or procedure.
      at org.apache.derby.iapi.error.StandardException.newException(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;(Unknown Source)
      at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/JavaValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.GenerationClauseNode.bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;(Unknown Source)
      at org.apache.derby.impl.sql.compile.TableElementList.bindAndValidateGenerationClauses(Lorg/apache/derby/impl/sql/compile/FromList;)V(Unknown Source)
      at org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement()V(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;Z[Ljava/lang/Object;Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;Z)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;Z)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;Ljava/lang/String;ZZ)Lorg/apache/derby/iapi/sql/PreparedStatement;(Unknown Source)
      ... 32 more

        Attachments

        1. derby-3931-01-aa-makeIndependent.diff
          3 kB
          Richard N. Hillegas

          Activity

            People

            • Assignee:
              rhillegas Richard N. Hillegas
              Reporter:
              olesolberg Ole Solberg
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: