| 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: | Whole Thread | Raw Message | 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 | 
| 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 |