You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/27 07:16:54 UTC

[GitHub] [shardingsphere] trycache0828 opened a new issue #12049: SqlValidatorException for ShardingSphere-5.0.0-beta: No match found for function signature ifnull

trycache0828 opened a new issue #12049:
URL: https://github.com/apache/shardingsphere/issues/12049


   ## Bug Report
   
   org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature ifnull(<CHARACTER>, <CHARACTER>)
   
   ### Which version of ShardingSphere did you use?
   
   ShardingSphere-5.0.0-beta
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-JDBC 
   
   ### Expected behavior
   
   org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature ifnull(<CHARACTER>, <CHARACTER>)
   	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   
   ### Actual behavior
   
   SQL syntax parsing is normal
   
   ### Reason analyze (If you can)
   
   SQL syntax parsing is not supported
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   
   SELECT ifnull( t3.name, '' ) AS actUser FROM auser t3
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] avalon5666 commented on issue #12049: SqlValidatorException for ShardingSphere-5.0.0-beta: No match found for function signature ifnull

Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12049:
URL: https://github.com/apache/shardingsphere/issues/12049#issuecomment-907919688


   Related #11437.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] trycache0828 commented on issue #12049: SqlValidatorException for ShardingSphere-5.0.0-beta: No match found for function signature ifnull

Posted by GitBox <gi...@apache.org>.
trycache0828 commented on issue #12049:
URL: https://github.com/apache/shardingsphere/issues/12049#issuecomment-907947452


   > Related #11437.
   
   ## I have encountered a new problem. Is it a paging query proble?
   
   	java.lang.AssertionError: not a literal: ?0
   		at org.apache.calcite.rex.RexLiteral.findValue(RexLiteral.java:1174)
   		at org.apache.calcite.rex.RexLiteral.intValue(RexLiteral.java:1149)
   		at org.apache.calcite.rel.metadata.RelMdUtil.checkInputForCollationAndLimit(RelMdUtil.java:886)
   		at org.apache.calcite.rel.rules.SortJoinTransposeRule.onMatch(SortJoinTransposeRule.java:135)
   		at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:229)
   		at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:58)
   		at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:510)
   		at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:271)
   		at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:331)
   		at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:166)
   		at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
   		at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:208)
   		at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:642)
   		at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:508)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] avalon5666 commented on issue #12049: SqlValidatorException for ShardingSphere-5.0.0-beta: No match found for function signature ifnull

Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12049:
URL: https://github.com/apache/shardingsphere/issues/12049#issuecomment-911126997


   @trycache0828 same sql or another sql?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org