Bug #24293 '\Z' token is not handled correctly in views

Description:
If SELECT-part of CREATE VIEW statement contains '\Z',
it is not handled correctly.

The problem is in String::print().
Symbol with code 032 (26) is replaced with '\z',
which is not supported by the lexer.

How to repeat:
mysql> CREATE VIEW v1 AS SELECT 'The\ZEnd';
Query OK, 0 rows affected (0.00 sec)

mysql> select * from v1;
+---------+
| The▒End |
+---------+
| ThezEnd |
+---------+
1 row in set (0.00 sec)

mysql> show create view v1\G
*************************** 1. row ***************************
       View: v1
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select _latin1'ThezEnd' AS `The▒End`
1 row in set (0.00 sec)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/16378

ChangeSet@1.2317, 2006-12-04 16:04:27+03:00, anozdrin@booka. +4 -0
  Fix for BUG#24293: '\Z' token is not handled correctly in views.
  
  If SELECT-part of CREATE VIEW statement contains '\Z',
  it is not handled correctly.
  
  The problem was in String::print().
  Symbol with code 032 (26) is replaced with '\z',
  which is not supported by the lexer.
  
  The fix is to replace the symbol with '\Z'.

Approved by email

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17155

ChangeSet@1.2320, 2006-12-19 15:32:02+03:00, anozdrin@alik. +3 -0
  Fix for BUG#24293: '\Z' token is not handled correctly in views.
  
  If SELECT-part of CREATE VIEW statement contains '\Z',
  it is not handled correctly.
  
  The problem was in String::print().
  Symbol with code 032 (26) is replaced with '\z',
  which is not supported by the lexer.
  
  The fix is to replace the symbol with '\Z'.

Merged into 5.0.34 and 5.1.15

Noted in 5.0.34, 5.1.15 changelogs.

A view was not handled correctly if the SELECT part contained `\Z'.