Re: pltcl regress test?
JanWieck@t-online.de (Jan Wieck) writes:
[ pltcl's regress test is failing ]
Seems to suffer due to some bug. The functions use a feature
of the Tcl interpreter, who treates a backslash followed by a
newline as a whitespace that doesn't start a new command
(previous command is continued).
I did some other tests and ISTM that it is totally impossible
by now to insert data where backslash is followed by newline
at all. At least I wasn't able to quote it properly. Maybe
these are filtered already by psql?
Yes, it seems that psql's handling of backslashes has changed for the
worse.
In current sources, I type:
regression=# select 'abc \\
regression'# def';
?column?
-----------
abc
def
(1 row)
Running with -d2, the postmaster log shows:
DEBUG: StartTransactionCommand
DEBUG: query: select 'abc
def';
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
psql has eaten the backslashes, even though they are within quotes.
This is not cool. 6.5.* psql did not do that, and current sources
don't either *unless* the backslashes are at the very end of a line.
regards, tom lane
Import Notes
Reply to msg id not found: 200007171238.OAA07299@hot.jw.homeReference msg id not found: 200007171238.OAA07299@hot.jw.home
Tom Lane wrote:
JanWieck@t-online.de (Jan Wieck) writes:
[ pltcl's regress test is failing ]
Seems to suffer due to some bug. The functions use a feature
of the Tcl interpreter, who treates a backslash followed by a
newline as a whitespace that doesn't start a new command
(previous command is continued).I did some other tests and ISTM that it is totally impossible
by now to insert data where backslash is followed by newline
at all. At least I wasn't able to quote it properly. Maybe
these are filtered already by psql?Yes, it seems that psql's handling of backslashes has changed for the
worse.
After Peter's fix to psql I updated the pltcl test expected
result and removed an ordering problem from the test queries.
Should work again now.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #