[Rails-core] AR Unit Tests

[Wilson Bilkovich]

Good to know. I'll be more careful with when guessing at MySQL syntax
next time. Sorry for the inconvenience. :)

On 2/11/06, Bob Silva <me at bobsilva.com> wrote:
> 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
>
> _______________________________________________
> Rails-core mailing list
> Rails-core at lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails-core
>