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 2020/10/09 14:39:16 UTC

[GitHub] [shardingsphere] z3sm opened a new issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

z3sm opened a new issue #7722:
URL: https://github.com/apache/shardingsphere/issues/7722


   ## Question
   
   Are the following cases supported?
   SQL:
   ```
   select * from co t
   where upper(t.co) like trim(upper(concat('%','c213', '%')).
   ```
   
   I got an error like this:
   ### line 41:31 no viable alternative at input '(upper(T.CO)likeTRIM(UPPER'
   


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] kimmking commented on issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

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


   Another question NEED to open another issue.


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] z3sm commented on issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

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


   I have another case, a same error occured:
   
   ```
   	SELECT
   		t.KEY,
   		t.VALUE
   FROM T_SYS_SYSTEM_CONFIG T 
   ```


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] z3sm commented on issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

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


   > Those statements are not supported now.
   
   By the way，whether or not broadcast-tables can be excluded a datasource?
   I don't want save data to a special datasource   


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] z3sm edited a comment on issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

Posted by GitBox <gi...@apache.org>.
z3sm edited a comment on issue #7722:
URL: https://github.com/apache/shardingsphere/issues/7722#issuecomment-706223274


   I have another case, a same error occured:
   
   ```
   SELECT
   	t.KEY,
   	t.VALUE
   FROM T_SYS_SYSTEM_CONFIG T 
   ```


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] kimmking closed issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7722:
URL: https://github.com/apache/shardingsphere/issues/7722


   


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] kimmking commented on issue #7722: SQL Text contains 'like trim(upper(concat('%','c213', '%'))',did this case supported?

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


   Those statements are not supported now.


----------------------------------------------------------------
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.

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