|
| 1 | +From owner-pgsql-hackers@hub.org Wed Nov 25 19:01:02 1998 |
| 2 | +Received: from renoir.op.net (root@renoir.op.net [209.152.193.4]) |
| 3 | +by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id TAA16399 |
| 4 | +for <maillist@candle.pha.pa.us>; Wed, 25 Nov 1998 19:01:01 -0500 (EST) |
| 5 | +Received: from hub.org (majordom@hub.org [209.47.148.200]) by renoir.op.net (o1/$ Revision: 1.18 $) with ESMTP id SAA05250 for <maillist@candle.pha.pa.us>; Wed, 25 Nov 1998 18:53:12 -0500 (EST) |
| 6 | +Received: from localhost (majordom@localhost) |
| 7 | +by hub.org (8.9.1/8.9.1) with SMTP id SAA17798; |
| 8 | +Wed, 25 Nov 1998 18:49:38 -0500 (EST) |
| 9 | +(envelope-from owner-pgsql-hackers@hub.org) |
| 10 | +Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Wed, 25 Nov 1998 18:49:07 +0000 (EST) |
| 11 | +Received: (from majordom@localhost) |
| 12 | +by hub.org (8.9.1/8.9.1) id SAA17697 |
| 13 | +for pgsql-hackers-outgoing; Wed, 25 Nov 1998 18:49:06 -0500 (EST) |
| 14 | +(envelope-from owner-pgsql-hackers@postgreSQL.org) |
| 15 | +Received: from mail.enterprise.net (root@mail.enterprise.net [194.72.192.18]) |
| 16 | +by hub.org (8.9.1/8.9.1) with ESMTP id SAA17650; |
| 17 | +Wed, 25 Nov 1998 18:48:55 -0500 (EST) |
| 18 | +(envelope-from olly@lfix.co.uk) |
| 19 | +Received: from linda.lfix.co.uk (root@max01-040.enterprise.net [194.72.197.40]) |
| 20 | +by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id XAA20539; |
| 21 | +Wed, 25 Nov 1998 23:48:52 GMT |
| 22 | +Received: from linda.lfix.co.uk (olly@localhost [127.0.0.1]) |
| 23 | +by linda.lfix.co.uk (8.9.1a/8.9.1/Debian/GNU) with ESMTP id XAA12089; |
| 24 | +Wed, 25 Nov 1998 23:48:52 GMT |
| 25 | +Message-Id: <199811252348.XAA12089@linda.lfix.co.uk> |
| 26 | +X-Mailer: exmh version 2.0.2 2/24/98 (debian) |
| 27 | +X-URL: http://www.lfix.co.uk/oliver |
| 28 | +X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- |
| 29 | +KMLl*!h}B)u@TW|B}6<X<J|}QsVlTi:RA:O7Abc(@D2Y/"J\S,b1!<&<B/J}b.Ii9@B]H6V!+#sE0Q |
| 30 | +_+=`K$5TI|4I0-=Cp%pt~L#QYydO'iBXR~\tT?uftep9n9AF`@SzTwsw6uqJ}pL,h(cZi}T#PB"#!k |
| 31 | +p^e=Z.K~fuw$l?]lUV)?R]U}l;f*~Ol)#fpKR)Yt}XOr6BI\_Jjr0!@GMnpCTnTym4f;c{;Ms=0{`D |
| 32 | +Lq9MO6{wj%s-*N"G,g |
| 33 | +To: bugs@postgreSQL.org, hackers@postgreSQL.org |
| 34 | +Subject: [HACKERS] Failures with arrays |
| 35 | +Mime-Version: 1.0 |
| 36 | +Content-Type: text/plain; charset=us-ascii |
| 37 | +Date: Wed, 25 Nov 1998 23:48:51 +0000 |
| 38 | +From: "Oliver Elphick" <olly@lfix.co.uk> |
| 39 | +Sender: owner-pgsql-hackers@postgreSQL.org |
| 40 | +Precedence: bulk |
| 41 | +Status: ROr |
| 42 | + |
| 43 | +This was reported as a bug with the Debian package of 6.3.2; the same |
| 44 | +behaviour is still present in 6.4. |
| 45 | + |
| 46 | +bray=> create table foo ( t text[]); |
| 47 | +CREATE |
| 48 | +bray=> insert into foo values ( '{"a"}'); |
| 49 | +INSERT 201354 1 |
| 50 | +bray=> insert into foo values ( '{"a","b"}'); |
| 51 | +INSERT 201355 1 |
| 52 | +bray=> insert into foo values ( '{"a","b","c"}'); |
| 53 | +INSERT 201356 1 |
| 54 | +bray=> select * from foo; |
| 55 | +t |
| 56 | +------------- |
| 57 | +{"a"} |
| 58 | +{"a","b"} |
| 59 | +{"a","b","c"} |
| 60 | +(3 rows) |
| 61 | + |
| 62 | +bray=> select t[1] from foo; |
| 63 | +ERROR: type name lookup of t failed |
| 64 | +bray=> select * from foo; |
| 65 | +t |
| 66 | +------------- |
| 67 | +{"a"} |
| 68 | +{"a","b"} |
| 69 | +{"a","b","c"} |
| 70 | +(3 rows) |
| 71 | + |
| 72 | +bray=> select foo.t[1] from foo; |
| 73 | +t |
| 74 | +- |
| 75 | +a |
| 76 | +a |
| 77 | +a |
| 78 | +(3 rows) |
| 79 | + |
| 80 | +bray=> select count(foo.t[1]) from foo; |
| 81 | +pqReadData() -- backend closed the channel unexpectedly. |
| 82 | + |
| 83 | +-- |
| 84 | +Oliver Elphick Oliver.Elphick@lfix.co.uk |
| 85 | +Isle of Wight http://www.lfix.co.uk/oliver |
| 86 | + PGP key from public servers; key ID 32B8FAA1 |
| 87 | + ======================================== |
| 88 | + "Let us therefore come boldly unto the throne of grace, |
| 89 | + that we may obtain mercy, and find grace to help in |
| 90 | + time of need." Hebrews 4:16 |
| 91 | + |
| 92 | + |
| 93 | + |
| 94 | + |