diff options
| author | jimw@mysql.com <> | 2005-04-01 19:17:15 -0800 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-04-01 19:17:15 -0800 |
| commit | 5865330a9e27c050dd644705457eb5d4415e27fd (patch) | |
| tree | 0f605570b31eecc8dd6b58343d5a07d32375e540 /mysql-test/r/user_var.result | |
| parent | 2292480e795a02973b828a37f826c6e4e0192b69 (diff) | |
| parent | 623a5d5a57f8f8ee2674245e0abafaef698577fb (diff) | |
| download | mariadb-git-5865330a9e27c050dd644705457eb5d4415e27fd.tar.gz | |
Merge embedded server testing changes from 4.1.
Diffstat (limited to 'mysql-test/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 32 |
1 files changed, 0 insertions, 32 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index bd261751938..24470c8f716 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -168,38 +168,6 @@ latin2 latin2_bin 2 select (@a:=_latin2'test' collate latin2_bin) = _latin2'TEST' collate latin2_general_ci; (@a:=_latin2'test' collate latin2_bin) = _latin2'TEST' collate latin2_general_ci 1 -create table t1 (a varchar(50)); -reset master; -SET TIMESTAMP=10000; -SET @`a b`='hello'; -INSERT INTO t1 VALUES(@`a b`); -set @var1= "';aaa"; -SET @var2=char(ascii('a')); -insert into t1 values (@var1),(@var2); -show binlog events from 98; -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # User var 1 # @`a b`=_latin1 0x68656C6C6F COLLATE latin1_swedish_ci -master-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES(@`a b`) -master-bin.000001 # User var 1 # @`var1`=_latin1 0x273B616161 COLLATE latin1_swedish_ci -master-bin.000001 # User var 1 # @`var2`=_latin1 0x61 COLLATE latin1_swedish_ci -master-bin.000001 # Query 1 # use `test`; insert into t1 values (@var1),(@var2) -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -ROLLBACK; -SET @`a b`:=_latin1 0x68656C6C6F COLLATE `latin1_swedish_ci`; -use test; -SET TIMESTAMP=10000; -SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1; -SET @@session.sql_mode=0; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8; -INSERT INTO t1 VALUES(@`a b`); -SET @`var1`:=_latin1 0x273B616161 COLLATE `latin1_swedish_ci`; -SET @`var2`:=_latin1 0x61 COLLATE `latin1_swedish_ci`; -SET TIMESTAMP=10000; -insert into t1 values (@var1),(@var2); -ROLLBACK; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; -drop table t1; set @var= NULL ; select FIELD( @var,'1it','Hit') as my_column; my_column |