I tried that. It doesn't work because the whole name attribute gets escaped by backticks for mysql. I used the <sql> tag as you suggested. But I think that's not perfect as <sql> tags can't be automatically reverted.
Jens Voxland, Nathan wrote: > > You could try putting name(10) in the column name. > > Otherwise you can always fall back to using the <sql> tag whenthe > built in changes do not support what you are trying to do. > > Nathan > > > > On Feb 15, 2009, at 6:05 AM, "Jensomato" <jensom...@googlemail.com> > wrote: > >> >> Hi all, >> I wonder if there is a way to provide index prefix length using the >> createIndex refactroing. >> I'm using MySql and want SQL like this. >> >> CREATE INDEX part_of_name ON customer (name(10)); >> >> In the docs and on this list I haven't found any hints. >> >> Regards, Jens >> -- >> View this message in context: >> http://www.nabble.com/provide-index-prefix-length-to-createIndex-refactoring--tp22021738p22021738.html >> Sent from the LiquiBase - User mailing list archive at Nabble.com. >> >> >> --- >> --- >> --- >> --------------------------------------------------------------------- >> 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 > > -- View this message in context: http://www.nabble.com/provide-index-prefix-length-to-createIndex-refactoring--tp22021738p22035543.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ 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
