bug? in current cvs with bigint datatype

Поиск
Список
Период
Сортировка
От Barry Lind
Тема bug? in current cvs with bigint datatype
Дата
Msg-id 3CDCB419.70308@xythos.com
обсуждение исходный текст
Ответы Re: bug? in current cvs with bigint datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: troubleshooting pointers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: troubleshooting pointers