<?xml version="1.0" encoding="UTF-8"?>
<ticket>
  <assigned-user-id type="integer" nil="true"></assigned-user-id>
  <attachments-count type="integer">0</attachments-count>
  <closed type="boolean">true</closed>
  <created-at type="datetime">2008-09-13T20:36:29+01:00</created-at>
  <creator-id type="integer">10285</creator-id>
  <milestone-due-on type="datetime" nil="true"></milestone-due-on>
  <milestone-id type="integer">9903</milestone-id>
  <number type="integer">1041</number>
  <permalink>mysql-adapter-quoting-bug-when-searching-with-bigdecimal</permalink>
  <priority type="integer">473</priority>
  <project-id type="integer">8994</project-id>
  <raw-data type="binary" nil="true" encoding="base64"></raw-data>
  <state>duplicate</state>
  <tag>activerecord</tag>
  <title>Mysql Adapter quoting bug when searching with BigDecimal</title>
  <updated-at type="datetime">2008-12-10T14:39:52+00:00</updated-at>
  <user-id type="integer">17477</user-id>
  <user-name>Frederick Cheung</user-name>
  <creator-name>Steve Martocci</creator-name>
  <url>http://rails.lighthouseapp.com/projects/8994/tickets/1041</url>
  <milestone-title>2.x</milestone-title>
  <original-body>BigDecimals must be converted to strings but without quotes when being used in mysql querys in order to match results.  The current implementation in mysql_adapter does the proper formatting, but wraps it in single quotes.  This is a simple one line fix with major implications for those using :decimal columns.  

Here is a Gist of the change

http://gist.github.com/10643</original-body>
  <latest-body>BigDecimals must be converted to strings but without quotes when being used in mysql querys in order to match results.  The current implementation in mysql_adapter does the proper formatting, but wraps it in single quotes.  This is a simple one line fix with major implications for those using :decimal columns.  

Here is a Gist of the change

http://gist.github.com/10643</latest-body>
  <original-body-html>&lt;div&gt;&lt;p&gt;BigDecimals must be converted to strings but without quotes when
being used in mysql querys in order to match results. The current
implementation in mysql_adapter does the proper formatting, but
wraps it in single quotes. This is a simple one line fix with major
implications for those using :decimal columns.&lt;/p&gt;
&lt;p&gt;Here is a Gist of the change&lt;/p&gt;
&lt;p&gt;&lt;a href=&quot;http://gist.github.com/10643&quot;&gt;http://gist.github.com/10643&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</original-body-html>
  <versions type="array">
    <version type="Ticket::Version">
      <assigned-user-id type="integer" nil="true"></assigned-user-id>
      <attachments-count type="integer">0</attachments-count>
      <body>BigDecimals must be converted to strings but without quotes when being used in mysql querys in order to match results.  The current implementation in mysql_adapter does the proper formatting, but wraps it in single quotes.  This is a simple one line fix with major implications for those using :decimal columns.  

Here is a Gist of the change

http://gist.github.com/10643</body>
      <body-html>&lt;div&gt;&lt;p&gt;BigDecimals must be converted to strings but without quotes when
being used in mysql querys in order to match results. The current
implementation in mysql_adapter does the proper formatting, but
wraps it in single quotes. This is a simple one line fix with major
implications for those using :decimal columns.&lt;/p&gt;
&lt;p&gt;Here is a Gist of the change&lt;/p&gt;
&lt;p&gt;&lt;a href=&quot;http://gist.github.com/10643&quot;&gt;http://gist.github.com/10643&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</body-html>
      <closed type="boolean">false</closed>
      <created-at type="datetime">2008-09-13T20:36:29+01:00</created-at>
      <creator-id type="integer">10285</creator-id>
      <diffable-attributes type="yaml">--- {}

</diffable-attributes>
      <milestone-id type="integer">9903</milestone-id>
      <number type="integer">1041</number>
      <permalink>mysql-adapter-quoting-bug-when-searching-with-bigdecimal</permalink>
      <priority type="integer">0</priority>
      <project-id type="integer">8994</project-id>
      <state>new</state>
      <tag>activerecord</tag>
      <title>Mysql Adapter quoting bug when searching with BigDecimal</title>
      <updated-at type="datetime">2008-09-13T20:36:38+01:00</updated-at>
      <user-id type="integer">10285</user-id>
      <user-name>Steve Martocci</user-name>
      <creator-name>Steve Martocci</creator-name>
      <url>http://rails.lighthouseapp.com/projects/8994/tickets/1041</url>
      <milestone-title>2.x</milestone-title>
    </version>
    <version type="Ticket::Version">
      <assigned-user-id type="integer" nil="true"></assigned-user-id>
      <attachments-count type="integer">0</attachments-count>
      <body>Duplicate of #1168 (since fixed)</body>
      <body-html>&lt;div&gt;&lt;p&gt;Duplicate of &lt;a href=&quot;/projects/8994/tickets/1168&quot; title=&quot;Ticket #1168&quot;&gt;#1168&lt;/a&gt; (since fixed)&lt;/p&gt;&lt;/div&gt;</body-html>
      <closed type="boolean">true</closed>
      <created-at type="datetime">2008-12-10T14:39:51+00:00</created-at>
      <creator-id type="integer">10285</creator-id>
      <diffable-attributes type="yaml">--- 
:state: new
</diffable-attributes>
      <milestone-id type="integer">9903</milestone-id>
      <number type="integer">1041</number>
      <permalink>mysql-adapter-quoting-bug-when-searching-with-bigdecimal</permalink>
      <priority type="integer">0</priority>
      <project-id type="integer">8994</project-id>
      <state>duplicate</state>
      <tag>activerecord</tag>
      <title>Mysql Adapter quoting bug when searching with BigDecimal</title>
      <updated-at type="datetime">2008-12-10T14:39:52+00:00</updated-at>
      <user-id type="integer">17477</user-id>
      <user-name>Frederick Cheung</user-name>
      <creator-name>Steve Martocci</creator-name>
      <url>http://rails.lighthouseapp.com/projects/8994/tickets/1041</url>
      <milestone-title>2.x</milestone-title>
    </version>
  </versions>
</ticket>
