[sqlite] where did my data go ? Re: Import data into a temporary table

Luuk writes: | sqlite> .import abc.csv temp.test | Error: no such table: temp.test |. . . | Where did my data go (see above)? The above command to the shell results in an attempted prepare of SQL like this, INSERT INTO “temp.text” VALUES … which fails with a “no such table” complaint. If

Re: [sqlite] .import fails CHECK constraint on valid data

The check constraint is probably being evaluated (with t as a string) before any type conversion to match the column affinity is done. On Sun, Mar 10, 2019, 2:05 PM James K. Lowden wrote: > $ sqlite3 db "create table T (t integer not null);" > $ sqlite3 db "create table Tc (t integer not null >

[sqlite] .import fails CHECK constraint on valid data

$ sqlite3 db "create table T (t integer not null);" $ sqlite3 db "create table Tc (t integer not null check(typeof(t) = 'integer'));" $ echo 1 > dat $ sqlite3 db ".import 'dat' T" $ sqlite3 db ".import 'dat' Tc" dat:1: INSERT failed: CHECK constraint failed: Tc $

[sqlite] missing SQLITE_DEFAULT_TEMP_CACHE_SIZE

Hello, The documentation here (https://www.sqlite.org/tempfiles.html#other_temporary_file_optimizations ) mentions that temporary tables and