#66 TransferT (Ora->HSQLDB) RTE unsupported internal operation

open
None
7
2014-08-22
2009-08-21
I S
No

By executing the generated alter table statements the transfer tool freezes likely because of the RTE in engine:

Table X: start alter
Executing CREATE UNIQUE INDEX PK_X ON X(USERID,ROLEID);
Executing ALTER TABLE X ADD CONSTRAINT FK_X FOREIGN KEY (USERID) REFERENCES XT (USERID)
Executing ALTER TABLE X ADD CONSTRAINT FK_X2 FOREIGN KEY (ROLEID) REFERENCES XT2 (ROLEID)

Exception in thread "HSQLDB Connection @b1c260" java.lang.RuntimeException: unsupported internal operation: NumberType
at org.hsqldb.Error.runtimeError(Error.java:65)
at org.hsqldb.types.NumberType.convertToDecimal(NumberType.java:997)
at org.hsqldb.types.NumberType.compare(NumberType.java:596)
at org.hsqldb.index.IndexAVL.compareRowNonUnique(IndexAVL.java:1259)
at org.hsqldb.index.IndexAVL.findNode(IndexAVL.java:1396)
at org.hsqldb.index.IndexAVL.exists(IndexAVL.java:756)
at org.hsqldb.Constraint.checkReferencedRows(Constraint.java:910)
at org.hsqldb.TableWorks.addForeignKey(TableWorks.java:168)
at org.hsqldb.ParserDDL.processAlterTableAddForeignKeyConstraint(ParserDDL.java:3383)
at org.hsqldb.ParserDDL.processAlterTable(ParserDDL.java:576)
at org.hsqldb.ParserDDL.processAlter(ParserDDL.java:212)
at org.hsqldb.StatementSchema.getResult(StatementSchema.java:388)
at org.hsqldb.StatementSchema.execute(StatementSchema.java:260)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1137)
at org.hsqldb.Session.executeDirectStatement(Session.java:1050)
at org.hsqldb.Session.execute(Session.java:865)
at org.hsqldb.server.ServerConnection.receiveResult(ServerConnection.java:361)
at org.hsqldb.server.ServerConnection.run(ServerConnection.java:1530)
at java.lang.Thread.run(Unknown Source)

Discussion

  • I S
    I S
    2009-08-21

    • assigned_to: nobody --> fredt
     
  • I S
    I S
    2009-08-21

    • priority: 5 --> 7
     
  • Fred Toussi
    Fred Toussi
    2009-08-22

    Moved to the correct tracker.
    Please note that TransferTool issues should be resolved by users who submit patches.

     
  • Fred Toussi
    Fred Toussi
    2009-08-22

    • labels: 325100 -->
    • milestone: 116102 -->
    • assigned_to: fredt --> nobody
     
  • I S
    I S
    2009-08-31

    • assigned_to: nobody --> unsaved