public class org.hsqldb.test.TestAllTypes
  minor version: 0
  major version: 59
  flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
  this_class: org.hsqldb.test.TestAllTypes
  super_class: java.lang.Object
{
  protected java.lang.String url;
    descriptor: Ljava/lang/String;
    flags: (0x0004) ACC_PROTECTED

  boolean network;
    descriptor: Z
    flags: (0x0000) 

  java.lang.String user;
    descriptor: Ljava/lang/String;
    flags: (0x0000) 

  java.lang.String password;
    descriptor: Ljava/lang/String;
    flags: (0x0000) 

  java.sql.Statement sStatement;
    descriptor: Ljava/sql/Statement;
    flags: (0x0000) 

  java.sql.Connection cConnection;
    descriptor: Ljava/sql/Connection;
    flags: (0x0000) 

  boolean reportProgress;
    descriptor: Z
    flags: (0x0000) 

  boolean cachedTable;
    descriptor: Z
    flags: (0x0000) 

  int cacheScale;
    descriptor: I
    flags: (0x0000) 

  int logType;
    descriptor: I
    flags: (0x0000) 

  int writeDelay;
    descriptor: I
    flags: (0x0000) 

  boolean indexZip;
    descriptor: Z
    flags: (0x0000) 

  boolean indexLastName;
    descriptor: Z
    flags: (0x0000) 

  boolean addForeignKey;
    descriptor: Z
    flags: (0x0000) 

  boolean refIntegrity;
    descriptor: Z
    flags: (0x0000) 

  boolean createTempTable;
    descriptor: Z
    flags: (0x0000) 

  boolean deleteWhileInsert;
    descriptor: Z
    flags: (0x0000) 

  int deleteWhileInsertInterval;
    descriptor: I
    flags: (0x0000) 

  int bigrows;
    descriptor: I
    flags: (0x0000) 

  public void <init>();
    descriptor: ()V
    flags: (0x0001) ACC_PUBLIC
    Code:
      stack=2, locals=1, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 51
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 53
            aload 0 /* this */
            ldc "jdbc:hsqldb:g:/hsql/testalltypes/test;hsqldb.sqllog=0"
            putfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
         2: .line 56
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestAllTypes.network:Z
         3: .line 63
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestAllTypes.reportProgress:Z
         4: .line 64
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestAllTypes.cachedTable:Z
         5: .line 65
            aload 0 /* this */
            bipush 12
            putfield org.hsqldb.test.TestAllTypes.cacheScale:I
         6: .line 66
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestAllTypes.logType:I
         7: .line 67
            aload 0 /* this */
            bipush 60
            putfield org.hsqldb.test.TestAllTypes.writeDelay:I
         8: .line 68
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestAllTypes.indexZip:Z
         9: .line 69
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestAllTypes.indexLastName:Z
        10: .line 70
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestAllTypes.addForeignKey:Z
        11: .line 71
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestAllTypes.refIntegrity:Z
        12: .line 72
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestAllTypes.createTempTable:Z
        13: .line 75
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestAllTypes.deleteWhileInsert:Z
        14: .line 76
            aload 0 /* this */
            sipush 10000
            putfield org.hsqldb.test.TestAllTypes.deleteWhileInsertInterval:I
        15: .line 79
            aload 0 /* this */
            ldc 1048576
            putfield org.hsqldb.test.TestAllTypes.bigrows:I
        16: .line 51
            return
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   17     0  this  Lorg/hsqldb/test/TestAllTypes;

  protected void setUp();
    descriptor: ()V
    flags: (0x0004) ACC_PROTECTED
    Code:
      stack=4, locals=2, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 83
            aload 0 /* this */
            ldc "sa"
            putfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
         1: .line 84
            aload 0 /* this */
            ldc ""
            putfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
         2: .line 87
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
         3: .line 88
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
         4: .line 90
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
         5: .line 92
            iconst_1
            istore 1 /* createDatabase */
        start local 1 // boolean createDatabase
         6: .line 94
            iload 1 /* createDatabase */
            ifeq 23
         7: .line 95
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
         8: .line 96
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
         9: .line 98
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SET DATABASE EVENT LOG LEVEL 3"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        10: .line 99
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SET FILES LOG SIZE 100"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        11: .line 100
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SET FILES LOG TRUE"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        12: .line 101
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            new java.lang.StringBuilder
            dup
            ldc "SET FILES WRITE DELAY "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.writeDelay:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        13: .line 102
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SET FILES CACHE ROWS 600000"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        14: .line 103
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SET FILES CACHE SIZE 240000"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        15: .line 104
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SHUTDOWN"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        16: .line 105
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
        17: .line 107
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        18: .line 108
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
        end local 1 // boolean createDatabase
        19: .line 110
            goto 23
      StackMap locals:
      StackMap stack: java.lang.Exception
        20: astore 1 /* e */
        start local 1 // java.lang.Exception e
        21: .line 111
            aload 1 /* e */
            invokevirtual java.lang.Exception.printStackTrace:()V
        22: .line 112
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "TestSql.setUp() error: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* e */
            invokevirtual java.lang.Exception.getMessage:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 1 // java.lang.Exception e
        23: .line 114
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot            Name  Signature
            0   24     0            this  Lorg/hsqldb/test/TestAllTypes;
            6   19     1  createDatabase  Z
           21   23     1               e  Ljava/lang/Exception;
      Exception table:
        from    to  target  type
           2    19      20  Class java.lang.Exception

  public void testFillUp();
    descriptor: ()V
    flags: (0x0001) ACC_PUBLIC
    Code:
      stack=8, locals=22, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 123
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 124
            sipush 4095
            istore 2 /* smallrows */
        start local 2 // int smallrows
         2: .line 126
            ldc "DROP TABLE test IF EXISTS;DROP TABLE zip IF EXISTS;"
            astore 3 /* ddl1 */
        start local 3 // java.lang.String ddl1
         3: .line 128
            ldc "CREATE TABLE zip( zip INT IDENTITY );"
            astore 4 /* ddl2 */
        start local 4 // java.lang.String ddl2
         4: .line 129
            new java.lang.StringBuilder
            dup
            ldc "CREATE "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cachedTable:Z
            ifeq 5
            ldc "CACHED "
            goto 6
         5: .line 130
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.lang.String java.lang.String
      StackMap stack: java.lang.StringBuilder
            ldc ""
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.lang.String java.lang.String
      StackMap stack: java.lang.StringBuilder java.lang.String
         6: invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            ldc "TABLE test( id INT IDENTITY,"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
         7: .line 131
            ldc " firstname VARCHAR(128), "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
         8: .line 132
            ldc " lastname VARCHAR(128), "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
         9: .line 133
            ldc " zip SMALLINT, "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        10: .line 134
            ldc " longfield BIGINT, "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        11: .line 135
            ldc " doublefield DOUBLE, "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        12: .line 136
            ldc " bigdecimalfield DECIMAL(19), "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        13: .line 137
            ldc " bigdecimal2field DECIMAL(20,4), "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        14: .line 138
            ldc " datefield DATE, "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        15: .line 139
            ldc " filler VARCHAR(128)); "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        16: .line 129
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 5 /* ddl3 */
        start local 5 // java.lang.String ddl3
        17: .line 142
            ldc "CREATE INDEX idx1 ON TEST (lastname);"
            astore 6 /* ddl4 */
        start local 6 // java.lang.String ddl4
        18: .line 145
            ldc "CREATE INDEX idx2 ON TEST (zip);"
            astore 7 /* ddl5 */
        start local 7 // java.lang.String ddl5
        19: .line 148
            ldc "CREATE INDEX idx3 ON TEST (longfield);"
            astore 8 /* ddl6 */
        start local 8 // java.lang.String ddl6
        20: .line 151
            ldc "CREATE INDEX idx4 ON TEST (bigdecimalfield);"
            astore 9 /* ddl7 */
        start local 9 // java.lang.String ddl7
        21: .line 153
            ldc "CREATE INDEX idx5 ON TEST (bigdecimal2field);"
            astore 10 /* ddl8 */
        start local 10 // java.lang.String ddl8
        22: .line 154
            ldc "CREATE INDEX idx6 ON TEST (datefield);"
            astore 11 /* ddl9 */
        start local 11 // java.lang.String ddl9
        23: .line 157
            ldc "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip);"
        24: .line 156
            astore 12 /* ddl26 */
        start local 12 // java.lang.String ddl26
        25: .line 158
            ldc "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"
            astore 13 /* filler */
        start local 13 // java.lang.String filler
        26: .line 161
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Connecting"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 162
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        28: .line 164
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        29: .line 165
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
        30: .line 166
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        31: .line 168
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "connected: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        32: .line 169
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        33: .line 171
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
        34: .line 173
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 14 /* randomgen */
        start local 14 // java.util.Random randomgen
        35: .line 175
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 3 /* ddl1 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        36: .line 176
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 4 /* ddl2 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        37: .line 177
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 5 /* ddl3 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        38: .line 178
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "test table with no index"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        39: .line 180
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.indexLastName:Z
            ifeq 42
        40: .line 181
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 6 /* ddl4 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        41: .line 182
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "create index on lastname"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        42: .line 185
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.util.Random
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.indexZip:Z
            ifeq 45
        43: .line 186
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 7 /* ddl5 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        44: .line 187
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "create index on zip"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        45: .line 190
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.addForeignKey:Z
            ifeq 48
        46: .line 191
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 12 /* ddl26 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        47: .line 192
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "add foreign key"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        48: .line 197
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 8 /* ddl6 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        49: .line 198
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 9 /* ddl7 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        50: .line 199
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 10 /* ddl8 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        51: .line 200
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            aload 11 /* ddl9 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        52: .line 204
            iconst_0
            istore 15 /* i */
        start local 15 // int i
        53: goto 56
        54: .line 205
      StackMap locals: int
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "INSERT INTO zip VALUES(null);"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        55: .line 204
            iinc 15 /* i */ 1
      StackMap locals:
      StackMap stack:
        56: iload 15 /* i */
            iload 2 /* smallrows */
            if_icmple 54
        57: .line 208
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        58: .line 209
            ldc "INSERT INTO test (firstname,lastname,zip,longfield,doublefield,bigdecimalfield,bigdecimal2field,datefield, filler) VALUES (?,?,?,?,?,?,?,?, ?)"
        59: .line 208
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 16 /* ps */
        start local 16 // java.sql.PreparedStatement ps
        60: .line 211
            aload 16 /* ps */
            iconst_1
            ldc "Julia                 "
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        61: .line 212
            aload 16 /* ps */
            iconst_2
            ldc "Clancy"
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        62: .line 214
            iconst_0
            istore 15 /* i */
            goto 99
        63: .line 215
      StackMap locals: java.sql.PreparedStatement
      StackMap stack:
            aload 16 /* ps */
            iconst_3
            aload 0 /* this */
            aload 14 /* randomgen */
            iload 2 /* smallrows */
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        64: .line 217
            aload 0 /* this */
            aload 14 /* randomgen */
            aload 13 /* filler */
            invokevirtual java.lang.String.length:()I
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            istore 17 /* nextrandom */
        start local 17 // int nextrandom
        65: .line 218
            aload 0 /* this */
            aload 14 /* randomgen */
            aload 13 /* filler */
            invokevirtual java.lang.String.length:()I
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            istore 18 /* randomlength */
        start local 18 // int randomlength
        66: .line 220
            aload 16 /* ps */
            iconst_4
            aload 14 /* randomgen */
            invokevirtual java.util.Random.nextLong:()J
            invokeinterface java.sql.PreparedStatement.setLong:(IJ)V
        67: .line 221
            aload 16 /* ps */
            iconst_5
            aload 14 /* randomgen */
            invokevirtual java.util.Random.nextDouble:()D
            invokeinterface java.sql.PreparedStatement.setDouble:(ID)V
        68: .line 222
            aload 16 /* ps */
            bipush 6
            new java.math.BigDecimal
            dup
            aload 14 /* randomgen */
            invokevirtual java.util.Random.nextLong:()J
            invokespecial java.math.BigDecimal.<init>:(J)V
            invokeinterface java.sql.PreparedStatement.setBigDecimal:(ILjava/math/BigDecimal;)V
        69: .line 224
            aload 16 /* ps */
            bipush 7
            new java.math.BigDecimal
            dup
            aload 14 /* randomgen */
            invokevirtual java.util.Random.nextDouble:()D
            invokespecial java.math.BigDecimal.<init>:(D)V
            invokeinterface java.sql.PreparedStatement.setBigDecimal:(ILjava/math/BigDecimal;)V
        70: .line 225
            aload 16 /* ps */
            bipush 8
            new java.sql.Date
            dup
            aload 0 /* this */
            aload 14 /* randomgen */
            sipush 1000
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            i2l
        71: .line 226
            ldc 24
            lmul
            ldc 3600
            lmul
            ldc 1000
            lmul
            invokespecial java.sql.Date.<init>:(J)V
        72: .line 225
            invokeinterface java.sql.PreparedStatement.setDate:(ILjava/sql/Date;)V
        73: .line 228
            aload 13 /* filler */
            iconst_0
            iload 18 /* randomlength */
            invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
            astore 19 /* varfiller */
        start local 19 // java.lang.String varfiller
        74: .line 230
            aload 16 /* ps */
            bipush 9
            new java.lang.StringBuilder
            dup
            iload 17 /* nextrandom */
            invokestatic java.lang.String.valueOf:(I)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 19 /* varfiller */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        75: .line 231
            aload 16 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        76: .line 233
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
            ifeq 80
            iload 15 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifne 80
        77: .line 234
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Insert "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 15 /* i */
            iconst_1
            iadd
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        78: .line 235
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        79: .line 234
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        80: .line 239
      StackMap locals: int int java.lang.String
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.deleteWhileInsert:Z
            ifeq 98
            iload 15 /* i */
            ifeq 98
        81: .line 240
            iload 15 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.deleteWhileInsertInterval:I
            irem
            ifne 98
        82: .line 241
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "CALL IDENTITY();"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        83: .line 243
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 20 /* rs */
        start local 20 // java.sql.ResultSet rs
        84: .line 245
            aload 20 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        85: .line 247
            aload 20 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 21 /* lastId */
        start local 21 // int lastId
        86: .line 249
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
        87: .line 250
            new java.lang.StringBuilder
            dup
            ldc "SELECT * INTO TEMP tempt FROM test WHERE id > "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
        88: .line 251
            iload 21 /* lastId */
            sipush 4000
            isub
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " ;"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        89: .line 250
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        90: .line 249
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        91: .line 252
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            new java.lang.StringBuilder
            dup
            ldc "DELETE FROM test WHERE id > "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
        92: .line 253
            iload 21 /* lastId */
            sipush 4000
            isub
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " ;"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        93: .line 252
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        94: .line 254
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
        95: .line 255
            ldc "INSERT INTO test SELECT * FROM tempt;"
        96: .line 254
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        97: .line 256
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "DROP TABLE tempt;"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        end local 21 // int lastId
        end local 20 // java.sql.ResultSet rs
        end local 19 // java.lang.String varfiller
        end local 18 // int randomlength
        end local 17 // int nextrandom
        98: .line 214
      StackMap locals:
      StackMap stack:
            iinc 15 /* i */ 1
      StackMap locals:
      StackMap stack:
        99: iload 15 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            if_icmplt 63
       100: .line 263
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Total insert: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 15 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       101: .line 264
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Insert time: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
       102: .line 265
            iload 15 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
       103: .line 264
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       104: .line 266
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
       105: .line 268
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.network:Z
            ifne 107
       106: .line 269
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SHUTDOWN"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       107: .line 272
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
       108: .line 273
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Shutdown Time: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 16 // java.sql.PreparedStatement ps
        end local 15 // int i
        end local 14 // java.util.Random randomgen
       109: .line 274
            goto 112
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String
      StackMap stack: java.sql.SQLException
       110: astore 14 /* e */
        start local 14 // java.sql.SQLException e
       111: .line 275
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 14 /* e */
            invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 14 // java.sql.SQLException e
       112: .line 277
      StackMap locals:
      StackMap stack:
            return
        end local 13 // java.lang.String filler
        end local 12 // java.lang.String ddl26
        end local 11 // java.lang.String ddl9
        end local 10 // java.lang.String ddl8
        end local 9 // java.lang.String ddl7
        end local 8 // java.lang.String ddl6
        end local 7 // java.lang.String ddl5
        end local 6 // java.lang.String ddl4
        end local 5 // java.lang.String ddl3
        end local 4 // java.lang.String ddl2
        end local 3 // java.lang.String ddl1
        end local 2 // int smallrows
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot          Name  Signature
            0  113     0          this  Lorg/hsqldb/test/TestAllTypes;
            1  113     1            sw  Lorg/hsqldb/lib/StopWatch;
            2  113     2     smallrows  I
            3  113     3          ddl1  Ljava/lang/String;
            4  113     4          ddl2  Ljava/lang/String;
           17  113     5          ddl3  Ljava/lang/String;
           18  113     6          ddl4  Ljava/lang/String;
           19  113     7          ddl5  Ljava/lang/String;
           20  113     8          ddl6  Ljava/lang/String;
           21  113     9          ddl7  Ljava/lang/String;
           22  113    10          ddl8  Ljava/lang/String;
           23  113    11          ddl9  Ljava/lang/String;
           25  113    12         ddl26  Ljava/lang/String;
           26  113    13        filler  Ljava/lang/String;
           35  109    14     randomgen  Ljava/util/Random;
           53  109    15             i  I
           60  109    16            ps  Ljava/sql/PreparedStatement;
           65   98    17    nextrandom  I
           66   98    18  randomlength  I
           74   98    19     varfiller  Ljava/lang/String;
           84   98    20            rs  Ljava/sql/ResultSet;
           86   98    21        lastId  I
          111  112    14             e  Ljava/sql/SQLException;
      Exception table:
        from    to  target  type
          26   109     110  Class java.sql.SQLException

  protected void tearDown();
    descriptor: ()V
    flags: (0x0004) ACC_PROTECTED
    Code:
      stack=0, locals=1, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 279
            return
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    1     0  this  Lorg/hsqldb/test/TestAllTypes;

  protected void checkResults();
    descriptor: ()V
    flags: (0x0004) ACC_PROTECTED
    Code:
      stack=4, locals=3, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 284
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 287
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
         2: .line 289
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Reopened database: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         3: .line 290
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
         4: .line 292
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
         5: .line 294
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            new java.lang.StringBuilder
            dup
            ldc "SET FILES WRITE DELAY "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.writeDelay:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         6: .line 299
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SELECT count(*) from TEST"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         7: .line 301
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        start local 2 // java.sql.ResultSet rs
         8: .line 303
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         9: .line 304
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Row Count: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        10: .line 305
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Time to count: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        11: .line 308
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        12: .line 309
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            ldc "SELECT count(*) from TEST where zip > -1"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        13: .line 311
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        14: .line 313
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        15: .line 314
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Row Count: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        16: .line 315
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Time to count: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        17: .line 316
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestAllTypes.checkSelects:()V
        18: .line 317
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestAllTypes.checkUpdates:()V
        19: .line 318
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        20: .line 319
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
        21: .line 320
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Closed connection: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 2 // java.sql.ResultSet rs
        end local 1 // org.hsqldb.lib.StopWatch sw
        22: .line 321
            goto 25
      StackMap locals:
      StackMap stack: java.sql.SQLException
        23: astore 1 /* e */
        start local 1 // java.sql.SQLException e
        24: .line 322
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 1 /* e */
            invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 1 // java.sql.SQLException e
        25: .line 324
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   26     0  this  Lorg/hsqldb/test/TestAllTypes;
            1   22     1    sw  Lorg/hsqldb/lib/StopWatch;
            8   22     2    rs  Ljava/sql/ResultSet;
           24   25     1     e  Ljava/sql/SQLException;
      Exception table:
        from    to  target  type
           0    22      23  Class java.sql.SQLException

  private void checkSelects();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=6, locals=7, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 328
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 329
            sipush 4095
            istore 2 /* smallrows */
        start local 2 // int smallrows
         2: .line 330
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 3 /* randomgen */
        start local 3 // java.util.Random randomgen
         3: .line 331
            iconst_0
            istore 4 /* i */
        start local 4 // int i
         4: .line 332
            iconst_0
            istore 5 /* slow */
        start local 5 // boolean slow
         5: .line 335
            goto 20
         6: .line 336
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.util.Random int int
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
         7: .line 337
            ldc "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?"
         8: .line 336
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
         9: .line 339
            aload 6 /* ps */
            iconst_1
            aload 0 /* this */
            aload 3 /* randomgen */
            iload 2 /* smallrows */
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        10: .line 340
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        11: .line 342
            iload 4 /* i */
            iconst_1
            iadd
            bipush 100
            if_icmpne 13
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldc 5000
            lcmp
            ifle 13
        12: .line 343
            iconst_1
            istore 5 /* slow */
        13: .line 346
      StackMap locals: java.sql.PreparedStatement
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
            ifeq 14
            iload 4 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 15
        14: .line 347
      StackMap locals:
      StackMap stack:
            iload 5 /* slow */
            ifeq 19
            iload 4 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 19
        15: .line 348
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Select "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            iconst_1
            iadd
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        16: .line 349
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        17: .line 350
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        18: .line 348
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 6 // java.sql.PreparedStatement ps
        19: .line 335
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        20: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            iconst_4
            idiv
            if_icmplt 6
        21: .line 353
            goto 23
      StackMap locals:
      StackMap stack: java.sql.SQLException
        22: pop
        23: .line 355
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Select random zip "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        24: .line 356
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        25: .line 357
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        26: .line 355
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 358
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        28: .line 361
            iconst_0
            istore 4 /* i */
            goto 40
        29: .line 362
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        30: .line 363
            ldc "SELECT firstname,lastname,zip,filler FROM test WHERE id = ?"
        31: .line 362
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
        32: .line 365
            aload 6 /* ps */
            iconst_1
            aload 0 /* this */
            aload 3 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        33: .line 366
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        34: .line 368
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
            ifeq 35
            iload 4 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 36
        35: .line 369
      StackMap locals: java.sql.PreparedStatement
      StackMap stack:
            iload 5 /* slow */
            ifeq 39
            iload 4 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 39
        36: .line 370
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Select "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            iconst_1
            iadd
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        37: .line 371
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        38: .line 370
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 6 // java.sql.PreparedStatement ps
        39: .line 361
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        40: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            iconst_4
            idiv
            if_icmplt 29
        41: .line 374
            goto 43
      StackMap locals:
      StackMap stack: java.sql.SQLException
        42: pop
        43: .line 376
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Select random id "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        44: .line 377
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        45: .line 378
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        46: .line 376
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        47: .line 379
            return
        end local 5 // boolean slow
        end local 4 // int i
        end local 3 // java.util.Random randomgen
        end local 2 // int smallrows
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot       Name  Signature
            0   48     0       this  Lorg/hsqldb/test/TestAllTypes;
            1   48     1         sw  Lorg/hsqldb/lib/StopWatch;
            2   48     2  smallrows  I
            3   48     3  randomgen  Ljava/util/Random;
            4   48     4          i  I
            5   48     5       slow  Z
            9   19     6         ps  Ljava/sql/PreparedStatement;
           32   39     6         ps  Ljava/sql/PreparedStatement;
      Exception table:
        from    to  target  type
           5    21      22  Class java.sql.SQLException
          28    41      42  Class java.sql.SQLException

  private void checkUpdates();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=8, locals=9, args_size=1
        start local 0 // org.hsqldb.test.TestAllTypes this
         0: .line 383
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 384
            sipush 4095
            istore 2 /* smallrows */
        start local 2 // int smallrows
         2: .line 385
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 3 /* randomgen */
        start local 3 // java.util.Random randomgen
         3: .line 386
            iconst_0
            istore 4 /* i */
        start local 4 // int i
         4: .line 387
            iconst_0
            istore 5 /* slow */
        start local 5 // boolean slow
         5: .line 388
            iconst_0
            istore 6 /* count */
        start local 6 // int count
         6: .line 391
            goto 18
         7: .line 392
      StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.util.Random int int int
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
         8: .line 393
            ldc "UPDATE test SET filler = filler || zip WHERE zip = ?"
         9: .line 392
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 7 /* ps */
        start local 7 // java.sql.PreparedStatement ps
        10: .line 394
            aload 0 /* this */
            aload 3 /* randomgen */
            iload 2 /* smallrows */
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            istore 8 /* random */
        start local 8 // int random
        11: .line 396
            aload 7 /* ps */
            iconst_1
            iload 8 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        12: .line 398
            iload 6 /* count */
            aload 7 /* ps */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            iadd
            istore 6 /* count */
        13: .line 400
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
            ifeq 17
            iload 6 /* count */
            sipush 10000
            irem
            bipush 20
            if_icmpge 17
        14: .line 401
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Update "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 6 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        15: .line 402
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        16: .line 401
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 8 // int random
        end local 7 // java.sql.PreparedStatement ps
        17: .line 391
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        18: iload 4 /* i */
            iload 2 /* smallrows */
            if_icmplt 7
        19: .line 405
            goto 21
      StackMap locals:
      StackMap stack: java.sql.SQLException
        20: pop
        21: .line 407
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Update with random zip "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        22: .line 408
            ldc " UPDATE commands, "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 6 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        23: .line 409
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        24: .line 410
            iload 6 /* count */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lconst_1
            ladd
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        25: .line 407
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        26: .line 411
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        27: .line 414
            iconst_0
            istore 4 /* i */
            goto 41
        28: .line 415
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
        29: .line 416
            ldc "UPDATE test SET zip = zip + 1 WHERE id = ?"
        30: .line 415
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 7 /* ps */
        start local 7 // java.sql.PreparedStatement ps
        31: .line 417
            aload 0 /* this */
            aload 3 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
            istore 8 /* random */
        start local 8 // int random
        32: .line 419
            aload 7 /* ps */
            iconst_1
            iload 8 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        33: .line 420
            aload 7 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        34: .line 422
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
            ifeq 35
            iload 4 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 36
        35: .line 423
      StackMap locals: java.sql.PreparedStatement int
      StackMap stack:
            iload 5 /* slow */
            ifeq 40
            iload 4 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 40
        36: .line 424
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Update "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            iconst_1
            iadd
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        37: .line 425
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        38: .line 426
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        39: .line 424
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 8 // int random
        end local 7 // java.sql.PreparedStatement ps
        40: .line 414
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        41: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestAllTypes.bigrows:I
            bipush 8
            idiv
            if_icmplt 28
        42: .line 429
            goto 44
      StackMap locals:
      StackMap stack: java.sql.SQLException
        43: pop
        44: .line 431
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Update with random id "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 4 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        45: .line 432
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " rps: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        46: .line 433
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lconst_1
            ladd
            ldiv
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        47: .line 431
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        48: .line 434
            return
        end local 6 // int count
        end local 5 // boolean slow
        end local 4 // int i
        end local 3 // java.util.Random randomgen
        end local 2 // int smallrows
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot       Name  Signature
            0   49     0       this  Lorg/hsqldb/test/TestAllTypes;
            1   49     1         sw  Lorg/hsqldb/lib/StopWatch;
            2   49     2  smallrows  I
            3   49     3  randomgen  Ljava/util/Random;
            4   49     4          i  I
            5   49     5       slow  Z
            6   49     6      count  I
           10   17     7         ps  Ljava/sql/PreparedStatement;
           11   17     8     random  I
           31   40     7         ps  Ljava/sql/PreparedStatement;
           32   40     8     random  I
      Exception table:
        from    to  target  type
           6    19      20  Class java.sql.SQLException
          27    42      43  Class java.sql.SQLException

  int nextIntRandom(java.util.Random, int);
    descriptor: (Ljava/util/Random;I)I
    flags: (0x0000) 
    Code:
      stack=2, locals=4, args_size=3
        start local 0 // org.hsqldb.test.TestAllTypes this
        start local 1 // java.util.Random r
        start local 2 // int range
         0: .line 438
            aload 1 /* r */
            invokevirtual java.util.Random.nextInt:()I
            istore 3 /* b */
        start local 3 // int b
         1: .line 440
            iload 3 /* b */
            ldc -2147483648
            if_icmpne 3
         2: .line 441
            ldc 2147483647
            istore 3 /* b */
         3: .line 444
      StackMap locals: int
      StackMap stack:
            iload 3 /* b */
            invokestatic java.lang.Math.abs:(I)I
            istore 3 /* b */
         4: .line 446
            iload 3 /* b */
            iload 2 /* range */
            irem
            ireturn
        end local 3 // int b
        end local 2 // int range
        end local 1 // java.util.Random r
        end local 0 // org.hsqldb.test.TestAllTypes this
      LocalVariableTable:
        Start  End  Slot   Name  Signature
            0    5     0   this  Lorg/hsqldb/test/TestAllTypes;
            0    5     1      r  Ljava/util/Random;
            0    5     2  range  I
            1    5     3      b  I
    MethodParameters:
       Name  Flags
      r      
      range  

  public static void main(java.lang.String[]);
    descriptor: ([Ljava/lang/String;)V
    flags: (0x0009) ACC_PUBLIC, ACC_STATIC
    Code:
      stack=4, locals=3, args_size=1
        start local 0 // java.lang.String[] argv
         0: .line 451
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 452
            new org.hsqldb.test.TestAllTypes
            dup
            invokespecial org.hsqldb.test.TestAllTypes.<init>:()V
            astore 2 /* test */
        start local 2 // org.hsqldb.test.TestAllTypes test
         2: .line 454
            aload 2 /* test */
            invokevirtual org.hsqldb.test.TestAllTypes.setUp:()V
         3: .line 455
            aload 2 /* test */
            invokevirtual org.hsqldb.test.TestAllTypes.testFillUp:()V
         4: .line 458
            aload 2 /* test */
            invokevirtual org.hsqldb.test.TestAllTypes.checkResults:()V
         5: .line 459
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Total Test Time: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         6: .line 460
            return
        end local 2 // org.hsqldb.test.TestAllTypes test
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // java.lang.String[] argv
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    7     0  argv  [Ljava/lang/String;
            1    7     1    sw  Lorg/hsqldb/lib/StopWatch;
            2    7     2  test  Lorg/hsqldb/test/TestAllTypes;
    MethodParameters:
      Name  Flags
      argv  
}
SourceFile: "TestAllTypes.java"