[ http://issues.apache.org/jira/browse/DERBY-1304?page=comments#action_12435727 ] Yip Ng commented on DERBY-1304: -------------------------------
I stumbled on this while writing testcases and I have a patch for it. Will post it for review once derbyall passes. > DROP view does not always completely remove view > ------------------------------------------------ > > Key: DERBY-1304 > URL: http://issues.apache.org/jira/browse/DERBY-1304 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.1.2.1 > Environment: Windows XP > Reporter: Piet Blok > Fix For: 10.2.1.0 > > > Execute the following scenario: > Create a schema > Create a table > Create a view > Drop the view > Drop the table > Drop the schema > The first time this sequence executes OK, However, executing the same > sequence again fails on the drop view: > ERROR X0X05: Table 'view' does not exist. > When I leave out the create and drop of a view, all goes well, so it seems > to have something to do with the view. > I encountered the problem first using > org.apache.derby.jdbc.ClientConnectionPoolDataSource, but later I found that > the problem is reproducable with a simple ij script as follows: > -- ******************************************************* > -- Setup connection > -- ******************************************************* > connect 'jdbc:derby://localhost/TestData;create=true;'; > -- ******************************************************* > -- The first time > -- ******************************************************* > CREATE SCHEMA TEST_SCHEMA; > CREATE TABLE TEST_SCHEMA.T1 (TABLE_COLUMN LONG VARCHAR); > CREATE VIEW TEST_SCHEMA.V1 AS SELECT TABLE_COLUMN AS VIEW_COLUMN FROM > TEST_SCHEMA.T1; > DROP VIEW TEST_SCHEMA.V1; > DROP TABLE TEST_SCHEMA.T1; > DROP SCHEMA TEST_SCHEMA RESTRICT; > -- ******************************************************* > -- The second time > -- ******************************************************* > CREATE SCHEMA TEST_SCHEMA; > CREATE TABLE TEST_SCHEMA.T1 (TABLE_COLUMN LONG VARCHAR); > CREATE VIEW TEST_SCHEMA.V1 AS SELECT TABLE_COLUMN AS VIEW_COLUMN FROM > TEST_SCHEMA.T1; > DROP VIEW TEST_SCHEMA.V1; -- This statement fails > DROP TABLE TEST_SCHEMA.T1; > DROP SCHEMA TEST_SCHEMA RESTRICT; > -- ******************************************************* > -- Cleanup > -- ******************************************************* > disconnect; > connect 'jdbc:derby://localhost/TestData;shutdown=true;'; > As an explanation why I would like to be able to create and then drop views: > I am trying to interactively create my table setup. When I make mistakes I > must drop wrongly defined tables or views. > I encountered some other very strange behaviour that might be related to this > issue (table not found when I just created it and wanted to create a second > table with a foreign key referencing the first table), but which I am not yet > able to reproduce in a consistent and simple way. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
