Supporting uppercased SQL statment in splitQuery()

beata wrote: Well, I think some developers prefer using uppercase of SQL statement than lowercase. (like me...)

However, if we' using uppercased SQL statement, we'll get an error message.
Because the regular expression in the first line of spliteQuery() is case sensitive.

Code: Select all

$count = $this->getRow(
  preg_replace(
    array('/select(.*)from /As', '/order by (.*)/'),
    array('select count(*) as total from ', ''),
    $sql, 1)
);

Although we could make it insensitive through adding ignore case mod in the regular expression.
But every time after update, we got to change the default source file manually.

Would it be possible to be support in the next release?