[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16643086#comment-16643086 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde], I have filed a [PR|https

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-09 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16643796#comment-16643796 ] Julian Hyde commented on CALCITE-525: - I saw [~vlsi]'s comments on the PR, but let's

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1661#comment-1661 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde] and [~vlsi], thank you for

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-10 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16645019#comment-16645019 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote} 2. Decorate the inner enu

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16645499#comment-16645499 ] Julian Hyde commented on CALCITE-525: - bq. What is the practical use of the feature

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-10 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646032#comment-16646032 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote} As I said, the SQL standa

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646100#comment-16646100 ] Hongze Zhang commented on CALCITE-525: -- AFAIK, MySQL has [sql mode|https://dev.mys

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646114#comment-16646114 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote} It actually drop the whol

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646160#comment-16646160 ] Hongze Zhang commented on CALCITE-525: -- {quote}Suppose there's SEMI-ANTI-JOIN. Supp

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646168#comment-16646168 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote}The row will be emitted, s

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646233#comment-16646233 ] Hongze Zhang commented on CALCITE-525: -- Thanks for the example, and I know simply d

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-12 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16648644#comment-16648644 ] Julian Hyde commented on CALCITE-525: - If consistency is paramount for someone, they

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-13 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16648796#comment-16648796 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote}ability to ignore errors i

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16648996#comment-16648996 ] Julian Hyde commented on CALCITE-525: - Here: https://oracle-base.com/articles/10g/dm

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-13 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16649004#comment-16649004 ] Vladimir Sitnikov commented on CALCITE-525: --- That does not catch 0/0 kind of e

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16649087#comment-16649087 ] Julian Hyde commented on CALCITE-525: - It's immaterial which kinds of errors Oracle

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-13 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16649112#comment-16649112 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote}Calcite should provide a f

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16651127#comment-16651127 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde] and [~vladimirsitnikov],

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16651272#comment-16651272 ] Vladimir Sitnikov commented on CALCITE-525: --- {quote}Also, you can see an issue

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16651281#comment-16651281 ] Hongze Zhang commented on CALCITE-525: -- [~vladimirsitnikov] The link is here: http