/**
* @test
* @see http://forge.typo3.org/issues/15366
*/
public function canParseUniqueIndexCreation()
{
$sql = 'ALTER TABLE static_territories ADD UNIQUE uid (uid)';
$expected = $sql;
$alterTables = $this->subject->_callRef('parseALTERTABLE', $sql);
$queries = $this->subject->compileSQL($alterTables);
$this->assertEquals($expected, $queries);
}
/**
* @test
* @see http://forge.typo3.org/issues/23374
*/
public function questionMarkParametersMayBeSafelyReplaced()
{
$sql = 'SELECT * FROM pages WHERE pid = ? AND timestamp < ? AND title != \'How to test?\'';
$parameterValues = array(12, 1281782690);
$components = $this->subject->_callRef('parseSELECT', $sql);
$questionMarkParamCount = count($components['parameters']['?']);
for ($i = 0; $i < $questionMarkParamCount; $i++) {
$components['parameters']['?'][$i][0] = $parameterValues[$i];
}
$result = $this->subject->compileSQL($components);
$expected = 'SELECT * FROM pages WHERE pid = 12 AND timestamp < 1281782690 AND title != \'How to test?\'';
$this->assertEquals($expected, $this->cleanSql($result));
}
