bug? in current cvs with bigint datatype

From: Barry Lind <barry(at)xythos(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: bug? in current cvs with bigint datatype
Date: 2002-05-11 06:03:05
Message-ID: 3CDCB419.70308@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I just did a fresh build from current cvs and found the following
regression from 7.2:

create table test (cola bigint);
update test set cola = 10000000000;

In 7.3 the update results in the following error:

ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
You will need to rewrite or cast the expression

In 7.2 the update worked. (updated 0 rows in this case)

It is interesting to note that if I use 'cola = 10000000000' in a where
clause instead of as an assignment (i.e. select * from test where cola =
10000000000) this works in both 7.3 and 7.2.

thanks,
--Barry

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-05-11 12:15:48 Re: internal voting
Previous Message Rajesh Kumar Mallah. 2002-05-11 05:05:05 Further info : Very high load average but no cpu utilization ?