Hello,
We are using symfony framework in our projects and we found some BUG/
PROBLEM that is a bit confused for us.
Problem is with order by columns that have 'string' type.
We found in sources such lines for building ORDER BY columns with
MySQL DB Adapter
in BasePeer class
00821 if ($column && $column->getType() == 'string') {
00822 $orderByClause[] = $db-
>ignoreCaseInOrderBy("$tableAlias.$columnAlias") . $direction;
00823 $selectClause[] = $db-
>ignoreCaseInOrderBy("$tableAlias.$columnAlias");
00824 }
00825 else {
00826 $orderByClause[] = $orderByColumn;
00827 }
and $db->ignoreCaseInOrderBy() is pointing to
00054 public function ignoreCase($in)
00055 {
00056 return "UPPER(" . $in . ")";
00057 }
in DBMysql class
We are wondering if this is some BUG because we want use ORDER BY
without this UPPER function and have no idea how to make that without
changing that code in core libs.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
-~----------~----~----~----~------~----~------~--~---
