Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped
Дата
Msg-id 24565.1255016292@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
... Actually, I just noticed that there *is* a bug here:

regression=# select '1' /* foo
regression*# */
regression-# '2';
ERROR:  syntax error at or near "'2'"
LINE 3: '2';
        ^
regression=#

The above should be accepted, but it isn't.  I think the problem is
here:

special_whitespace        ({space}+|{comment}{newline})

Shouldn't that be

special_whitespace        ({space}+|{comment}|{newline})

?  Although I'm not quite sure how this leads to the error, because
I didn't type anything between the second return and the '2', so in

whitespace_with_newline    ({horiz_whitespace}*{newline}{special_whitespace}*)

the {special_whitespace}* should have been satisfied with zero
repetitions no matter what.  Odd ...

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #5105: "Select Into Strict" does not throw NO_DATA_FOUND
Следующее
От: Dominic Bevacqua
Дата:
Сообщение: incorrect exit code from psql with single transaction + violation of deferred FK constraint