> The broken.sql file works with 3.7.12 here. So you're not using Mountain Lion ...
> SQLite version 3.7.12 2012-05-14 01:41:23 Apple's version is 3.7.12 2012-04-03 19:43:07. > CREATE TABLE t1(x, CONSTRAINT pk_cons PRIMARY KEY(x)); Yes I can do that too. But in some larger tables, it does not work. > SELECT sqlite_source_id(); I get: 2012-04-03 19:43:07 86b8481be7e76cccc92d14ce762d21bfb69504af Kind Regards, Tobias Giesen "To avoid a reboot, make sure that no SuperFlexible or ExtremeSync processes are running in Task Manager before installing an update." Super Flexible Software Ltd. & Co. KG Lessingstr. 42 48485 Neuenkirchen, Germany www.superflexible.com www.tgtools.com ----------------------------------------------------------- Registered at register court Steinfurt as HRA 5061 Liability / general partner: TGTools Ltd. Company No. 05513299 Registered in England and Wales Directors: Tobias Giesen and Claudia Giesen _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users