Bug #23318 Server change DDL automatically
Submitted: 16 Oct 2006 3:21 Modified: 27 Jul 2007 13:36
Reporter: Fauzan Badriawan Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.27-BK OS:Linux (Linux, Windows XP)
Assigned to:

[16 Oct 2006 3:21] Fauzan Badriawan
Description:
I created veiws and trigger in my database server, and i compiled them successfully. But when I reopen them (for editing) the script was changed by server. for example "Select space(10)+Code from .....    change to "select repeat(' ',10) ......

I think it makes me unconfortable.

How to repeat:
Please consider about this
[16 Oct 2006 3:22] Fauzan Badriawan
Thanks
[16 Oct 2006 10:47] Valerii Kravchuk
Thank you for a bug report report. Verified just as described with 5.0.27-BK on Linux:

openxs@suse:~/dbs/5.0> bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.27-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create view vvvv as select space(10);
Query OK, 0 rows affected (0.00 sec)

mysql> show create view vvvv\G
*************************** 1. row ***************************
       View: vvvv
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY
DEFINER VIEW `vvvv` AS select repeat(_latin1' ',10) AS `space(10)`
1 row in set (0.01 sec)
[2 Jun 2007 10:06] Konstantin Osipov
This one will perhaps be fixed when Alik pushes his patch for Bug#11986
[27 Jul 2007 13:36] Konstantin Osipov
Fixed by the patch for Bug#11986