diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-12-04 22:12:05 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-12-04 22:46:08 +0100 |
| commit | bccb57ec045b6b1e66e776baebeebeb2837c7efc (patch) | |
| tree | 242de1a1ab69a35705430215d22dbe78342ef9de /data/sql | |
| parent | 42fa3b5791d7a53988afe9d97f52dcea41918f40 (diff) | |
| download | PROJ-bccb57ec045b6b1e66e776baebeebeb2837c7efc.tar.gz PROJ-bccb57ec045b6b1e66e776baebeebeb2837c7efc.zip | |
Database: fix building proj.db with SQLite built with -DSQLITE_DQS=0
That is the option to make SQLite reject misuses of double quotes instead
of single quotes. Most SQLite builds are forgiving, but some forks proposing
a CMake build system default to SQLITE_DQS=0
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 05c64e45..b879cab8 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1460,9 +1460,9 @@ CREATE VIEW object_view AS UNION ALL SELECT 'prime_meridian', auth_name, code, name, NULL, deprecated FROM prime_meridian UNION ALL - SELECT 'geodetic_datum', auth_name, code, name, CASE WHEN ensemble_accuracy IS NOT NULL THEN "ensemble" ELSE "datum" END, deprecated FROM geodetic_datum + SELECT 'geodetic_datum', auth_name, code, name, CASE WHEN ensemble_accuracy IS NOT NULL THEN 'ensemble' ELSE 'datum' END, deprecated FROM geodetic_datum UNION ALL - SELECT 'vertical_datum', auth_name, code, name, CASE WHEN ensemble_accuracy IS NOT NULL THEN "ensemble" ELSE "datum" END, deprecated FROM vertical_datum + SELECT 'vertical_datum', auth_name, code, name, CASE WHEN ensemble_accuracy IS NOT NULL THEN 'ensemble' ELSE 'datum' END, deprecated FROM vertical_datum UNION ALL SELECT 'axis', auth_name, code, name, NULL, 0 as deprecated FROM axis UNION ALL |