Re: [BUGS] Parser failed to return an error
| От | David G. Johnston |
|---|---|
| Тема | Re: [BUGS] Parser failed to return an error |
| Дата | |
| Msg-id | CAKFQuwYrr8Qs2rJey=C=2yjktMN8U-i+wEn=vZW-6XMMaT8J8A@mail.gmail.com обсуждение исходный текст |
| Ответ на | [BUGS] Parser failed to return an error (rob stone <floriparob@gmail.com>) |
| Ответы |
Re: [BUGS] Parser failed to return an error
|
| Список | pgsql-bugs |
On Thursday, February 2, 2017, rob stone <floriparob@gmail.com> wrote:
Linux roblaptop 4.9.0-1-amd64 #1 SMP Debian 4.9.2-2 (2017-01-12) x86_64
GNU/Linux
I was running a query like:-
SELECT TO_CHAR(my_date,'dd-mm-yyyy) FROM my_table;
and I forgot to type the second single quotation mark at the end of the
mask string.
Under psql it just hung and I had to Ctrl-C to go back to a prompt and
under JDBC it hung as well and EQ just said "error", as in a failure of
some sort.
I would have expected either a 42601 error or maybe a 03000 error to
have been returned.
At least in psql that isn't a query. It's a multi-line query fragment. The UI is waiting for you to enter more of the query and end the string literal that you've begun.
David J.
В списке pgsql-bugs по дате отправления: