Bug #5332 Views: CREATE VIEW allows INTO clause
Submitted: 1 Sep 2004 2:49 Modified: 6 Sep 2004 13:55
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[1 Sep 2004 2:49] Peter Gulutzan 
Description:
MySQL allows the clause "INTO <variable>" in CREATE VIEW ... SELECT. 
This is insignificant, but the ANSI standard says it should be illegal, so make it so. 
 

How to repeat:
mysql> create view vk as select 5 into @w; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show create view vk; 
+-------+--------------------------------------------------------+ 
| Table | Create Table                                           | 
+-------+--------------------------------------------------------+ 
| vk    | CREATE VIEW `db5`.`vk` AS select sql_no_cache 5 AS `5` | 
+-------+--------------------------------------------------------+ 
1 row in set (0.26 sec)
[1 Sep 2004 4:44] MySQL Verification Team 
Verified with latest BK 5.0 source tree.
[2 Sep 2004 11:20] Oleksandr Byelkin 
ChangeSet 
  1.1743 04/09/02 12:09:26 bell@sanja.is.com.ua +27 -0 
  checked INTO clause during view creation (BUG#5332)
[6 Sep 2004 13:55] Oleksandr Byelkin 
Thank you for bugreport! Bug is fixed, patch is pushed into source repository.