test canonical ddl through adhoc