You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/09/03 07:56:07 UTC
[GitHub] [iotdb] herowzz opened a new issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
herowzz opened a new issue #3903:
URL: https://github.com/apache/iotdb/issues/3903
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] herowzz commented on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
herowzz commented on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-928496530
@jixuan1989
单引号，双引号识别的是字符串，反引号识别的是转义字符，个人建议不要同义
比如上图中的`select id from xxx` 这里的id没有引号标识，则查询的是表中的字段
但是 `select ‘id’ from xxx` 这个id有引号标识，识别的是字符串 ，查询结果则直接是字符串 id
反引号同样 select \`id` from xxx 这个id是转义的id，查询的还是字段 id
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] herowzz commented on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
herowzz commented on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-928496530
@jixuan1989
单引号，双引号识别的是字符串，反引号识别的是转义字符，个人建议不要同义
比如上图中的`select id from xxx` 这里的id没有引号标识，则查询的是表中的字段
但是 `select ‘id’ from xxx` 这个id有引号标识，识别的是字符串 ，查询结果则直接是字符串 id
反引号同样 select \`id` from xxx 这个id是转义的id，查询的还是字段 id
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] jixuan1989 commented on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
jixuan1989 commented on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-916851252
Hi, I do not find the difference between ', " and `... how do you think we consider them as synonym?
将单引号、双引号、反引号 当做同义词如何？（必须成对出现）
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] herowzz edited a comment on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
herowzz edited a comment on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-928496530
@jixuan1989
单引号，双引号识别的是字符串，反引号识别的是转义字符，个人建议不要同义
比如上图中的`select id from xxx` 这里的id没有引号标识，则查询的是表中的字段
但是 `select ‘id’ from xxx` 这个id有单引号标识，识别的是字符串 ，查询结果则直接是字符串 id
反引号同样 select \`id` from xxx 这个id是转义的id，查询的还是字段 id
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] icloudsong commented on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
icloudsong commented on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-992494413
It's a good idea
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] herowzz edited a comment on issue #3903: 希望能够支持反引号模式，从而能够让SQL支持保留关键字
Posted by GitBox <gi...@apache.org>.
herowzz edited a comment on issue #3903:
URL: https://github.com/apache/iotdb/issues/3903#issuecomment-928496530
@jixuan1989
单引号，双引号识别的是字符串，反引号识别的是转义字符，个人建议不要同义
比如上图中的`select id from xxx` 这里的id没有引号标识，则查询的是表中的字段
但是 `select ‘id’ from xxx` 这个id有单引号标识，识别的是字符串 ，查询结果则直接是字符串 id
反引号同样 select \`id` from xxx 这个id是转义的id，查询的还是字段 id
--
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: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org