function test_add_meta_data_columns()
{
$parser = new SQL_Parser(null, 'MySQL');
$compiler = new SQL_Compiler();
$sql = "SELECT a,b,c from Foo";
$parsed = $parser->parse($sql);
$wrapper = new SQL_Parser_wrapper($parsed);
$wrapper->addMetaDataColumns();
$sql = $compiler->compile($parsed);
$this->assertEquals("select a, b, c, length(a) as __a_length, length(b) as __b_length, length(c) as __c_length from Foo", $sql);
// make sure that doing it twice doesn't do anything
$wrapper->addMetaDataColumns();
$sql = $compiler->compile($parsed);
$this->assertEquals("select a, b, c, length(a) as __a_length, length(b) as __b_length, length(c) as __c_length from Foo", $sql);
}
