[eluser]Unknown[/eluser]
I'm performing a batch insert with the active record class. The periods within my column names are getting back ticked; I don't want this to happen. So, in DB_driver.php, I have tried adding '.' to the protected identifiers list:
var $_reserved_identifiers = array('*','.');
This doesn't work and I am still getting an error when performing an Active Record batch insert on tables with '.' in the column names:
Unknown column 'gameplay.base.FBCSpend' in 'field list'
INSERT INTO `matt37` (`activity_date`, `game`, `gameplay`.`base`.`FBCSpend`, etc...
I want CI to refer to the column as `gameplay.base.FBCSpend`
and NOT as `gameplay`.`base`.`FBCSpend`
Any ideas on how to prevent the backticking of periods? I already have gotten batch inserts to work elsewhere in CI.