Am Montag, 27. November 2017 10:02:23 UTC+1 schrieb Noel Grandin:
>
> this seems to be working on current MASTER, not sure where we fixed it
>
I just downloaded version 1.4.196
Executing the SQL-Statements in the h2 console results in the same result:
--
-- Constraints der Tabelle `changehistorycomment`
--
ALTER TABLE `changehistorycomment`
ADD CONSTRAINT `fk_changehistorycomment_historycomment1` FOREIGN KEY
(`historycommentid`, `scidhistorycomment`) REFERENCES `historycomment`
(`historycommentid`, `scid`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `fk_{D84AC7C2-453F-4894-A87C-47081E2D1954}` FOREIGN KEY
(`scid`, `changehistoryid`) REFERENCES `changehistory` (`scid`,
`changehistoryid`) ON DELETE CASCADE ON UPDATE CASCADE;
*Syntax Fehler in SQL Befehl "-- -- Constraints der Tabelle
`changehistorycomment` -- ALTER TABLE `changehistorycomment` ADD
CONSTRAINT `fk_changehistorycomment_historycomment1` FOREIGN KEY
(`historycommentid`, `scidhistorycomment`) REFERENCES `historycomment`
(`historycommentid`, `scid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD
CONSTRAINT `fk_{D84AC7C2-453F-4894-A87C-47081E2D1954}` FOREIGN KEY (`scid`,
`changehistoryid`) REFERENCES `changehistory` (`scid`, `changehistoryid`)
ON DELETE CASCADE ON UPDATE CASCAD[*]E"Syntax error in SQL statement "-- --
Constraints der Tabelle `changehistorycomment` -- ALTER TABLE
`changehistorycomment` ADD CONSTRAINT
`fk_changehistorycomment_historycomment1` FOREIGN KEY (`historycommentid`,
`scidhistorycomment`) REFERENCES `historycomment` (`historycommentid`,
`scid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT
`fk_{D84AC7C2-453F-4894-A87C-47081E2D1954}` FOREIGN KEY (`scid`,
`changehistoryid`) REFERENCES `changehistory` (`scid`, `changehistoryid`)
ON DELETE CASCADE ON UPDATE CASCAD[*]E" [42000-196]*
<http://localhost:8082/query.do?jsessionid=9f42cb1601c2ed261ad7f450126405cd#>
42000/42000 *(Hilfe)*
<http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c42000>
But if it is really working on current MASTER, I only have to wait for the
next version (> 1.4.196), right?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
