"SCRIPT DROP TO filename" does not create "DROP SEQUENCE" statements

[Andreas Liebig]

Hello!

There seems to be a bug in the "SCRIPT DROP" option:

The H2 SQL Grammar document states the following for the SCRIPT
command:
"If the DROP option is specified, drop statements are created for
tables, views, and sequences."

However, using the command "script drop to filename" does not create
DROP statements for the SEQUENCEs in the database (DROP statements for
ALIAS, TABLES, VIEWS are generated correctly).

We managed to reproduce this with version 1.2.131 as well as 1.2.131.

Best regards,
Andreas Liebig

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[Thomas Mueller]

Hi,

Sorry, I can't reproduce this problem. My test case is:

create sequence test;
script drop;
script drop to 'test.sql';

In both cases the "drop sequence test" statement is included.

Regards,
Thomas