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

Error when fully qualifying a field from a view in an ORDER BY clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1
    • 10.5.3.2, 10.6.2.4, 10.7.1.4, 10.8.1.2
    • SQL
    • Windows 7
    • Normal
    • Repro attached, Workaround attached
    • Deviation from standard

    Description

      I have a strange issue that can be reproduced easily with the following objects in schema "test":

      create table a (a integer);
      insert into a (a) values(1);
      create view v as select * from a;

      This works:
      select test.a.a from test.a where test.a.a <> 2 order by test.a.a asc;

      This doesn't work:
      select test.v.a from test.v where test.v.a <> 2 order by test.v.a asc;

      But this does:
      select test.v.a from test.v where test.v.a <> 2 order by v.a asc;

      This is the error I get:
      Error: 'TEST.V' is not an exposed table name in the scope in which it appears.
      SQLState: 42X10
      ErrorCode: -1

      I've tried quite a few SELECT clauses, and I think the ORDER BY clause is the only one having this issue.

      Attachments

        1. derby-5005_10_5_diff.txt
          2 kB
          Katherine Marsden
        2. derby-5005b.stat
          0.5 kB
          Dag H. Wanvik
        3. derby-5005b.diff
          7 kB
          Dag H. Wanvik
        4. derby-5005.stat
          0.5 kB
          Dag H. Wanvik
        5. derby-5005.diff
          8 kB
          Dag H. Wanvik
        6. 5005.sql
          0.4 kB
          Richard N. Hillegas

        Activity

          People

            dagw Dag H. Wanvik
            lukas.eder Lukas Eder
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: