Bug #11387 create view v1 as select caset(1 as decimal); select * from v1 fails
Submitted: 16 Jun 2005 15:36 Modified: 23 Jun 2005 18:31
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:Linux (SuSE 9.1)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[16 Jun 2005 15:36] Konstantin Osipov 
Description:
mysql> create view v2 as select cast(1 as decimal);
Query OK, 0 rows affected (0.04 sec)

mysql> select * from v2;
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?(1) AS `cast(1 as decimal)`' at line 1

How to repeat:
See description.

Suggested fix:
Implement proper ::print() method of all CAST items.
[17 Jun 2005 14:28] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/26121
[18 Jun 2005 19:22] Oleksandr Byelkin 
pushed to 5.0.8
[23 Jun 2005 18:31] Mike Hillyer 
Documented in 5.0.8 changelog.