[
https://issues.apache.org/jira/browse/DERBY-3845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12624848#action_12624848
]
Ole Solberg commented on DERBY-3845:
------------------------------------
If -Dderby.optimizertest.mode=... was given, the test did not initialize the
database if the database did not exist.
Had to use -reset even if there was no database to reset...
java -Dderby.optimizertest.mode=embedded
org.apache.derbyTesting.system.optimizer.RunOptimizerTest
Fri Aug 22 14:25:20 CEST 2008
Running test with url jdbc:derby:testdb;create=true
EXCEPTION:Table/View 'MYTABLE1' does not exist.
Stack Trace :
java.sql.SQLSyntaxErrorException: Table/View 'MYTABLE1' does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:91)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2192)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(EmbedStatement.java:152)
at
org.apache.derbyTesting.system.optimizer.utils.DataUtils.insertData(DataUtils.java:113)
at
org.apache.derbyTesting.system.optimizer.RunOptimizerTest.main(RunOptimizerTest.java:100)
Caused by: java.sql.SQLException: Table/View 'MYTABLE1' does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 9 more
Caused by: ERROR 42X05: Table/View 'MYTABLE1' does not exist.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2451)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2175)
at
org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:310)
at
org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:390)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:199)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:137)
at
org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:236)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:793)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
... 3 more
SQL Exception :java.sql.SQLException: Failed query:
> If org.apache.derbyTesting.system.optimizer.RunOptimizerTest is run without
> the -verbose option the time used per query is not collected
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3845
> URL: https://issues.apache.org/jira/browse/DERBY-3845
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.5.0.0
> Reporter: Ole Solberg
> Assignee: Ole Solberg
> Fix For: 10.5.0.0
>
> Attachments: DERBY-3845_diff.txt
>
>
> If org.apache.derbyTesting.system.optimizer.RunOptimizerTest is run without
> the -verbose option the time used per query is not collected:
> java org.apache.derbyTesting.system.optimizer.RunOptimizerTest
> Running test with url jdbc:derby:testdb;create=true
> ========================= R E S U L T S =========================
> ________________________________________________________________________________________________
> Timings for Query type: Select from single view
> QueryName Using PreparedStatment Using Statement Rows Expected
> ------------------------------------------------------------------------------
> Query size: 4
> QUERY # 1 null null 3
> QUERY # 1 null null 3
> *************************************************************************
> QUERY # 2 null null 6
> QUERY # 2 null null 6
> *************************************************************************
> QUERY # 3 null null 10
> QUERY # 3 null null 10
> *************************************************************************
> QUERY # 4 null null 10
> QUERY # 4 null null 10
> *************************************************************************
> .
> .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
