Function definition regression in 15beta1 when specific parameter name (string) is used

Поиск
Список
Период
Сортировка
От Alastair McKinley
Тема Function definition regression in 15beta1 when specific parameter name (string) is used
Дата
Msg-id PAXPR02MB760049C92DFC2D8B5E8B8F5AE3DA9@PAXPR02MB7600.eurprd02.prod.outlook.com
обсуждение исходный текст
Ответы Re: Function definition regression in 15beta1 when specific parameter name (string) is used
Re: Function definition regression in 15beta1 when specific parameter name (string) is used
Список pgsql-general
Hi all,

I was testing an existing codebase with 15beta1 and ran into this issue.

I reduced the test case to an example with works in 14.3, and fails in 15beta1.

The following function definition fails in 15beta1 (ok in 14.3):

    create or replace function regexp_match_test(string text,pattern text) returns text[] as
    $$
        select regexp_match(string,pattern);
    $$ language sql;

The error message is:

    ERROR:  syntax error at or near ","
    LINE 3:     select regexp_match(string,pattern);
                                                              ^
Changing the first parameter name from string to anything else (e.g. strin or string1) resolves the issue.

The issue also occurs with the "string" parameter name if this is used in a plpgsql function like this:

    create or replace function regexp_match_test(string text,pattern text) returns text[] as
    $$
    begin
            return (select regexp_match(string,pattern));
    end;
    $$ language plpgsql;

Best regards,

Alastair


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

Предыдущее
От: Shaheed Haque
Дата:
Сообщение: Re: JSONB index not in use, but is TOAST the real cause of slow query?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Function definition regression in 15beta1 when specific parameter name (string) is used