search

kashipai / h2database

H2 Database for reference.
0 stars 0 forks source link

DROP INDEX does not accept " ON tbl_name" #433

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
This is a compatibility issue.

To reproduce issue:

CREATE TABLE foo (id BIGINT);
CREATE INDEX foo_id ON foo (id);

DROP INDEX foo_id ON foo;  <-- invalid syntax as documented in 
http://www.h2database.com/html/grammar.html#drop_index.

However, this makes it a pain to work with other DBs, such as MySQL, which 
require the "ON table" clause 
http://dev.mysql.com/doc/refman/5.5/en/drop-index.html

Original issue reported on code.google.com by lopez.ju...@gmail.com on 15 Jan 2013 at 6:56

GoogleCodeExporter commented 9 years ago 
I don't plan to support this, sorry.

Original comment by thomas.t...@gmail.com on 15 Jan 2013 at 7:01