transportExecutor.exec("select * from sys.shards where match(table_name, 'characters')");
}
@Test
public void testSelectOrderBy() throws Exception {
SQLResponse response = transportExecutor.exec("select * from sys.shards order by table_name");
assertEquals(30L, response.rowCount());
String[] tableNames = {"blobs", "characters", "quotes"};
for (int i=0; i<response.rowCount(); i++) {
int idx = i/10;
assertEquals(tableNames[idx], response.rows()[i][1]);
}
}