Bug #6376 Create view with union

• Submitted: 2 Nov 2004 2:29
• Modified: 2 Nov 2004 3:20
• Reporter: James Dunn
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.1
• OS: Windows (Windows)
• CPU Architecture: Any

[2 Nov 2004 2:29] James Dunn

Description:
Unable to create view containing union query. 

How to repeat:
CREATE TABLE `Curl`.`tablea` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `TextField` text NULL,
  PRIMARY KEY (`Id`)
)  TYPE=MyISAM;
SHOW TABLE STATUS FROM `Curl`;
CREATE TABLE `tableb` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `TextField` text NULL,
  PRIMARY KEY (`Id`)
)  TYPE=MyISAM;
CREATE TABLE `TableB` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `TextField` text NULL,
  PRIMARY KEY (`Id`)
)  TYPE=MyISAM;
CREATE OR REPLACE view vwtableab AS SELECT * FROM tablea UNION SELECT * FROM tableb;

[2 Nov 2004 3:20] MySQL Verification Team

This was already fixed on Bk source tree 5.0:

mysql> CREATE OR REPLACE view vwtableab AS SELECT * FROM tablea UNION SELECT * FROM
    -> tableb;
Query OK, 0 rows affected (0.02 sec)

mysql> select version();
+-----------------------+
| version()             |
+-----------------------+
| 5.0.2-alpha-debug-log |
+-----------------------+
1 row in set (0.00 sec)

Thank you for the bug report.