~james-page/ubuntu/precise/mysql-5.5/misc-fixes

« back to all changes in this revision

Viewing changes to mysql-test/r/cast.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-06-11 07:34:33 UTC
  • mfrom: (1.1.6)
  • Revision ID: package-import@ubuntu.com-20120611073433-l9za2ni4ipp848y3
Tags: 5.5.24-0ubuntu0.12.04.1
* SECURITY UPDATE: Update to 5.5.24 to fix security issues (LP: #1011371)
  - http://dev.mysql.com/doc/refman/5.5/en/news-5-5-24.html

Show diffs side-by-side

added added

removed removed

Lines of Context:
468
468
Warnings:
469
469
Warning 1301    Result of cast_as_char() was larger than max_allowed_packet (2048) - truncated
470
470
SET @@GLOBAL.max_allowed_packet=default;
 
471
#
 
472
# Bug#13519724 63793: CRASH IN DTCOLLATION::SET(DTCOLLATION &SET)
 
473
#
 
474
CREATE TABLE t1 (a VARCHAR(50));
 
475
SELECT a FROM t1 
 
476
WHERE CAST(a as BINARY)=x'62736D697468' 
 
477
AND CAST(a AS BINARY)=x'65736D697468';
 
478
a
 
479
DROP TABLE t1;
471
480
End of 5.1 tests