diff options
| author | Robert Haas <rhaas@postgresql.org> | 2012-02-13 23:43:24 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2012-02-13 23:43:24 -0500 |
| commit | dc66f1c5f2a6e93d949252a0ad661388e1fe7856 (patch) | |
| tree | 2e8de1ed2c138d683c17f8ebecc8c7104b8ffd09 /src | |
| parent | e37e448650dfd9f4afdf916843015c5cb33346c8 (diff) | |
| download | postgresql-dc66f1c5f2a6e93d949252a0ad661388e1fe7856.tar.gz postgresql-dc66f1c5f2a6e93d949252a0ad661388e1fe7856.zip | |
Remove new, intermittently failing regression test.
Per buildfarm.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/create_function_3.out | 42 | ||||
| -rw-r--r-- | src/test/regress/sql/create_function_3.sql | 24 |
2 files changed, 1 insertions, 65 deletions
diff --git a/src/test/regress/expected/create_function_3.out b/src/test/regress/expected/create_function_3.out index e77799ac4e9..8dceb762e1b 100644 --- a/src/test/regress/expected/create_function_3.out +++ b/src/test/regress/expected/create_function_3.out @@ -99,43 +99,6 @@ SELECT proname, prosecdef FROM pg_proc (3 rows) -- --- COST --- -CREATE FUNCTION functext_D_1(int,int) RETURNS int LANGUAGE 'sql' - AS 'SELECT $1 + $2'; -CREATE FUNCTION functext_D_2(int,int) RETURNS int LANGUAGE 'internal' - AS 'int4pl'; -CREATE FUNCTION functext_D_3(int,int) RETURNS int LANGUAGE 'sql' - COST 500 AS 'SELECT $1 * $2'; -CREATE FUNCTION functext_D_4(int,int) RETURNS int LANGUAGE 'sql' - COST 0 AS 'SELECT $1 / $2'; -- Error -ERROR: COST must be positive -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - proname | procost ---------------+--------- - functext_d_1 | 100 - functext_d_2 | 1 - functext_d_3 | 500 -(3 rows) - -ALTER FUNCTION functext_D_1(int,int) STABLE; -- unrelated change, no effect -ALTER FUNCTION functext_D_2(int,int) COST 50; -ALTER FUNCTION functext_D_3(int,int) COST 0.0001; -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - proname | procost ---------------+--------- - functext_d_1 | 100 - functext_d_2 | 50 - functext_d_3 | 0.0001 -(3 rows) - --- -- LEAKPROOF -- CREATE FUNCTION functext_E_1(int) RETURNS bool LANGUAGE 'sql' @@ -440,7 +403,7 @@ SELECT proname, proisstrict FROM pg_proc -- Cleanups DROP SCHEMA temp_func_test CASCADE; -NOTICE: drop cascades to 19 other objects +NOTICE: drop cascades to 16 other objects DETAIL: drop cascades to function functest_a_1(text,date) drop cascades to function functest_a_2(text[]) drop cascades to function functest_a_3() @@ -451,9 +414,6 @@ drop cascades to function functest_b_4(integer) drop cascades to function functext_c_1(integer) drop cascades to function functext_c_2(integer) drop cascades to function functext_c_3(integer) -drop cascades to function functext_d_1(integer,integer) -drop cascades to function functext_d_2(integer,integer) -drop cascades to function functext_d_3(integer,integer) drop cascades to function functext_e_1(integer) drop cascades to function functext_e_2(integer) drop cascades to function functext_f_1(integer) diff --git a/src/test/regress/sql/create_function_3.sql b/src/test/regress/sql/create_function_3.sql index f895aaa1a9e..56ed215a288 100644 --- a/src/test/regress/sql/create_function_3.sql +++ b/src/test/regress/sql/create_function_3.sql @@ -69,30 +69,6 @@ SELECT proname, prosecdef FROM pg_proc 'functext_C_3'::regproc) ORDER BY proname; -- --- COST --- -CREATE FUNCTION functext_D_1(int,int) RETURNS int LANGUAGE 'sql' - AS 'SELECT $1 + $2'; -CREATE FUNCTION functext_D_2(int,int) RETURNS int LANGUAGE 'internal' - AS 'int4pl'; -CREATE FUNCTION functext_D_3(int,int) RETURNS int LANGUAGE 'sql' - COST 500 AS 'SELECT $1 * $2'; -CREATE FUNCTION functext_D_4(int,int) RETURNS int LANGUAGE 'sql' - COST 0 AS 'SELECT $1 / $2'; -- Error -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - -ALTER FUNCTION functext_D_1(int,int) STABLE; -- unrelated change, no effect -ALTER FUNCTION functext_D_2(int,int) COST 50; -ALTER FUNCTION functext_D_3(int,int) COST 0.0001; -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - --- -- LEAKPROOF -- CREATE FUNCTION functext_E_1(int) RETURNS bool LANGUAGE 'sql' |