Lines Matching refs:self

1366   1 { CREATE TABLE self(a INTEGER PRIMARY KEY, b REFERENCES self(a))
1368   2 { CREATE TABLE self(a PRIMARY KEY, b REFERENCES self(a)) WITHOUT rowid }
1369   3 { CREATE TABLE self(a UNIQUE, b INT PRIMARY KEY REFERENCES self(a))
1375     execsql { INSERT INTO self VALUES(13, 13) }
1378     execsql { UPDATE self SET a = 14, b = 14 }
1382     catchsql { UPDATE self SET b = 15 }
1386     catchsql { UPDATE self SET a = 15 }
1390     catchsql { UPDATE self SET a = 15, b = 16 }
1394     catchsql { UPDATE self SET a = 17, b = 17 }
1398     execsql { DELETE FROM self }
1401     catchsql { INSERT INTO self VALUES(20, 21) }
1405 # Additional tests cases using multi-column self-referential