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

use of direct column name rather than alias make aggregation fail (Hibernate depends on that)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.1.0, 10.1.3.1
    • 10.3.1.4
    • SQL
    • None

    Description

      Error: org.apache.derby.client.am.SqlException: Column 'MODEL0_.COL_0_0_' 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 'MODEL0_.COL_0_0_' is not a column in the target table., SQL State: 42X04, Error Code: -1

      for

      select
      model0_.balance as col_0_0_,
      count as col_1_0_
      from
      account model0_
      group by
      model0_.balance
      having
      count > 1

      Attachments

        1. 1624_repro.sql
          2 kB
          Samuel Andrew McIntyre

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-681 Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3094 Grouping of expressions causes NullPointerException

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-681 Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2457 Use of column aliases in group by / having clauses can cause queries to fail

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              mkhettry Manish Khettry
              epbernard Emmanuel Bernard
              Votes:
              3 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: