SQlite3-Driver Problem using table named "order"

[ghost]

Created by Knut Alboldt, 4th Dec 2012. (originally Lighthouse ticket #46):

---

I found a small glitch in the SQLite(3)-Driver (cakephp 2.2.3, ./lib/Cake/Model/Datasource/Database/Sqlite.php):

I named a table "order". When using "Console/cake bake" I*ve got an Error (sorry, can't remember the right msg now) at the line 475:

475: $indexes = $this->query('PRAGMA index_list(' . $table . ')');

Obviously, "order" is interpreted as a keyword here. Changed the line to

475: $indexes = $this->query('PRAGMA index_list("' . $table . '")');

and "bake" works.

Maybe you could check, if I'm right.

Thanks

Knut