Пример #1
0
  @Test
  public void createTemporaryTableAsSelect() {
    Table table = new Table("A_SCHEMA", "A_TABLE_AS_SELECT");
    CreateTable ct = new CreateTable(table);
    ct.setTemporary(true);

    PlainSelect select = new PlainSelect();
    Table selectTable = new Table("A_SCHEMA", "Table", "Alias");
    select.setSelectItems(Arrays.asList(new ISelectItem[] {new AllTableColumns(selectTable)}));
    select.setTableReference(selectTable);
    ct.setSelect(select);

    String sql = sqlGenerator.generateSQL(ct);

    Assert.assertNotNull(sql);
    Assert.assertEquals(
        "CREATE GLOBAL TEMPORARY TABLE A_SCHEMA.A_TABLE_AS_SELECT ON COMMIT PRESERVE ROWS AS SELECT Alias.* FROM A_SCHEMA.Table AS Alias",
        sql);
  }
Пример #2
0
  @Test
  public void testCreateTemporaryComplexTableWithPrimaryKey() {
    CreateTable createTable = new CreateTable(new Table("A_SCHEMA", "COMPLEX_TABLE"));
    createTable.setTemporary(true);

    List<TableElement> columns = new ArrayList<TableElement>();
    columns.add(new ColumnDefinition("field1", new CharacterDataType(25), true));
    columns.add(new ColumnDefinition("field2", new CharacterDataType(25), true));
    columns.add(new ColumnDefinition("field3", new CharacterDataType(25)));
    columns.add(
        new UniqueConstraintDefinition(
            UniqueConstraintType.primaryKey, Arrays.asList(new String[] {"field1", "field2"})));
    createTable.setTableElements(columns);

    String sql = sqlGenerator.generateSQL(createTable);

    Assert.assertNotNull(sql);
    Assert.assertEquals(
        "CREATE GLOBAL TEMPORARY TABLE A_SCHEMA.COMPLEX_TABLE ( field1 VARCHAR(25) NOT NULL,\nfield2 VARCHAR(25) NOT NULL,\nfield3 VARCHAR(25),\nPRIMARY KEY (field1, field2) ) ON COMMIT PRESERVE ROWS",
        sql);
  }