Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 40045
Status: open
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: cpan [...] desert-island.me.uk
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 0.09001
Fixed in: (no value)

History Show all quoted text
  Tue Oct 14 15:15:28 2008 cpan [...] desert-island.me.uk - Ticket created
Subject: Diffing for SQLite produces SQL that is not valid
SQLite doesn't like ALTER TABLE statements like: ALTER TABLE businesses ADD COLUMN url varchar(1024) NOT NULL According to current sqlite docs: ADD Column restrictions: If a NOT NULL constraint is specified, then the column must have a default value other than NULL. Diff should notice this and complain.
  Tue Jan 17 06:39:15 2012 ribasushi [...] leporine.io - Correspondence added
On Tue Oct 14 15:15:28 2008, JROBINSON wrote: Show quoted text
> SQLite doesn't like ALTER TABLE statements like: > ALTER TABLE businesses ADD COLUMN url varchar(1024) NOT NULL > > According to current sqlite docs: > ADD Column restrictions: If a NOT NULL constraint is specified, then > the column must have a default value other than NULL. > > Diff should notice this and complain.
Jess, can you please check if this is still the case, and write a test if so?
  Tue Jan 17 06:39:16 2012 The RT System itself - Status changed from 'new' to 'open'