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 0: aload 0
invokespecial java.lang.Object.<init>:()V
1: aload 0
ldc "jdbc:hsqldb:g:/hsql/testalltypes/test;hsqldb.sqllog=0"
putfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
2: aload 0
iconst_0
putfield org.hsqldb.test.TestAllTypes.network:Z
3: aload 0
iconst_1
putfield org.hsqldb.test.TestAllTypes.reportProgress:Z
4: aload 0
iconst_1
putfield org.hsqldb.test.TestAllTypes.cachedTable:Z
5: aload 0
bipush 12
putfield org.hsqldb.test.TestAllTypes.cacheScale:I
6: aload 0
iconst_1
putfield org.hsqldb.test.TestAllTypes.logType:I
7: aload 0
bipush 60
putfield org.hsqldb.test.TestAllTypes.writeDelay:I
8: aload 0
iconst_1
putfield org.hsqldb.test.TestAllTypes.indexZip:Z
9: aload 0
iconst_0
putfield org.hsqldb.test.TestAllTypes.indexLastName:Z
10: aload 0
iconst_0
putfield org.hsqldb.test.TestAllTypes.addForeignKey:Z
11: aload 0
iconst_1
putfield org.hsqldb.test.TestAllTypes.refIntegrity:Z
12: aload 0
iconst_0
putfield org.hsqldb.test.TestAllTypes.createTempTable:Z
13: aload 0
iconst_0
putfield org.hsqldb.test.TestAllTypes.deleteWhileInsert:Z
14: aload 0
sipush 10000
putfield org.hsqldb.test.TestAllTypes.deleteWhileInsertInterval:I
15: aload 0
ldc 1048576
putfield org.hsqldb.test.TestAllTypes.bigrows:I
16: return
end local 0 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 0: aload 0
ldc "sa"
putfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
1: aload 0
ldc ""
putfield org.hsqldb.test.TestAllTypes.password:Ljava/lang/String;
2: aload 0
aconst_null
putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
3: aload 0
aconst_null
putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
4: ldc "org.hsqldb.jdbc.JDBCDriver"
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
5: iconst_1
istore 1
start local 1 6: iload 1
ifeq 23
7: aload 0
aload 0
getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
aload 0
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: aload 0
aload 0
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: aload 0
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: aload 0
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: aload 0
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: aload 0
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
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: aload 0
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: aload 0
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: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
16: aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
17: aload 0
aload 0
getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
aload 0
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: aload 0
aload 0
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 19: goto 23
StackMap locals:
StackMap stack: java.lang.Exception
20: astore 1
start local 1 21: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
22: 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
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 23: StackMap locals:
StackMap stack:
return
end local 0 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 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: sipush 4095
istore 2
start local 2 2: ldc "DROP TABLE test IF EXISTS;DROP TABLE zip IF EXISTS;"
astore 3
start local 3 3: ldc "CREATE TABLE zip( zip INT IDENTITY );"
astore 4
start local 4 4: new java.lang.StringBuilder
dup
ldc "CREATE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestAllTypes.cachedTable:Z
ifeq 5
ldc "CACHED "
goto 6
5: 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: ldc " firstname VARCHAR(128), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
8: ldc " lastname VARCHAR(128), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
9: ldc " zip SMALLINT, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
10: ldc " longfield BIGINT, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
11: ldc " doublefield DOUBLE, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
12: ldc " bigdecimalfield DECIMAL(19), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
13: ldc " bigdecimal2field DECIMAL(20,4), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
14: ldc " datefield DATE, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
15: ldc " filler VARCHAR(128)); "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
16: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 5
start local 5 17: ldc "CREATE INDEX idx1 ON TEST (lastname);"
astore 6
start local 6 18: ldc "CREATE INDEX idx2 ON TEST (zip);"
astore 7
start local 7 19: ldc "CREATE INDEX idx3 ON TEST (longfield);"
astore 8
start local 8 20: ldc "CREATE INDEX idx4 ON TEST (bigdecimalfield);"
astore 9
start local 9 21: ldc "CREATE INDEX idx5 ON TEST (bigdecimal2field);"
astore 10
start local 10 22: ldc "CREATE INDEX idx6 ON TEST (datefield);"
astore 11
start local 11 23: ldc "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip);"
24: astore 12
start local 12 25: ldc "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"
astore 13
start local 13 26: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Connecting"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
28: aload 0
aconst_null
putfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
29: aload 0
aconst_null
putfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
30: aload 0
aload 0
getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
aload 0
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: 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
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: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
33: aload 0
aload 0
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: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 14
start local 14 35: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 3
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
36: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 4
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
37: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 5
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
38: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "test table with no index"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
39: aload 0
getfield org.hsqldb.test.TestAllTypes.indexLastName:Z
ifeq 42
40: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 6
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
41: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "create index on lastname"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
42: 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
getfield org.hsqldb.test.TestAllTypes.indexZip:Z
ifeq 45
43: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
44: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "create index on zip"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
45: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.addForeignKey:Z
ifeq 48
46: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 12
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
47: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "add foreign key"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
48: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 8
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
49: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 9
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
50: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 10
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
51: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
aload 11
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
52: iconst_0
istore 15
start local 15 53: goto 56
54: StackMap locals: int
StackMap stack:
aload 0
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: iinc 15 1
StackMap locals:
StackMap stack:
56: iload 15
iload 2
if_icmple 54
57: aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
58: ldc "INSERT INTO test (firstname,lastname,zip,longfield,doublefield,bigdecimalfield,bigdecimal2field,datefield, filler) VALUES (?,?,?,?,?,?,?,?, ?)"
59: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 16
start local 16 60: aload 16
iconst_1
ldc "Julia "
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
61: aload 16
iconst_2
ldc "Clancy"
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
62: iconst_0
istore 15
goto 99
63: StackMap locals: java.sql.PreparedStatement
StackMap stack:
aload 16
iconst_3
aload 0
aload 14
iload 2
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
64: aload 0
aload 14
aload 13
invokevirtual java.lang.String.length:()I
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
istore 17
start local 17 65: aload 0
aload 14
aload 13
invokevirtual java.lang.String.length:()I
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
istore 18
start local 18 66: aload 16
iconst_4
aload 14
invokevirtual java.util.Random.nextLong:()J
invokeinterface java.sql.PreparedStatement.setLong:(IJ)V
67: aload 16
iconst_5
aload 14
invokevirtual java.util.Random.nextDouble:()D
invokeinterface java.sql.PreparedStatement.setDouble:(ID)V
68: aload 16
bipush 6
new java.math.BigDecimal
dup
aload 14
invokevirtual java.util.Random.nextLong:()J
invokespecial java.math.BigDecimal.<init>:(J)V
invokeinterface java.sql.PreparedStatement.setBigDecimal:(ILjava/math/BigDecimal;)V
69: aload 16
bipush 7
new java.math.BigDecimal
dup
aload 14
invokevirtual java.util.Random.nextDouble:()D
invokespecial java.math.BigDecimal.<init>:(D)V
invokeinterface java.sql.PreparedStatement.setBigDecimal:(ILjava/math/BigDecimal;)V
70: aload 16
bipush 8
new java.sql.Date
dup
aload 0
aload 14
sipush 1000
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
i2l
71: ldc 24
lmul
ldc 3600
lmul
ldc 1000
lmul
invokespecial java.sql.Date.<init>:(J)V
72: invokeinterface java.sql.PreparedStatement.setDate:(ILjava/sql/Date;)V
73: aload 13
iconst_0
iload 18
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 19
start local 19 74: aload 16
bipush 9
new java.lang.StringBuilder
dup
iload 17
invokestatic java.lang.String.valueOf:(I)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 19
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: aload 16
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
76: aload 0
getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
ifeq 80
iload 15
iconst_1
iadd
sipush 10000
irem
ifne 80
77: 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
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: aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
80: StackMap locals: int int java.lang.String
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.deleteWhileInsert:Z
ifeq 98
iload 15
ifeq 98
81: iload 15
aload 0
getfield org.hsqldb.test.TestAllTypes.deleteWhileInsertInterval:I
irem
ifne 98
82: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
ldc "CALL IDENTITY();"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
83: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 20
start local 20 84: aload 20
invokeinterface java.sql.ResultSet.next:()Z
pop
85: aload 20
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 21
start local 21 86: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
87: new java.lang.StringBuilder
dup
ldc "SELECT * INTO TEMP tempt FROM test WHERE id > "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
88: iload 21
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: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
90: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
91: aload 0
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: iload 21
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: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
94: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
95: ldc "INSERT INTO test SELECT * FROM tempt;"
96: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
97: aload 0
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 end local 20 end local 19 end local 18 end local 17 98: StackMap locals:
StackMap stack:
iinc 15 1
StackMap locals:
StackMap stack:
99: iload 15
aload 0
getfield org.hsqldb.test.TestAllTypes.bigrows:I
if_icmplt 63
100: 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
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: 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
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: iload 15
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
104: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
105: aload 0
getfield org.hsqldb.test.TestAllTypes.network:Z
ifne 107
106: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
107: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
108: 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
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 end local 15 end local 14 109: 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
start local 14 111: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 14
invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 14 112: StackMap locals:
StackMap stack:
return
end local 13 end local 12 end local 11 end local 10 end local 9 end local 8 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 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 0: return
end local 0 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 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: aload 0
aload 0
getfield org.hsqldb.test.TestAllTypes.url:Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestAllTypes.user:Ljava/lang/String;
aload 0
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: 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
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: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
4: aload 0
aload 0
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: aload 0
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
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: aload 0
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: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
start local 2 8: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
9: 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
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: 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
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: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
12: aload 0
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: aload 0
getfield org.hsqldb.test.TestAllTypes.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
14: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
15: 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
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: 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
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: aload 0
invokevirtual org.hsqldb.test.TestAllTypes.checkSelects:()V
18: aload 0
invokevirtual org.hsqldb.test.TestAllTypes.checkUpdates:()V
19: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
20: aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
21: 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
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 end local 1 22: goto 25
StackMap locals:
StackMap stack: java.sql.SQLException
23: astore 1
start local 1 24: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 1
invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 1 25: StackMap locals:
StackMap stack:
return
end local 0 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 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: sipush 4095
istore 2
start local 2 2: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: goto 20
6: StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.util.Random int int
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
7: ldc "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?"
8: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 6
start local 6 9: aload 6
iconst_1
aload 0
aload 3
iload 2
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
10: aload 6
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
11: iload 4
iconst_1
iadd
bipush 100
if_icmpne 13
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
ldc 5000
lcmp
ifle 13
12: iconst_1
istore 5
13: StackMap locals: java.sql.PreparedStatement
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
ifeq 14
iload 4
iconst_1
iadd
sipush 10000
irem
ifeq 15
14: StackMap locals:
StackMap stack:
iload 5
ifeq 19
iload 4
iconst_1
iadd
bipush 100
irem
ifne 19
15: 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
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: aload 1
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: iload 4
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 6 19: StackMap locals:
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
20: iload 4
aload 0
getfield org.hsqldb.test.TestAllTypes.bigrows:I
iconst_4
idiv
if_icmplt 6
21: goto 23
StackMap locals:
StackMap stack: java.sql.SQLException
22: pop
23: 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
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
24: aload 1
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: iload 4
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
28: iconst_0
istore 4
goto 40
29: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
30: ldc "SELECT firstname,lastname,zip,filler FROM test WHERE id = ?"
31: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 6
start local 6 32: aload 6
iconst_1
aload 0
aload 3
aload 0
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: aload 6
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
34: aload 0
getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
ifeq 35
iload 4
iconst_1
iadd
sipush 10000
irem
ifeq 36
35: StackMap locals: java.sql.PreparedStatement
StackMap stack:
iload 5
ifeq 39
iload 4
iconst_1
iadd
bipush 100
irem
ifne 39
36: 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
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: aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 6 39: StackMap locals:
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
40: iload 4
aload 0
getfield org.hsqldb.test.TestAllTypes.bigrows:I
iconst_4
idiv
if_icmplt 29
41: goto 43
StackMap locals:
StackMap stack: java.sql.SQLException
42: pop
43: 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
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
44: aload 1
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: iload 4
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
47: return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 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 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: sipush 4095
istore 2
start local 2 2: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: iconst_0
istore 6
start local 6 6: goto 18
7: StackMap locals: org.hsqldb.test.TestAllTypes org.hsqldb.lib.StopWatch int java.util.Random int int int
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
8: ldc "UPDATE test SET filler = filler || zip WHERE zip = ?"
9: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 7
start local 7 10: aload 0
aload 3
iload 2
iconst_1
isub
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
istore 8
start local 8 11: aload 7
iconst_1
iload 8
invokeinterface java.sql.PreparedStatement.setInt:(II)V
12: iload 6
aload 7
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
iadd
istore 6
13: aload 0
getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
ifeq 17
iload 6
sipush 10000
irem
bipush 20
if_icmpge 17
14: 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
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
15: aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 8 end local 7 17: StackMap locals:
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
18: iload 4
iload 2
if_icmplt 7
19: goto 21
StackMap locals:
StackMap stack: java.sql.SQLException
20: pop
21: 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
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
22: ldc " UPDATE commands, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 6
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
23: aload 1
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: iload 6
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
26: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
27: iconst_0
istore 4
goto 41
28: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestAllTypes.cConnection:Ljava/sql/Connection;
29: ldc "UPDATE test SET zip = zip + 1 WHERE id = ?"
30: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 7
start local 7 31: aload 0
aload 3
aload 0
getfield org.hsqldb.test.TestAllTypes.bigrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestAllTypes.nextIntRandom:(Ljava/util/Random;I)I
istore 8
start local 8 32: aload 7
iconst_1
iload 8
invokeinterface java.sql.PreparedStatement.setInt:(II)V
33: aload 7
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
34: aload 0
getfield org.hsqldb.test.TestAllTypes.reportProgress:Z
ifeq 35
iload 4
iconst_1
iadd
sipush 10000
irem
ifeq 36
35: StackMap locals: java.sql.PreparedStatement int
StackMap stack:
iload 5
ifeq 40
iload 4
iconst_1
iadd
bipush 100
irem
ifne 40
36: 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
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: aload 1
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: iload 4
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 8 end local 7 40: StackMap locals:
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
41: iload 4
aload 0
getfield org.hsqldb.test.TestAllTypes.bigrows:I
bipush 8
idiv
if_icmplt 28
42: goto 44
StackMap locals:
StackMap stack: java.sql.SQLException
43: pop
44: 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
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
45: aload 1
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: iload 4
sipush 1000
imul
i2l
aload 1
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: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
48: return
end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 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 start local 1 start local 2 0: aload 1
invokevirtual java.util.Random.nextInt:()I
istore 3
start local 3 1: iload 3
ldc -2147483648
if_icmpne 3
2: ldc 2147483647
istore 3
3: StackMap locals: int
StackMap stack:
iload 3
invokestatic java.lang.Math.abs:(I)I
istore 3
4: iload 3
iload 2
irem
ireturn
end local 3 end local 2 end local 1 end local 0 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 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new org.hsqldb.test.TestAllTypes
dup
invokespecial org.hsqldb.test.TestAllTypes.<init>:()V
astore 2
start local 2 2: aload 2
invokevirtual org.hsqldb.test.TestAllTypes.setUp:()V
3: aload 2
invokevirtual org.hsqldb.test.TestAllTypes.testFillUp:()V
4: aload 2
invokevirtual org.hsqldb.test.TestAllTypes.checkResults:()V
5: 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
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: return
end local 2 end local 1 end local 0 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"