Bug/Change in behavior for 7.3 vs 7.2.1
I was just testing my product running on a 7.3 snapshot from a few days
ago. And I ran into the following change in behavior that I consider a
bug. You can no long insert large values into a bigint column without a
cast. Small values (in the int range work fine though).
On 7.3 I get:
files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
You will need to rewrite or cast the expression
On 7.2.1 this works correctly:
files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
INSERT 108683 1
thanks,
--Barry
Dang it...meant to mention that the other day when I was working on
those python patches. I had to place tick marks (single quote) around
the number and it was converted correctly.
gcope=# insert into a values ( 9999999999 ) ;
ERROR: column "a" is of type 'bigint' but expression is of type 'double
precision'
You will need to rewrite or cast the expression
gcope=# insert into a values ( '9999999999' ) ;
INSERT 25115 1
Greg
Show quoted text
On Thu, 2002-08-15 at 20:03, Barry Lind wrote:
I was just testing my product running on a 7.3 snapshot from a few days
ago. And I ran into the following change in behavior that I consider a
bug. You can no long insert large values into a bigint column without a
cast. Small values (in the int range work fine though).On 7.3 I get:
files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
You will need to rewrite or cast the expressionOn 7.2.1 this works correctly:
files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
INSERT 108683 1thanks,
--Barry---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Barry Lind <barry@xythos.com> writes:
You can no long insert large values into a bigint column without a
cast.
This seems to be fallout from the move to tighten up implicit coercions
(cf http://archives.postgresql.org/pgsql-hackers/2002-04/msg00528.php
as well as lots of earlier discussions).
I said right along that this topic needed more debate, but we haven't
gotten back to looking at it. We have a number of other nasty behaviors
in current sources that trace back to altering the set of available
coercions.
regards, tom lane
Then shouldn't this appear on the "Open 7.3 issues" list that has been
circulating around? This seems like an open issue to me, that needs to
be addressed before 7.3 ships.
--Barry
Tom Lane wrote:
Show quoted text
Barry Lind <barry@xythos.com> writes:
You can no long insert large values into a bigint column without a
cast.This seems to be fallout from the move to tighten up implicit coercions
(cf http://archives.postgresql.org/pgsql-hackers/2002-04/msg00528.php
as well as lots of earlier discussions).I said right along that this topic needed more debate, but we haven't
gotten back to looking at it. We have a number of other nasty behaviors
in current sources that trace back to altering the set of available
coercions.regards, tom lane
Barry Lind <barry@xythos.com> writes:
Then shouldn't this appear on the "Open 7.3 issues" list that has been
circulating around?
It does.
regards, tom lane
It is already there, I think:
fix implicit type coercions that are worse
---------------------------------------------------------------------------
Barry Lind wrote:
Then shouldn't this appear on the "Open 7.3 issues" list that has been
circulating around? This seems like an open issue to me, that needs to
be addressed before 7.3 ships.--Barry
Tom Lane wrote:
Barry Lind <barry@xythos.com> writes:
You can no long insert large values into a bigint column without a
cast.This seems to be fallout from the move to tighten up implicit coercions
(cf http://archives.postgresql.org/pgsql-hackers/2002-04/msg00528.php
as well as lots of earlier discussions).I said right along that this topic needed more debate, but we haven't
gotten back to looking at it. We have a number of other nasty behaviors
in current sources that trace back to altering the set of available
coercions.regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073