Re: [Rails-core] activerecord rake test_mysql

[David Rupp]

Ben,

There's a bug recorded at http://bugs.mysql.com/bug.php?id=14786;  
seems to be a known issue with MySQL 5. There's also a post at http:// 
wordpress.org/support/topic/46047 that recommends disabling "strict  
mode". I'm not on MySQL5 yet, so I can't vouch for this fix. Sounds  
like it's worth a try though.

Regards,
David

On Nov 29, 2005, at 6:05 AM, Ben Anderson wrote:

Annoying me again,
Sorry for berating this list... and sorry if I sounded annoyed
previously - seems everything is fine here.  I tried posting this
question over the weekend and as I recall, it may not have gone
through.  Anyways, here it is again.  I apologize if this already came
through the other day.  Is there an archive of this list I could check
such things?  I see the rails list is mirrored in the forums, but I
don't see this list.

I'd like to submit a patch and am following the steps on this page:
http://dev.rubyonrails.org/

Here's what I did (using mysql 5.0.15-nt):

created 2 databases:
  activerecord_unittest
  activerecord_unittest2

created 1 user:  rails (giving all priveleges to both databases)

ran $RAILS_HOME/activerecord\test\fixtures\db_definitions\mysql.sql on
activerecord_unittest
ran $RAILS_HOME/activerecord\test\fixtures\db_definitions\mysql2.sql
on activerecord_unittest2

modified $RAILS_HOME/activerecord\test\connections\native_mysql/ 
connect.rb
accordingly

I removed all my local changes, so I'm running with a pristine copy of
the current trunk.
cd $RAILS_HOME/activerecord
rake test_mysql

below I posted the output I received.  I'm assuming at least most of
the tests should pass, if not all and that I've got something screwed
up.  Anyone have any ideas?  Can someone let me if the tests should
pass?
Thanks,
Ben


(in C:/ruby/projects/rails/projects/myWardrobe/vendor/rails/ 
activerecord)
Using native MySQL
Loaded suite c:/ruby/ruby-1.8.2-15/ruby/lib/ruby/gems/1.8/gems/ 
rake-0.6.2/lib/rake/rake_test_loader
Started
........EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE 
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE 
EEEEEEEE.................EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...... 
...................................................................... 
...................F.............F.......EEEEEEEEEEEEEEEEEEEEEEEEEEEEE 
EEEEEEE...EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE....EE 
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......................E...E... 
.......E............F............EEE..............EEEEEEE............. 
.......FF....F........................................................ 
.............................
Finished in 77.0 seconds.

  1) Error:
test_adding_macro_callbacks(AssociationCallbacksTest):
ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type'
doesn't have a default value: INSERT INTO projects (`name`, `id`)
VALUES ('Active Record', 1)
    ./test/../lib/active_record/connection_adapters/ 
abstract_adapter.rb:78:in
`log'
    ./test/../lib/active_record/connection_adapters/ 
mysql_adapter.rb:181:in
`execute'
    ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:283:in `each'
    ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `each'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:251:in `transaction'
    ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:244:in `silence'
    ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures'
    ./test/../lib/active_record/fixtures.rb:487:in  
`setup_with_fixtures'
    ./test/../lib/active_record/fixtures.rb:521:in `setup'
    ./test/../lib/active_record/fixtures.rb:520:in `setup'

  2) Error:
test_adding_with_proc_callbacks(AssociationCallbacksTest):
ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type'
doesn't have a default value: INSERT INTO projects (`name`, `id`)
VALUES ('Active Record', 1)
    ./test/../lib/active_record/connection_adapters/ 
abstract_adapter.rb:78:in
`log'
    ./test/../lib/active_record/connection_adapters/ 
mysql_adapter.rb:181:in
`execute'
    ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:283:in `each'
    ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `each'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:251:in `transaction'
    ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:244:in `silence'
    ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures'
    ./test/../lib/active_record/fixtures.rb:487:in  
`setup_with_fixtures'
    ./test/../lib/active_record/fixtures.rb:521:in `setup'
    ./test/../lib/active_record/fixtures.rb:520:in `setup'

  3) Error:
test_dont_add_if_before_callback_raises_exception 
(AssociationCallbacksTest):
ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type'
doesn't have a default value: INSERT INTO projects (`name`, `id`)
VALUES ('Active Record', 1)
    ./test/../lib/active_record/connection_adapters/ 
abstract_adapter.rb:78:in
`log'
    ./test/../lib/active_record/connection_adapters/ 
mysql_adapter.rb:181:in
`execute'
    ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:283:in `each'
    ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `each'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:251:in `transaction'
    ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:244:in `silence'
    ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures'
    ./test/../lib/active_record/fixtures.rb:487:in  
`setup_with_fixtures'
    ./test/../lib/active_record/fixtures.rb:521:in `setup'
    ./test/../lib/active_record/fixtures.rb:520:in `setup'

  4) Error:
test_has_and_belongs_to_many_add_callback(AssociationCallbacksTest):
ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type'
doesn't have a default value: INSERT INTO projects (`name`, `id`)
VALUES ('Active Record', 1)
    ./test/../lib/active_record/connection_adapters/ 
abstract_adapter.rb:78:in
`log'
    ./test/../lib/active_record/connection_adapters/ 
mysql_adapter.rb:181:in
`execute'
    ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:283:in `each'
    ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `each'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:251:in `transaction'
    ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:244:in `silence'
    ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures'
    ./test/../lib/active_record/fixtures.rb:487:in  
`setup_with_fixtures'
    ./test/../lib/active_record/fixtures.rb:521:in `setup'
    ./test/../lib/active_record/fixtures.rb:520:in `setup'

...
bunch of smiliar stuff in the middle
...


326) Error:
test_readonly_scoping(ReadOnlyTest):
ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type'
doesn't have a default value: INSERT INTO projects (`name`, `id`)
VALUES ('Active Record', 1)
    ./test/../lib/active_record/connection_adapters/ 
abstract_adapter.rb:78:in
`log'
    ./test/../lib/active_record/connection_adapters/ 
mysql_adapter.rb:181:in
`execute'
    ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:283:in `each'
    ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:253:in `each'
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:251:in `transaction'
    ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:244:in `silence'
    ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures'
    ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures'
    ./test/../lib/active_record/fixtures.rb:487:in `setup'

327) Failure:
test_callback_rollback_in_save(TransactionTest)
[./test/transactions_test.rb:119]:
<false> is not true.

328) Failure:
test_failing_on_exception(TransactionTest) [./test/ 
transactions_test.rb:87]:
First shouldn't have been approved.
<false> is not true.

329) Failure:
test_successful_with_return(TransactionTest) [./test/ 
transactions_test.rb:49]:
<false> is not true.

659 tests, 1142 assertions, 6 failures, 323 errors
rake aborted!
Command failed with status (1): [c:/ruby/ruby-1.8.2-15/ruby/bin/ 
ruby -Ilib;...]
_______________________________________________
Rails-core mailing list
Rails-core@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails-core

_______________________________________________
Rails-core mailing list
Rails-core@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails-core