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 // org.hsqldb.test.TestSubQueriesInPreparedStatements this
         0: .line 50
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
            return
        end local 0 // org.hsqldb.test.TestSubQueriesInPreparedStatements this
      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 // java.lang.String[] args
         0: .line 53
            invokestatic org.hsqldb.test.TestSubQueriesInPreparedStatements.test:()V
         1: .line 54
            return
        end local 0 // java.lang.String[] args
      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: .line 63
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
         1: .line 65
            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 /* conn */
        start local 0 // java.sql.Connection conn
         2: .line 66
            aload 0 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            pop
         3: .line 67
            aload 0 /* conn */
            ldc "drop table t if exists"
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
        start local 1 // java.sql.PreparedStatement pstmnt
         4: .line 69
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
         5: .line 71
            aload 0 /* conn */
            ldc "create table t(i decimal)"
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
         6: .line 73
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
         7: .line 75
            aload 0 /* conn */
            ldc "insert into t values(?)"
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
         8: .line 77
            iconst_0
            istore 2 /* i */
        start local 2 // int i
         9: goto 13
        10: .line 78
      StackMap locals: java.sql.Connection java.sql.PreparedStatement int
      StackMap stack:
            aload 1 /* pstmnt */
            iconst_1
            iload 2 /* i */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        11: .line 79
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
        12: .line 77
            iinc 2 /* i */ 1
      StackMap locals:
      StackMap stack:
        13: iload 2 /* i */
            bipush 100
            if_icmplt 10
        end local 2 // int i
        14: .line 82
            aload 0 /* conn */
        15: .line 83
            ldc "select * from (select * from t where i < ?)"
        16: .line 82
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
        17: .line 85
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: 0..3"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        18: .line 86
            aload 1 /* pstmnt */
            iconst_1
            iconst_4
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        19: .line 88
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        start local 2 // java.sql.ResultSet rs
        20: .line 90
            goto 22
        21: .line 91
      StackMap locals: java.sql.Connection java.sql.PreparedStatement java.sql.ResultSet
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.io.PrintStream.println:(I)V
        22: .line 90
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 21
        23: .line 94
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: 0..4"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        24: .line 95
            aload 1 /* pstmnt */
            iconst_1
            iconst_5
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        25: .line 97
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        26: .line 99
            goto 28
        27: .line 100
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.io.PrintStream.println:(I)V
        28: .line 99
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 27
        29: .line 103
            aload 0 /* conn */
        30: .line 104
            ldc "select sum(i) from (select i from t where i between ? and ?)"
        31: .line 103
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
        32: .line 106
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: 9"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        33: .line 107
            aload 1 /* pstmnt */
            iconst_1
            iconst_4
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        34: .line 108
            aload 1 /* pstmnt */
            iconst_2
            iconst_5
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        35: .line 110
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        36: .line 112
            goto 38
        37: .line 113
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.io.PrintStream.println:(I)V
        38: .line 112
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 37
        39: .line 116
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: 15"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        40: .line 117
            aload 1 /* pstmnt */
            iconst_2
            bipush 6
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        41: .line 119
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        42: .line 121
            goto 44
        43: .line 122
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.io.PrintStream.println:(I)V
        44: .line 121
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 43
        45: .line 125
            aload 0 /* conn */
        46: .line 126
            ldc "select * from (select i as c1 from t where i < ?) a, (select i as c2 from t where i < ?) b"
        47: .line 125
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 1 /* pstmnt */
        48: .line 128
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: (0,0)"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        49: .line 129
            aload 1 /* pstmnt */
            iconst_1
            iconst_1
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        50: .line 130
            aload 1 /* pstmnt */
            iconst_2
            iconst_1
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        51: .line 132
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        52: .line 134
            goto 54
        53: .line 135
      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 /* rs */
            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 /* rs */
            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: .line 134
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 53
        55: .line 138
            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: .line 139
            aload 1 /* pstmnt */
            iconst_1
            iconst_2
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        57: .line 140
            aload 1 /* pstmnt */
            iconst_2
            iconst_2
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        58: .line 142
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        59: .line 144
            goto 61
        60: .line 145
      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 /* rs */
            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 /* rs */
            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: .line 144
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 60
        62: .line 148
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Expecting: ((0,0) .. (3,3)"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        63: .line 149
            aload 1 /* pstmnt */
            iconst_1
            iconst_4
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        64: .line 150
            aload 1 /* pstmnt */
            iconst_2
            iconst_4
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        65: .line 152
            aload 1 /* pstmnt */
            invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        66: .line 154
            goto 68
        67: .line 155
      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 /* rs */
            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 /* rs */
            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: .line 154
      StackMap locals:
      StackMap stack:
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 67
        69: .line 157
            return
        end local 2 // java.sql.ResultSet rs
        end local 1 // java.sql.PreparedStatement pstmnt
        end local 0 // java.sql.Connection conn
      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"