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

From: "brian" <b4kramer(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4618: nolock changes first column name of query result set to 'nolock'
Date: 2009-01-16 00:41:46
Message-ID: 200901160041.n0G0fkAx099808@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4618
Logged by: brian
Email address: b4kramer(at)yahoo(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Saito 2009-01-16 02:14:30 BUG #4619: pg_ctl reports strange error message when be executed on non executable directory
Previous Message Bruce Momjian 2009-01-15 23:54:03 Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION