You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/11/27 08:46:47 UTC
[GitHub] [incubator-doris] exialym opened a new issue #4974: 关于使用单/双引号转义自身的建议
exialym opened a new issue #4974:
URL: https://github.com/apache/incubator-doris/issues/4974
Doris 现在只支持使用反斜杠转义单/双引号，如：
`select * from table where col = 'I\'m'`
期望支持使用自身转义单/双引号的方式，如：
`select * from table where col = 'I''m'`
其他数据库现状：
支持自身转义的数据库：MySQL，Oracle，SQL Server，Postgres...
只支持自身转义，不支持反斜杠转义的数据库：Oracle，SQL Server，Postgres...
由于很多数据库只支持自身转义的情况，对接多数据库的系统一般都采用自身转义的方式来处理，Doris 如果也能支持的话，会减小多数据库系统对接 Doris 的成本。
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] chaoyli closed issue #4974: 关于使用单/双引号转义自身的建议
Posted by GitBox <gi...@apache.org>.
chaoyli closed issue #4974:
URL: https://github.com/apache/incubator-doris/issues/4974
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] Kate605690919 commented on issue #4974: 关于使用单/双引号转义自身的建议
Posted by GitBox <gi...@apache.org>.
Kate605690919 commented on issue #4974:
URL: https://github.com/apache/incubator-doris/issues/4974#issuecomment-734719461
诶诶，我们也遇到了这个问题，特别希望能支持下
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] sduzh commented on issue #4974: 关于使用单/双引号转义自身的建议
Posted by GitBox <gi...@apache.org>.
sduzh commented on issue #4974:
URL: https://github.com/apache/incubator-doris/issues/4974#issuecomment-740558218
This can be achieved by adding a simple patch on `fe/fe-core/src/main/jflex/sql_scanner.flex`, I'll create PR later.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org