Re: Postgres on QNX - Mailing list pgsql-ports

Am 12:37 09.11.01 -0600 schrieb Igor Kovalenko:
>Hi Bernd

Hi Igor


>I ran across your notes in the postgres distribution about regression
>some tests failing on QNX4. I did QNX6 port (slightly modified your SYSV
>emulation stuff) and i see some similar test failures.
>
>In particular, i have NUMERIC test failing with same 'ERROR: cannot
>create unique index. Table contains noon-unique values'. Also CREATE
>VIEW fails with 'cannot insert a duplicate key into unique index
>pg_rewrite_rulename_index' (note, there is no issue with shared
>libraries in QNX6).

Good to hear that.


>You notes mention errors like that are 'subject to further
>investigation'.

That sentence was written by my predecessor, Andreas but AFAIK neither
he nor I investigated this further.

>  Have you figured anything yet?

I just did a few tests, see psql log below. It looks like there is
something wrong with the test for uniqueness when creating a unique
index. I deleted rows from the table until I could create the index
then added the deleted rows again while the index was in place.
I haven't tried to find the bug in the code yet.

>Did you try to post into postgres-ports list?

I'm crossposting this now.


>Thanks,
>- igor

pmc=> \d num_exp_add
           Table "num_exp_add"
  Attribute |      Type       | Modifier
-----------+-----------------+----------
  id1       | integer         |
  id2       | integer         |
  expected  | numeric(210,10) |
pmc=> select * from num_exp_add;
  id1 | id2 |       expected
-----+-----+----------------------
    0 |   0 |         0.0000000000
    0 |   1 |         0.0000000000
    0 |   2 | -34338492.2153970470
    0 |   3 |         4.3100000000
    0 |   4 |   7799461.4119000000
    0 |   5 |     16397.0384910000
    0 |   6 |     93901.5776302600
    0 |   7 | -83028485.0000000000
    0 |   8 |     74881.0000000000
    0 |   9 | -24926804.0450474200
    1 |   0 |         0.0000000000
    1 |   1 |         0.0000000000
    1 |   2 | -34338492.2153970470
    1 |   3 |         4.3100000000
    1 |   4 |   7799461.4119000000
    1 |   5 |     16397.0384910000
    1 |   6 |     93901.5776302600
    1 |   7 | -83028485.0000000000
    1 |   8 |     74881.0000000000
    1 |   9 | -24926804.0450474200
(20 rows)

pmc=> CREATE UNIQUE INDEX num_exp_add_idx ON num_exp_add (id1, id2);
ERROR:  Cannot create unique index. Table contains non-unique values
pmc=> delete from num_exp_add where id1 > 0;
DELETE 10
pmc=> CREATE UNIQUE INDEX num_exp_add_idx ON num_exp_add (id1, id2);
CREATE
pmc=> INSERT INTO num_exp_add VALUES (1,0,'0');
INSERT 19232 1
pmc=> INSERT INTO num_exp_add VALUES (1,1,'0');
INSERT 19233 1
pmc=> INSERT INTO num_exp_add VALUES (1,2,'-34338492.215397047');
INSERT 19234 1
pmc=>  INSERT INTO num_exp_add VALUES (1,3,'4.31');
INSERT 19235 1
pmc=>  INSERT INTO num_exp_add VALUES (1,4,'7799461.4119');
INSERT 19236 1
pmc=>  INSERT INTO num_exp_add VALUES (1,5,'16397.038491');
INSERT 19237 1
pmc=>  INSERT INTO num_exp_add VALUES (1,6,'93901.57763026');
INSERT 19238 1
pmc=> INSERT INTO num_exp_add VALUES (1,7,'-83028485');
INSERT 19239 1
pmc=> INSERT INTO num_exp_add VALUES (1,8,'74881');
INSERT 19240 1
pmc=>  INSERT INTO num_exp_add VALUES (1,9,'-24926804.045047420');
INSERT 19241 1
pmc=> drop index num_exp_add_idx;
DROP
pmc=>  CREATE UNIQUE INDEX num_exp_add_idx ON num_exp_add (id1, id2);
ERROR:  Cannot create unique index. Table contains non-unique values
pmc=>




----