[jira] [Commented] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190047#comment-17190047 ] Pressenna commented on CALCITE-3504: Current internal solution: default to {{null}}

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

[ https://issues.apache.org/jira/browse/CALCITE-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna closed CALCITE-3219. -- Resolution: Abandoned closing for now as not relevant ... > Allow finer control over which expressi

[jira] [Closed] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna closed CALCITE-3504. -- Resolution: Won't Do internally resolved ... > allow empty ARRAY[] literals > -

[jira] [Commented] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974902#comment-16974902 ] Pressenna commented on CALCITE-3504: here's a quick check in postgresql: {code:sql

[jira] [Commented] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974899#comment-16974899 ] Pressenna commented on CALCITE-3504: I would just argue as follows: {code::sql} SE

[jira] [Comment Edited] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974899#comment-16974899 ] Pressenna edited comment on CALCITE-3504 at 11/15/19 7:54 AM: ---

[jira] [Commented] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974893#comment-16974893 ] Pressenna commented on CALCITE-3504: I tried casting an empty array construct, but

[jira] [Commented] (CALCITE-3504) allow empty ARRAY[] literals

[ https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974212#comment-16974212 ] Pressenna commented on CALCITE-3504: We are mostly wondering how to update an array

[jira] [Created] (CALCITE-3504) allow empty ARRAY[] literals

Pressenna created CALCITE-3504: -- Summary: allow empty ARRAY[] literals Key: CALCITE-3504 URL: https://issues.apache.org/jira/browse/CALCITE-3504 Project: Calcite Issue Type: Wish Affects Ver

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944146#comment-16944146 ] Pressenna commented on CALCITE-3186: thank you. > IN expressions in UPDATE stateme

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

[ https://issues.apache.org/jira/browse/CALCITE-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907211#comment-16907211 ] Pressenna commented on CALCITE-3219: created https://github.com/apache/calcite/pull

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

[ 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.

[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901342#comment-16901342 ] Pressenna commented on CALCITE-3230: [~danny0405], I apologise. It turned out that

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

[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16900702#comment-16900702 ] Pressenna commented on CALCITE-3230: I am guessing it is caused by CALCITE-2590 >

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

[ 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.

[ 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 exampl

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

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16896833#comment-16896833 ] Pressenna edited comment on CALCITE-3186 at 7/31/19 7:08 AM:

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16896833#comment-16896833 ] Pressenna edited comment on CALCITE-3186 at 7/31/19 7:08 AM:

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16896833#comment-16896833 ] Pressenna commented on CALCITE-3186: It's more then a refactoring. Before I would

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16895756#comment-16895756 ] Pressenna commented on CALCITE-3186: [~danny0405], I created a PR with a test case

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

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: C

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

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884999#comment-16884999 ] Pressenna commented on CALCITE-2978: [~hyuan], yes, you are right, sorry for reopen

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

[ 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 correctl

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

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884979#comment-16884979 ] Pressenna commented on CALCITE-2978: So I think I finally found a valid use case fo

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

[ 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: CALC

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

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881190#comment-16881190 ] Pressenna commented on CALCITE-3186: It is hitting a needToImplement issue in  {{or

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

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 Issue

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

[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881124#comment-16881124 ] Pressenna commented on CALCITE-2427: [~julianhyde] I tried this out in 1.20.0 and i

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

[ 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

[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16813516#comment-16813516 ] Pressenna commented on CALCITE-2427: [~julianhyde] I added PR https://github.com/ap

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

[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16813497#comment-16813497 ] Pressenna commented on CALCITE-2427: Hi [~julianhyde] I've checkout the latest mas

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

[ 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

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 Affects

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

[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16574569#comment-16574569 ] Pressenna commented on CALCITE-2427: [~julianhyde], we managed to get the sub-queri

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

[ 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. R

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

[ 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] [Created] (CALCITE-2427) Subqueries not supported in DML statements

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

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: Bug