On Sun, Dec 13, 2009 at 10:53 PM, Roger Binns <rog...@rogerbinns.com> wrote:
> And just to blow your mind, SQLite supports zero length names too!
>
> create table ""("");
true, true
SQLite version 3.6.19
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE "" ("" UNIQUE NOT NULL);
sqlite> INSERT INTO "" ("") VALUES ('');
sqlite> INSERT INTO "" ("") VALUES ('');
SQL error: column is not unique
sqlite> INSERT INTO "" ("") VALUES (NULL);
SQL error: . may not be NULL
sqlite> INSERT INTO "" ("") VALUES ("");
SQL error: column is not unique
sqlite> SELECT * FROM "";
sqlite>
sqlite> .s
CREATE TABLE "" ("" UNIQUE NOT NULL);
Life is a rim-less zero, a handle-less knife without a blade.
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
