[
https://issues.apache.org/jira/browse/DERBY-4645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-4645:
---------------------------------
Urgency: Low
Labels: derby_triage10_8 (was: )
> 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
> Labels: derby_triage10_8
> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
