contrib/auto_explain/expected/extension_options.out - master - githubmirror/postgres

contrib/auto_explain/expected/extension_options.out
49 строк3 KB
Robert Haas
auto_explain: Add new GUC, auto_explain.log_extension_options.
06 апр 2026, 22:19
06 апр 2026, 22:19e972dff
--
-- Tests for auto_explain.log_extension_options.
--
LOAD 'auto_explain';
LOAD 'pg_overexplain';
-- Various legal values with assorted quoting and whitespace choices.
SET auto_explain.log_extension_options = '';
SET auto_explain.log_extension_options = 'debug, RANGE_TABLE';
SET auto_explain.log_extension_options = 'debug TRUE  ';
SET auto_explain.log_extension_options = '   debug 1,RAnge_table "off"';
SET auto_explain.log_extension_options = $$"debug" tRuE, range_table 'false'$$;
-- Syntax errors.
SET auto_explain.log_extension_options = ',';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": ","
DETAIL:  option name missing or empty
SET auto_explain.log_extension_options = ', range_table';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": ", range_table"
DETAIL:  option name missing or empty
SET auto_explain.log_extension_options = 'range_table, ';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": "range_table, "
DETAIL:  trailing comma in option list
SET auto_explain.log_extension_options = 'range_table true false';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": "range_table true false"
DETAIL:  expected comma or end of option list
SET auto_explain.log_extension_options = '"range_table';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": ""range_table"
DETAIL:  option name missing or empty
SET auto_explain.log_extension_options = 'range_table 3.1415nine';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": "range_table 3.1415nine"
DETAIL:  invalid numeric value
SET auto_explain.log_extension_options = 'range_table "true';
ERROR:  invalid value for parameter "auto_explain.log_extension_options": "range_table "true"
DETAIL:  unterminated double-quoted string
SET auto_explain.log_extension_options = $$range_table 'true$$;
ERROR:  invalid value for parameter "auto_explain.log_extension_options": "range_table 'true"
DETAIL:  unterminated single-quoted string
SET auto_explain.log_extension_options = $$'$$;
ERROR:  unrecognized EXPLAIN option "'"
-- Unacceptable option values.
SET auto_explain.log_extension_options = 'range_table maybe';
ERROR:  EXPLAIN option "range_table" requires a Boolean value
SET auto_explain.log_extension_options = 'range_table 2';
ERROR:  EXPLAIN option "range_table" requires a Boolean value
SET auto_explain.log_extension_options = 'range_table "0"';
ERROR:  EXPLAIN option "range_table" requires a Boolean value
SET auto_explain.log_extension_options = 'range_table 3.14159';
ERROR:  EXPLAIN option "range_table" requires a Boolean value
-- Supply enough options to force the option array to be reallocated.
SET auto_explain.log_extension_options = 'debug, debug, debug, debug, debug, debug, debug, debug, debug, debug false';