[
https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5626:
-
Description:
If query has a sub-query in EXIXST function and full column names used in
[
https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5626:
-
Description:
If query has a sub-query with EXIXST and full column names used in
[
https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5626:
-
Affects Version/s: 1.34.0
(was: 1.30.0)
> Query with EXISTS
Roman Churganov created CALCITE-5626:
Summary: Query with EXISTS function gives Table ... not found error
Key: CALCITE-5626
URL: https://issues.apache.org/jira/browse/CALCITE-5626
Project: Calcite
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Summary: Query with aggregate function, DISTINCT and ORDER BY fails with
exception
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Summary: Query with aggregate function, DISTINCT and ORDER BY fails (was:
Query with
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17525213#comment-17525213
]
Roman Churganov edited comment on CALCITE-5100 at 4/20/22 7:00 PM:
---
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17525213#comment-17525213
]
Roman Churganov edited comment on CALCITE-5100 at 4/20/22 6:51 PM:
---
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17525213#comment-17525213
]
Roman Churganov commented on CALCITE-5100:
--
with a simpler query it makes sub-query without
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5100:
-
Description:
Execute query like:
{code:sql}
select C11, LISTAGG( distinct C12, ', '
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Description:
If query has some aggregate window function with a DISTINCT keyword and
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Description:
If query has some aggregate window function with a DISTINCT keyword and
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Description:
If query has some aggregate window function with a DISTINCT keyword and
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5100:
-
Affects Version/s: 1.30.0
(was: 1.29.0)
> Incorrect syntax
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Affects Version/s: 1.30.0
(was: 1.29.0)
> Query with
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Description:
Execute query like:
{code:sql}
SELECT C11, LISTAGG( DISTINCT C12)
[
https://issues.apache.org/jira/browse/CALCITE-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5101:
-
Description:
Execute query like:
{code:sql}
SELECT C11, LISTAGG( DISTINCT C12)
Roman Churganov created CALCITE-5101:
Summary: Query with LISTAGG, DISTINCT and ORDER BY
Key: CALCITE-5101
URL: https://issues.apache.org/jira/browse/CALCITE-5101
Project: Calcite
Issue
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5100:
-
Description:
Execute query like:
{code:sql}
select C11, LISTAGG( distinct C12, ', '
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5100:
-
Description:
Execute query like:
{code:sql}
select C11, LISTAGG( distinct C12, ', '
[
https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5100:
-
Description:
Execute query like:
{code:sql}
select C11, LISTAGG( distinct C12, ', '
Roman Churganov created CALCITE-5100:
Summary: Incorrect syntax in sub-query, unsupported LISTAGG
Key: CALCITE-5100
URL: https://issues.apache.org/jira/browse/CALCITE-5100
Project: Calcite
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506759#comment-17506759
]
Roman Churganov edited comment on CALCITE-5042 at 3/15/22, 11:06 AM:
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506759#comment-17506759
]
Roman Churganov commented on CALCITE-5042:
--
So it won't solve the same problem with outer
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506526#comment-17506526
]
Roman Churganov edited comment on CALCITE-5042 at 3/14/22, 9:14 PM:
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506526#comment-17506526
]
Roman Churganov edited comment on CALCITE-5042 at 3/14/22, 8:33 PM:
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17506526#comment-17506526
]
Roman Churganov commented on CALCITE-5042:
--
Actually we use Calcite between services, one
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{code:sql}
SELECT f.id FROM sch1.foo as f
JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{code:sql}
SELECT f.id FROM sch1.foo as f
JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{code:sql}
SELECT f.id FROM sch1.foo as f
JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{code:sql}
{{SELECT f.id FROM sch1.foo as f}}
{{
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{code}
{{SELECT f.id FROM sch1.foo as f}}
{{
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{{SELECT f.id FROM sch1.foo as f}}
{{ JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{{SELECT f.id FROM sch1.foo as f}}
{{ JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{{SELECT f.id FROM sch1.foo as f}}
{{ JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{{SELECT f.id FROM sch1.foo as f}}
{{ JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{}SELECT f.id FROM sch1.foo as f{}
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
SELECT f.id FROM sch1.foo as f
JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description:
Execute query like:
{{SELECT f.id FROM sch1.foo as f}}
{{ JOIN
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Affects Version/s: 1.29.0
> Incorrect syntax in sub-query
>
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Fix Version/s: (was: 1.30.0)
> Incorrect syntax in sub-query
>
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Component/s: core
> Incorrect syntax in sub-query
> -
>
>
[
https://issues.apache.org/jira/browse/CALCITE-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-5042:
-
Description: (was: When run during the build ({{./gradlew clean
build}}) the test
Roman Churganov created CALCITE-5042:
Summary: Incorrect syntax in sub-query
Key: CALCITE-5042
URL: https://issues.apache.org/jira/browse/CALCITE-5042
Project: Calcite
Issue Type: Bug
[
https://issues.apache.org/jira/browse/CALCITE-4158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17365927#comment-17365927
]
Roman Churganov commented on CALCITE-4158:
--
hi, [~nobigo]xiong , I am not working on this,
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 11:12 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 11:09 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 11:06 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 9:50 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 7:33 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov edited comment on CALCITE-4290 at 10/26/20, 7:32 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17220949#comment-17220949
]
Roman Churganov commented on CALCITE-4290:
--
Thanks for the resources. Using column width in
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17212027#comment-17212027
]
Roman Churganov edited comment on CALCITE-4290 at 10/11/20, 8:06 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17212027#comment-17212027
]
Roman Churganov commented on CALCITE-4290:
--
Have you got any basic description of concepts
[
https://issues.apache.org/jira/browse/CALCITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17210876#comment-17210876
]
Roman Churganov commented on CALCITE-4290:
--
This problem can be reproduced on pure Calcite
Roman Churganov created CALCITE-4290:
Summary: Not optimal subqueries due to a "*" in them
Key: CALCITE-4290
URL: https://issues.apache.org/jira/browse/CALCITE-4290
Project: Calcite
[
https://issues.apache.org/jira/browse/CALCITE-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov resolved CALCITE-4272.
--
Fix Version/s: 1.25.0
Resolution: Fixed
> Incorrect sub-query to JDBC driver
[
https://issues.apache.org/jira/browse/CALCITE-4272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-4272:
-
Description:
run a query like
{{select t.id, t.c11 from foo t join bar tt on
Roman Churganov created CALCITE-4272:
Summary: Incorrect sub-query to JDBC driver
Key: CALCITE-4272
URL: https://issues.apache.org/jira/browse/CALCITE-4272
Project: Calcite
Issue Type:
Roman Churganov created CALCITE-4158:
Summary: Printing a query with asterix
Key: CALCITE-4158
URL: https://issues.apache.org/jira/browse/CALCITE-4158
Project: Calcite
Issue Type: Bug
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17156088#comment-17156088
]
Roman Churganov edited comment on CALCITE-4108 at 7/11/20, 6:15 PM:
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov closed CALCITE-4108.
Resolution: Not A Bug
> ClassCastException: java.lang.Float cannot be cast to
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17156088#comment-17156088
]
Roman Churganov commented on CALCITE-4108:
--
obviously that the problem is on our side, we use
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17154369#comment-17154369
]
Roman Churganov commented on CALCITE-4108:
--
tp.o type doesn't matter for this case
>
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17154368#comment-17154368
]
Roman Churganov commented on CALCITE-4108:
--
Are you using a JDBC Data Source? must be JDBC
>
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17153360#comment-17153360
]
Roman Churganov edited comment on CALCITE-4108 at 7/8/20, 8:47 AM:
---
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17153360#comment-17153360
]
Roman Churganov edited comment on CALCITE-4108 at 7/8/20, 8:46 AM:
---
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17153360#comment-17153360
]
Roman Churganov commented on CALCITE-4108:
--
tp.n in Schema is FLOAT, the value returned from
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17152664#comment-17152664
]
Roman Churganov commented on CALCITE-4108:
--
no, then getting another error
Caused by:
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-4108:
-
Description:
running a query like :
{{select tp.o, MAX( tp.n )}}
{{ from tp join o
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-4108:
-
Description:
running a query like :
select tp.o, MAX( tp.n )
{{ {{ from tp
[
https://issues.apache.org/jira/browse/CALCITE-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-4108:
-
Description:
running a query like :
{{select tp.o, MAX( tp.n )}}
{{ from tp join o
Roman Churganov created CALCITE-4108:
Summary: ClassCastException: java.lang.Float cannot be cast to
java.lang.Double
Key: CALCITE-4108
URL: https://issues.apache.org/jira/browse/CALCITE-4108
73 matches
Mail list logo