Bug #20500 trim(both ' ' from col) causes syntax error in a view
| Submitted: | 16 Jun 2006 12:30 | Modified: | 18 Jun 2006 19:35 |
|---|---|---|---|
| Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Views | Severity: | S3 (Non-critical) |
| Version: | 5.0BK, 5.1.11 | OS: | Any (*) |
| Assigned to: | CPU Architecture: | Any |
[16 Jun 2006 12:30]
Shane Bester
[16 Jun 2006 12:51]
Valeriy Kravchuk
Even more simple test case: mysql> select trim(both ' ' from ' edfdfd ') as a; +--------+ | a | +--------+ | edfdfd | +--------+ 1 row in set (0.00 sec) mysql> create view vvv2 as select trim(both ' ' from ' edfdfd ') as a; Query OK, 0 rows affected (0.01 sec) mysql> select * from vvv2; ERROR 1064 (42000): 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 '_latin1' ') AS `a`' at line 1
[17 Jun 2006 13:12]
Trent Lloyd
This is a duplicate of Bug #17526
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 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.