diff options
author | unknown <jimw@mysql.com> | 2005-02-10 18:08:30 -0800 |
---|---|---|
committer | unknown <jimw@mysql.com> | 2005-02-10 18:08:30 -0800 |
commit | 20586596285bc31eb8ad76a71504d17a4fa71cf1 (patch) | |
tree | 779b402a12190be99434357ca4b71e0d129f29b4 | |
parent | 4f7a0857f17247e05ed05dd6263acba059982337 (diff) | |
download | mariadb-git-20586596285bc31eb8ad76a71504d17a4fa71cf1.tar.gz |
Re-enable ctype_latin1_de test for embedded server (already passes, so it
appears to have been accidently disabled) and enable ctype_ucs after moving
a subtest that requires binlog to its own test file.
mysql-test/mysql-test-run.sh:
Remove hardcoded skip of ctype_latin1_de and ctype_ucs for embedded server
mysql-test/t/ctype_ucs.test:
Move binlog test to a new test file
mysql-test/r/ctype_ucs.result:
Update result after test moved
-rw-r--r-- | mysql-test/mysql-test-run.sh | 2 | ||||
-rw-r--r-- | mysql-test/r/ctype_ucs.result | 15 | ||||
-rw-r--r-- | mysql-test/r/ctype_ucs_binlog.result | 15 | ||||
-rw-r--r-- | mysql-test/t/ctype_ucs.test | 17 | ||||
-rw-r--r-- | mysql-test/t/ctype_ucs_binlog.test | 19 |
5 files changed, 34 insertions, 34 deletions
diff --git a/mysql-test/mysql-test-run.sh b/mysql-test/mysql-test-run.sh index 0bc68c3b6bb..f31d1af48aa 100644 --- a/mysql-test/mysql-test-run.sh +++ b/mysql-test/mysql-test-run.sh @@ -1508,8 +1508,6 @@ run_testcase () for t in \ "bdb-deadlock" \ "connect" \ - "ctype_latin1_de" \ - "ctype_ucs" \ "flush_block_commit" \ "grant2" \ "grant_cache" \ diff --git a/mysql-test/r/ctype_ucs.result b/mysql-test/r/ctype_ucs.result index 3f50d9dfa1b..115e35817d6 100644 --- a/mysql-test/r/ctype_ucs.result +++ b/mysql-test/r/ctype_ucs.result @@ -510,21 +510,6 @@ prepare stmt1 from @str2; execute stmt1 using @ivar; ? 1234 -SET TIMESTAMP=10000; -create table t2 (c char(30)) charset=ucs2; -set @v=convert('abc' using ucs2); -reset master; -insert into t2 values (@v); -show binlog events from 79; -Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000001 79 User var 1 79 @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci -master-bin.000001 119 Query 1 119 use `test`; insert into t2 values (@v) -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`; -use test; -SET TIMESTAMP=10000; -insert into t2 values (@v); -drop table t2; set names latin1; create table t1 (a enum('x','y','z') character set ucs2); show create table t1; diff --git a/mysql-test/r/ctype_ucs_binlog.result b/mysql-test/r/ctype_ucs_binlog.result new file mode 100644 index 00000000000..29718fa32a1 --- /dev/null +++ b/mysql-test/r/ctype_ucs_binlog.result @@ -0,0 +1,15 @@ +SET TIMESTAMP=10000; +create table t2 (c char(30)) charset=ucs2; +set @v=convert('abc' using ucs2); +reset master; +insert into t2 values (@v); +show binlog events from 79; +Log_name Pos Event_type Server_id Orig_log_pos Info +master-bin.000001 79 User var 1 79 @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci +master-bin.000001 119 Query 1 119 use `test`; insert into t2 values (@v) +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`; +use test; +SET TIMESTAMP=10000; +insert into t2 values (@v); +drop table t2; diff --git a/mysql-test/t/ctype_ucs.test b/mysql-test/t/ctype_ucs.test index 1a0ba82d6ff..52c46a77c8c 100644 --- a/mysql-test/t/ctype_ucs.test +++ b/mysql-test/t/ctype_ucs.test @@ -329,23 +329,6 @@ prepare stmt1 from @str2; execute stmt1 using @ivar; # -# Check correct binlogging of UCS2 user variables (BUG#3875) -# -SET TIMESTAMP=10000; -create table t2 (c char(30)) charset=ucs2; -set @v=convert('abc' using ucs2); -reset master; -insert into t2 values (@v); -show binlog events from 79; -# more important than SHOW BINLOG EVENTS, mysqlbinlog (where we -# absolutely need variables names to be quoted and strings to be -# escaped). ---replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR ---exec $MYSQL_BINLOG --short-form $MYSQL_TEST_DIR/var/log/master-bin.000001 -drop table t2; - - -# # Check that ucs2 works with ENUM and SET type # set names latin1; diff --git a/mysql-test/t/ctype_ucs_binlog.test b/mysql-test/t/ctype_ucs_binlog.test new file mode 100644 index 00000000000..57b831a9dcb --- /dev/null +++ b/mysql-test/t/ctype_ucs_binlog.test @@ -0,0 +1,19 @@ +--source include/not_embedded.inc + +# +# Check correct binlogging of UCS2 user variables (BUG#3875) +# +SET TIMESTAMP=10000; +create table t2 (c char(30)) charset=ucs2; +set @v=convert('abc' using ucs2); +reset master; +insert into t2 values (@v); +show binlog events from 79; +# more important than SHOW BINLOG EVENTS, mysqlbinlog (where we +# absolutely need variables names to be quoted and strings to be +# escaped). +--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR +--exec $MYSQL_BINLOG --short-form $MYSQL_TEST_DIR/var/log/master-bin.000001 +drop table t2; + + |