diff options
| author | Zane van Iperen <zane@zanevaniperen.com> | 2023-10-06 18:31:37 +1000 |
|---|---|---|
| committer | Zane van Iperen <zane@zanevaniperen.com> | 2023-10-06 18:31:37 +1000 |
| commit | 984e555acbadbd1aed7df17ab53e2c586a2f8f68 (patch) | |
| tree | a93ab944c72bb081633f951ac29af540b02c7c4c /postprocess.sql | |
| parent | 470373386cf33c3c7359d15a44d82d2d84a7c065 (diff) | |
| download | openrussian-cli-984e555acbadbd1aed7df17ab53e2c586a2f8f68.tar.gz | |
postprocess: remove use of double-quoted strings
As of SQLite 3.41.0, their use is disabled by default.
Diffstat (limited to 'postprocess.sql')
| -rw-r--r-- | postprocess.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/postprocess.sql b/postprocess.sql index 5976cb1..950bb27 100644 --- a/postprocess.sql +++ b/postprocess.sql @@ -18,7 +18,7 @@ CREATE TABLE bare_inflections (`word_id` INTEGER NOT NULL, `bare` VARCHAR(100) N -- also be BINARY collated. See also: -- https://www.sqlite.org/optoverview.html#the_like_optimization CREATE INDEX idx_bare_inflections_bare ON bare_inflections (`bare`); -INSERT INTO bare_inflections SELECT word_id, REPLACE(temp, "'", "") AS bare +INSERT INTO bare_inflections SELECT word_id, REPLACE(temp, '''', '') AS bare FROM ( -- Search word might be a noun or adjective declension SELECT word_id, nom AS temp FROM declensions @@ -72,7 +72,7 @@ FROM ( UNION ALL SELECT word_id, pl3 AS temp FROM conjugations ) -WHERE bare <> ""; +WHERE bare <> ''; -- Saves a few megabytes VACUUM; |