Derby
  1. Derby
  2. DERBY-364

Provide a more helpful message when the incorrect column name is given in a SELECT statement for a VTI

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Invalid
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      If you specify a column name incorrectly in a SELECT statement from a VTI, you get a fairly unhelpful error message

      ij> SELECT SQLSTATE FROM new org.apache.derby.diag.ErrorMessages() vti;
      ERROR 42X01: Syntax error: Encountered "SQLSTATE" at line 1, column 8.
      ij> SELECT SQL_STATE FROM new org.apache.derby.diag.ErrorMessages() vti;
      – list of SQL States returned –

      If you do the same thing from a regular table, the error message is much more clear:

      ij> create table foo(id integer);
      0 rows inserted/updated/deleted
      ij> select ixd from foo;
      ERROR 42X04: Column 'IXD' 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 CREA
      TE or ALTER TABLE statement then 'IXD' is not a column in the target table.

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            David Van Couvering
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development