<?xml version="1.0" encoding="UTF-8"?>
<ticket>
  <assigned-user-id type="integer">14510</assigned-user-id>
  <attachments-count type="integer">0</attachments-count>
  <closed type="boolean">true</closed>
  <created-at type="datetime">2008-08-06T19:03:03-04:00</created-at>
  <creator-id type="integer">14510</creator-id>
  <milestone-due-on type="datetime" nil="true"></milestone-due-on>
  <milestone-id type="integer" nil="true"></milestone-id>
  <number type="integer">2</number>
  <permalink>rails-2-1-0-compatability-bug</permalink>
  <priority type="integer">2</priority>
  <project-id type="integer">14379</project-id>
  <raw-data type="binary" nil="true" encoding="base64"></raw-data>
  <state>resolved</state>
  <tag>rails2.1.0</tag>
  <title>Rails 2.1.0 compatability bug</title>
  <updated-at type="datetime">2008-08-06T19:41:48-04:00</updated-at>
  <user-id type="integer">14510</user-id>
  <user-name>Zach Dennis</user-name>
  <creator-name>Zach Dennis</creator-name>
  <assigned-user-name>Zach Dennis</assigned-user-name>
  <url>http://zdennis.lighthouseapp.com/projects/14379/tickets/2</url>
  <original-body>ar-extensions is breaking the following test Rails 2.1.0:

* HasManyAssociationsTest#test_find_with_blank_conditions

test_find_with_blank_conditions(HasManyAssociationsTest):
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' ' at line 1: SELECT * FROM `companies`     WHERE (`companies`.firm_id = 1 AND ()) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' OR `companies`.`type` = 'VerySpecialClient' ) )  ORDER BY id
    ./lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute_without_counting'
    ./test/cases/helper.rb:38:in `execute'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select'
    ./lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
    ./lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
    ./lib/active_record/base.rb:582:in `find_by_sql'
    ./lib/active_record/base.rb:1341:in `find_every'
    ./lib/active_record/base.rb:536:in `find'
    ./lib/active_record/associations/association_collection.rb:47:in `find'
    ./test/cases/associations/has_many_associations_test.rb:57:in `test_find_with_blank_conditions'
    ./test/cases/associations/has_many_associations_test.rb:56:in `each'
    ./test/cases/associations/has_many_associations_test.rb:56:in `test_find_with_blank_conditions'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run'</original-body>
  <latest-body>ar-extensions is breaking the following test Rails 2.1.0:

* HasManyAssociationsTest#test_find_with_blank_conditions

test_find_with_blank_conditions(HasManyAssociationsTest):
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' ' at line 1: SELECT * FROM `companies`     WHERE (`companies`.firm_id = 1 AND ()) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' OR `companies`.`type` = 'VerySpecialClient' ) )  ORDER BY id
    ./lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute_without_counting'
    ./test/cases/helper.rb:38:in `execute'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select'
    ./lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
    ./lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
    ./lib/active_record/base.rb:582:in `find_by_sql'
    ./lib/active_record/base.rb:1341:in `find_every'
    ./lib/active_record/base.rb:536:in `find'
    ./lib/active_record/associations/association_collection.rb:47:in `find'
    ./test/cases/associations/has_many_associations_test.rb:57:in `test_find_with_blank_conditions'
    ./test/cases/associations/has_many_associations_test.rb:56:in `each'
    ./test/cases/associations/has_many_associations_test.rb:56:in `test_find_with_blank_conditions'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run'</latest-body>
  <original-body-html>&lt;div&gt;&lt;p&gt;ar-extensions is breaking the following test Rails 2.1.0:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;HasManyAssociationsTest#test&lt;em&gt;find&lt;/em&gt;with&lt;em&gt;blank&lt;/em&gt;conditions&lt;/li&gt;
&lt;/ul&gt;


