[jifty-devel] schema upgrade packet length limited

[Jesse Vincent]

On Thu, Jan 17, 2008 at 12:30:04AM -0800, Stanislav Sinyagin wrote:
> (tested with Jifty releasse at CPAN and current SVN too)
> 
> schema upgrade command produces an error below. It looks like MySQL server
> receives only a part of the upgrade command: the command is cut at the second 
> INDEX statement:
> 
> [root at lab1 Toponet]# jifty schema --setup
> ERROR - Toponet::Dispatcher did not return a true value; assuming it was a dispatcher rule
> WARN - Application schema version in database (0.0.4) doesn't match application schema version (0.0.6)
> WARN - Automatically upgrading your database to match the current application schema at /usr/lib/perl5/site_perl/5.8.8/Jifty/Handle.pm line 174.
> Jifty version 0.71129 up to date.
> 
> CREATE  INDEX hardware_elements2 ON hardware_elements ( parent ) ;


... Wow. I'd really expect each SQL CREATE to be run as its own
statement. Want to try your hand at a patch to do that?