KohanaPHP » Kohana v2.x

Causes #1049, #1062.

When caching is disabled, a call to clear_cache() is required for introspection to return correct results. clear_cache() should have no effect with caching disabled.

Test Case:

$db = new Database(array(
  'cache' => FALSE,
  'connection' => array(
    'type' => 'mysql',
    'host' => 'localhost',
    'socket' => TRUE,
    'user' => 'root',
    'pass' => 'password',
    'database' => 'testing',
  ),
));

$db->query('CREATE TABLE testtable ( first integer )');
$result1 = $db->list_fields('testtable'); // 1

$db->query('ALTER TABLE testtable ADD second integer');
$result2 = $db->list_fields('testtable'); // 2

// Correct results are obtained after clearing the cache
$db->clear_cache();
$result3 = $db->list_fields('testtable'); // 3

$db->query('DROP TABLE testtable');

try {
  $result4 = $db->list_fields('testtable'); // 4
} catch (Kohana_Database_Exception $de) {
  $result4 = FALSE;
}

• Results 1 and 2 match.
• Results 2 and 3 differ.
• Results 3 and 4 match.

• Results 1 and 2 should differ.
• Results 2 and 3 should match.
• Call 4 should throw an exception.
• $result1 should contain one more element than $result2.
• $db->clear_cache() should have no effect.

Possible Solution:

Utilize the regular query cache by calling $this->query() for introspection rather than mysql_query() directly.