MP trunk sql.c COLLATE VERSION

[Bradley Giesbrecht]

With port from trunk I do not have VERSION collation available in registry.db.

$ sqlite3 registry.db 
SQLite version 3.7.9 2011-11-01 00:52:41

sqlite> PRAGMA collation_list;
0|NOCASE
1|RTRIM
2|BINARY

sqlite> .schema
CREATE TABLE dependencies (id INTEGER, name TEXT, variants TEXT, FOREIGN KEY(id) REFERENCES ports(id));
CREATE TABLE files (id INTEGER, path TEXT, actual_path TEXT, active INT, mtime DATETIME, md5sum TEXT, editable INT, FOREIGN KEY(id) REFERENCES ports(id));
CREATE TABLE metadata (key UNIQUE, value);
CREATE TABLE ports (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT COLLATE NOCASE, portfile CLOB, url TEXT, location TEXT, epoch INTEGER, version TEXT COLLATE VERSION, revision INTEGER, variants TEXT, negated_variants TEXT, state TEXT, date DATETIME, installtype TEXT, archs TEXT, requested INT, os_platform TEXT, os_major INTEGER, UNIQUE (name, epoch, version, revision, variants), UNIQUE (url, epoch, version, revision, variants));
CREATE INDEX dep_name ON dependencies (name);
CREATE INDEX file_actual ON files(actual_path);
CREATE INDEX file_path ON files(path);
CREATE INDEX file_port ON files (id);
CREATE INDEX port_name ON ports (name, epoch, version, revision, variants);
CREATE INDEX port_state ON ports (state);
CREATE INDEX port_url ON ports (url, epoch, version, revision, variants);


I am trying to use branches/gsoc11-rev-upgrade on OS X 10.5/PPC and "make install" is corrupting my registry.db.

FWIW, branches/gsoc11-rev-upgrade installed without issue on OS X 10.6/Intel with the same version of sqlite3.
VERSION is missing from collation_list on my 10.6/Intel machine as well, but the upgrade proceeded without obvious error; AND the rev-upgrade command is working well :)

I am focusing on COLLATE VERSION because while using sqlite3 command line and performing the "create table" or "update table" queries, sqlite3 fails to create/update the "ports" table and changing COLLATE VERSION to some other collation succeeds.


Regards,
Bradley Giesbrecht (pixilla)