[jira] [Resolved] (CALCITE-5906) JDBC adapter should generate TABLESAMPLE

[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5906. - Resolution: Fixed > JDBC adapter should generate TABLESAMPLE >

[jira] [Commented] (CALCITE-5906) JDBC adapter should generate TABLESAMPLE

[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754828#comment-17754828 ] Jiajun Xie commented on CALCITE-5906: - Fixed via

[jira] [Commented] (CALCITE-5873) Add REGEXP_CONTAINS function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754753#comment-17754753 ] Julian Hyde commented on CALCITE-5873: -- The decision is made. We use Java regex (not re2) for now.

[jira] [Commented] (CALCITE-5910) Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754752#comment-17754752 ] Julian Hyde commented on CALCITE-5910: -- No one has complained in five days, so we have a decision:

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754670#comment-17754670 ] Julian Hyde commented on CALCITE-5743: -- [~leepb], Ok, I agree, that’s a different issue, because

[jira] [Commented] (CALCITE-5921) SqlOperatorFixture.checkFails and checkAggFails don't check runtime failure

[ https://issues.apache.org/jira/browse/CALCITE-5921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754666#comment-17754666 ] Runkang He commented on CALCITE-5921: - [~julianhyde] Thanks for linking the related issue. I have

[jira] [Comment Edited] (CALCITE-5921) SqlOperatorFixture.checkFails and checkAggFails don't check runtime failure

[ https://issues.apache.org/jira/browse/CALCITE-5921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754666#comment-17754666 ] Runkang He edited comment on CALCITE-5921 at 8/15/23 2:52 PM: --

[jira] [Updated] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5930: -- Description: Wrong calculation result {code:java} select * from dept where deptno in ( select

[jira] [Comment Edited] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754661#comment-17754661 ] libopeng edited comment on CALCITE-5930 at 8/15/23 2:33 PM: [~shenlang] I

[jira] [Commented] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754661#comment-17754661 ] libopeng commented on CALCITE-5930: --- [~leepb] I have refined some information which I hope will be

[jira] [Updated] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5930: -- Description: Wrong calculation result {code:java} select * from dept where deptno in ( select

[jira] [Updated] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5930: -- Description: Wrong calculation result {code:java} select * from dept where deptno in ( select

[jira] [Commented] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754657#comment-17754657 ] LakeShen commented on CALCITE-5930: --- Hi [~leepb] ,could you make the description more clearly,like

[jira] [Updated] (CALCITE-5930) When data types do not match, calcite may make a calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5930: -- Description: {code:java} select * from dept where deptno in ( select count(*) from emp where

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754647#comment-17754647 ] libopeng commented on CALCITE-5743: --- Look at this issue [CALCITE-5930] > Query gives incorrect

[jira] [Created] (CALCITE-5930) When data types do not match, calcite may make a calculation error

libopeng created CALCITE-5930: - Summary: When data types do not match, calcite may make a calculation error Key: CALCITE-5930 URL: https://issues.apache.org/jira/browse/CALCITE-5930 Project: Calcite

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754530#comment-17754530 ] libopeng commented on CALCITE-5743: --- [~julianhyde] I think your case is caused by other bugs, and

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754512#comment-17754512 ] LakeShen commented on CALCITE-5743: --- Hi [~julianhyde] ,thanks for your reply,and I will debug with

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754442#comment-17754442 ] LakeShen commented on CALCITE-5889: --- The PR is

[jira] [Updated] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5922: Summary: The SQL generated for the POSITION function(with 3 input arguments) by the

[jira] [Comment Edited] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL.

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754436#comment-17754436 ] hongyu guo edited comment on CALCITE-5922 at 8/15/23 6:30 AM: -- Hi, Julian.

[jira] [Commented] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL.

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754436#comment-17754436 ] hongyu guo commented on CALCITE-5922: - Hi Julian~ Thank you for you replay, I change the summary

[jira] [Assigned] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL.

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo reassigned CALCITE-5922: --- Assignee: hongyu guo > The SQL generated for the POSITION function(with 3 input

[jira] [Updated] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL.

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5922: Summary: The SQL generated for the POSITION function(with 3 input arguments) by the

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5889: Labels: pull-request-available (was: ) > Add the RelRule that converts Minus into UNION