[Liquibase-user] Diff not generating Not Null constraint on the first go..

Hi I have a database (db1) with a user table, say user (db1) --- id (INT) name (VARCHAR) email (VARCHAR) I make a new database (db2) with the an added row called create_date which is NOT NULL user (db2) -- id (INT) name (VARCHAR) email (VARCHAR) create_date (DATETIME NOT NULL) Now when

Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Anttargetiscreating createIndex elements without the columnnamewhichis required

Good to hear, I think I'll put out a 1.9.3 release as it could be a pretty major problem. The problem was in liquibase.database.structure.SqlDatabaseSnapshot, line 470. There was a patch added in 1.9.2 (I think that was where it was first released) around multi-column indexes being returned ou

Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Anttargetiscreating createIndex elements without the columnnamewhichis required

Thanks for the details Nathan :) Will find some time to look into the stuff. Cheers Animesh On Thu, Apr 9, 2009 at 10:05 PM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > Good to hear, I think I’ll put out a 1.9.3 release as it could be a > pretty major problem. > > > > The proble

Re: [Liquibase-user] Diff not generating Not Null constraint on thefirst go..

It was because our diff comparison for missing columns was not checking for nullability. I put a new snapshot up at http://www.liquibase.org/liquibase-SNAPSHOT.jar see if that is better. Nathan From: Animesh Jain [mailto:anim...@itasveer.com] Sent: Thursday, April 09, 2009 2:15 AM To: li

Re: [Liquibase-user] Diff not generating Not Null constraint on thefirst go..

Hi Nathan Yes.. this fixes the problem. Thanks again! I'll be playing around with Liquibase a bit more, so I might bother you again :) Animesh On Fri, Apr 10, 2009 at 1:37 AM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > It was because our diff comparison for missing columns was