mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 20:20:20 +00:00
ad79ef48a2
* add tests * add bench
26 lines
573 B
Plaintext
26 lines
573 B
Plaintext
|
|
CREATE TABLE t1(x);
|
|
INSERT INTO t1 VALUES('b');
|
|
INSERT INTO t1 VALUES('B');
|
|
|
|
|
|
SELECT * FROM t1 WHERE x COLLATE nocase BETWEEN 'a' AND 'c';
|
|
|
|
|
|
SELECT * FROM t1 WHERE x BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
|
|
|
|
|
SELECT * FROM t1
|
|
WHERE x COLLATE nocase BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
|
|
|
|
|
SELECT * FROM t1 WHERE +x COLLATE nocase BETWEEN 'a' AND 'c';
|
|
|
|
|
|
SELECT * FROM t1 WHERE +x BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
|
|
|
|
|
SELECT * FROM t1
|
|
WHERE +x COLLATE nocase BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
|
|