diff options
| -rw-r--r-- | src/test/regress/expected/stats_ext.out | 10 | ||||
| -rw-r--r-- | src/test/regress/sql/stats_ext.sql | 11 |
2 files changed, 6 insertions, 15 deletions
diff --git a/src/test/regress/expected/stats_ext.out b/src/test/regress/expected/stats_ext.out index 5a4077f8ed5..eb70ea5a2ee 100644 --- a/src/test/regress/expected/stats_ext.out +++ b/src/test/regress/expected/stats_ext.out @@ -3786,18 +3786,15 @@ SELECT FROM sb_1 LEFT JOIN sb_2 RESET enable_nestloop; RESET enable_mergejoin; -- Check that we can use statistics on a bool-valued function. -CREATE FUNCTION extstat_small(x numeric) RETURNS bool -STRICT IMMUTABLE LANGUAGE plpgsql -AS $$ BEGIN RETURN x < 1; END $$; -SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE extstat_small(y)'); +SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE numeric_lt(y, 1.0)'); estimated | actual -----------+-------- 3333 | 196 (1 row) -CREATE STATISTICS extstat_sb_2_small ON extstat_small(y) FROM sb_2; +CREATE STATISTICS extstat_sb_2_small ON numeric_lt(y, 1.0) FROM sb_2; ANALYZE sb_2; -SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE extstat_small(y)'); +SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE numeric_lt(y, 1.0)'); estimated | actual -----------+-------- 196 | 196 @@ -3805,4 +3802,3 @@ SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE extstat_small(y)'); -- Tidy up DROP TABLE sb_1, sb_2 CASCADE; -DROP FUNCTION extstat_small(x numeric); diff --git a/src/test/regress/sql/stats_ext.sql b/src/test/regress/sql/stats_ext.sql index 94e2139c504..3f8e03f28a0 100644 --- a/src/test/regress/sql/stats_ext.sql +++ b/src/test/regress/sql/stats_ext.sql @@ -1855,17 +1855,12 @@ RESET enable_nestloop; RESET enable_mergejoin; -- Check that we can use statistics on a bool-valued function. -CREATE FUNCTION extstat_small(x numeric) RETURNS bool -STRICT IMMUTABLE LANGUAGE plpgsql -AS $$ BEGIN RETURN x < 1; END $$; +SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE numeric_lt(y, 1.0)'); -SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE extstat_small(y)'); - -CREATE STATISTICS extstat_sb_2_small ON extstat_small(y) FROM sb_2; +CREATE STATISTICS extstat_sb_2_small ON numeric_lt(y, 1.0) FROM sb_2; ANALYZE sb_2; -SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE extstat_small(y)'); +SELECT * FROM check_estimated_rows('SELECT * FROM sb_2 WHERE numeric_lt(y, 1.0)'); -- Tidy up DROP TABLE sb_1, sb_2 CASCADE; -DROP FUNCTION extstat_small(x numeric); |