CREATE TABLE "test" (
"id" INTEGER PRIMARY KEY,
"name" TEXT NOT NULL);
-----------------------------
ok
INSERT INTO "test" ("id", "name") VALUES (123, "one");
-----------------------------
ok
SELECT "id" FROM "test" WHERE "name" = "one";
-----------------------------
123
INSERT INTO test (id, name) VALUES (123456, 'two');
-----------------------------
ok
SELECT id FROM test WHERE name = 'two';
-----------------------------
123456
|
CREATE TABLE "test" (
"id" INTEGER PRIMARY KEY,
"name" TEXT NOT NULL);
-----------------------------
ok
INSERT INTO "test" ("id", "name") VALUES (123, "one");
-----------------------------
no such column: one
SELECT "id" FROM "test" WHERE "name" = "one";
-----------------------------
no such column: one
INSERT INTO test (id, name) VALUES (123456, 'two');
-----------------------------
ok
SELECT id FROM test WHERE name = 'two';
-----------------------------
123456
|