Query inside transaction

AFAIK, there isn't a way to exclude queries from being tracked once transactions begin.

The CI documentation shows a way to disable transactions but he example given will not work.

The example shows this

PHP Code:

$this->db->trans_off();

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->trans_complete(); 


Again THIS WON'T WORK.
Once trans_off() is called the calls to both trans_start() and trans_complete() will immediately return FALSE and that is all.

CI does not provide a method that reverses a call to trans_off(). I'm not sure it matters because I'm not sure that MySql is capable of "pausing" a transaction session once it is started.