yanjing.wang created CALCITE-4740:
-------------------------------------
Summary: Converting rel to sql with big query dialect results
incorrect having clause
Key: CALCITE-4740
URL: https://issues.apache.org/jira/browse/CALCITE-4740
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.27.0
Environment: jdk8
macos
Reporter: yanjing.wang
I'm converting
{code:java}
String query = select
"product_id" , sum("shelf_width")
from "foodmart"."product"
where "product_id" > 0
group by "product_id" having sum("shelf_width") > 1{code}
with big query dialect, but results
{code:java}
SELECT product_id, SUM(shelf_width)
FROM foodmart.product
WHERE product_id > 0
GROUP BY product_id
HAVING `EXPR$1` > 1
{code}
Maybe we need replace having clause aliases when stripping trivial aliases.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
