SQLite3 Datasource - Wrong regexp to get field names

[ghost]

Created by Sebastian Isaac Velasco, 30th Jun 2011. (originally Lighthouse ticket #24):

---

What happened

The function resultSet (dbo_sqlite3.php) has a regexp to extract the field name from the columns defined like:

field_expression AS field_name

The current regexp is a bit weak and sometimes (using virtual fields) the field name is not the correct.
The code to modify is:

https://github.com/cakephp/datasources/blob/master/models/datasources/dbo/dbo_sqlite3.php

534            if (preg_match('/.*AS (.*).*/i', $selects[$j], $matches)) {

What I expected to happen

The code should be like:

https://github.com/cakephp/cakephp/blob/2.0/lib/Cake/Model/Datasource/Database/Sqlite.php

302            if (preg_match('/\bAS\s+(.*)/i', $selects[$j], $matches)) {

Thanks for all !!!