[jira] [Comment Edited] (CALCITE-5633) Allow table functions to be inside select list

2023-11-17 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17787228#comment-17787228 ] Dmitry Sysolyatin edited comment on CALCITE-5633 at 11/17/23 2:24 PM:

[jira] [Commented] (CALCITE-5633) Allow table functions to be inside select list

2023-11-17 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17787228#comment-17787228 ] Dmitry Sysolyatin commented on CALCITE-5633: At least Postgres allows it: {code} CREATE

[jira] [Commented] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec should use equalsDeep for fieldTypes rather than reference comparison

2023-11-11 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17785221#comment-17785221 ] Dmitry Sysolyatin commented on CALCITE-6100: Fixed in

[jira] [Resolved] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec should use equalsDeep for fieldTypes rather than reference comparison

2023-11-11 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-6100. Fix Version/s: 1.37.0 Resolution: Fixed > The equalsDeep of

[jira] [Updated] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec should use equalsDeep for fieldTypes rather than reference comparison

2023-11-11 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6100: --- Summary: The equalsDeep of SqlRowTypeNameSpec should use equalsDeep for fieldTypes

[jira] [Commented] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec should return true if two SqlRowTypeNameSpecs are structurally equivalent

2023-11-10 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17784948#comment-17784948 ] Dmitry Sysolyatin commented on CALCITE-6100: [~julianhyde]  I've addressed the suggestions

[jira] [Updated] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec should return true if two SqlRowTypeNameSpecs are structurally equivalent

2023-11-10 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6100: --- Summary: The equalsDeep of SqlRowTypeNameSpec should return true if two

[jira] [Updated] (CALCITE-6101) SqlCollectionTypeNameSpec should preserve nullable property of element type

2023-11-09 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6101: --- Description: SqlCollectionTypeNameSpec uses SqlTypeNameSpec for the elementType

[jira] [Updated] (CALCITE-6101) SqlCollectionTypeNameSpec should preserve nullable property of element type

2023-11-09 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6101: --- Summary: SqlCollectionTypeNameSpec should preserve nullable property of element

[jira] [Updated] (CALCITE-6101) SqlCollectionTypeNameSpec should preserve nullability property of element type

2023-11-09 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6101: --- Summary: SqlCollectionTypeNameSpec should preserve nullability property of element

[jira] [Created] (CALCITE-6101) SqlCollectionTypeNameSpec should preserve the nullability property of the element type

2023-11-09 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-6101: -- Summary: SqlCollectionTypeNameSpec should preserve the nullability property of the element type Key: CALCITE-6101 URL:

[jira] [Assigned] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec returns wrong result

2023-11-09 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-6100: -- Assignee: Dmitry Sysolyatin > The equalsDeep of SqlRowTypeNameSpec returns

[jira] [Created] (CALCITE-6100) The equalsDeep of SqlRowTypeNameSpec returns wrong result

2023-11-09 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-6100: -- Summary: The equalsDeep of SqlRowTypeNameSpec returns wrong result Key: CALCITE-6100 URL: https://issues.apache.org/jira/browse/CALCITE-6100 Project:

[jira] [Updated] (CALCITE-6026) MongoDB: Column is not quoted in "order by" clause and throws JsonParseException

2023-09-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-6026: --- Affects Version/s: 1.35.0 > MongoDB: Column is not quoted in "order by" clause and

[jira] [Resolved] (CALCITE-6026) MongoDB: Column is not quoted in "order by" clause and throws JsonParseException

2023-09-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-6026. Fix Version/s: 1.36.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5779) Implicit column alias for single-column table function should work

2023-06-22 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5779. Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5779) Implicit column alias for single-column table function should work

2023-06-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733504#comment-17733504 ] Dmitry Sysolyatin commented on CALCITE-5779: I found a way how to do it. Pr is available -

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Description: Implicit column alias for single-column table function works only for

[jira] [Assigned] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5779: -- Assignee: Dmitry Sysolyatin > Implicit column alias for single-column table

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function should work

