public void TestTeradataRenameTable()
{
parser.sqltext = "RENAME TABLE renA TO renX;";
int ret = parser.parse();
Assert.IsTrue(ret == 0, parser.Errormessage);
Assert.IsTrue(parser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstrename);
TRenameStmt renameTable = (TRenameStmt)parser.sqlstatements.get(0);
Assert.IsTrue(renameTable.NewName.ToString().Equals("renX", StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(renameTable.OldName.ToString().Equals("renA", StringComparison.CurrentCultureIgnoreCase));
}
public void testColumn()
{
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "RENAME COLUMN customer.customer_num TO c_num;";
Assert.IsTrue(sqlparser.parse() == 0);
TRenameStmt stmt = (TRenameStmt)sqlparser.sqlstatements.get(0);
Assert.IsTrue(stmt.OldName.ToString().Equals("customer.customer_num", StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(stmt.NewName.ToString().Equals("c_num", StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(stmt.ObjectType == EDbObjectType.column);
}
public void testTable()
{
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "RENAME TABLE new_table TO items;";
Assert.IsTrue(sqlparser.parse() == 0);
TRenameStmt stmt = (TRenameStmt)sqlparser.sqlstatements.get(0);
Assert.IsTrue(stmt.OldName.ToString().Equals("new_table", StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(stmt.NewName.ToString().Equals("items", StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(stmt.ObjectType == EDbObjectType.table);
}
