From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Christoph Berg <myon(at)debian(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
Subject: | Re: 10beta1 sequence regression failure on sparc64 |
Date: | 2017-05-18 18:48:11 |
Message-ID: | 20170518184811.7c44jcvwjvnzczho@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2017-05-18 10:11:48 -0400, Tom Lane wrote:
> Christoph Berg <myon(at)debian(dot)org> writes:
> > *** 34,44 ****
> > --- 34,47 ----
> > CREATE SEQUENCE sequence_test7 AS bigint;
> > CREATE SEQUENCE sequence_test8 AS integer MAXVALUE 100000;
> > CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1;
> > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer
> > CREATE SEQUENCE sequence_test10 AS integer MINVALUE -100000 START 1;
> > CREATE SEQUENCE sequence_test11 AS smallint;
> > CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1;
> > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
> > CREATE SEQUENCE sequence_test13 AS smallint MINVALUE -32768;
> > CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1;
> > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
> > CREATE SEQUENCE sequence_testx AS text;
> > ERROR: sequence type must be smallint, integer, or bigint
> > CREATE SEQUENCE sequence_testx AS nosuchtype;
>
> Well, that's just wacko. Somehow sequence.c's init_params() must
> be falling down on the job in selecting the right seqform->seqmin,
> but I'm darned if I see anything that's either wrong or potentially
> machine-dependent in that code. It almost looks like it must be
> a compiler bug, though I hesitate to jump to that conclusion so
> quickly. Peter, any ideas?
Weird. Christoph, IIRC you can help gaining access to a porter machine
to reproduce this?
- Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-05-18 19:14:18 | Re: 10beta1 sequence regression failure on sparc64 |
Previous Message | Robert Haas | 2017-05-18 18:06:02 | Re: NOT NULL constraints on range partition key columns |