[Rails-core] AR Unit Tests

[Bob Silva]

Hi Wilson,

The problem was with the comment in front of the table. In MySQL, comments
starting with -- need a whitespace character following it.

Bob Silva
http://www.railtie.net/

> -----Original Message-----
> From: rails-core-bounces at lists.rubyonrails.org [mailto:rails-core-
> bounces at lists.rubyonrails.org] On Behalf Of Wilson Bilkovich
> Sent: Friday, February 10, 2006 6:38 AM
> To: rails-core at lists.rubyonrails.org
> Subject: Re: [Rails-core] AR Unit Tests
> 
> On 2/10/06, Bob Silva <me at bobsilva.com> wrote:
> >
> > test_lock_column_name_existing(LockingTest):
> >
> > ActiveRecord::StatementInvalid: Mysql::Error: #42S02Table
> > 'activerecord_unittest.legacy_things' doesn't exist: DELETE
> > FROM legacy_things
> 
> This is a test I wrote.  I don't use MySQL, unfortunately, so I can
> only hope that I got the definition syntax right.  This is what is in
> the mysql.sql file.. is this correct?
> 
> CREATE TABLE `legacy_things` (
>   `id` int(11) NOT NULL auto_increment,
>   `tps_report_number` int(11) default NULL,
>   `version` int(11) NOT NULL default 0,
>   PRIMARY KEY  (`id`)
> ) TYPE=InnoDB;
> _______________________________________________
> Rails-core mailing list
> Rails-core at lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails-core