Error 90037 'view not found' occurs while exexuting 'drop view if exists' DDL statement

[GoogleCodeExporter]

In my database DDL script I drop all existing tables and views before creating 
new ones. 

This seems to go fine for tables ('DROP TABLE IF EXISTS <table>'), but throws 
an error for view ('DROP VIEW IF EXISTS <view>').

The error is:

Caused by: org.h2.jdbc.JdbcSQLException: View "IPV6_ADDRESS_HEX" not found; SQL 
statement:
DROP VIEW IF EXISTS `ipv6_address_hex`   [90037-181]
    at com.mycompany.products.myproduct.results.dataprovider.generator.impl.ScriptRunner.runScript(ScriptRunner.java:196)

It seems the 'if exists' statement has no effect.

We use these 'hex' views to visualize binary data (such as IP addresses), which 
is important for debugging. Since we use H2 particularly for debugging and 
testing, this issue has high priority for us.

Original issue reported on code.google.com by tim.deba...@gmail.com on 1 Sep 2014 at 8:14

[GoogleCodeExporter]

Can you post the entire stack trace? Because this is working fine for me.

Original comment by noelgrandin on 5 Sep 2014 at 3:56

[GoogleCodeExporter]

closed because of lack of input

Original comment by noelgrandin on 20 Oct 2014 at 6:41

• Changed state: Invalid