[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=17190047#comment-17190047 ] Pressenna commented on CALCITE-3504: Current internal solution: default to {{null}} component type

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

[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=16974902#comment-16974902 ] Pressenna commented on CALCITE-3504: here's a quick check in postgresql: {code:sql} postgres=#

[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=16974899#comment-16974899 ] Pressenna commented on CALCITE-3504: I would just argue as follows: {code::sql} SELECT ARRAY[null]

[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=16974899#comment-16974899 ] Pressenna edited comment on CALCITE-3504 at 11/15/19 7:54 AM: -- I would

[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=16974893#comment-16974893 ] Pressenna commented on CALCITE-3504: I tried casting an empty array construct, but it fails:

[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=16974212#comment-16974212 ] Pressenna commented on CALCITE-3504: We are mostly wondering how to update an array column to an

[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

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

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

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

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

[ 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

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

[ 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

[ 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

[ 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

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

[ 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

[ 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

[ 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

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

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

[ 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=16813516#comment-16813516 ] Pressenna commented on CALCITE-2427: [~julianhyde] I added PR

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

[ 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

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

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