Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

literal string single and double quoting rule are a bit different from mysql #623

Closed
whitewum opened this issue Jul 12, 2019 · 1 comment
Assignees
Labels
type/enhancement Type: make the code neat or more efficient

Comments

@whitewum
Copy link
Contributor

In mysql: Quoted strings placed next to each other are concatenated to a single string.

'a string'

'a' ' ' 'string'

mysql> SELECT 'hello', '"hello"', '""hello""', 'hel''lo', '\'hello';
+-------+---------+-----------+--------+--------+
| hello | "hello" | ""hello"" | hel'lo | 'hello |
+-------+---------+-----------+--------+--------+

mysql> SELECT "hello", "'hello'", "''hello''", "hel""lo", "\"hello";
+-------+---------+-----------+--------+--------+
| hello | 'hello' | ''hello'' | hel"lo | "hello |
+-------+---------+-----------+--------+--------+

ref #543

@whitewum whitewum added the type/enhancement Type: make the code neat or more efficient label Jul 12, 2019
@whitewum
Copy link
Contributor Author

some of the above literals are syntax error in nGQL

@whitewum whitewum added this to the R201910 milestone Jul 12, 2019
@jude-zhu jude-zhu removed this from the R201910 milestone Oct 28, 2019
@whitewum whitewum closed this as completed Sep 7, 2021
yixinglu pushed a commit to yixinglu/nebula that referenced this issue Mar 21, 2022
Co-authored-by: jimingquan <mingquan.ji@vesoft.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement Type: make the code neat or more efficient
Projects
None yet
Development

No branches or pull requests

3 participants