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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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-5005b.stat
          0.5 kB
          Dag H. Wanvik
        2. derby-5005b.diff
          7 kB
          Dag H. Wanvik
        3. derby-5005.stat
          0.5 kB
          Dag H. Wanvik
        4. derby-5005.diff
          8 kB
          Dag H. Wanvik
        5. derby-5005_10_5_diff.txt
          2 kB
          Katherine Marsden
        6. 5005.sql
          0.4 kB
          Richard N. Hillegas

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment