@Test
public void shouldParseCreateTableWithConstraint() {

    printTest("shouldParseCreateTableWithConstraint()");
    String tableName = "MY_TABLE_B";
    String content = "CREATE TABLE MY_TABLE_B (PARTID VARCHAR (255), PRIMARY KEY (C1, C2), \nPARTCOLOR INTEGER NOT NULL, CONSTRAINT PK_A PRIMARY KEY (FILE_UID) );";
    DdlTokenStream tokens = getTokens(content);
    AstNode result = parser.parseCreateTableStatement(tokens, rootNode);
    assertEquals(1, rootNode.getChildCount());
    AstNode tableNode = rootNode.getChildren().get(0);
    assertThat(result, is(tableNode));
    assertEquals(tableName, tableNode.getName());
    assertEquals(4, tableNode.getChildCount()); // 2 COLUMNs + 2 PRIMARY KEY CONSTRAINTS (BOGUS)
    AstNode column1 = tableNode.getChildren().get(0);
    assertEquals("VARCHAR", column1.getProperty(DATATYPE_NAME));
    assertEquals(255L, column1.getProperty(DATATYPE_LENGTH));
    assertTrue(column1.getProperty(DATATYPE_PRECISION) == null);
}