mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
ad79ef48a2
* add tests * add bench
23 lines
721 B
Plaintext
23 lines
721 B
Plaintext
|
|
SELECT 'abc'==('ABC'||'') COLLATE nocase;
|
|
SELECT 'abc'==('ABC'||'' COLLATE nocase);
|
|
SELECT 'abc'==('ABC'||('' COLLATE nocase));
|
|
SELECT 'abc'==('ABC'||upper('' COLLATE nocase));
|
|
|
|
|
|
SELECT 'abc'==('ABC'||max('' COLLATE nocase,'' COLLATE binary));
|
|
|
|
|
|
SELECT 'abc'==('ABC'||max('' COLLATE binary,'' COLLATE nocase));
|
|
|
|
|
|
SELECT 'abc'==('ABC'||CASE WHEN 1-1=2 THEN '' COLLATE nocase
|
|
ELSE '' COLLATE binary END);
|
|
SELECT 'abc'==('ABC'||CASE WHEN 1+1=2 THEN '' COLLATE nocase
|
|
ELSE '' COLLATE binary END);
|
|
|
|
|
|
SELECT 'abc'==('ABC'||CASE WHEN 1=2 THEN '' COLLATE binary
|
|
ELSE '' COLLATE nocase END);
|
|
|