Re: [PgFoundry] Unsigned Data Types [1 of 2]

On Mon, Sep 8, 2008 at 10:08 PM, Ryan Bradetich <[email protected]> wrote:
>
> Can you send me the test case that generates this error?
> My regression tests do not include a table t1 so I was not able
> to reproduce this error directly.
>

yeah! that table is mine! here are the scripts...

> contrib_regression=# select f1 from t1 where f1 > 99998;
>   f1
> --------
>  99999
>  100000
> (2 rows)
>
> My testing shows this is working correctly.
>

mmm... i rebuild my test env and it works for me this time... until i
execute an analyze. I guess autovacuum executed an auto analyze last
time...

-- 
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157


-- 
Sent via pgsql-patches mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches

drop table t1_int4;
create table t1_int4 (f1 int4  primary key);
insert into t1_int4 select generate_series(1, 255);
select * from t1_int4, generate_series(1, 10) as foo where t1_int4.f1 = foo;

drop table t1_uint4;
create table t1_uint4 (f1 uint4  primary key);
insert into t1_uint4 select generate_series(1, 255);
select * from t1_uint4, generate_series(1, 10) as foo where t1_uint4.f1 = foo;

drop table if exists t1_int4;
create table t1_int4 (f1 int4  primary key);
insert into t1_int4 select generate_series(1, 255);
analyze;
select * from t1_int4 where f1 > 30;

drop table if exists t1_uint4;
create table t1_uint4 (f1 uint4  primary key);
insert into t1_uint4 select generate_series(1, 255);
analyze;
select * from t1_uint4 where f1 > 30;
explain analyze select * from t1_uint4 where f1 > 30;