[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw exception in elasticsearch adapter

2020-07-20 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Description: For sql like {code:java} select id, count(id) from test group by id order by count(id) {code}

[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw exception in elasticsearch adapter

2020-07-20 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Summary: Aggregation function in order by clause will throw exception in elasticsearch adapter (was: Aggrega

[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw exception

2020-07-20 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Summary: Aggregation function in order by clause will throw exception (was: Aggregation function in order b

[jira] [Commented] (CALCITE-4130) Aggregation function in order by clause will throw exception

2020-07-19 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17160925#comment-17160925 ] yuqi commented on CALCITE-4130: --- Name of count(*), sqlline cant' resolve the column name

[jira] [Comment Edited] (CALCITE-4130) Aggregation function in order by clause will throw exception

2020-07-19 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17160867#comment-17160867 ] yuqi edited comment on CALCITE-4130 at 7/20/20, 3:37 AM: - Seems

[jira] [Commented] (CALCITE-4130) Aggregation function in order by clause will throw exception

2020-07-19 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17160867#comment-17160867 ] yuqi commented on CALCITE-4130: --- Seems unlikely the problem of rel to sql conversion. Aft

[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw exception

2020-07-19 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Description: For sql like {code:java} select id, count(id) from test group by id order by count(id) {code}

[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw E

2020-07-18 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Description: For sql like `select id, count(id) from test group by id order by count(id)` When execute que

[jira] [Updated] (CALCITE-4130) Aggregation function in order by clause will throw E

2020-07-18 Thread yuqi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-4130: -- Environment: (was: Add test as below in AggregationTest CalciteAssert.that() .with(newConnectionFa

[jira] [Created] (CALCITE-4130) Aggregation function in order by clause will throw E

2020-07-18 Thread yuqi (Jira)
yuqi created CALCITE-4130: - Summary: Aggregation function in order by clause will throw E Key: CALCITE-4130 URL: https://issues.apache.org/jira/browse/CALCITE-4130 Project: Calcite Issue Type: Bug

[jira] [Issue Comment Deleted] (CALCITE-3186) IN expressions in UPDATE statements throwing Exceptions

2019-07-10 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-3186: -- Comment: was deleted (was: [~danny0405] Confirm, see below ``` @Test public void test() throws Exception {

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

2019-07-09 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881223#comment-16881223 ] yuqi edited comment on CALCITE-3186 at 7/9/19 1:33 PM: --- [~danny04

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

2019-07-09 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881223#comment-16881223 ] yuqi commented on CALCITE-3186: --- [~danny0405] Confirm, see below ```java @Test public

[jira] [Commented] (CALCITE-3100) cast(? as DATE) won't work with PreparedStatement

2019-07-05 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16879198#comment-16879198 ] yuqi commented on CALCITE-3100: --- By the way, can anyone give me contribution permission ?

[jira] [Closed] (CALCITE-2879) Improve filter condition in Join

2019-07-05 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi closed CALCITE-2879. - Resolution: Not A Problem > Improve filter condition in Join > > >

[jira] [Commented] (CALCITE-2879) Improve filter condition in Join

2019-07-05 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16879195#comment-16879195 ] yuqi commented on CALCITE-2879: --- (y), Indeed, this is a duplication of rule JoinPushTrans

[jira] [Commented] (CALCITE-3100) cast(? as DATE) won't work with PreparedStatement

2019-07-05 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16879124#comment-16879124 ] yuqi commented on CALCITE-3100: --- [~danny0405] , I have just make a PR on this issue, can

[jira] [Comment Edited] (CALCITE-3030) merge sql problem

2019-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827983#comment-16827983 ] yuqi edited comment on CALCITE-3030 at 4/28/19 12:50 PM: - [~wzq

[jira] [Updated] (CALCITE-3030) merge sql problem

2019-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-3030: -- Attachment: wx20190428-204...@2x.png > merge sql problem > - > > Key: CALCITE

[jira] [Commented] (CALCITE-3030) merge sql problem

2019-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827983#comment-16827983 ] yuqi commented on CALCITE-3030: --- [~wzqiang1332], There seems a bug in calcite !wx2019042

[jira] [Comment Edited] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817844#comment-16817844 ] yuqi edited comment on CALCITE-2999 at 4/15/19 10:23 AM: - [~zhz

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817844#comment-16817844 ] yuqi commented on CALCITE-2999: --- [~zhztheplayer] amzaing, RelRoot output Type is correct

[jira] [Updated] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Attachment: picture4.png > Can't get the right column value in LogicalSort >

[jira] [Comment Edited] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817677#comment-16817677 ] yuqi edited comment on CALCITE-2999 at 4/15/19 9:18 AM: [~danny

[jira] [Updated] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Attachment: picture2.png > Can't get the right column value in LogicalSort >

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817677#comment-16817677 ] yuqi commented on CALCITE-2999: --- [~zhztheplayer], I do agree with you on this point, ther

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817675#comment-16817675 ] yuqi commented on CALCITE-2999: --- [~zhztheplayer] Thanks for your attention, see the pictu

[jira] [Issue Comment Deleted] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Comment: was deleted (was: [~zhztheplayer] Thanks for you attention My problems are in the picture below !p

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817673#comment-16817673 ] yuqi commented on CALCITE-2999: --- [~zhztheplayer] Thanks for you attention My problems ar

[jira] [Updated] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Attachment: problem.png > Can't get the right column value in LogicalSort > -

[jira] [Updated] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Description: Let's consider the sql: {code:sql} // Some comments here select 'hello', tag from b where text

[jira] [Updated] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2999: -- Attachment: problem.png > Can't get the right column value in LogicalSort > -

[jira] [Created] (CALCITE-2999) Can't get the right column value in LogicalSort

2019-04-15 Thread yuqi (JIRA)
yuqi created CALCITE-2999: - Summary: Can't get the right column value in LogicalSort Key: CALCITE-2999 URL: https://issues.apache.org/jira/browse/CALCITE-2999 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2861) Exception occurs when do arithmetic between decimal and other numeric types

2019-03-27 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16802716#comment-16802716 ] yuqi commented on CALCITE-2861: --- [~zhztheplayer] Thanks for your carefully review, When I

[jira] [Updated] (CALCITE-2861) Exception occurs when do arithmetic between decimal and other numeric types

2019-03-27 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2861: -- Summary: Exception occurs when do arithmetic between decimal and other numeric types (was: Exception occurs

[jira] [Created] (CALCITE-2879) Improve filter condition in Join

2019-02-27 Thread yuqi (JIRA)
yuqi created CALCITE-2879: - Summary: Improve filter condition in Join Key: CALCITE-2879 URL: https://issues.apache.org/jira/browse/CALCITE-2879 Project: Calcite Issue Type: Improvement Re

[jira] [Updated] (CALCITE-2861) Exception occurs when do +-*/ between decimal and other numeric types

2019-02-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2861: -- Description: 1. add decimal type in ReflectiveSchemaTest#EveryType {code:java} public static class Ever

[jira] [Updated] (CALCITE-2861) Exception occurs when do +-*/ between decimal and other numeric types

2019-02-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2861: -- Description: 1. add decimal type in ReflectiveSchemaTest#EveryType {code:java} public static class Ever

[jira] [Updated] (CALCITE-2861) Exception occurs when do +-*/ between decimal and other numeric types

2019-02-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2861: -- Description: 1. add decimal type in ReflectiveSchemaTest.EveryType {code:java} public static class Eve

[jira] [Created] (CALCITE-2861) Exception occurs when do +-*/ between decimal and other numeric types

2019-02-22 Thread yuqi (JIRA)
yuqi created CALCITE-2861: - Summary: Exception occurs when do +-*/ between decimal and other numeric types Key: CALCITE-2861 URL: https://issues.apache.org/jira/browse/CALCITE-2861 Project: Calcite

[jira] [Commented] (CALCITE-2841) Simplification: push negation into Case expression

2019-02-12 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16765989#comment-16765989 ] yuqi commented on CALCITE-2841: --- Is there any detail about this issue ? > Simplification

[jira] [Commented] (CALCITE-2749) org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 13. Encountered: "`" (96), after : ""

2018-12-20 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16725709#comment-16725709 ] yuqi commented on CALCITE-2749: --- Set parser config lex as 'Lex.MYSQL' words if use back

[jira] [Commented] (CALCITE-2637) Prefix minus operator failed in between and clause

2018-12-01 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706060#comment-16706060 ] yuqi commented on CALCITE-2637: --- Fixed > Prefix minus operator failed in between and cla

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-09 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681553#comment-16681553 ] yuqi commented on CALCITE-2659: --- [~julianhyde], i could not understand your answer 'The p

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: The following is the code: {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Description: public static void main(String[] args) { try { SchemaPlu

[jira] [Created] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
yuqi created CALCITE-2659: - Summary: Wrong plan In natural left/right join Key: CALCITE-2659 URL: https://issues.apache.org/jira/browse/CALCITE-2659 Project: Calcite Issue Type: Bug Compon

[jira] [Updated] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2659: -- Environment: (was: {code:java} public static void main(String[] args) { try {

[jira] [Commented] (CALCITE-2637) Prefix minus operator failed in between and clause

2018-10-23 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16660696#comment-16660696 ] yuqi commented on CALCITE-2637: --- [~julianhyde], Can you help to confirm this problem? Tha

[jira] [Updated] (CALCITE-2637) Prefix minus operator failed in between and clause

2018-10-23 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2637: -- Environment: (was: We can reproduce it like this {code:java} public static void main(String[] args) {

[jira] [Updated] (CALCITE-2637) Prefix minus operator failed in between and clause

2018-10-23 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2637: -- Description: We can reproduce it like this {code:java} public static void main(String[] args) {

[jira] [Created] (CALCITE-2637) Prefix minus operator failed in between and clause

2018-10-23 Thread yuqi (JIRA)
yuqi created CALCITE-2637: - Summary: Prefix minus operator failed in between and clause Key: CALCITE-2637 URL: https://issues.apache.org/jira/browse/CALCITE-2637 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-06 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16503048#comment-16503048 ] yuqi commented on CALCITE-2349: --- [~julianhyde] As the JavaDoc says: A special operator f

[jira] [Commented] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-02 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498965#comment-16498965 ] yuqi commented on CALCITE-2349: --- [~julianhyde] I'am a little confused, DateTime is not a

[jira] [Updated] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-02 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2349: -- Attachment: screenshot-1.png > Failed to build RexCall with SqlDatetimeSubtractionOperator >

[jira] [Updated] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-01 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2349: -- Attachment: 1.png > Failed to build RexCall with SqlDatetimeSubtractionOperator > ---

[jira] [Commented] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-01 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498864#comment-16498864 ] yuqi commented on CALCITE-2349: --- [~julianhyde] I debug it and the number of operands of t

[jira] [Created] (CALCITE-2349) Failed to build RexCall with SqlDatetimeSubtractionOperator

2018-06-01 Thread yuqi (JIRA)
yuqi created CALCITE-2349: - Summary: Failed to build RexCall with SqlDatetimeSubtractionOperator Key: CALCITE-2349 URL: https://issues.apache.org/jira/browse/CALCITE-2349 Project: Calcite Issue Type

[jira] [Commented] (CALCITE-2336) SqlValidatorImpl throws java.lang.IndexOutOfBoundsException

2018-05-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16497488#comment-16497488 ] yuqi commented on CALCITE-2336: --- [~xu fei] You can make a MR about this problem or i do i

[jira] [Comment Edited] (CALCITE-2336) SqlValidatorImpl throws java.lang.IndexOutOfBoundsException

2018-05-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16496548#comment-16496548 ] yuqi edited comment on CALCITE-2336 at 5/31/18 1:43 PM: [~xu fe

[jira] [Commented] (CALCITE-2336) SqlValidatorImpl throws java.lang.IndexOutOfBoundsException

2018-05-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16496548#comment-16496548 ] yuqi commented on CALCITE-2336: --- [~xu fei] I suggest you check column size in function `v

[jira] [Updated] (CALCITE-2336) SqlValidatorImpl throws java.lang.IndexOutOfBoundsException

2018-05-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2336: -- Attachment: 1.patch > SqlValidatorImpl throws java.lang.IndexOutOfBoundsException > -

[jira] [Updated] (CALCITE-2328) Operand of Logical And/OR should support type like INT, DOUTLE not only Boolean

2018-05-25 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2328: -- Summary: Operand of Logical And/OR should support type like INT, DOUTLE not only Boolean (was: Operand of Log

[jira] [Created] (CALCITE-2328) Operand of Logical And/OR should support type like INT, DOUTLE not only boolean

2018-05-25 Thread yuqi (JIRA)
yuqi created CALCITE-2328: - Summary: Operand of Logical And/OR should support type like INT, DOUTLE not only boolean Key: CALCITE-2328 URL: https://issues.apache.org/jira/browse/CALCITE-2328 Project: Calcite

[jira] [Updated] (CALCITE-2328) Operand of Logical And/OR should support type like INT, DOUTLE not only boolean

2018-05-25 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2328: -- Description: As far as i see , MySQL support the following sql {code:java} select id, name from tb where 1 an

[jira] [Commented] (CALCITE-2311) case when returns redundant white space

2018-05-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16476707#comment-16476707 ] yuqi commented on CALCITE-2311: --- It's depends on the type of the column that the value wil

[jira] [Comment Edited] (CALCITE-2273) misinterpreted

2018-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16457488#comment-16457488 ] yuqi edited comment on CALCITE-2273 at 4/28/18 9:31 AM: As far a

[jira] [Comment Edited] (CALCITE-2273) misinterpreted

2018-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16457488#comment-16457488 ] yuqi edited comment on CALCITE-2273 at 4/28/18 9:29 AM: As far a

[jira] [Commented] (CALCITE-2273) misinterpreted

2018-04-28 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16457488#comment-16457488 ] yuqi commented on CALCITE-2273: --- As far as i see, unicode that have length more than 4 wil

[jira] [Commented] (CALCITE-1882) Can't obtain the user defined aggregate function such as sum,avg by calcite

2018-04-19 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16445123#comment-16445123 ] yuqi commented on CALCITE-1882: --- Ok, [~vladimirsitnikov] , If you have time, please help t

[jira] [Commented] (CALCITE-1882) Can't obtain the user defined aggregate function such as sum,avg by calcite

2018-04-19 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16444071#comment-16444071 ] yuqi commented on CALCITE-1882: --- [~julianhyde] Code have updated, Could you help to revie

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-04-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16429601#comment-16429601 ] yuqi commented on CALCITE-2053: --- [~julianhyde], Could you take time to this issue and look

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-03-11 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16394854#comment-16394854 ] yuqi commented on CALCITE-2053: --- [~julianhyde] Is this change look OK? > Overloaded user-

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-02-07 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16356590#comment-16356590 ] yuqi commented on CALCITE-2053: --- Thanks for your time. > Overloaded user-defined function

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-02-04 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16351794#comment-16351794 ] yuqi commented on CALCITE-2053: --- En, FLOAT should take into consideration if we want to so

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-02-03 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Affects Version/s: (was: 1.13.0) > Overloaded user-defined functions that have Double and BigDecimal argum

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-02-02 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16350178#comment-16350178 ] yuqi commented on CALCITE-2053: --- Ok, I  change  {code:java} .put(SqlTypeName.DOUBLE, numer

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-02-01 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Affects Version/s: 1.15.0 > Overloaded user-defined functions that have Double and BigDecimal arguments > wil

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16348015#comment-16348015 ] yuqi commented on CALCITE-2053: --- [~julianhyde] , I confirm this,  here is my MR [https://

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Description: We add the following udf method in Smalls.AllTypesFunction {code:java} public double toDouble(

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Description: We add the following udf method in Smalls.AllTypesFunction {code:java} public double toDouble(

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Description: We add the following udf method in Smalls.AllTypesFunction {code:java} public double toDouble(

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Description: We add the following udf method in Smalls.AllTypesFunction {code:java} public double toDouble

[jira] [Updated] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2018-01-31 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yuqi updated CALCITE-2053: -- Description: We add the following udf method in Smalls.AllTypesFunction {code:java} public double toDouble(

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

2017-11-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16263683#comment-16263683 ] yuqi commented on CALCITE-1903: --- I see, thanks a lot > Support charset in LIKE expression

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

2017-11-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16263653#comment-16263653 ] yuqi commented on CALCITE-1903: --- Ok, That closely depends on flink SQL, seems that for cal

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

2017-11-22 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16262141#comment-16262141 ] yuqi commented on CALCITE-1903: --- [~jark], is there is any solution about using chinese cha

[jira] [Commented] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-19 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16258753#comment-16258753 ] yuqi commented on CALCITE-2053: --- yes, similar to CALCITE-1881, but it does exist and has n

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:30 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:29 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:28 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:27 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:26 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:25 AM: - The pr

[jira] [Comment Edited] (CALCITE-2053) Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong

2017-11-15 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16253170#comment-16253170 ] yuqi edited comment on CALCITE-2053 at 11/15/17 9:24 AM: - The pr

  1   2   >