[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759402#comment-17759402 ] Julian Hyde commented on CALCITE-4777: -- I am marking this case a duplicate of CALC

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428012#comment-17428012 ] Julian Hyde commented on CALCITE-4777: -- My vote is for what you describe: forbid c

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428009#comment-17428009 ] xuyangzhong commented on CALCITE-4777: -- So, I want to know that whether we have re

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17426091#comment-17426091 ] xuyangzhong commented on CALCITE-4777: -- The sql standard 2011 forbids casting all

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17425986#comment-17425986 ] Julian Hyde commented on CALCITE-4777: -- I don't think we should cast integer to bo

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17425381#comment-17425381 ] Alessandro Solimando commented on CALCITE-4777: --- This is my understanding

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17425375#comment-17425375 ] Ruben Q L commented on CALCITE-4777: Just to confirm and to avoid any confusion, wi

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422873#comment-17422873 ] Julian Hyde commented on CALCITE-4777: -- [~rubenql], Exactly right. (I should have

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422628#comment-17422628 ] xuyangzhong commented on CALCITE-4777: -- Uh..What do you mean, [~donnyzone]. List t

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422616#comment-17422616 ] Feng Zhu commented on CALCITE-4777: --- [~xuyangzhong] Can we create an umbrella ticket

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422563#comment-17422563 ] Ruben Q L commented on CALCITE-4777: [~julianhyde], if I understood this correctly,

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422513#comment-17422513 ] xuyangzhong commented on CALCITE-4777: -- I even found that the SQL standard (2011)

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17422396#comment-17422396 ] Julian Hyde commented on CALCITE-4777: -- So, it appears that no SQL engines support

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17421910#comment-17421910 ] xuyangzhong commented on CALCITE-4777: -- Hi all, I am trying to fix this bug and th

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416418#comment-17416418 ] xuyangzhong commented on CALCITE-4777: -- The another issue created is here: https:

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416414#comment-17416414 ] xuyangzhong commented on CALCITE-4777: -- Ok, thanks [~julianhyde], . I will create

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416387#comment-17416387 ] Julian Hyde commented on CALCITE-4777: -- [~xuyangzhong], Not really. To fix this JI

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416385#comment-17416385 ] xuyangzhong commented on CALCITE-4777: -- So i think here we need to do the list: #

[jira] [Commented] (CALCITE-4777) Casting from DECIMAL to BOOLEAN throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416379#comment-17416379 ] duan xiong commented on CALCITE-4777: - +1. this solution is very clear and lenient.

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416376#comment-17416376 ] Julian Hyde commented on CALCITE-4777: -- The documentation that says you can cast D

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416200#comment-17416200 ] duan xiong commented on CALCITE-4777: - According [~asolimando] , The MS SQL Server

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416196#comment-17416196 ] duan xiong commented on CALCITE-4777: - [~rubenql] I find three types of implementat

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416186#comment-17416186 ] Alessandro Solimando commented on CALCITE-4777: --- I agree with [~rubenql],

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416184#comment-17416184 ] Ruben Q L commented on CALCITE-4777: I guess it's a design decision, we should cons

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416175#comment-17416175 ] duan xiong commented on CALCITE-4777: - [~rubenql] I don't think so. According I run

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416105#comment-17416105 ] Ruben Q L commented on CALCITE-4777: Thanks for the investigation [~xuyangzhong]. S

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416092#comment-17416092 ] xuyangzhong commented on CALCITE-4777: -- [~rubenql], [~nobigo],I test cast(0.42e0 a

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416087#comment-17416087 ] xuyangzhong commented on CALCITE-4777: -- I think i find the bug.So let me try to ex

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416035#comment-17416035 ] Ruben Q L commented on CALCITE-4777: Interestingly, it seems that using scientific

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415827#comment-17415827 ] xuyangzhong commented on CALCITE-4777: -- Thank you very much [~nobigo].I'll begin t

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415756#comment-17415756 ] duan xiong commented on CALCITE-4777: - I think the doc is no problem. But the SQL y

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415606#comment-17415606 ] xuyangzhong commented on CALCITE-4777: -- [~nobigo] Thanks for your answer :). So sh

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415593#comment-17415593 ] duan xiong commented on CALCITE-4777: - HI.[~xuyangzhong] This SqlFunctions is helpi

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415480#comment-17415480 ] xuyangzhong commented on CALCITE-4777: -- The table about conversion is : [https://

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415479#comment-17415479 ] xuyangzhong commented on CALCITE-4777: -- And if casting from decimal to boolean is

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415478#comment-17415478 ] duan xiong commented on CALCITE-4777: - [~xuyangzhong] Thanks again. Can you delete

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415475#comment-17415475 ] xuyangzhong commented on CALCITE-4777: -- Hi, [~nobigo]. So does the doc have a mist

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415474#comment-17415474 ] xuyangzhong commented on CALCITE-4777: -- !calcite.png! > Casting from decimal to b

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415470#comment-17415470 ] duan xiong commented on CALCITE-4777: - [~xuyangzhong] Hi. Can you help me point out

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415447#comment-17415447 ] xuyangzhong commented on CALCITE-4777: -- But the CalCite Docs (+https://calcite.ap

[jira] [Commented] (CALCITE-4777) Casting from decimal to boolean throws an exception

[ https://issues.apache.org/jira/browse/CALCITE-4777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415431#comment-17415431 ] Ruben Q L commented on CALCITE-4777: Is casting decimal to boolean something standa