You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/01/08 23:01:45 UTC
[GitHub] [druid] samarthjain opened a new issue #9152: Druid SQL - escaping
non-letter or digit characters in string literals not correct
samarthjain opened a new issue #9152: Druid SQL - escaping non-letter or digit characters in string literals not correct
URL: https://github.com/apache/druid/issues/9152
The Druid version where the problem was encountered.
0.16
### Description
When using the avatica driver, druid sql doesn't work correctly for datasource names containing non-alpha numeric characters (like underscore). This is because the metadata query made to fetch information about columns of the table fails to return anything because of the buggy where clause.
For ex -
SELECT * FROM druid.datasource_name results in the metadata query whose where clause is:
WHERE TABLES.TABLE_NAME LIKE U&'datasource\\005Fname'
The above where clause is incorrect as there should only be a single slash
WHERE TABLES.TABLE_NAME LIKE U&'datasource\005Fname'
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] samarthjain commented on issue #9152: Druid SQL - escaping
non-letter or digit characters in string literals not correct
Posted by GitBox <gi...@apache.org>.
samarthjain commented on issue #9152: Druid SQL - escaping non-letter or digit characters in string literals not correct
URL: https://github.com/apache/druid/issues/9152#issuecomment-572318145
This turned out to be the issue in the application making metadata requests and not a bug in Druid.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] samarthjain closed issue #9152: Druid SQL - escaping
non-letter or digit characters in string literals not correct
Posted by GitBox <gi...@apache.org>.
samarthjain closed issue #9152: Druid SQL - escaping non-letter or digit characters in string literals not correct
URL: https://github.com/apache/druid/issues/9152
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org