From 984e555acbadbd1aed7df17ab53e2c586a2f8f68 Mon Sep 17 00:00:00 2001 From: Zane van Iperen Date: Fri, 6 Oct 2023 18:31:37 +1000 Subject: postprocess: remove use of double-quoted strings As of SQLite 3.41.0, their use is disabled by default. --- postprocess.sql | 4 ++-- 1 file 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; -- cgit v1.2.3