diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-26 16:11:46 +0400 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-26 16:11:46 +0400 |
| commit | 3eff43162ba3136ecd305534f1e9d7cc779ce301 (patch) | |
| tree | c8c034c5ee2087b4b6a01f36456f4ca2bd8d20dc /mysql-test/r/cast.result | |
| parent | c1e76fc06051f7f061f40d44e2b846ab04fdabfd (diff) | |
| download | mariadb-git-3eff43162ba3136ecd305534f1e9d7cc779ce301.tar.gz | |
1. New data types, from the user point of view:
BINARY(N) and VARBIBARY(N)
2. More 4.0 compatibility and more BINARY keyword consistency:
2a. CREATE TABLE a (a CHAR(N) BINARY)
is now synonym for
CREATE TABLE a (a CHAR(N) COLLATE xxxx_bin)
2b. SELECT BINARY x
is still synonin for
SELECT x COLLATE xxxxx_bin.
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 877a349d188..cdeb5b3dc21 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -51,11 +51,11 @@ CONVERT(DATE "2004-01-22 21:45:33",CHAR) select CONVERT(DATE "2004-01-22 21:45:33",CHAR(4)); CONVERT(DATE "2004-01-22 21:45:33",CHAR(4)) 2004 -select CONVERT(DATE "2004-01-22 21:45:33",CHAR(4) BINARY); -CONVERT(DATE "2004-01-22 21:45:33",CHAR(4) BINARY) +select CONVERT(DATE "2004-01-22 21:45:33",BINARY(4)); +CONVERT(DATE "2004-01-22 21:45:33",BINARY(4)) 2004 -select CAST(DATE "2004-01-22 21:45:33" AS CHAR(4) BINARY); -CAST(DATE "2004-01-22 21:45:33" AS CHAR(4) BINARY) +select CAST(DATE "2004-01-22 21:45:33" AS BINARY(4)); +CAST(DATE "2004-01-22 21:45:33" AS BINARY(4)) 2004 set names binary; select cast(_latin1'test' as char character set latin2); @@ -91,11 +91,11 @@ ab a ab a a show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `c1` char(2) binary NOT NULL default '', - `c2` char(2) binary NOT NULL default '', - `c3` char(2) binary NOT NULL default '', - `c4` char(2) binary NOT NULL default '', - `c5` char(2) binary NOT NULL default '' + `c1` binary(2) NOT NULL default '', + `c2` binary(2) NOT NULL default '', + `c3` binary(2) NOT NULL default '', + `c4` binary(2) NOT NULL default '', + `c5` binary(2) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; select |