&lt;p&gt;test&lt;em&gt;find&lt;/em&gt;with&lt;em&gt;blank&lt;/em&gt;conditions(HasManyAssociationsTest):
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND ( (&lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'Client' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'SpecialClient' ' at line 1: SELECT * FROM &lt;code&gt;companies&lt;/code&gt;     WHERE (&lt;code&gt;companies&lt;/code&gt;.firm_id = 1 AND ()) AND ( (&lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'Client' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'SpecialClient' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'VerySpecialClient' ) )  ORDER BY id&lt;/p&gt;

&lt;pre&gt;&lt;code&gt;./lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute_without_counting'
./test/cases/helper.rb:38:in `execute'
./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select'
./lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
./lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
./lib/active_record/base.rb:582:in `find_by_sql'
./lib/active_record/base.rb:1341:in `find_every'
./lib/active_record/base.rb:536:in `find'
./lib/active_record/associations/association_collection.rb:47:in `find'
./test/cases/associations/has_many_associations_test.rb:57:in `test_find_with_blank_conditions'
./test/cases/associations/has_many_associations_test.rb:56:in `each'
./test/cases/associations/has_many_associations_test.rb:56:in `test_find_with_blank_conditions'
./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__'
./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run'
&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;</original-body-html>
  <versions type="array">
    <version type="Ticket::Version">
      <assigned-user-id type="integer">14510</assigned-user-id>
      <attachments-count type="integer">0</attachments-count>
      <body>ar-extensions is breaking the following test Rails 2.1.0:

* HasManyAssociationsTest#test_find_with_blank_conditions

test_find_with_blank_conditions(HasManyAssociationsTest):
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' ' at line 1: SELECT * FROM `companies`     WHERE (`companies`.firm_id = 1 AND ()) AND ( (`companies`.`type` = 'Client' OR `companies`.`type` = 'SpecialClient' OR `companies`.`type` = 'VerySpecialClient' ) )  ORDER BY id
    ./lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute_without_counting'
    ./test/cases/helper.rb:38:in `execute'
    ./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select'
    ./lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
    ./lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
    ./lib/active_record/base.rb:582:in `find_by_sql'
    ./lib/active_record/base.rb:1341:in `find_every'
    ./lib/active_record/base.rb:536:in `find'
    ./lib/active_record/associations/association_collection.rb:47:in `find'
    ./test/cases/associations/has_many_associations_test.rb:57:in `test_find_with_blank_conditions'
    ./test/cases/associations/has_many_associations_test.rb:56:in `each'
    ./test/cases/associations/has_many_associations_test.rb:56:in `test_find_with_blank_conditions'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__'
    ./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run'</body>
      <body-html>&lt;div&gt;&lt;p&gt;ar-extensions is breaking the following test Rails 2.1.0:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;HasManyAssociationsTest#test&lt;em&gt;find&lt;/em&gt;with&lt;em&gt;blank&lt;/em&gt;conditions&lt;/li&gt;
&lt;/ul&gt;


&lt;p&gt;test&lt;em&gt;find&lt;/em&gt;with&lt;em&gt;blank&lt;/em&gt;conditions(HasManyAssociationsTest):
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND ( (&lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'Client' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'SpecialClient' ' at line 1: SELECT * FROM &lt;code&gt;companies&lt;/code&gt;     WHERE (&lt;code&gt;companies&lt;/code&gt;.firm_id = 1 AND ()) AND ( (&lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'Client' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'SpecialClient' OR &lt;code&gt;companies&lt;/code&gt;.&lt;code&gt;type&lt;/code&gt; = 'VerySpecialClient' ) )  ORDER BY id&lt;/p&gt;

&lt;pre&gt;&lt;code&gt;./lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute_without_counting'
./test/cases/helper.rb:38:in `execute'
./test/cases/../../lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select'
./lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
./lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
./lib/active_record/base.rb:582:in `find_by_sql'
./lib/active_record/base.rb:1341:in `find_every'
./lib/active_record/base.rb:536:in `find'
./lib/active_record/associations/association_collection.rb:47:in `find'
./test/cases/associations/has_many_associations_test.rb:57:in `test_find_with_blank_conditions'
./test/cases/associations/has_many_associations_test.rb:56:in `each'
./test/cases/associations/has_many_associations_test.rb:56:in `test_find_with_blank_conditions'
./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__'
./lib/../../activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run'
&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;</body-html>
      <closed type="boolean">false</closed>
      <created-at type="datetime">2008-08-06T19:03:04-04:00</created-at>
      <creator-id type="integer">14510</creator-id>
      <diffable-attributes type="yaml">--- {}

</diffable-attributes>
      <milestone-id type="integer" nil="true"></milestone-id>
      <number type="integer">2</number>
      <permalink>rails-2-1-0-compatability-bug</permalink>
      <priority type="integer">0</priority>
      <project-id type="integer">14379</project-id>
      <state>new</state>
      <tag>rails2.1.0</tag>
      <title>Rails 2.1.0 compatability bug</title>
      <updated-at type="datetime">2008-08-06T19:03:04-04:00</updated-at>
      <user-id type="integer">14510</user-id>
      <user-name>Zach Dennis</user-name>
      <creator-name>Zach Dennis</creator-name>
      <assigned-user-name>Zach Dennis</assigned-user-name>
      <url>http://zdennis.lighthouseapp.com/projects/14379/tickets/2</url>
    </version>
    <version type="Ticket::Version">
      <assigned-user-id type="integer">14510</assigned-user-id>
      <attachments-count type="integer">0</attachments-count>
      <body>Fixed in http://github.com/zdennis/ar-extensions/commit/8388e3015c0dc8ef3cd2d89c4f68a838a4440e9d</body>
      <body-html>&lt;div&gt;&lt;p&gt;Fixed in &lt;a href=&quot;http://github.com/zdennis/ar-extensions/commit/8388e3015c0dc8ef3cd2d89c4f68a838a4440e9d&quot;&gt;http://github.com/zdennis/ar-ext...&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</body-html>
      <closed type="boolean">true</closed>
      <created-at type="datetime">2008-08-06T19:41:48-04:00</created-at>
      <creator-id type="integer">14510</creator-id>
      <diffable-attributes type="yaml">--- 
:state: new
</diffable-attributes>
      <milestone-id type="integer" nil="true"></milestone-id>
      <number type="integer">2</number>
      <permalink>rails-2-1-0-compatability-bug</permalink>
      <priority type="integer">0</priority>
      <project-id type="integer">14379</project-id>
      <state>resolved</state>
      <tag>rails2.1.0</tag>
      <title>Rails 2.1.0 compatability bug</title>
      <updated-at type="datetime">2008-08-06T19:41:48-04:00</updated-at>
      <user-id type="integer">14510</user-id>
      <user-name>Zach Dennis</user-name>
      <creator-name>Zach Dennis</creator-name>
      <assigned-user-name>Zach Dennis</assigned-user-name>
      <url>http://zdennis.lighthouseapp.com/projects/14379/tickets/2</url>
    </version>
  </versions>
</ticket>
