PostgreSQL 7.0 beta 4: Error in Insert/Select

From: Michael Shepelev <MichaelS(at)alias(dot)ru>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: PostgreSQL 7.0 beta 4: Error in Insert/Select
Date: 2000-04-25 04:41:02
Message-ID: 70CB60CD235DD2119AC6008048E912161C9E@VENUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Michael Shepelev
Your email address : docent(at)alias(dot)ru

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Celeron 400

Operating System (example: Linux 2.0.26 ELF) : Mandrake 7.0 RE

PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0 beta 4

Compiler used (example: gcc 2.8.0) : gcc version 2.95.2
19991024 (release)

Please enter a FULL description of your problem:
------------------------------------------------
Sorry my english.
I found bug (IMHO) in Insert/Select Union command.
Result of SELECT UNION differs from INSERT SELECT UNION.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
I attach an example that demonstrates this bug.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
<<bug_in_insert.tgz>>

Attachment Content-Type Size
bug_in_insert.tgz application/octet-stream 2.0 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-04-25 06:10:02 Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Previous Message Tom Lane 2000-04-25 03:42:46 Re: initdb crash after install