Class PGF1010962
- java.lang.Object
-
- org.postgresql.pljava.example.annotation.PGF1010962
-
@SQLAction(requires="1010962 func", install={"CREATE TYPE javatest.B1010962 AS ( b1_val float8, b2_val int)","CREATE TYPE javatest.C1010962 AS ( c1_val float8, c2_val float8)","CREATE TYPE javatest.A1010962 as ( b B1010962, c C1010962, a_val int)","SELECT javatest.complexParam(array_agg( CAST( ( CAST((0.1, i) AS javatest.B1010962), CAST((0.1, 10/i) AS javatest.C1010962), i ) AS javatest.A1010962) )) FROM generate_series (1,10) i"}, remove={"DROP TYPE javatest.A1010962","DROP TYPE javatest.C1010962","DROP TYPE javatest.B1010962"}) public class PGF1010962 extends Object
A gnarly test of TupleDesc reference management, crafted by Johann Oskarsson for bug report 1010962 on pgFoundry.
-
-
Constructor Summary
Constructors Constructor Description PGF1010962()
-
Method Summary
Modifier and Type Method Description static int
complexParam(ResultSet[] receiver)
Test for bug 1010962: pass in an array of A1010962, expect no TupleDesc reference leak warnings.
-
-
-
Constructor Detail
-
PGF1010962
public PGF1010962()
-
-
Method Detail
-
complexParam
@Function(schema="javatest", provides="1010962 func") public static int complexParam(ResultSet[] receiver) throws SQLException
Test for bug 1010962: pass in an array of A1010962, expect no TupleDesc reference leak warnings.- Parameters:
receiver
- Looks polymorphic, but expects an array of A1010962- Returns:
- 0
- Throws:
SQLException
-
-