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: | |
| 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: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.
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