bug? in current cvs with bigint datatype - Mailing list pgsql-hackers

From Barry Lind
Subject bug? in current cvs with bigint datatype
Date
Msg-id 3CDCB419.70308@xythos.com
Whole thread Raw
Responses Re: bug? in current cvs with bigint datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: troubleshooting pointers
Next
From: Tom Lane
Date:
Subject: Re: troubleshooting pointers