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: CPU Architecture:Any

[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] Valeriy 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.