2023-06-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Summary: Implicit column alias for single-column table function should work (was:

[jira] [Commented] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin commented on CALCITE-5779: Easy fix to use AliasNamespace for table

[jira] [Comment Edited] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin edited comment on CALCITE-5779 at 6/14/23 10:59 AM:

[jira] [Comment Edited] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732486#comment-17732486 ] Dmitry Sysolyatin edited comment on CALCITE-5779 at 6/14/23 10:59 AM:

[jira] [Assigned] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5779: -- Assignee: (was: Dmitry Sysolyatin) > Implicit column alias for

[jira] [Assigned] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5779: -- Assignee: Dmitry Sysolyatin > Implicit column alias for single-column table

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Description: Implicit column alias for single-column table function works only for

[jira] [Updated] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5779: --- Description: Implicit column alias for single-column table function works only for

[jira] [Created] (CALCITE-5779) Implicit column alias for single-column table function does not work

2023-06-14 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5779: -- Summary: Implicit column alias for single-column table function does not work Key: CALCITE-5779 URL: https://issues.apache.org/jira/browse/CALCITE-5779

[jira] [Updated] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-05-29 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5612: --- Fix Version/s: 1.35.0 > Babel parser should support PostgreSQL's SET TRANSACTION

[jira] [Updated] (CALCITE-5029) Babel parser support identifier starting with number

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5029: --- Affects Version/s: 1.34.0 > Babel parser support identifier starting with number >

[jira] [Resolved] (CALCITE-5029) Babel parser support identifier starting with number

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5029. Fix Version/s: 1.35.0 Resolution: Fixed Fixed in 

[jira] [Resolved] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5668. Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Fix Version/s: 1.35.0 > When parsing SQL in PostgreSQL dialect, allow unquoted

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-22 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Description: According PostgreSQL documentation [1][2]: ??SQL identifiers and key

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-22 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Description: According PostgreSQL documentation [1][2]: ??SQL identifiers and key

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-22 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Summary: When parsing SQL in PostgreSQL dialect, allow unquoted table names to

[jira] [Resolved] (CALCITE-5677) SUBSTR signature incorrect for BigQuery

2023-05-08 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5677. Fix Version/s: 1.35.0 Resolution: Fixed > SUBSTR signature incorrect for

[jira] [Commented] (CALCITE-5677) SUBSTR signature incorrect for BigQuery

2023-05-08 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720778#comment-17720778 ] Dmitry Sysolyatin commented on CALCITE-5677: Fixed in

[jira] [Updated] (CALCITE-5677) SUBSTR signature incorrect for BigQuery

2023-05-08 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5677: --- Component/s: core > SUBSTR signature incorrect for BigQuery >

[jira] [Updated] (CALCITE-5677) SUBSTR signature incorrect for BigQuery

2023-05-08 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5677: --- Affects Version/s: 1.34.0 > SUBSTR signature incorrect for BigQuery >

[jira] [Comment Edited] (CALCITE-5677) Fix unparsing for BigQuery SUBSTR

2023-04-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17716984#comment-17716984 ] Dmitry Sysolyatin edited comment on CALCITE-5677 at 4/27/23 5:46 AM:

[jira] [Commented] (CALCITE-5677) Fix unparsing for BigQuery SUBSTR

2023-04-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17716984#comment-17716984 ] Dmitry Sysolyatin commented on CALCITE-5677: Is there any database that does not support

[jira] [Commented] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-04-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17716633#comment-17716633 ] Dmitry Sysolyatin commented on CALCITE-5612: [~julianhyde] I've created a PR for this task.

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign

2023-04-21 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Description: According PostgreSQL documentation [1]: ??SQL identifiers and key

[jira] [Created] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign

2023-04-21 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5668: -- Summary: When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign Key: CALCITE-5668 URL:

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17712826#comment-17712826 ] Dmitry Sysolyatin commented on CALCITE-5634: I don't have time to finish this PR at the

[jira] [Updated] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5634: --- Description: The LEAST and GREATEST functions have been implemented for BigQuery

[jira] [Updated] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5634: --- Description: The LEAST and GREATEST functions have been implemented for BigQuery

[jira] [Updated] (CALCITE-5634) Enable GREATEST, LEAST functions in Postgres library

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5634: --- Summary: Enable GREATEST, LEAST functions in Postgres library (was: Add LEAST,

[jira] [Updated] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5634: --- Summary: Enable GREATEST, LEAST functions in PostgreSQL library (was: Enable

[jira] [Commented] (CALCITE-5127) Support correlation variables in Project

2023-04-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17712824#comment-17712824 ] Dmitry Sysolyatin commented on CALCITE-5127: [~julianhyde] I have already logged it

[jira] [Resolved] (CALCITE-5619) Support PostgreSQL's TO_CHAR function

2023-04-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5619. Resolution: Fixed Thanks for PR, [~tnieradzik]. Fixed in

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-04-10 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710119#comment-17710119 ] Dmitry Sysolyatin commented on CALCITE-5403: [~julianhyde] Regarding: {code} Having a

[jira] [Commented] (CALCITE-5634) Add LEAST, GREATEST for PostgreSQL

2023-04-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17709294#comment-17709294 ] Dmitry Sysolyatin commented on CALCITE-5634: PR is available -

[jira] [Created] (CALCITE-5634) Add LEAST, GREATEST for PostgreSQL

2023-04-06 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5634: -- Summary: Add LEAST, GREATEST for PostgreSQL Key: CALCITE-5634 URL: https://issues.apache.org/jira/browse/CALCITE-5634 Project: Calcite Issue

[jira] [Updated] (CALCITE-5633) Allow table functions to be inside select list

2023-04-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5633: --- Component/s: core > Allow table functions to be inside select list >

[jira] [Assigned] (CALCITE-5634) Add LEAST, GREATEST for PostgreSQL

2023-04-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5634: -- Assignee: Dmitry Sysolyatin > Add LEAST, GREATEST for PostgreSQL >

[jira] [Created] (CALCITE-5633) Allow table functions to be inside select list

2023-04-06 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5633: -- Summary: Allow table functions to be inside select list Key: CALCITE-5633 URL: https://issues.apache.org/jira/browse/CALCITE-5633 Project: Calcite

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-04-02 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707696#comment-17707696 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 4/2/23 5:30 PM:

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-04-02 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707696#comment-17707696 ] Dmitry Sysolyatin commented on CALCITE-5590: My previous fix, which I implemented in

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:36 AM:

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:36 AM:

[jira] [Comment Edited] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707123#comment-17707123 ] Dmitry Sysolyatin edited comment on CALCITE-5590 at 3/31/23 5:29 AM:

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

2023-03-30 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707123#comment-17707123 ] Dmitry Sysolyatin commented on CALCITE-5590: [~libenchao] Yes, it is related to

[jira] [Assigned] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-03-27 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5612: -- Assignee: Dmitry Sysolyatin > Babel parser should support PostgreSQL's SET

[jira] [Created] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-03-27 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5612: -- Summary: Babel parser should support PostgreSQL's SET TRANSACTION command Key: CALCITE-5612 URL: https://issues.apache.org/jira/browse/CALCITE-5612

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-26 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705115#comment-17705115 ] Dmitry Sysolyatin commented on CALCITE-5403: [~julianhyde], I will try to improve the code.

[jira] [Resolved] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5160. Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17704583#comment-17704583 ] Dmitry Sysolyatin edited comment on CALCITE-5160 at 3/24/23 12:09 PM:

[jira] [Resolved] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-23 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5403. Fix Version/s: 1.35.0 Resolution: Fixed > Babel parser should parse

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-23 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703963#comment-17703963 ] Dmitry Sysolyatin commented on CALCITE-5403: Fixed in

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-07 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697403#comment-17697403 ] Dmitry Sysolyatin commented on CALCITE-5403: [~julianhyde] I have changed summary to "Babel

[jira] [Updated] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-07 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5403: --- Summary: Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK,

[jira] [Updated] (CALCITE-5403) PostgreSQL dialect should support SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5403: --- Affects Version/s: 1.34.0 > PostgreSQL dialect should support SET, RESET, BEGIN,

[jira] [Updated] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5160: --- Summary: ANY/SOME, ALL operators should support collection expressions (was:

[jira] [Commented] (CALCITE-5560) Add support for escape strings in the format of E'foo\n'.

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17696947#comment-17696947 ] Dmitry Sysolyatin commented on CALCITE-5560: [~aitozi] Please check

[jira] [Updated] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5160: --- Affects Version/s: 1.34.0 > ANY/SOME, ALL operators should support collection

[jira] [Updated] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5160: --- Description: At the moment ANY, SOME functions support subquery: {code:java}

[jira] [Updated] (CALCITE-5160) ANY/SOME, ALL operators should support collection expressions

2023-03-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5160: --- Summary: ANY/SOME, ALL operators should support collection expressions (was:

[jira] [Commented] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-18 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17690785#comment-17690785 ] Dmitry Sysolyatin commented on CALCITE-5532: [~julianhyde] I didn't manage to find an

[jira] [Commented] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17689825#comment-17689825 ] Dmitry Sysolyatin commented on CALCITE-5532: PR -

[jira] [Updated] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5532: --- Labels: pull-request-available (was: ) > CompositeOperandTypeChecker should check

[jira] [Assigned] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5532: -- Assignee: Dmitry Sysolyatin > CompositeOperandTypeChecker should check

[jira] [Updated] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-16 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5532: --- Summary: CompositeOperandTypeChecker should check operands without type coercion

[jira] [Created] (CALCITE-5532) CompositeOperandsTypeChecking should check operands without type coercion first

2023-02-16 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5532: -- Summary: CompositeOperandsTypeChecking should check operands without type coercion first Key: CALCITE-5532 URL: https://issues.apache.org/jira/browse/CALCITE-5532

[jira] [Updated] (CALCITE-5468) SqlToRelConverter throws if ORDER BY contains IN

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5468: --- Affects Version/s: 1.33.0 > SqlToRelConverter throws if ORDER BY contains IN >

[jira] [Resolved] (CALCITE-5468) SqlToRelConverter throws if ORDER BY contains IN

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5468. Fix Version/s: 1.34.0 Resolution: Fixed Thanks for review [~julianhyde]!

[jira] [Commented] (CALCITE-5400) EnumerableCalc should not generate Enumerable.current with a non-idempotent function inside

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17687984#comment-17687984 ] Dmitry Sysolyatin commented on CALCITE-5400: [~mamo] Hi! I have a lot of work at the

[jira] [Updated] (CALCITE-5515) Add keyspace parameter to CassandraSchema and CassandraTable

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5515: --- Fix Version/s: 1.34.0 > Add keyspace parameter to CassandraSchema and

[jira] [Resolved] (CALCITE-5515) Add keyspace parameter to CassandraSchema and CassandraTable

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5515. Resolution: Fixed > Add keyspace parameter to CassandraSchema and CassandraTable

[jira] [Commented] (CALCITE-5515) Add keyspace parameter to CassandraSchema and CassandraTable

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17687866#comment-17687866 ] Dmitry Sysolyatin commented on CALCITE-5515: Thanks for PR [~tnieradzik]. Fixed in

[jira] [Updated] (CALCITE-5515) Keyspace in CQL sessions cannot be optional

2023-02-13 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5515: --- Affects Version/s: 1.33.0 > Keyspace in CQL sessions cannot be optional >

[jira] [Comment Edited] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17677068#comment-17677068 ] Dmitry Sysolyatin edited comment on CALCITE-5209 at 1/15/23 5:30 PM:

[jira] [Updated] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5209: --- Fix Version/s: 1.33.0 > Proper sub-query handling if it is used inside select list

[jira] [Resolved] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5209. Resolution: Fixed > Proper sub-query handling if it is used inside select list

[jira] [Commented] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17677068#comment-17677068 ] Dmitry Sysolyatin commented on CALCITE-5209: Fixed via

[jira] [Updated] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5209: --- Description: SqlRelConverter.getSubQuery uses reference comparing in order to find

[jira] [Updated] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5209: --- Description: For these examples assume that: -

[jira] [Updated] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

2023-01-15 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5209: --- Summary: Proper sub-query handling if it is used inside select list and group by

[jira] [Updated] (CALCITE-5468) SqlToRelConverter throws if ORDER BY contains IN

2023-01-12 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5468: --- Summary: SqlToRelConverter throws if ORDER BY contains IN (was: SqlToRelConverter

  1   2   3   >