public class org.hsqldb.test.TestSubQueriesInPreparedStatements
minor version: 0
major version: 59
flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
this_class: org.hsqldb.test.TestSubQueriesInPreparedStatements
super_class: java.lang.Object
{
public void <init>();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
invokespecial java.lang.Object.<init>:()V
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 1 0 this Lorg/hsqldb/test/TestSubQueriesInPreparedStatements;
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=0, locals=1, args_size=1
start local 0 0: invokestatic org.hsqldb.test.TestSubQueriesInPreparedStatements.test:()V
1: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 args [Ljava/lang/String;
Exceptions:
throws java.lang.Exception
MethodParameters:
Name Flags
args
public static void test();
descriptor: ()V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=4, locals=3, args_size=0
0: ldc "org.hsqldb.jdbc.JDBCDriver"
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
1: ldc "jdbc:hsqldb:mem:test"
ldc "sa"
ldc ""
invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 0
start local 0 2: aload 0
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
pop
3: aload 0
ldc "drop table t if exists"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
start local 1 4: aload 1
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
5: aload 0
ldc "create table t(i decimal)"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
6: aload 1
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
7: aload 0
ldc "insert into t values(?)"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
8: iconst_0
istore 2
start local 2 9: goto 13
10: StackMap locals: java.sql.Connection java.sql.PreparedStatement int
StackMap stack:
aload 1
iconst_1
iload 2
invokeinterface java.sql.PreparedStatement.setInt:(II)V
11: aload 1
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
12: iinc 2 1
StackMap locals:
StackMap stack:
13: iload 2
bipush 100
if_icmplt 10
end local 2 14: aload 0
15: ldc "select * from (select * from t where i < ?)"
16: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
17: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: 0..3"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
18: aload 1
iconst_1
iconst_4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
19: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
start local 2 20: goto 22
21: StackMap locals: java.sql.Connection java.sql.PreparedStatement java.sql.ResultSet
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.io.PrintStream.println:(I)V
22: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 21
23: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: 0..4"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
24: aload 1
iconst_1
iconst_5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
25: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
26: goto 28
27: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.io.PrintStream.println:(I)V
28: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 27
29: aload 0
30: ldc "select sum(i) from (select i from t where i between ? and ?)"
31: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
32: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: 9"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
33: aload 1
iconst_1
iconst_4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
34: aload 1
iconst_2
iconst_5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
35: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
36: goto 38
37: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.io.PrintStream.println:(I)V
38: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 37
39: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: 15"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
40: aload 1
iconst_2
bipush 6
invokeinterface java.sql.PreparedStatement.setInt:(II)V
41: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
42: goto 44
43: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.io.PrintStream.println:(I)V
44: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 43
45: aload 0
46: ldc "select * from (select i as c1 from t where i < ?) a, (select i as c2 from t where i < ?) b"
47: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 1
48: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: (0,0)"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
49: aload 1
iconst_1
iconst_1
invokeinterface java.sql.PreparedStatement.setInt:(II)V
50: aload 1
iconst_2
iconst_1
invokeinterface java.sql.PreparedStatement.setInt:(II)V
51: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
52: goto 54
53: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "("
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;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 2
iconst_2
invokeinterface java.sql.ResultSet.getInt:(I)I
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;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
54: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 53
55: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: ((0,0), (0,1), (1,0), (1,1)"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
56: aload 1
iconst_1
iconst_2
invokeinterface java.sql.PreparedStatement.setInt:(II)V
57: aload 1
iconst_2
iconst_2
invokeinterface java.sql.PreparedStatement.setInt:(II)V
58: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
59: goto 61
60: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "("
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;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 2
iconst_2
invokeinterface java.sql.ResultSet.getInt:(I)I
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;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
61: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 60
62: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Expecting: ((0,0) .. (3,3)"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
63: aload 1
iconst_1
iconst_4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
64: aload 1
iconst_2
iconst_4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
65: aload 1
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 2
66: goto 68
67: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "("
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;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 2
iconst_2
invokeinterface java.sql.ResultSet.getInt:(I)I
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;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
68: StackMap locals:
StackMap stack:
aload 2
invokeinterface java.sql.ResultSet.next:()Z
ifne 67
69: return
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
2 70 0 conn Ljava/sql/Connection;
4 70 1 pstmnt Ljava/sql/PreparedStatement;
9 14 2 i I
20 70 2 rs Ljava/sql/ResultSet;
Exceptions:
throws java.lang.Exception
}
SourceFile: "TestSubQueriesInPreparedStatements.java"