Bug #5160 Views: column name not found if long number used
Submitted: 23 Aug 2004 1:44 Modified: 6 Sep 2004 13:50
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

[23 Aug 2004 1:44] Peter Gulutzan 
Description:
If I have 52 digits in a number, I get no error when I 
create a view. But I can't see the view. The column name 
that I give for the number appears to be lost. I get an 
"Unknown column" error. 

How to repeat:
mysql> create view v as select 
99999999999999999999999999999999999999999999999999999 as col1; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show create view v; 
ERROR 1054 (42S22): Unknown column 'col1' in 'field list'
[1 Sep 2004 19:31] Oleksandr Byelkin 
ChangeSet 
  1.1742 04/09/01 20:30:48 bell@sanja.is.com.ua +4 -0 
  fixed printing of real constants (BUG#5160)
[6 Sep 2004 13:50] Oleksandr Byelkin 
Thank you for bugreport! 
Bug is fixed patch is pushed into server 5.0 source repository.