On Sun, 27 Sep 2009 00:31:04 -0400, Tom Lane <t...@sss.pgh.pa.us> wrote:
> "Mauro Infantino" <mauro.infant...@latincontrol-soft.com> writes:
>> I'm just experiencing the same as in here,
>> http://archives.postgresql.org/pgsql-bugs/2008-06/msg00175.php
>> It was not happening for 8.3.7 (at least on Windows).
>
> This is the very definition of an unhelpful bug report.
>
> You are not seeing the same thing that was reported against 8.3.3,
> because that bug is fixed --- there's a regression test proving so.
> You might be seeing something else with a similar symptom, but with
> no details or test case, there is nothing we can do about it.
>
> regards, tom lane
Thank you for your answer, Tom.
Attached is what I think would be enough to reproduce the problem. Please
tell me if you need anything else.
When I use this query,
SELECT v_relacionatributocont.bo_place_id,
v_relacionatributocont.descripcion,
v_relacionatributocont.atributo_id,
v_atributos.lista
FROM v_relacionatributocont
LEFT OUTER JOIN v_atributos ON v_relacionatributocont.atributo_id =
v_atributos.id
WHERE v_relacionatributocont.bo_place_id =
'{BF0EFA28-A615-11D5-B09D-004854841C8A}'
AND v_relacionatributocont.atributo_id IS NOT NULL
AND (v_atributos.lista = '' OR v_atributos.lista IS NULL)
I get three rows when only one should be returned. It's easier to see it
just by removing the last condition of the where clause. Just take a look
at the "lista" column's content.
Please tell me if I'm not seeing something obvious.
Thanks in advance,
Mauro Infantino.
CREATE TABLE atributocancelacion
(
id character varying(40) NOT NULL,
descripcion character varying(200),
nombre character varying(80),
attributoclassid character varying(40),
tipo integer DEFAULT 0,
iscompound boolean DEFAULT false,
listaatributos_id character varying(40),
lista character varying(50),
listaitemclassid character varying(50),
relacionar boolean DEFAULT false,
readonly boolean DEFAULT false,
atributoauxiliar boolean DEFAULT false,
bo_place_id character varying(40),
bo_owner_id character varying(40),
atributoscancelacion_id character varying(40),
CONSTRAINT atributocancelacion_pkey PRIMARY KEY (id)
);
CREATE INDEX a ON atributocancelacion(bo_place_id);
CREATE INDEX b ON atributocancelacion(bo_owner_id);
CREATE INDEX c ON atributocancelacion(nombre);
CREATE INDEX d ON atributocancelacion(lista);
CREATE TABLE atributos
(
id character varying(40) NOT NULL,
bo_place_id character varying(40),
bo_owner_id character varying(40),
descripcion character varying(200),
nombre character varying(80),
attributoclassid character varying(40),
tipo integer DEFAULT 0,
iscompound boolean DEFAULT false,
listaatributos_id character varying(40),
lista character varying(50),
listaitemclassid character varying(50),
relacionar boolean DEFAULT false,
readonly boolean DEFAULT false,
atributoauxiliar boolean DEFAULT false,
CONSTRAINT atributos_pkey PRIMARY KEY (id)
);
CREATE INDEX e ON atributos(bo_place_id);
CREATE INDEX f ON atributos(bo_owner_id);
CREATE INDEX g ON atributos(nombre);
CREATE INDEX h ON atributos(lista);
CREATE TABLE relacionatributocont
(
id character varying(40) NOT NULL,
bo_place_id character varying(40),
bo_owner_id character varying(40),
descripcion character varying(40),
atributo_id character varying(40),
descripcioncontable_id character varying(40),
cuentacontable_id character varying(40),
evaluascriptctacontable boolean DEFAULT false,
scriptcuentacontable_id character varying(40),
atributoimporte_id character varying(40),
comportamiento_id character varying(40),
CONSTRAINT relacionatributocont_pkey PRIMARY KEY (id)
);
CREATE INDEX i ON relacionatributocont(bo_place_id);
CREATE INDEX j ON relacionatributocont(bo_owner_id);
CREATE OR REPLACE VIEW v_atributos AS
SELECT atributos.id, atributos.bo_place_id, atributos.bo_owner_id, atributos.descripcion, atributos.nombre, atributos.attributoclassid, atributos.tipo, atributos.iscompound, atributos.listaatributos_id, atributos.lista, atributos.listaitemclassid, atributos.relacionar, atributos.readonly, atributos.atributoauxiliar
FROM atributos
UNION ALL
SELECT atributocancelacion.id, atributocancelacion.bo_place_id, atributocancelacion.bo_owner_id, atributocancelacion.descripcion, atributocancelacion.nombre, atributocancelacion.attributoclassid, atributocancelacion.tipo, atributocancelacion.iscompound, atributocancelacion.listaatributos_id, atributocancelacion.lista, atributocancelacion.listaitemclassid, atributocancelacion.relacionar, atributocancelacion.readonly, atributocancelacion.atributoauxiliar
FROM atributocancelacion;
CREATE OR REPLACE VIEW v_relacionatributocont AS
SELECT relacionatributocont.id, relacionatributocont.bo_place_id, relacionatributocont.bo_owner_id, relacionatributocont.descripcion, relacionatributocont.atributo_id, relacionatributocont.descripcioncontable_id, relacionatributocont.cuentacontable_id, relacionatributocont.evaluascriptctacontable, relacionatributocont.scriptcuentacontable_id, relacionatributocont.atributoimporte_id, relacionatributocont.comportamiento_id
FROM relacionatributocont;
insert into RELACIONATRIBUTOCONT values
('{BF0EFA2D-A615-11D5-B09D-004854841C8A}','{BF0EFA28-A615-11D5-B09D-004854841C8A}',null,'Cliente','{92D3E2DD-3D9D-11D5-B059-004854841C8A}','{BF0EFA09-A615-11D5-B09D-004854841C8A}',null,'t','{BF0EFA2E-A615-11D5-B09D-004854841C8A}','{BF0EFA2F-A615-11D5-B09D-004854841C8A}','{92D3F5FD-3D9D-11D5-B059-004854841C8A}'),
('{BF0EFA38-A615-11D5-B09D-004854841C8A}','{BF0EFA28-A615-11D5-B09D-004854841C8A}',null,'Venta','{92D3E270-3D9D-11D5-B059-004854841C8A}','{89C2371D-3F01-11D5-86AD-0080AD403F5F}',null,'t','{BF0EFA39-A615-11D5-B09D-004854841C8A}','{BF0EFA3A-A615-11D5-B09D-004854841C8A}','{92D3F604-3D9D-11D5-B059-004854841C8A}'),
('{082FDDE6-C954-489B-BE69-A1FEAE233D51}','{BF0EFA28-A615-11D5-B09D-004854841C8A}',null,'Descuento Total',null,null,null,'t','{7E7F8669-5E5D-4111-B872-02C7FA2C2D81}','{153A0367-70DA-4F71-8B00-A672AACDBF91}','{92D3F5FD-3D9D-11D5-B059-004854841C8A}'),
('{1F40BD50-3D27-4BA1-AAEF-3EF7FCC18226}','{BF0EFA28-A615-11D5-B09D-004854841C8A}',null,'Bonificaciones item','{92D3E270-3D9D-11D5-B059-004854841C8A}','{BF0EFA09-A615-11D5-B09D-004854841C8A}',null,'t','{67A66814-2B45-4B4C-A54B-1E6762B7F099}','{4D1BD659-1CAC-4BDA-9150-99B39B401A34}','{92D3F5FD-3D9D-11D5-B059-004854841C8A}');
insert into atributos values
('{92D3E2DD-3D9D-11D5-B059-004854841C8A}','{92D3E26E-3D9D-11D5-B059-004854841C8A}',null,'Destinatario','DESTINATARIO','{F87C09C1-77CB-11D1-8668-0000C0162096}',7,'f','{05FAC491-1998-11D6-B2A0-0048548404E5}',null,null,'t','f','f'),
('{92D3E270-3D9D-11D5-B059-004854841C8A}','{92D3E26E-3D9D-11D5-B059-004854841C8A}',null,'Items de transacción.Referencia','REFERENCIA','{F87C09C1-77CB-11D1-8668-0000C0162096}',7,'f','{24DF7DF6-569C-11D5-B613-0050DAC017BE}','ITEMSTRANSACCION','{6F724B45-FADE-11D1-9E49-0000214166F2}','t','f','f');
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
