note afoken <dl> <dt>[id://907862]</dt> <dd>Problem 1: "<c>limit ?</c>" with [mod://DBD::mysql]. Seems to be a bug introduced in some version of DBD::mysql. Maybe the placeholder support for <c>limit</c> was an accidental feature removed by a "bugfix", but as this "bugfix" breaks existing code, it is a bug, not a bugfix. Maybe it is related to changed placeholder handling code in 4.014 / 4.015, and maybe it could be fixed using the <c>mysql_bind_comment_placeholders</c> attribute. Or it was broken in 3.0008_1, when the LIMIT parsing was changed. I don't know, I don't like MySQL, and so I don't use it.</dd> <dd>Problem 2: Datetime literals with [mod://DBD::ODBC]. Seems to be caused by using an incompatible datetime format in the application, according to [id://907945|the reply] by [id://492557], the maintainer of DBD::ODBC.</dd> <dt>[id://174709]</dt> <dd>Problem 3: "<c>col like ?</c>" instead of "<c>col like 'prefix%'</c>" forces Oracle's query optimizer into a full table scan, because it can no longer see the special case that only col values starting with <c>prefix</c> are relevant and thus an index on <c>col</c> can be used. When I learned to use Oracle, I was told to avoid <c>like</c> when <c>substr</c> can be used. I have no Oracle instance available, but I think the query optimizer should be able to use the index with "<c>substr(col,1,length(:p1))=:p1</c>".</dd> <dt>[id://667081]</dt> <dd>Problem 4: "<c>col in (</c><i>list</i><c>)</c>". Yeah. SQL sucks here. This is not a DBI problem. You have to construct a different SQL statement for each different list length. And in parallel, you can/have to construct a list of parameters to be passed to <c>$sth->bind_param()</c> or <c>$sth->execute()</c>. Or, you use a wrapper to do so: [id://646155]'s [id://686282|reply] proposes to use the special "??" placeholder of [mod://DBIx::Simple].</dd> </dl> <p>I still see no reason to use <c>quote()</c> in all but the first case. And even this "limit" problem would better be fixed by reconfiguring or reparing DBD::mysql, or by downgrading it to the latest "known good" version.</p> <p>Alexander</p> <div class="pmsig"><div class="pmsig-747201"> --<br> Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-) </div></div> 930008 930043