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'
|
Список | 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 по дате отправления: