Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6540

Schema-qualified table names could be mistaken for transition tables

    XMLWordPrintableJSON

Details

    Description

      ij version 10.11
      ij> connect 'jdbc:derby:memory:db;create=true';
      ij> create table new(x int);
      0 rows inserted/updated/deleted
      ij> create table t(y int);
      0 rows inserted/updated/deleted
      ij> create trigger tr1 after insert on t referencing new table as new select x from app.new;
      ERROR 42X04: Column 'X' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'X' is not a column in the target table.

      The error message here is wrong. Column X does exist in APP.NEW, so the CREATE TRIGGER statement should have succeeded.

      Attachments

        1. d6540-1a.diff
          10 kB
          Knut Anders Hatlen

        Activity

          People

            knutanders Knut Anders Hatlen
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: