search

kawasin73 / prsqlite

Pure Rust implementation of SQLite
Apache License 2.0
563 stars 23 forks source link

string literal support #17

Closed kawasin73 closed 1 year ago

kawasin73 commented 1 year ago

close #16

Now it supports == and != comparison.

sqlite> CREATE TABLE example(col);
sqlite> INSERT INTO example(col) VALUES ('hello'), ('world'), ('hello');
sqlite> INSERT INTO example(col) VALUES ('hel''lo');
sqlite> SELECT * FROM example WHERE col = 'hello';
hello
hello
sqlite> SELECT * FROM example WHERE col = 'hel''lo';
hel'lo
sqlite> .quit
prsqlite> SELECT * FROM example WHERE col = 'hello';
hello
hello
prsqlite> SELECT * FROM example WHERE col = 'hel''lo';
hel'lo
prsqlite> .quit