VACUUM fails to parse 0 and 1 as boolean value

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема VACUUM fails to parse 0 and 1 as boolean value
Дата
Msg-id CAHGQGwGYg82A8UCQxZe7Zn9MnyUBGdyB=1CNpKF3jBny+RbyfA@mail.gmail.com
обсуждение исходный текст
Ответы Re: VACUUM fails to parse 0 and 1 as boolean value  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL-spec incompatibilities in similar_escape() and related stuff
Следующее
От: Andres Freund
Дата:
Сообщение: Re: VACUUM fails to parse 0 and 1 as boolean value