Hi, VACUUM fails to parse 0 and 1 as boolean value
The document for VACUUM explains
boolean
Specifies whether the selected option should be turned on or off.
You can write TRUE, ON, or 1 to enable the option, and FALSE, OFF,
or 0 to disable it.
But VACUUM fails to parse 0 and 1 as boolean value as follows.
=# VACUUM (INDEX_CLEANUP 1);
ERROR: syntax error at or near "1" at character 23
STATEMENT: VACUUM (INDEX_CLEANUP 1);
This looks a bug. The cause of this is a lack of NumericOnly clause
for vac_analyze_option_arg in gram.y. The attached patch
adds such NumericOnly. The bug exists only in 12dev.
Barring any objection, I will commit the patch.
Regards,
--
Fujii Masao
vacuum_numeric_as_boolean.patch
Description: Binary data
