Title
#users-public
iamnota goodman

iamnota goodman

04/23/2022, 10:47 AM
@Test
public void testShowTablesWithAlphabeticalOrder() throws Exception {
    assertMemoryLeak(() -> {
        String tableNames = "wyoxbaivdumesgftclkprhzqjn";
        for (int i = 0; i < tableNames.length(); ++i){
            String sql = "create table " + tableNames.charAt(i) + " (cust_id int, ccy symbol, balance double)";
            compiler.compile(sql, sqlExecutionContext);
        }
        assertQuery("table\na\nb\nc\nd\ne\nf\ng\nh\ni\nj\nk\nl\nm\nn\no\np\nq\nr\ns\nt\nu\nv\nw\nx\ny\nz\n", "show tables", null, false, sqlExecutionContext, false);
    });
}