/**
* Ensure the system columns are present. See issue #196.
*
* @return void
*/
public function testRetrieveSystemColumns()
{
$metaModel = new MetaModel(array('id' => '1', 'sorting' => '256', 'tstamp' => '1367274071', 'name' => 'Test RetrieveSystemColumns', 'tableName' => 'mm_test_retrieve', 'translated' => '1', 'languages' => serialize(array('en' => array('isfallback' => '1'), 'de' => array('isfallback' => '0'))), 'varsupport' => ''));
$rows = array(1 => array('id' => 1, 'pid' => 0, 'sorting' => 1, 'tstamp' => 343094400));
$database = Database::getNewTestInstance();
$metaModel->setServiceContainer($this->mockServiceContainer($database));
$database->getQueryCollection()->theQuery('SELECT * FROM mm_test_retrieve WHERE id IN (?) ORDER BY FIELD(id,?)')->with(1, 1)->result()->addRows($rows);
$this->assertEquals($metaModel->getName(), 'Test RetrieveSystemColumns');
$item = $metaModel->findById(1);
$this->assertEquals(1, $item->get('id'));
$this->assertEquals(0, $item->get('pid'));
$this->assertEquals(1, $item->get('sorting'));
$this->assertEquals(343094400, $item->get('tstamp'));
$this->assertNull($item->get('varbase'));
$this->assertNull($item->get('vargroup'));
}