Skip to content

Instantly share code, notes, and snippets.

@laurocaetano
Created May 14, 2014 21:31
Show Gist options
  • Save laurocaetano/ca35c32ca39aec19eb1d to your computer and use it in GitHub Desktop.
Save laurocaetano/ca35c32ca39aec19eb1d to your computer and use it in GitHub Desktop.
1) Failure:
MysqlConnectionTest#test_bad_connection [/Users/lauro/src/opensource/rails/rails/activerecord/test/cases/adapters/mysql2/connection_test.rb:20]:
[ActiveRecord::NoDatabaseError] exception expected, not
Class: <Mysql2::Error>
Message: <"Access denied for user 'rails'@'localhost' to database 'inexistent_activerecord_unittest'">
---Backtrace---
/opt/boxen/rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/mysql2-0.3.15/lib/mysql2/client.rb:67:in `connect'
/opt/boxen/rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/mysql2-0.3.15/lib/mysql2/client.rb:67:in `initialize'
/Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
/Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
/Users/lauro/src/opensource/rails/rails/activerecord/test/cases/adapters/mysql2/connection_test.rb:22:in `block in test_bad_connection'
---------------


  2) Error:
BasicsTest#test_group_weirds_by_from:
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column '#<struct Arel::Attributes::Attribute relation=#<Arel::Table:0x007fc4e80995c0 @name="weirds", @engine=Weird(id: integer, a$b: string, なまえ: string, from: string), @columns=nil, @aliases=[]' in 'group statement': SELECT COUNT(*) AS count_all, `weirds`.`from` AS weirds_from FROM `weirds` GROUP BY `#<struct Arel::Attributes::Attribute relation=#<Arel::Table:0x007fc4e80995c0 @name="weirds", @engine=Weird(id: integer, a$b: string, なまえ: string, from: string), @columns=nil, @aliases=[], @table_alias=nil, @primary_key=nil>, name=:from>`
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `block in execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:380:in `block in log'
    /Users/lauro/src/opensource/rails/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:374:in `log'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:236:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `exec_query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:248:in `select'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:314:in `execute_grouped_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:214:in `perform_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:111:in `calculate'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:26:in `count'
    /Users/lauro/src/opensource/rails/rails/activerecord/test/cases/base_test.rb:683:in `test_group_weirds_by_from'


  3) Error:
CalculationsTest#test_should_calculate_grouped_by_function:
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'UPPER(`type`)' in 'group statement': SELECT COUNT(*) AS count_all, UPPER(`type`) AS upper_type FROM `companies` GROUP BY `UPPER(``type``)`
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `block in execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:380:in `block in log'
    /Users/lauro/src/opensource/rails/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:374:in `log'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:236:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `exec_query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:248:in `select'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:314:in `execute_grouped_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:214:in `perform_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:111:in `calculate'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:26:in `count'
    /Users/lauro/src/opensource/rails/rails/activerecord/test/cases/calculations_test.rb:278:in `test_should_calculate_grouped_by_function'


  4) Error:
CalculationsTest#test_should_group_by_arel_attribute:
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column '#<struct Arel::Attributes::Attribute relation=#<Arel::Table:0x007fc4e3fa1ab8 @name="accounts", @engine=Account(id: integer, firm_id: integer, firm_name: string, credit_limit: integer), @column' in 'group statement': SELECT SUM(`accounts`.`credit_limit`) AS sum_credit_limit, `accounts`.`firm_id` AS accounts_firm_id FROM `accounts` GROUP BY `#<struct Arel::Attributes::Attribute relation=#<Arel::Table:0x007fc4e3fa1ab8 @name="accounts", @engine=Account(id: integer, firm_id: integer, firm_name: string, credit_limit: integer), @columns=nil, @aliases=[], @table_alias=nil, @primary_key=nil>, name=:firm_id>`
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `block in execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:380:in `block in log'
    /Users/lauro/src/opensource/rails/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:374:in `log'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:236:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `exec_query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:248:in `select'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:314:in `execute_grouped_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:214:in `perform_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:111:in `calculate'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:67:in `sum'
    /Users/lauro/src/opensource/rails/rails/activerecord/test/cases/calculations_test.rb:77:in `test_should_group_by_arel_attribute'


  5) Error:
CalculationsTest#test_should_group_by_multiple_fields_having_functions:
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'COALESCE(type, title)' in 'group statement': SELECT COUNT(*) AS count_all, author_name AS author_name, COALESCE(type, title) AS coalesce_type_title FROM `topics` GROUP BY `author_name`, `COALESCE(type, title)`
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `block in execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:380:in `block in log'
    /Users/lauro/src/opensource/rails/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:374:in `log'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:320:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:236:in `execute'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `exec_query'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:248:in `select'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:314:in `execute_grouped_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:214:in `perform_calculation'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:111:in `calculate'
    /Users/lauro/src/opensource/rails/rails/activerecord/lib/active_record/relation/calculations.rb:26:in `count'
    /Users/lauro/src/opensource/rails/rails/activerecord/test/cases/calculations_test.rb:89:in `test_should_group_by_multiple_fields_having_functions'



Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment