FuelPHP Forums

I've got the latest commit locally. I try to check the operation on MariaDB / MySQL using the PDO and everything works correctly! So there is only problem with PostgreSQL.

Please analyze the following queries and responses:

$sql = "SELECT * FROM users";

// MYSQL

$aUser = \DB::query($sql, \DB::SELECT)->execute('mysql_test')->current();
var_dump($aUser);

----
/var/www/(...)/fuel/packages/myauth/classes/auth.php:41:
array (size=6)
  'id' => string '1' (length=1)
  'login' => string 'test' (length=4)
  'password' => string 'hash_password' (length=13)
  'name' => string 'test' (length=4)
  'surname' => string 'TESTxxxTEST' (length=11)
  'status' => string '1' (length=1)
----

$aUser = \DB::select()->from('users')->execute('mysql_test')->current();
var_dump($aUser);

----
/var/www/(...)/fuel/packages/myauth/classes/auth.php:45:
array (size=6)
  'id' => string '1' (length=1)
  'login' => string 'test' (length=4)
  'password' => string 'hash_password' (length=13)
  'name' => string 'test' (length=4)
  'surname' => string 'TESTxxxTEST' (length=11)
  'status' => string '1' (length=1)
----

// POSTGRESQL

$aUser = \DB::query($sql, \DB::SELECT)->execute()->current();
var_dump($aUser);

----
/var/www/(...)/fuel/packages/myauth/classes/auth.php:51:null
----

$aUser = \DB::select()->from('users')->execute()->current();   
var_dump($aUser);

----
/var/www/(...)/fuel/packages/myauth/classes/auth.php:55:null
----

$aUser = \DB::query($sql, \DB::SELECT)->execute();
foreach ($aUser as $aDetail)
{
    var_dump($aDetail);
}

----
/var/www/(...)/fuel/packages/myauth/classes/auth.php:61:
array (size=6)
  'id' => int 1
  'login' => string 'test' (length=4)
  'password' => string 'hash_password' (length=13)
  'name' => string 'test' (length=4)
  'surname' => string 'TESTxxxTEST' (length=11)
  'status' => int 1
----

I think I found a problem. In the above tests for Postgres I had the directive enable_cache=false; for MySQL I didn't have it at all (default is enable_cache=true). I noticed this checking for you what the execute () method returns :)

For Postgres it was Fuel\Core\Database_PDO_Result object, and for MySQL Fuel\Core\Database_PDO_Cached. Try to switch enable_cache to false to check what happend in your projects.

What exactly this option is for (enable_cache) ?