[
https://issues.apache.org/jira/browse/DERBY-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden updated DERBY-3257:
----------------------------------
Attachment: derby-3257_stat.txt
derby-3257_diff.txt
Attached is a patch to fix this issue. derby-3257_diff.txt. It has Army's
changes plus code to mark the subqueries that are in the having clause as such
so that we can avoid flattenning during preprocess. We clearly are not setup
to handle subquery flattenning within the having clause and just happenned to
avoid it before because the having clause was not normalized. Adding the
normalization meant we needed another mechanism to flag these subqueries to
avoid flattenning. Perhaps a better long term strategy would be to allow for
flattenning of subqueries in the having clause, but I am guessing that is a
fairly significant endeavor.
> SELECT with HAVING clause containing OR conditional incorrectly return 1 row
> - should return 2 rows - works correctly with 10.2 DB
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3257
> URL: https://issues.apache.org/jira/browse/DERBY-3257
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4, 10.3.2.1, 10.4.0.0
> Reporter: Stan Bradbury
> Assignee: Kathey Marsden
> Attachments: 42X24_error.sql, d3257_doNOTCommit.patch,
> derby-3257_diff.txt, derby-3257_plan_10.2.txt, derby-3257_plan_10.4.txt,
> derby-3257_stat.txt, TestHaving.java
>
>
> Attached program demonstrates the problem. Only one count is returned
> (matching CODE= GBR) - the count of CODE=CHA is not returned. Works fine
> with versions 10.1 and 10.2 or if program is run using 10.3 jars and 10.2
> database (soft upgrade).
> Query:
> SELECT COUNT(t0.ID) FROM CTS1.TEST_TABLE t0
> GROUP BY t0.CODE
> HAVING (t0.CODE = 'GBR' OR t0.CODE = 'CHA') AND t0.CODE IS NOT NULL
> Incorrect results (see last line):
> Database product: Apache Derby
> Database version: 10.3.1.5 - (579866)
> Driver name: Apache Derby Embedded JDBC Driver
> Driver version: 10.3.1.5 - (579866)
> result: 2
> Correct results:
> Database product: Apache Derby
> Database version: 10.2.2.0 - (485682)
> Driver name: Apache Derby Embedded JDBC Driver
> Driver version: 10.2.2.0 - (485682)
> result: 4
> result: 2
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
