@Test (expected=InvalidCreateAsException.class)
public void createTableAs6() throws Exception {

    makeSeparateAIS();
    String sql = "CREATE TABLE t1 (c1, c2, c3) AS (SELECT column1, column2 FROM t2) WITH NO DATA";
    createTableAsMixGenerateAIS();
    StatementNode stmt = parser.parseStatement(sql);
    assertTrue (stmt instanceof CreateTableNode);
    List<String> columnNames = Arrays.asList("column1", "column2");
    DataTypeDescriptor d = new DataTypeDescriptor(TypeId.INTEGER_ID, false);
    List<DataTypeDescriptor> descriptors = Arrays.asList(d,d);
    TableDDL.createTable(ddlFunctions, null, DEFAULT_SCHEMA, (CreateTableNode)stmt, null, descriptors ,columnNames, null);
}