Comment bug in psql

Started by Martin Olssonabout 25 years ago2 messagesbugs
Jump to latest
#1Martin Olsson
elof@sentor.se

Hi!

I just found a bug in psql 7.0.3 (a FreeBSD 4.2 port).

1 db=# /* Foo bar
2 db*# gazonk's gurka
3 db'# 2001 */
4 db'# CREATE TABLE foo (bar INTEGER);
5 db'# '
6 db*# */
7 db-# CREATE TABLE gazonk (blirp INTEGER);
8 ERROR: Unterminated quoted string

1 Prompt is =, ok
Start a comment

2 Prompt changes to *, ok
Write more comments and include an apostrofe (')

3 Prompt changes to ', ERROR! You shouldn't enter this mode because of an
apostrofe in commented text.
Write more comments and end them, ERROR! The end of the comments aren't
recognized.
The rest, 4-8, will be interpreted incorrectly.

/Martin Olsson Sentor AB

"There is at least one incorrect statement in this text,
but it may be this one!"

#2Bruce Momjian
bruce@momjian.us
In reply to: Martin Olsson (#1)
Re: Comment bug in psql

Looks like this is fixed in 7.1RC4:

test=> /* Foo bar
test*> gazonk's gurka
test*> 2001 */
test-> CREATE TABLE foo (bar INTEGER);
CREATE

Thanks.

Hi!

I just found a bug in psql 7.0.3 (a FreeBSD 4.2 port).

1 db=# /* Foo bar
2 db*# gazonk's gurka
3 db'# 2001 */
4 db'# CREATE TABLE foo (bar INTEGER);
5 db'# '
6 db*# */
7 db-# CREATE TABLE gazonk (blirp INTEGER);
8 ERROR: Unterminated quoted string

1 Prompt is =, ok
Start a comment

2 Prompt changes to *, ok
Write more comments and include an apostrofe (')

3 Prompt changes to ', ERROR! You shouldn't enter this mode because of an
apostrofe in commented text.
Write more comments and end them, ERROR! The end of the comments aren't
recognized.
The rest, 4-8, will be interpreted incorrectly.

/Martin Olsson Sentor AB

"There is at least one incorrect statement in this text,
but it may be this one!"

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026