[jira] [Commented] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

2019-10-03 Thread Pressenna (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944146#comment-16944146 ] Pressenna commented on CALCITE-3186: thank you. > IN expressions in UPDATE statements throws

[jira] [Commented] (CALCITE-3219) Allow finer control over which expressions get expanded in SqlToRelConverter

2019-08-14 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907211#comment-16907211 ] Pressenna commented on CALCITE-3219: created https://github.com/apache/calcite/pull/1378 for the

[jira] [Resolved] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna resolved CALCITE-3230. Resolution: Invalid resolving as invalid > Explicit CASTs by user are not applied. >

[jira] [Commented] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16901342#comment-16901342 ] Pressenna commented on CALCITE-3230: [~danny0405], I apologise. It turned out that Calcites

[jira] [Commented] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16900702#comment-16900702 ] Pressenna commented on CALCITE-3230: I am guessing it is caused by CALCITE-2590 > Explicit CASTs

[jira] [Updated] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna updated CALCITE-3230: --- Environment: (was: For some reason casting is not working correctly with aggregate functions.

[jira] [Updated] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna updated CALCITE-3230: --- Description: For some reason casting is not working correctly with aggregate functions. for

[jira] [Created] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Pressenna (JIRA)
Pressenna created CALCITE-3230: -- Summary: Explicit CASTs by user are not applied. Key: CALCITE-3230 URL: https://issues.apache.org/jira/browse/CALCITE-3230 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

2019-07-31 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896833#comment-16896833 ] Pressenna edited comment on CALCITE-3186 at 7/31/19 7:08 AM: - It's more

[jira] [Comment Edited] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

2019-07-31 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896833#comment-16896833 ] Pressenna edited comment on CALCITE-3186 at 7/31/19 7:08 AM: - It's more

[jira] [Commented] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

2019-07-31 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896833#comment-16896833 ] Pressenna commented on CALCITE-3186: It's more then a refactoring. Before I would scan the entire

[jira] [Commented] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

2019-07-29 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16895756#comment-16895756 ] Pressenna commented on CALCITE-3186: [~danny0405], I created a PR with a test case and a fix for

[jira] [Created] (CALCITE-3219) allow finer control over which expressions get expanded in SqlToRelConverter

2019-07-29 Thread Pressenna (JIRA)
Pressenna created CALCITE-3219: -- Summary: allow finer control over which expressions get expanded in SqlToRelConverter Key: CALCITE-3219 URL: https://issues.apache.org/jira/browse/CALCITE-3219 Project:

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

2019-07-15 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16884999#comment-16884999 ] Pressenna commented on CALCITE-2978: [~hyuan], yes, you are right, sorry for reopening. > sorting

[jira] [Resolved] (CALCITE-2978) sorting not applied in subqueries

2019-07-15 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna resolved CALCITE-2978. Resolution: Invalid It works correctly when a LIMIT is applied (then the sorting is done

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

2019-07-15 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16884979#comment-16884979 ] Pressenna commented on CALCITE-2978: So I think I finally found a valid use case for this:  

[jira] [Reopened] (CALCITE-2978) sorting not applied in subqueries

2019-07-15 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna reopened CALCITE-2978: > sorting not applied in subqueries > - > > Key:

[jira] [Commented] (CALCITE-3186) IN expressions in UPDATE statements throwing Exceptions

2019-07-09 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881190#comment-16881190 ] Pressenna commented on CALCITE-3186: It is hitting a needToImplement issue in 

[jira] [Created] (CALCITE-3186) IN expressions in UPDATE statements throwing Exceptions

2019-07-09 Thread Pressenna (JIRA)
Pressenna created CALCITE-3186: -- Summary: IN expressions in UPDATE statements throwing Exceptions Key: CALCITE-3186 URL: https://issues.apache.org/jira/browse/CALCITE-3186 Project: Calcite

[jira] [Commented] (CALCITE-2427) Sub-queries not supported in DML statements

2019-07-09 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881124#comment-16881124 ] Pressenna commented on CALCITE-2427: [~julianhyde] I tried this out in 1.20.0 and it fails for

[jira] [Resolved] (CALCITE-2427) Sub-queries not supported in DML statements

2019-04-15 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna resolved CALCITE-2427. Resolution: Fixed PR merged, resolving > Sub-queries not supported in DML statements >

[jira] [Commented] (CALCITE-2427) Sub-queries not supported in DML statements

2019-04-09 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813516#comment-16813516 ] Pressenna commented on CALCITE-2427: [~julianhyde] I added PR

[jira] [Commented] (CALCITE-2427) Sub-queries not supported in DML statements

2019-04-09 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813497#comment-16813497 ] Pressenna commented on CALCITE-2427: Hi [~julianhyde] I've checkout the latest master and applied

[jira] [Updated] (CALCITE-2978) sorting not applied in subqueries

2019-04-03 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna updated CALCITE-2978: --- Description: {code:sql} CREATE TABLE test (id INT, val INT); INSERT INTO test VALUES (1,1); INSERT

[jira] [Created] (CALCITE-2978) sorting not applied in subqueries

2019-04-03 Thread Pressenna (JIRA)
Pressenna created CALCITE-2978: -- Summary: sorting not applied in subqueries Key: CALCITE-2978 URL: https://issues.apache.org/jira/browse/CALCITE-2978 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2427) Sub-queries not supported in DML statements

2018-08-09 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574569#comment-16574569 ] Pressenna commented on CALCITE-2427: [~julianhyde], we managed to get the sub-queries working. The

[jira] [Updated] (CALCITE-2427) Subqueries not supported in DML statements

2018-07-24 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna updated CALCITE-2427: --- Affects Version/s: 1.14.0 1.15.0 1.16.0 > Subqueries

[jira] [Updated] (CALCITE-2427) Subqueries not supported in DML statements

2018-07-24 Thread Pressenna (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna updated CALCITE-2427: --- Description: It appears that subqueries are not supported in DML statements. The yield in a NPE.

[jira] [Created] (CALCITE-2427) Subqueries not supported in DML statements

2018-07-24 Thread Pressenna (JIRA)
Pressenna created CALCITE-2427: -- Summary: Subqueries not supported in DML statements Key: CALCITE-2427 URL: https://issues.apache.org/jira/browse/CALCITE-2427 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2416) Assertion error when determining monotonicity

2018-07-16 Thread Pressenna (JIRA)
Pressenna created CALCITE-2416: -- Summary: Assertion error when determining monotonicity Key: CALCITE-2416 URL: https://issues.apache.org/jira/browse/CALCITE-2416 Project: Calcite Issue Type: