Anoher (silly) question about what SQLite considers valid input, again out of mere curiosity.
A statement like: CREATE TABLE a (a CHAR COLLATE NOCASE COLLATE BINARY, b INTEGER DEFAULT 1 DEFAULT 2); doesn't cause any error: SQLite applies only the last constraint of each type, namely COLLATE BINARY and DEFAULT 2 in this case. Is there a rationale for allowing such statements or is that an effect of the 'Lite' nature? (Note: I'm not complaining, just asking.) Is it OK to ignore all but the last constraint of each type when parsing that statement, just like SQLite currently does? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users