pager_query, case sensitive SQL queries

Hi,
I'm a new Drupal member, so may this bug appeared to me because I didn't followed the standards while writing the SQL query inside pager_query function.

This is my code:

        $sql = 'select %s from {%s}';
	$rs  = pager_query(db_rewrite_sql($sql), 5, 0, NULL, 'id,year', 'my_table');

According to pager_query code above, if I have 10 records in the table (my_table), then I should got 2 pages with 5 records in each one of them, but what was happened is that I got only one page without any page numbers to navigate.

OK, now if I rewrite the code above as the following:

        $sql = 'SELECT %s FROM {%s}';
	$rs  = pager_query(db_rewrite_sql($sql), 5, 0, NULL, 'id,year', 'my_table');

The code will run in perfect way, and the pages numbers will be displayed and work in normal way.

Now, if we get into the pager_query core code inside pager.inc, we find that:

  if (!isset($count_query)) {
    $count_query = preg_replace(array('/SELECT.*?FROM /As', '/ORDER BY .*/'), array('SELECT COUNT(*) FROM ', ''), $query);
  }

The replacement options for first parameter - /SELECT.*?FROM / - are (As)
(A - PCRE_ANCHORED to match the start of string being searched)
(s - PCRE_DOTALL to include the new lines in search, if the string being searched contains multilines)

And no replacement options for second parameter - /ORDER BY .*/

According to that, the SQL query passed to pager_query (must) be capital case, otherwise you should pass the optional parameter ($count_query) of pager_query function.

The documentation of pager_query doesn't refer to the case sensitivity of the SQL query.