possible DB glitch in 1.7

[eluser]Jevedor[/eluser]
I just recently tried updating my CI 1.6.3 to 1.7 and ran into an issue that was not documented in the update guide.

I have a good number of sql scripts that run on my site and any of them that used "AS" became broken after installing the the 1.7 database library.

Here is an example of some code that worked in 1.6.3 but no longer does in 1.7


$this->CI->db->select('a.*, b.page_name AS parent_name');
$this->CI->db->from('pages AS a');
$this->CI->db->join('pages AS b', 'a.parent_id = b.page_id', 'left');
$this->CI->db->where('a.display_status', 'Y');
$this->CI->db->orderby('a.parent_id, a.sort_order');

$this->navigation = $this->CI->db->get();

Has something been deprecated that I am not aware of or Am I doing something incorrectly?

For now i will continue to use 1.6.3 as it still works but I would like to be able to use all of 1.7. Any help would be appreciated.