PostgreSQL 7.0 beta 4: Error in Insert/Select
Michael Shepelev <michaels@alias.ru>
From: Michael Shepelev <MichaelS@alias.ru>
To: "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>
Date: 2000-04-25T04:41:02Z
Lists: pgsql-bugs
Attachments
- bug_in_insert.tgz (application/octet-stream)
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Michael Shepelev
Your email address : docent@alias.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>>