[ http://issues.apache.org/jira/browse/DERBY-1304?page=comments#action_12436028 ] Bryan Pendleton commented on DERBY-1304: ----------------------------------------
Hi Yip, thanks for the explanation. That makes sense to me. I did not know about this behavior of IJ before, so I am glad to learn about it. With your latest patch, things are just as I expected: without the code change, the test fails in the expected way, and with the code change the test passes. Do you feel like this change is now ready for commit? Unless anybody else is intending to review it, I can commit it tonight. > 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 > Assigned To: Yip Ng > Fix For: 10.2.1.0 > > Attachments: derby1304-trunk-diff01.txt, derby1304-trunk-diff02.txt, > derby1304-trunk-stat01.txt, derby1304-trunk-stat02.txt > > > 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
