3 ms·
Oh, that's a bit scary. Both for use as a file format (in case of attacker supplied db file) and more general. I see that even with "INTEGER" affinity, I can i
by e12e 7y ago
Oh, that's a bit scary. Both for use as a file format (in case of attacker supplied db file) and more general.
I see that even with "INTEGER" affinity, I can insert and read back text to columns :/
sqlite :memory:
CREATE TABLE test(
x INTEGER, y TEXT);
INSERT INTO test
VALUES("a", "b");
SELECT * FROM test;
a|b
https://www.sqlite.org/datatype3.html https://www.sqlite.org/datatype3.html