[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809479#comment-16809479 ] Chunwei Lei commented on CALCITE-2965: -- Agree +1. I would like to take it, but it seems 

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809475#comment-16809475 ] Chunwei Lei commented on CALCITE-2846: -- [~stutigupta], sure. Please feel free to let me know if I

[jira] [Comment Edited] (CALCITE-2847) Optimize global LOOKAHEAD for SQL parsers

[ https://issues.apache.org/jira/browse/CALCITE-2847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809449#comment-16809449 ] Hongze Zhang edited comment on CALCITE-2847 at 4/4/19 3:30 AM: --- Thanks

[jira] [Commented] (CALCITE-2847) Optimize global LOOKAHEAD for SQL parsers

[ https://issues.apache.org/jira/browse/CALCITE-2847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809449#comment-16809449 ] Hongze Zhang commented on CALCITE-2847: --- Thanks for the review, [~julianhyde] and [~krisden]! But

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809384#comment-16809384 ] Julian Hyde commented on CALCITE-2965: -- Yes, I think a common operator table would make sense.

[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=16809380#comment-16809380 ] Julian Hyde commented on CALCITE-2427: -- [~psockali] Can you please provide a pull-request with

[jira] [Commented] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809378#comment-16809378 ] Julian Hyde commented on CALCITE-2967: -- [~jcamachorodriguez], Yes, that's what I was thinking of;

[jira] [Comment Edited] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809307#comment-16809307 ] Kevin Risden edited comment on CALCITE-2972 at 4/3/19 10:00 PM: For

[jira] [Commented] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809307#comment-16809307 ] Kevin Risden commented on CALCITE-2972: --- For those that are playing along at home. Both the

[jira] [Updated] (CALCITE-2974) Timestamp conversion performance can be improved

[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Valeriy Trofimov updated CALCITE-2974: -- Description: RexSimplify.simplifyCast() is slow when converting a string to SQL

[jira] [Commented] (CALCITE-1957) Cannot read HSQLDB CLOBs from avatica

[ https://issues.apache.org/jira/browse/CALCITE-1957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809278#comment-16809278 ] Josh Elser commented on CALCITE-1957: - [~kmmlearnings], the lack of an assignee on the issue

[jira] [Issue Comment Deleted] (CALCITE-2656) Timestamp Micro and Nano String literals are getting rounded to milliseconds

[ https://issues.apache.org/jira/browse/CALCITE-2656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wamsi Viswanath updated CALCITE-2656: - Comment: was deleted (was: No worries, my bad :)) > Timestamp Micro and Nano String

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

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2978. -- Resolution: Invalid Closing this issue, since this is an intended behavior. > sorting not

[jira] [Commented] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809082#comment-16809082 ] Jesus Camacho Rodriguez commented on CALCITE-2967: -- Same mechanism as for materialized

[jira] [Updated] (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 ] Haisheng Yuan updated CALCITE-2427: --- Labels: sub-query (was: ) > Sub-queries not supported in DML statements >

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809003#comment-16809003 ] Haisheng Yuan commented on CALCITE-2965: Can we have a Shared SqlOperatorTable that doesn't

[jira] [Updated] (CALCITE-2975) Add the JSON_REMOVE function

[ https://issues.apache.org/jira/browse/CALCITE-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2975: Labels: pull-request-available (was: ) > Add the JSON_REMOVE function >

[jira] [Commented] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808849#comment-16808849 ] Julian Hyde commented on CALCITE-2977: -- I agree that the validator should check for this and

[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=16808847#comment-16808847 ] Julian Hyde commented on CALCITE-2978: -- Yes, this is intended behavior. Note that if the

[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] [Commented] (CALCITE-1957) Cannot read HSQLDB CLOBs from avatica

[ https://issues.apache.org/jira/browse/CALCITE-1957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808727#comment-16808727 ] Mohan commented on CALCITE-1957: Hi Josh/ Team, I've started using Avatica and it surprised with an

[jira] [Updated] (CALCITE-2866) Allow passing factory of SqlValidator/SqlToRelConverter/CatalogReader into FrameworkConfig

[ https://issues.apache.org/jira/browse/CALCITE-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2866: -- Summary: Allow passing factory of SqlValidator/SqlToRelConverter/CatalogReader into

[jira] [Updated] (CALCITE-2866) Allow passing factory of SqlValidator / SqlToRelConverter / CatalogReader into FrameworkConfig

[ https://issues.apache.org/jira/browse/CALCITE-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2866: Labels: pull-request-available usability (was: usability) > Allow passing factory of

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

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2978: --- Assignee: Danny Chan > sorting not applied in subqueries >

[jira] [Comment Edited] (CALCITE-1581) UDTF like in hive

[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808689#comment-16808689 ] pengzhiwei edited comment on CALCITE-1581 at 4/3/19 12:56 PM: -- Hi

[jira] [Commented] (CALCITE-1581) UDTF like in hive

[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808689#comment-16808689 ] pengzhiwei commented on CALCITE-1581: - Hi [~julianhyde], I have done the syntax validation in

[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] [Comment Edited] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808664#comment-16808664 ] pengzhiwei edited comment on CALCITE-2977 at 4/3/19 12:17 PM: -- I think the

[jira] [Commented] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808664#comment-16808664 ] pengzhiwei commented on CALCITE-2977: - I think this problem exist in the 

[jira] [Created] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

pengzhiwei created CALCITE-2977: --- Summary: Exception is not thrown out when there are ambiguous field in select list Key: CALCITE-2977 URL: https://issues.apache.org/jira/browse/CALCITE-2977 Project:

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808539#comment-16808539 ] Stuti Gupta commented on CALCITE-2846: -- [~Chunwei Lei], I will take this change of creating a

[jira] [Commented] (CALCITE-2909) Optimize Enumerable SemiJoin with lazy computation of innerLookup

[ https://issues.apache.org/jira/browse/CALCITE-2909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808443#comment-16808443 ] Ruben Quesada Lopez commented on CALCITE-2909: -- [~sereda], thanks for taking care of the

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808418#comment-16808418 ] Chunwei Lei commented on CALCITE-1515: -- Oops, sorry for that. > Support TableFunctionScan in

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808413#comment-16808413 ] Chunwei Lei commented on CALCITE-2965: -- {quote}SOUNDEX is not in the SQL standard and it's not – I

[jira] [Commented] (CALCITE-2966) Problem with Code Generation

[ https://issues.apache.org/jira/browse/CALCITE-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808411#comment-16808411 ] Julian Feinauer commented on CALCITE-2966: -- Hi [~danny0405]... this is the last commit for the

[jira] [Resolved] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-1515. -- Resolution: Fixed Re-opened, and changed state to "fixed". We don't mark "closed" until the

[jira] [Reopened] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-1515: -- > Support TableFunctionScan in RelBuilder > --- > >

[jira] [Commented] (CALCITE-2920) RelBuilder: new method to create an antijoin

[ https://issues.apache.org/jira/browse/CALCITE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808408#comment-16808408 ] Julian Hyde commented on CALCITE-2920: -- Fixed in

[jira] [Resolved] (CALCITE-2920) RelBuilder: new method to create an antijoin

[ https://issues.apache.org/jira/browse/CALCITE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2920. -- Resolution: Fixed > RelBuilder: new method to create an antijoin >

[jira] [Updated] (CALCITE-2920) RelBuilder: new method to create an antijoin

[ https://issues.apache.org/jira/browse/CALCITE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2920: - Fix Version/s: 1.20.0 > RelBuilder: new method to create an antijoin >

[jira] [Commented] (CALCITE-2967) New rule to remove SemiJoin

[ https://issues.apache.org/jira/browse/CALCITE-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808407#comment-16808407 ] Julian Hyde commented on CALCITE-2967: -- It's problematic to represent a foreign-key constraint in

[jira] [Commented] (CALCITE-2974) Timestamp conversion performance can be improved

[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808397#comment-16808397 ] Julian Hyde commented on CALCITE-2974: -- We use compiled code because it was the simplest way to

[jira] [Updated] (CALCITE-2974) Timestamp conversion performance can be improved

[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2974: - Labels: easyfix performance (was: easyfix performance ready-to-commit) > Timestamp conversion

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808395#comment-16808395 ] Julian Hyde commented on CALCITE-2965: -- SOUNDEX is not in the SQL standard and it's not – I hope