[
https://issues.apache.org/jira/browse/DERBY-4645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12865900#action_12865900
]
Mamta A. Satoor commented on DERBY-4645:
----------------------------------------
Bryan, after the first drop table attempt, there is the exception as shown in
the repro above(details of it in derby.log). If I do a select from
SYSXPLAIN_STATEMENT_TIMINGS after doing the first drop, I am still able to see
the table. The second drop table attempt at SYSXPLAIN_STATEMENT_TIMINGS
succeeds and a select from SYSXPLAIN_STATEMENT_TIMINGS after the second drop
table fails. Following shows this behavior inside ij
$ java org.apache.derby.tools.ij
ij version 10.6
ij> connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true';
ij> CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA');
0 rows inserted/updated/deleted
ij> values syscs_util.syscs_get_xplain_schema();
1
--------------------------------------------------------------------------------
XPLAINSCHEMA
1 row selected
ij> set schema XPLAINSCHEMA;
0 rows inserted/updated/deleted
ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
ERROR 42X05: (20000) Table/View 'XPLAINSCHEMA.SYSXPLAIN_STATEMENT_TIMINGS' does
not exist.
ij> select * from SYSXPLAIN_STATEMENT_TIMINGS;
TIMING_ID |PARSE_TIME |BIND_TIME |O
PTIMIZE_TIME |GENERATE_TIME |COMPILE_TIME |EXECUTE_TIME
|BEGIN_COMP_TIME |END_COMP_TIME |BEGIN_EXE_TIME
|END_EXE_TIME
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------
522b00e8-0128-83ca-0d42-000000041138|0 |0 |0
|0 |0 |0
|2010-05-10 12:56:30.796 |2010-05-10 12:56:30.796 |2010-05-10 12:56:30.796
|2010-05-10 12:56:30.796
36e280fc-0128-83ca-0d42-000000041138|31 |0 |0
|0 |31 |0
|2010-05-10 12:56:31.875 |2010-05-10 12:56:31.906 |2010-05-10 12:56:31.906
|2010-05-10 12:56:31.906
2 rows selected
ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
0 rows inserted/updated/deleted
ij> select * from SYSXPLAIN_STATEMENT_TIMINGS;
ERROR 42X05: Table/View 'SYSXPLAIN_STATEMENT_TIMINGS' does not exist.
> Dropping one of the XPLAIN system tables while XPLAIN is enabled results into
> an exception. Trying it again succeeds.
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4645
> URL: https://issues.apache.org/jira/browse/DERBY-4645
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Mamta A. Satoor
> Priority: Minor
> Attachments: derby.log
>
>
> Ran into an exception when I tried dropping system table
> SYSXPLAIN_STATEMENT_TIMINGS after enabling XPLAIN logging using CALL
> SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA'); The second attempt at
> dropping the table succeeds
> eg ij script
> $ java org.apache.derby.tools.ij
> ij version 10.6
> ij> connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true';
> ij> CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
> 0 rows inserted/updated/deleted
> ij> CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);
> 0 rows inserted/updated/deleted
> ij> CALL SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA');
> 0 rows inserted/updated/deleted
> ij> values syscs_util.syscs_get_xplain_schema();
> 1
> --------------------------------------------------------------------------------
> XPLAINSCHEMA
> 1 row selected
> ij> set schema XPLAINSCHEMA;
> 0 rows inserted/updated/deleted
> ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
> java.sql.SQLSyntaxErrorException: Table/View
> 'XPLAINSCHEMA.SYSXPLAIN_STATEMENT_TIMINGS' does not exist.
> ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
> 0 rows inserted/updated/deleted
> I wonder if this is happening because we are trying to write into
> SYSXPLAIN_STATEMENT_TIMINGS as part of the XPLAIN functionality when first
> drop table for SYSXPLAIN_STATEMENT_TIMINGS is issued.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
