private void testPoundSymbolInColumnName() throws SQLException {
  deleteDb("oracle");
  Connection conn=getConnection("oracle;MODE=Oracle");
  Statement stat=conn.createStatement();
  stat.execute("CREATE TABLE TEST(ID INT PRIMARY KEY, U##NAME VARCHAR(255))");
  stat.execute("INSERT INTO TEST VALUES(1, 'Hello'), (2, 'HelloWorld'), (3, 'HelloWorldWorld')");
  assertResult("1",stat,"SELECT ID FROM TEST where U##NAME ='Hello'");
  conn.close();
}

private void testPoundSymbolInColumnName ( ) throws SQLException { deleteDb ( "oracle" ) ; Connection conn = getConnection ( "oracle;MODE=Oracle" ) ; Statement stat = conn . createStatement ( ) ; stat . execute ( "CREATE TABLE TEST(ID INT PRIMARY KEY, U##NAME VARCHAR(255))" ) ; stat . execute ( "INSERT INTO TEST VALUES(1, 'Hello'), (2, 'HelloWorld'), (3, 'HelloWorldWorld')" ) ; assertResult ( "1" , stat , "SELECT ID FROM TEST where U##NAME ='Hello'" ) ; conn . close ( ) ; }
test the # in a column name for oracle compatibility
