pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sebastian Meyer <meyer@mevis.de>
To: pgsql-interfaces@postgreSQL.org
Cc: Sascha Bohnenkamp <bonito@mevis.de>
Cc: Olaf Klinghamme <olafk@mevis.de>
Subject: pgsql.tcl: Bug concerning joins
Date: Tue, 1 Sep 1998 18:39:04 +0200
Message-ID: <Pine.SGI.4.02.9809011815240.3577-100000@forte> (raw)

I'm writing an application using PostgreSQL-6.3.2, Tcl/Tk 8.0 using 
pgsql.tcl as an interface. This approach allows to run code completely
unmodified on Unix, Windows and the Mac.

I found a bug processing a simple join like
   SELECT s1.b,s2.b FROM pgsqlbug1 s1, pgsqlbug2 s2 WHERE s1.a = s2.c;
This bug only occurs whern using pgsql.tcl. 

Here is the full story:

====== create script ============
-- Trigger a bug in the pgsql Tcl interface
--
CREATE TABLE pgsqlbug1 (
	a int2,
	b char(12), 
	primary key(a)
);
CREATE TABLE pgsqlbug2 (
       a int2,
       b char(12),
       c int2,
       primary key(a)
);

INSERT INTO pgsqlbug1 (a,b) VALUES (0,'from table 1');
INSERT INTO pgsqlbug2 (a,b,c) VALUES (0,'from table 2',0);
====== end of create script ============

Using psql I get the following (correct) output:

====== psql session ==========
meyer=> select * from pgsqlbug1;
a|b           
-+------------
0|from table 1
(1 row)

meyer=> select * from pgsqlbug2;
a|b           |c
-+------------+-
0|from table 2|0
(1 row)

meyer=> SELECT s1.b,s2.b FROM pgsqlbug1 s1, pgsqlbug2 s2 WHERE s1.a = s2.c;
b           |b           
------------+------------
from table 1|from table 2
(1 row)

====== pend of sql session ==========

Using pgsql.tcl from Tcl however I get:

meyer> SELECT s1.b,s2.b FROM pgsqlbug1 s1, pgsqlbug2 s2 WHERE s1.a = s2.c;

attributes: b b
lAttributes: {b 1042 -1} {b 1042 -1}
Tuple 0: {from table 2} {from table 2}

... what is wrong, obviously.

(Version info: timestamp of pgsql.tcl is "May 21 15:25" on
ftp://ftp.flex.ro/pub/pgaccess). 

BTW: What's the address of the developer of pgsql.tcl. I couldn't find
    it in the code....

Thanks,
	sebastian
-- 
    __o     Sebastian Meyer  Tel: (0421)218-7702 | "A weird imagination
  _ \<,_    meyer@mevis.de   http://www.mevis.de | is most useful to gain 
 (_)/ (_)   MeVis an der Universität Bremen      | full advantage of all the 
~~~~~~~~~~~ Universitätsallee 29, D-28359 Bremen | features." (amd(8))




view thread (3+ messages)  latest in thread

Message-ID: <Pine.SGI.4.02.9809011815240.3577-100000@forte>
Permalink:  ../Pine.SGI.4.02.9809011815240.3577-100000@forte/
Also on:    postgresql.org/message-id/Pine.SGI.4.02.9809011815240.3577-100000@forte

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-interfaces@postgresql.org
  Cc: meyer@mevis.de, bonito@mevis.de, olafk@mevis.de
  Subject: Re: pgsql.tcl: Bug concerning joins
  In-Reply-To: <Pine.SGI.4.02.9809011815240.3577-100000@forte>
  References: <Pine.SGI.4.02.9809011815240.3577-100000@forte>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox