BUG #4618: nolock changes first column name of query result set to 'nolock'

Поиск
Список
Период
Сортировка
От brian
Тема BUG #4618: nolock changes first column name of query result set to 'nolock'
Дата
Msg-id 200901160041.n0G0fkAx099808@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4618: nolock changes first column name of query result set to 'nolock'  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4618
Logged by:          brian
Email address:      b4kramer@yahoo.com
PostgreSQL version: 8.3.5 build1400
Operating system:   windows xp
Description:        nolock changes first column name of query result set  to
'nolock'
Details:

query1 works fine, first column in table is called movieid1:
select * from netflix.ratings where movieid = 1




query2 is a bug and should work just fine, but gives error:
ERROR:  column "movieid" does not exist
LINE 2: select * from netflix.ratings with (nolock) where movieid = ...
                                                          ^


********** Error **********

ERROR: column "movieid" does not exist
SQL state: 42703
Character: 52'
select * from netflix.ratings with (nolock) where movieid = 1




query3 is the similar bug, this query works but should not since field name
is 'movieid' not 'nolock', result set displays 'nolock' instead of 'movieid'
as well:
select * from netflix.ratings with (nolock) where nolock = 1


query4 changes first column name to 'nolock' and leaves all other column
names as normal:
select * from netflix.ratings with (nolock) limit 1

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

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: BUG #4619: pg_ctl reports strange error message when be executed on non executable directory
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #4618: nolock changes first column name of query result set to 'nolock'