public ResultSet testUltraliteZ() throws Exception {
    if (this.dbConn_General == null) {
        this.dbConn_General = new DatabaseConnection();
    }
    Connection ulConn_Select = this.dbConn_General.getUltraliteConnection();

    /*PreparedStatement ps = ulConn_Select
            .prepareStatement("DROP TABLE Test");
    ps.execute();*/

    PreparedStatement ps = ulConn_Select
            .prepareStatement("CREATE TABLE Test(id int PRIMARY KEY, col1 VARCHAR(10), col2 INT, col3 LONG BINARY)");
    ps.execute();

    ps = ulConn_Select
            .prepareStatement("INSERT INTO Test VALUES(1, 'Row1', 1, 0x1)");
    ps.execute();

    ps = ulConn_Select
            .prepareStatement("INSERT INTO Test VALUES(2, 'Row2', 2, 0x2)");
    ps.execute();

    ps = ulConn_Select
            .prepareStatement("INSERT INTO Test VALUES(3, 'Row3', 3, 0x3)");
    ps.execute();

    ps = ulConn_Select
            .prepareStatement("SELECT  A.id, A.col1, A.col2, A.col3 "
                    + "FROM (  "
                    + "SELECT P.id "
                    + ",(SELECT col1 FROM Test T WHERE T.id = P.id)       as col1 "
                    + ",(SELECT TOP 1 col2 FROM Test T WHERE T.id = P.id) as col2 "
                    + ",(SELECT TOP 1 col3 FROM Test T WHERE T.id = P.id) as col3 "
                    + "FROM Test P) AS A (id, col1, col2, col3)");

    ResultSet rs = ps.executeQuery();

    rs.first();

    // col1 receives a "" value, but should receive "Row1"
    String col1 = rs.getString("col1");

    // bytes receives a [] value, but should receive 0x1
    bytes = rs.getBytes(4);

    rs.next();
    col1 = rs.getString("col1");
    assertEquals(3, rs.getRowCount(0));
    return rs;
}