Skip to content
This repository has been archived by the owner on Dec 1, 2022. It is now read-only.

insert string bug #1033

Closed
czpmango opened this issue May 12, 2021 · 0 comments · Fixed by #1079
Closed

insert string bug #1033

czpmango opened this issue May 12, 2021 · 0 comments · Fixed by #1079
Assignees
Labels
bug Type: something is unexpected low-pri Priority: low

Comments

@czpmango
Copy link
Contributor

nebula test:

(czp@nebula) [test]> CREATE TAG test1(name string);
Execution succeeded (time spent 65251/70311 us)

(czp@nebula) [test]> insert vertex test1(name) values "1":("\7");
Execution succeeded (time spent 87069/91563 us)

(czp@nebula) [test]> insert vertex test1(name) values "1":("\8");
[ERROR (-7)]: SyntaxError: syntax error near `\8'

(czp@nebula) [test]> insert vertex test1(name) values "1":("\9");
[ERROR (-7)]: SyntaxError: syntax error near `\9'

(czp@nebula) [test]> insert vertex test1(name) values "1":("\n");
Execution succeeded (time spent 88657/93144 us)

(czp@nebula) [test]> create tag index i1 on test1(name(8));

(czp@nebula) [test]> rebuild tag index i1;
+------------+
| New Job Id |
+------------+
| 159        |
+------------+
Got 1 rows (time spent 59240/64734 us)

Wed, 12 May 2021 17:50:29 CST

(czp@nebula) [test]> match (v:test1) return v,v.name;
+---------------------+--------+
| v                   | v.name |
+---------------------+--------+
| ("1" :test1{name: " | "      |
| "})                 | "      |
+---------------------+--------+
Got 1 rows (time spent 469075/478308 us)

Wed, 12 May 2021 17:50:33 CST

(czp@nebula) [test]> insert vertex test1(name) values "1":("\7");
Execution succeeded (time spent 92218/96663 us)

Wed, 12 May 2021 17:50:58 CST

(czp@nebula) [test]> match (v:test1) return v,v.name;
+------------------------+--------+
| v                      | v.name |
+------------------------+--------+
| ("1" :test1{name: ""}) | ""     |
+------------------------+--------+
Got 1 rows (time spent 464821/474043 us)

neo4j test:

neo4j@neo4j> create (v:test1{name:"\7"});
0 rows available after 42 ms, consumed after another 0 ms
Added 1 nodes, Set 1 properties, Added 1 labels
neo4j@neo4j> create (v:test1{name:"\8"});
0 rows available after 15 ms, consumed after another 0 ms
Added 1 nodes, Set 1 properties, Added 1 labels
neo4j@neo4j> create (v:test1{name:"\9"});
0 rows available after 7 ms, consumed after another 0 ms
Added 1 nodes, Set 1 properties, Added 1 labels
neo4j@neo4j> create (v:test1{name:"\n"});
0 rows available after 12 ms, consumed after another 0 ms
Added 1 nodes, Set 1 properties, Added 1 labels
neo4j@neo4j> match (v:test1) return v,v.name;
+--------------------------------+
| v                     | v.name |
+--------------------------------+
| (:test1 {name: "\7"}) | "\7"   |
| (:test1 {name: "\8"}) | "\8"   |
| (:test1 {name: "\9"}) | "\9"   |
| (:test1 {name: "
"})  | "
"    |
+--------------------------------+

4 rows available after 22 ms, consumed after another 1 ms
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Type: something is unexpected low-pri Priority: low
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants