W. Martin Borgert wrote: > But if I look up the trac.db, it shows no difference: > > sqlite> SELECT id, milestone, status FROM ticket ; > 1||new > 2||new > > The milestone table is, AFAIK, completely empty. So, what is the > difference between an empty and a None milestone? TIA!
There is a difference, but it's not visible because in the default configuration, sqlite3 displays NULL values as empty strings. The "None" milestone has a NULL value, the empty one an empty string. Try the following: sqlite> .nullvalue NULL sqlite> SELECT id, milestone, status FROM ticket; You'll see that one of the ticket has a NULL value as the milestone. Whether these two values should be treated differently is debatable, though. -- Remy
signature.asc
Description: OpenPGP digital signature
