KohanaPHP » Kohana v3.x » ORM

sqlite has virtual tables which can be used for (amongst other things) powerful full text searches. virtual tables are special in that they don't have any indexes, they don't have any field types, and nor do they have a pk you define. they automatically come with a pk called 'rowid'. the problem is when a user searches on a virtual table using the wildcard *, all fields are returned, EXCEPT the rowid. you need to specifically ask for the rowid should you need it, so: select rowid, * from foo;

This seems to have a knock-on effect for the _loaded property of ORM classes, in that, even if a row is found from something like: ORM::factory('foo')->where('bar', '=', 'asdf')->find(),as the pk isn't returned, _loaded seems to be wrongly set to false, and neither is the pk accessible in the orm object;

as i understand there are two solutions, to not rely on the pk being present for such a situation when setting _loaded, using other fields as well, or, instead of searching with tbl.*, listing each field specifically in the query. as the $_primary_key is specified in the model as 'rowid', it would solve the above problem as the id would be specifically asked for it.