.import and typeof

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

.import and typeof

James K. Lowden
The .import command in sqlite3 chokes on CHECK constraints consisting of
typeof.  Is it intentional?  

$ sqlite3 -echo -header  :memory: < demo/typeof.sql
create table T (t int not null);
insert into T values (1);
.system echo 2 > T
.system nl T
     1  2
.import 'T' T
select * from T;
t
1
2
drop table T;
-- repeat with constraint
create table T (t int not null check (typeof(t) = 'integer') );
insert into T values (1);
.import 'T' T
T:1: INSERT failed: CHECK constraint failed: T
select * from T;
t
1
drop table T;

For the record, .import does honor

        pragma ignore_check_constraints = on;

The above script "works" when it begins with that line.

--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users