Constraint creation order is significant under some DB

engine.ReflectionTest.testbasic fails under FB2 because the test tries to create a table with a primary key and a foreign key to itself, but the issued SQL define the foreign key sooner than the primary key. In other words, the statement is something like

  CREATE TABLE engine_users (
    user_id INTEGER,
    ...
    FOREIGN KEY (parent_user_id) REFERENCES engine_users (user_id)
    PRIMARY KEY (user_id)
  )

Comments (2)