Hi thanks for the answers. Unfortunately it doesn't help.
Here is a script which shows the bug
java -cp h2-1.3.169.jar org.h2.tools.RunScript -url jdbc:h2:test -user sa
-script bug.sql
I hope it's small enough. It only handles 3 tables. Perhaps I could remove some
columns but the tables are small.
I would really appreciate if you can give me some feedback, how this issue will
be handled and if you have enough information.
Niels
Am Dienstag, 23. Oktober 2012 20:41:25 UTC+2 schrieb Thomas Mueller:
>
> Hi,
>
> FYI, the latest build is available for testing at:
> http://www.h2database.com/automated/h2-latest.jar
>
> See also http://h2database.com/html/download.html
>
> Regards,
> Thomas
>
>
>
>
> On Tue, Oct 23, 2012 at 3:51 PM, Noel Grandin <[email protected]<javascript:>
> > wrote:
>
>>
>> On 2012-10-19 20:40, niels wrote:
>>
>>> I attached the db which only contains the necessary tables. It works
>>> if I drop the foreign keys. But I used it with liquibase and don't
>>> like it to have there always special statement for h2. Furthermore I
>>> don't understand why the foreign keys are the problem.
>>> I drop the fk and recreate them after that I can drop the index. Looks
>>> like a bug to me.
>>>
>>>
>> I fixed a bug in H2 around foreign keys and indexes around a week ago,
>> which will probably fix your problem.
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to h2-database...@**
>> googlegroups.com <javascript:>.
>> For more options, visit this group at http://groups.google.com/**
>> group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>
>> .
>>
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/VkaComYHX7QJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: initialH2.xml
-- Ran at: 18.10.12 19:47
-- Against: TEST@jdbc:h2:C:/seu/sandboxes/launchpad/sze_play/test.db
-- Liquibase version: 2.0.5
-- *********************************************************************
-- Create Database Lock Table
CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
INSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
-- Lock Database
-- Create Database Change Log Table
CREATE TABLE DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME));
-- Changeset initialH2.xml::1350468362951-15::niels (generated)::(Checksum: 3:9f3a4f0d50631d9bff1d81aae6591bdd)
CREATE TABLE KLASSE (ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, VERSION BIGINT NOT NULL, GESCHLOSSEN BOOLEAN NOT NULL, JAHRGANG INT NOT NULL, SUFFIX VARCHAR(1) NOT NULL, CONSTRAINT PK_KLASSE PRIMARY KEY (ID));
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Table', 'EXECUTED', 'initialH2.xml', '1350468362951-15', '2.0.5', '3:9f3a4f0d50631d9bff1d81aae6591bdd', 15);
-- Changeset initialH2.xml::1350468362951-22::niels (generated)::(Checksum: 3:bba0a2396f0daa811b1314bbbc8f8fd2)
CREATE TABLE SCHULHALBJAHR (ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, VERSION BIGINT NOT NULL, HALBJAHR INT NOT NULL, JAHR INT NOT NULL, SELECTABLE BOOLEAN NOT NULL, CONSTRAINT PK_SCHULHALBJAHR PRIMARY KEY (ID));
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Table', 'EXECUTED', 'initialH2.xml', '1350468362951-22', '2.0.5', '3:bba0a2396f0daa811b1314bbbc8f8fd2', 22);
-- Changeset initialH2.xml::1350468362951-27::niels (generated)::(Checksum: 3:c6e98cdc8181d9b356d2f56c5ac05183)
CREATE TABLE ZEUGNIS_FORMULAR (ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, VERSION BIGINT NOT NULL, AUSGABE_DATUM TIMESTAMP NOT NULL, BESCHREIBUNG VARCHAR(50) NOT NULL, KLASSE_ID BIGINT NOT NULL, LEITSPRUCH VARCHAR(300), LEITSPRUCH2 VARCHAR(300), NACHTEILS_AUSGLEICHS_DATUM TIMESTAMP NOT NULL, QUELLE_LEITSPRUCH VARCHAR(30), QUELLE_LEITSPRUCH2 VARCHAR(30), SCHULHALBJAHR_ID BIGINT NOT NULL, TEMPLATE_FILE_NAME VARCHAR(255) NOT NULL, CONSTRAINT PK_ZEUGNIS_FORMULAR PRIMARY KEY (ID));
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Table', 'EXECUTED', 'initialH2.xml', '1350468362951-27', '2.0.5', '3:c6e98cdc8181d9b356d2f56c5ac05183', 27);
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: initialH2Constraints.xml
-- Ran at: 18.10.12 19:48
-- Against: TEST@jdbc:h2:C:/seu/sandboxes/launchpad/sze_play/test.db
-- Liquibase version: 2.0.5
-- *********************************************************************
-- Changeset initialH2Constraints.xml::1350468362951-57::niels (generated)::(Checksum: 3:ae4af3a7b414c4dae979eb8d3405a264)
ALTER TABLE PUBLIC.ZEUGNIS_FORMULAR ADD CONSTRAINT FK62F9A99040A05D6E FOREIGN KEY (KLASSE_ID) REFERENCES PUBLIC.KLASSE (ID) ON UPDATE RESTRICT ON DELETE RESTRICT;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Add Foreign Key Constraint', 'EXECUTED', 'initialH2Constraints.xml', '1350468362951-57', '2.0.5', '3:ae4af3a7b414c4dae979eb8d3405a264', 30);
-- Changeset initialH2Constraints.xml::1350468362951-58::niels (generated)::(Checksum: 3:5ed708ce72d513f5533e64c2e8b657f4)
ALTER TABLE PUBLIC.ZEUGNIS_FORMULAR ADD CONSTRAINT FK62F9A9906105B64D FOREIGN KEY (SCHULHALBJAHR_ID) REFERENCES PUBLIC.SCHULHALBJAHR (ID) ON UPDATE RESTRICT ON DELETE RESTRICT;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Add Foreign Key Constraint', 'EXECUTED', 'initialH2Constraints.xml', '1350468362951-58', '2.0.5', '3:5ed708ce72d513f5533e64c2e8b657f4', 31);
-- Changeset initialH2Constraints.xml::1350468362951-71::niels (generated)::(Checksum: 3:5628446bd5b700a5c019b15c921fdad3)
CREATE UNIQUE INDEX UK_SCHULAHLBJAHR_JAHR_HALBJAHR ON SCHULHALBJAHR(HALBJAHR, JAHR);
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Index', 'EXECUTED', 'initialH2Constraints.xml', '1350468362951-71', '2.0.5', '3:5628446bd5b700a5c019b15c921fdad3', 44);
-- Changeset initialH2Constraints.xml::1350468362951-75::niels (generated)::(Checksum: 3:289ee3ef034752a71a765c43e658f5f5)
CREATE UNIQUE INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG ON ZEUGNIS_FORMULAR(KLASSE_ID, SCHULHALBJAHR_ID, BESCHREIBUNG);
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Index', 'EXECUTED', 'initialH2Constraints.xml', '1350468362951-75', '2.0.5', '3:289ee3ef034752a71a765c43e658f5f5', 48);
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: upgradeH2.xml
-- Ran at: 18.10.12 19:49
-- Against: TEST@jdbc:h2:C:/seu/sandboxes/launchpad/sze_play/test.db
-- Liquibase version: 2.0.5
-- *********************************************************************
-- Changeset upgradeH2.xml::1350468477768-2::niels (generated)::(Checksum: 3:46068f769b230089be431f3e0155e596)
ALTER TABLE ZEUGNIS_FORMULAR ALTER COLUMN AUSGABE_DATUM DATE;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Modify data type', 'EXECUTED', 'upgradeH2.xml', '1350468477768-2', '2.0.5', '3:46068f769b230089be431f3e0155e596', 2);
-- Changeset upgradeH2.xml::1350468477768-3::niels (generated)::(Checksum: 3:5323bcf0e847cee9082e31198a5e294a)
ALTER TABLE ZEUGNIS_FORMULAR ALTER COLUMN NACHTEILS_AUSGLEICHS_DATUM DATE;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Modify data type', 'EXECUTED', 'upgradeH2.xml', '1350468477768-3', '2.0.5', '3:5323bcf0e847cee9082e31198a5e294a', 3);
-- Changeset upgradeH2.xml::1350468477768-13::niels (generated)::(Checksum: 3:e2c34523c7ecf8a39a122dd3fc154dd6)
DROP INDEX UK_SCHULAHLBJAHR_JAHR_HALBJAHR;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Drop Index', 'EXECUTED', 'upgradeH2.xml', '1350468477768-13', '2.0.5', '3:e2c34523c7ecf8a39a122dd3fc154dd6', 6);
-- Changeset upgradeH2.xml::1350468477768-14::niels (generated)::(Checksum: 3:40f90077808198665c4055c807de1385)
CREATE UNIQUE INDEX UK_SCHULAHLBJAHR_JAHR_HALBJAHR ON SCHULHALBJAHR(JAHR, HALBJAHR);
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Index', 'EXECUTED', 'upgradeH2.xml', '1350468477768-14', '2.0.5', '3:40f90077808198665c4055c807de1385', 7);
-- Changeset upgradeH2.xml::1350468477768-15::niels (generated)::(Checksum: 3:b8134f63b4337be68dfc2ac96b05ea7d)
DROP INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG;
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Drop Index', 'EXECUTED', 'upgradeH2.xml', '1350468477768-15', '2.0.5', '3:b8134f63b4337be68dfc2ac96b05ea7d', 8);
-- Changeset upgradeH2.xml::1350468477768-16::niels (generated)::(Checksum: 3:9e8a7b79ba9ebce4883c243b4c346eac)
CREATE UNIQUE INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG ON ZEUGNIS_FORMULAR(SCHULHALBJAHR_ID, KLASSE_ID, BESCHREIBUNG);
INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('niels (generated)', '', NOW(), 'Create Index', 'EXECUTED', 'upgradeH2.xml', '1350468477768-16', '2.0.5', '3:9e8a7b79ba9ebce4883c243b4c346eac', 9);
