Awesome. Thanks for cranking on this!
~~ Robert. Voxland, Nathan wrote: > Thanks. I'll get that change in. I'm hoping to have 1.9.1 out next > week. > > Nathan > > > > On Feb 13, 2009, at 8:52 PM, "Robert Fischer" > <robert.fisc...@smokejumperit.com > > wrote: > >> Double quotes: "". >> >> ~~ Robert. >> >> Voxland, Nathan wrote: >>> yes. The trouble is that our hsql database class does not specify a >>> table escape method. >>> >>> Do you know what hsql uses to escape tables? >>> >>> Nathan >>> >>> >>> On Feb 13, 2009, at 5:50 PM, "Robert Fischer" >>> <robert.fisc...@smokejumperit.com >>>> wrote: >>>> I'm not on postgres -- I'm on hypersonic by way of p6spy. Could >>>> this be causing a problem? >>>> >>>> ~~ Robert. >>>> >>>> Voxland, Nathan wrote: >>>>> It should just be doing that if you are doing a diff. Just making >>>>> sure >>>>> that is what you are doing and it is not making those calls on its >>>>> own... >>>>> >>>>> I checked and it looks like the call to the 1 = 0 statement is >>>>> trying to >>>>> escape the table name and the postgres Database class is coded to >>>>> quote >>>>> them correctly. What version of liquibase are you working with? >>>>> >>>>> Nathan >>>>> >>>>> -----Original Message----- >>>>> From: Robert Fischer [mailto:robert.fisc...@smokejumperit.com] >>>>> Sent: Friday, February 13, 2009 8:14 AM >>>>> To: liquibase-user@lists.sourceforge.net >>>>> Subject: [Liquibase-user] Dies on "SELECT ID FROM user WHERE 1 = 0" >>>>> >>>>> When Liquibase fires up, I'm getting a whole series of "select" >>>>> statements, including this one: >>>>> >>>>> p6spy - 08:59:30|1|1|statement||SELECT ID FROM TAXES WHERE 1 = 0 >>>>> p6spy - 08:59:30|0|1|statement||SELECT VERSION FROM TAXES WHERE 1 >>>>> = 0 >>>>> p6spy - 08:59:30|0|1|statement||SELECT LOCATION FROM TAXES WHERE 1 >>>>> = 0 >>>>> p6spy - 08:59:30|0|1|statement||SELECT PERCENT FROM TAXES WHERE 1 >>>>> = 0 >>>>> p6spy - 08:59:30|11|1|statement||SELECT ID FROM user WHERE 1 = 0 >>>>> >>>>> When the "user" call is hit, the rollback is triggered and then I'm >>>>> seeing the following: >>>>> >>>>> [11695] AutobaseGrailsPlugin Error during Autobase migration >>>>> liquibase.exception.MigrationFailedException: Migration failed for >>>>> change set >>>>> NewRepublic-autobase::RemoveModelNameUsing-model_name- >>>>> inventory::Robert: >>>>> Reason: >>>>> java.sql.SQLException: Table not found in statement >>>>> [SELECT >>>>> ID FROM user] >>>>> >>>>> at liquibase.ChangeSet.execute(ChangeSet.java:184) >>>>> at >>>>> liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) >>>>> at >>>>> liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) >>>>> at liquibase.LiquibaseDsl.update(LiquibaseDsl.groovy:93) >>>>> at liquibase.LiquibaseDsl$update.call(Unknown Source) >>>>> >>>>> ~~ Robert Fischer. >>>>> Grails Training http://GroovyMag.com/training >>>>> Smokejumper Consulting http://SmokejumperIT.com >>>>> Enfranchised Mind Blog http://EnfranchisedMind.com/blog >>>>> >>>>> Check out my book, "Grails Persistence with GORM and GSQL"! >>>>> http://www.smokejumperit.com/redirect.html >>>>> >>>>> --- >>>>> --- >>>>> ------------------------------------------------------------------ >>>>> ------ >>>>> Open Source Business Conference (OSBC), March 24-25, 2009, San >>>>> Francisco, CA >>>>> -OSBC tackles the biggest issue in open source: Open Sourcing the >>>>> Enterprise >>>>> -Strategies to boost innovation and cut costs with open source >>>>> participation >>>>> -Receive a $600 discount off the registration fee with the source >>>>> code: >>>>> SFAD >>>>> http://p.sf.net/sfu/XcvMzF8H >>>>> _______________________________________________ >>>>> Liquibase-user mailing list >>>>> Liquibase-user@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/liquibase-user >>>>> >>>>> --- >>>>> --- >>>>> --- >>>>> --- >>>>> ------------------------------------------------------------------ >>>>> Open Source Business Conference (OSBC), March 24-25, 2009, San >>>>> Francisco, CA >>>>> -OSBC tackles the biggest issue in open source: Open Sourcing the >>>>> Enterprise >>>>> -Strategies to boost innovation and cut costs with open source >>>>> participation >>>>> -Receive a $600 discount off the registration fee with the source >>>>> code: SFAD >>>>> http://p.sf.net/sfu/XcvMzF8H >>>>> _______________________________________________ >>>>> Liquibase-user mailing list >>>>> Liquibase-user@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/liquibase-user >>>>> >>>> -- >>>> ~~ Robert Fischer. >>>> Grails Training http://GroovyMag.com/training >>>> Smokejumper Consulting http://SmokejumperIT.com >>>> Enfranchised Mind Blog http://EnfranchisedMind.com/blog >>>> >>>> Check out my book, "Grails Persistence with GORM and GSQL"! >>>> http://www.smokejumperit.com/redirect.html >>>> >>>> --- >>>> --- >>>> --- >>>> --- >>>> ------------------------------------------------------------------ >>>> Open Source Business Conference (OSBC), March 24-25, 2009, San >>>> Francisco, CA >>>> -OSBC tackles the biggest issue in open source: Open Sourcing the >>>> Enterprise >>>> -Strategies to boost innovation and cut costs with open source >>>> participation >>>> -Receive a $600 discount off the registration fee with the source >>>> code: SFAD >>>> http://p.sf.net/sfu/XcvMzF8H >>>> _______________________________________________ >>>> Liquibase-user mailing list >>>> Liquibase-user@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/liquibase-user >>> >>> --- >>> --------------------------------------------------------------------- >>> >>> --- >>> --- >>> --- >>> --------------------------------------------------------------------- >>> Open Source Business Conference (OSBC), March 24-25, 2009, San >>> Francisco, CA >>> -OSBC tackles the biggest issue in open source: Open Sourcing the >>> Enterprise >>> -Strategies to boost innovation and cut costs with open source >>> participation >>> -Receive a $600 discount off the registration fee with the source >>> code: SFAD >>> http://p.sf.net/sfu/XcvMzF8H >>> >>> >>> --- >>> --------------------------------------------------------------------- >>> >>> _______________________________________________ >>> Liquibase-user mailing list >>> Liquibase-user@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> -- >> ~~ Robert Fischer. >> Grails Training http://GroovyMag.com/training >> Smokejumper Consulting http://SmokejumperIT.com >> Enfranchised Mind Blog http://EnfranchisedMind.com/blog >> >> Check out my book, "Grails Persistence with GORM and GSQL"! >> http://www.smokejumperit.com/redirect.html >> >> --- >> --- >> --- >> --------------------------------------------------------------------- >> Open Source Business Conference (OSBC), March 24-25, 2009, San >> Francisco, CA >> -OSBC tackles the biggest issue in open source: Open Sourcing the >> Enterprise >> -Strategies to boost innovation and cut costs with open source >> participation >> -Receive a $600 discount off the registration fee with the source >> code: SFAD >> http://p.sf.net/sfu/XcvMzF8H >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/liquibase-user > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/liquibase-user > -- ~~ Robert Fischer. Grails Training http://GroovyMag.com/training Smokejumper Consulting http://SmokejumperIT.com Enfranchised Mind Blog http://EnfranchisedMind.com/blog Check out my book, "Grails Persistence with GORM and GSQL"! http://www.smokejumperit.com/redirect.html ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user
