Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.1.2.1
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal
    • Issue & fix info:
      Newcomer, Repro attached

      Description

      create table acc.account
      (
      account_id integer not null,
      plan_id integer not null
      );
      create table acc.trans
      (
      plan_id integer not null,
      credit_id integer not null,
      );
      alter table acc.account add constraint account_pk primary key
      (account_id, plan_id);

      alter table acc.trans add constraint trans_credit_fk foreign key
      (plan_id, credit_id) references acc.account (plan_id, account_id)
      on delete restrict on update restrict;

      SQL Exception: Constraint 'TRANS_CREDIT_FK' is invalid: there is no
      unique or primary key constraint on table 'ACC.ACCOUNT' that matches the
      number and types of the columns in the foreign key.

      if in trans_credit_fk I change with places plan_id, account_id, it works

      it's a probleme of order, but message is wrong

      1. w.sql
        0.6 kB
        Rick Hillegas

        Activity

        Hide
        Rick Hillegas added a comment -

        Attaching repro, w.sql

        Show
        Rick Hillegas added a comment - Attaching repro, w.sql
        Hide
        Rick Hillegas added a comment -

        Triaged for 10.5.3: assigned normal urgency, marked as "newcomer" and "repro attached". This could be resolved by improving the wording of the error message.

        Show
        Rick Hillegas added a comment - Triaged for 10.5.3: assigned normal urgency, marked as "newcomer" and "repro attached". This could be resolved by improving the wording of the error message.

          People

          • Assignee:
            Unassigned
            Reporter:
            Veaceslav Chicu
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development