db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ole Solberg (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3845) If org.apache.derbyTesting.system.optimizer.RunOptimizerTest is run without the -verbose option the time used per query is not collected
Date Fri, 22 Aug 2008 14:36:44 GMT

    [ 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.


Mime
View raw message