diff options
author | unknown <monty@hundin.mysql.fi> | 2001-09-14 02:54:33 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2001-09-14 02:54:33 +0300 |
commit | 16115af97c160b5d1cbc18272d275cc749151966 (patch) | |
tree | 633afdf8fdbda69f1a5a66b706478fa9e37cf0f8 /mysql-test | |
parent | f9963095282551b24b6843d0d0df1ed69ad9d865 (diff) | |
download | mariadb-git-16115af97c160b5d1cbc18272d275cc749151966.tar.gz |
Changed to use my_global.h
Fixed problem with LIKE with latin1_de
Added parsing support of UNSIGNED LONG LONG
Docs/manual.texi:
Changelog
client/client_priv.h:
Changed to use my_global.h
client/completion_hash.cc:
Changed to use my_global.h
client/errmsg.c:
Changed to use my_global.h
client/get_password.c:
Changed to use my_global.h
client/mysqldump.c:
Changed to use my_global.h
client/mysqlshow.c:
Changed to use my_global.h
client/mysqltest.c:
Changed to use my_global.h
client/password.c:
Changed to use my_global.h
client/readline.cc:
Changed to use my_global.h
client/sql_string.cc:
Changed to use my_global.h
client/thimble.cc:
Changed to use my_global.h
client/thread_test.c:
Changed to use my_global.h
dbug/dbug.c:
Changed to use my_global.h
dbug/dbug_analyze.c:
Changed to use my_global.h
dbug/example1.c:
Changed to use my_global.h
dbug/example2.c:
Changed to use my_global.h
dbug/example3.c:
Changed to use my_global.h
dbug/factorial.c:
Changed to use my_global.h
dbug/main.c:
Changed to use my_global.h
dbug/sanity.c:
Changed to use my_global.h
extra/comp_err.c:
Changed to use my_global.h
extra/my_print_defaults.c:
Changed to use my_global.h
extra/perror.c:
Changed to use my_global.h
extra/replace.c:
Changed to use my_global.h
extra/resolve_stack_dump.c:
Changed to use my_global.h
extra/resolveip.c:
Changed to use my_global.h
fs/libmysqlfs.h:
Changed to use my_global.h
fs/mysqlcorbafs.h:
Changed to use my_global.h
heap/hp_test1.c:
Changed to use my_global.h
include/Makefile.am:
Changed to use my_global.h
include/m_ctype.h:
Changed to use my_global.h
include/my_base.h:
Changed to use my_global.h
innobase/include/univ.i:
Changed to use my_global.h
libmysql/dll.c:
Changed to use my_global.h
libmysql/errmsg.c:
Changed to use my_global.h
libmysql/get_password.c:
Changed to use my_global.h
libmysql/libmysql.c:
Changed to use my_global.h
libmysql/net.c:
Changed to use my_global.h
libmysql/password.c:
Changed to use my_global.h
libmysqld/lib_sql.cc:
Changed to use my_global.h
libmysqld/lib_vio.c:
Changed to use my_global.h
libmysqld/libmysqld.c:
Changed to use my_global.h
mysql-test/mysql-test-run.sh:
Changed to use latin1 as default character set
mysql-test/r/ctype_latin1_de.result:
Changed to use my_global.h
mysql-test/r/func_like.result:
New test
mysql-test/t/ctype_latin1_de.test:
Added test of part keys
mysql-test/t/func_like.test:
New test
mysys/checksum.c:
Changed to use my_global.h
mysys/getopt.c:
Changed to use my_global.h
mysys/getopt1.c:
Changed to use my_global.h
mysys/make-conf.c:
Changed to use my_global.h
mysys/my_alloc.c:
Changed to use my_global.h
mysys/my_clock.c:
Changed to use my_global.h
mysys/my_compress.c:
Changed to use my_global.h
mysys/mysys_priv.h:
Changed to use my_global.h
mysys/test_charset.c:
Changed to use my_global.h
mysys/testhash.c:
Changed to use my_global.h
mysys/thr_alarm.c:
Changed to use my_global.h
mysys/thr_mutex.c:
Changed to use my_global.h
regex/debug.c:
Changed to use my_global.h
regex/main.c:
Changed to use my_global.h
regex/regcomp.c:
Changed to use my_global.h
regex/regerror.c:
Changed to use my_global.h
regex/regexec.c:
Changed to use my_global.h
regex/regexp.c:
Changed to use my_global.h
regex/regfree.c:
Changed to use my_global.h
regex/reginit.c:
Changed to use my_global.h
sql/cache_manager.cc:
Changed to use my_global.h
sql/gen_lex_hash.cc:
Changed to use my_global.h
sql/ha_berkeley.cc:
Fixed problem with UNIQUE keys that could contain NULL
sql/ha_gemini.h:
Changed to use my_global.h
sql/handler.cc:
Fixed problem after merge
sql/item.cc:
Added Item_unit
sql/item.h:
Added Item_uint
sql/matherr.c:
Changed to use my_global.h
sql/md5.c:
Changed to use my_global.h
sql/mini_client.cc:
Changed to use my_global.h
sql/my_lock.c:
Changed to use my_global.h
sql/mysql_priv.h:
Changed to use my_global.h
sql/net_serv.cc:
Changed to use my_global.h
sql/password.c:
Changed to use my_global.h
sql/sql_lex.cc:
Added parsing support of UNSIGNED LONG LONG
sql/sql_show.cc:
Changed to use my_global.h
sql/sql_string.cc:
Changed to use my_global.h
sql/sql_yacc.yy:
Added usage of Int_uint
sql/stacktrace.c:
Changed to use my_global.h
sql/udf_example.cc:
Changed to use my_global.h
strings/atof.c:
Changed to use my_global.h
strings/bchange.c:
Changed to use my_global.h
strings/bcmp.c:
Changed to use my_global.h
strings/bfill.c:
Changed to use my_global.h
strings/bmove.c:
Changed to use my_global.h
strings/bmove512.c:
Changed to use my_global.h
strings/bmove_upp.c:
Changed to use my_global.h
strings/ctype-big5.c:
Changed to use my_global.h
strings/ctype-czech.c:
Changed to use my_global.h
strings/ctype-euc_kr.c:
Changed to use my_global.h
strings/ctype-gb2312.c:
Changed to use my_global.h
strings/ctype-gbk.c:
Changed to use my_global.h
strings/ctype-latin1_de.c:
Fixed problem with LIKE
strings/ctype-sjis.c:
Changed to use my_global.h
strings/ctype-tis620.c:
Changed to use my_global.h
strings/ctype-ujis.c:
Changed to use my_global.h
strings/ctype.c:
Changed to use my_global.h
strings/do_ctype.c:
Changed to use my_global.h
strings/int2str.c:
Changed to use my_global.h
strings/is_prefix.c:
Changed to use my_global.h
strings/llstr.c:
Changed to use my_global.h
strings/longlong2str.c:
Changed to use my_global.h
strings/r_strinstr.c:
Changed to use my_global.h
strings/str2int.c:
Changed to use my_global.h
strings/str_test.c:
Changed to use my_global.h
strings/strappend.c:
Changed to use my_global.h
strings/strcend.c:
Changed to use my_global.h
strings/strcont.c:
Changed to use my_global.h
strings/strend.c:
Changed to use my_global.h
strings/strfill.c:
Changed to use my_global.h
strings/strings-not-used.h:
Changed to use my_global.h
strings/strinstr.c:
Changed to use my_global.h
strings/strmake.c:
Changed to use my_global.h
strings/strmov.c:
Changed to use my_global.h
strings/strnlen.c:
Changed to use my_global.h
strings/strnmov.c:
Changed to use my_global.h
strings/strstr.c:
Changed to use my_global.h
strings/strto.c:
Changed to use my_global.h
strings/strtol.c:
Changed to use my_global.h
strings/strtoll.c:
Changed to use my_global.h
strings/strtoul.c:
Changed to use my_global.h
strings/strtoull.c:
Changed to use my_global.h
strings/strxmov.c:
Changed to use my_global.h
strings/strxnmov.c:
Changed to use my_global.h
strings/udiv.c:
Changed to use my_global.h
tools/mysqlmanager.c:
Changed to use my_global.h
vio/test-ssl.c:
Changed to use my_global.h
vio/test-sslclient.c:
Changed to use my_global.h
vio/test-sslserver.c:
Changed to use my_global.h
vio/test-ssl:
Changed to use my_global.h
vio/vio.c:
Changed to use my_global.h
vio/viosocket.c:
Changed to use my_global.h
vio/viossl.c:
Changed to use my_global.h
vio/viosslfactories.c:
Changed to use my_global.h
vio/viotest-ssl.c:
Changed to use my_global.h
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/mysql-test-run.sh | 2 | ||||
-rw-r--r-- | mysql-test/r/ctype_latin1_de.result | 21 | ||||
-rw-r--r-- | mysql-test/r/func_like.result | 3 | ||||
-rw-r--r-- | mysql-test/t/ctype_latin1_de.test | 12 | ||||
-rw-r--r-- | mysql-test/t/func_like.test | 2 |
5 files changed, 31 insertions, 9 deletions
diff --git a/mysql-test/mysql-test-run.sh b/mysql-test/mysql-test-run.sh index e876eb2264d..e20eb4e0869 100644 --- a/mysql-test/mysql-test-run.sh +++ b/mysql-test/mysql-test-run.sh @@ -128,7 +128,7 @@ DO_GDB="" DO_DDD="" DO_CLIENT_GDB="" SLEEP_TIME=2 -CHARACTER_SET=latin1_de +CHARACTER_SET=latin1 DBUSER="" while test $# -gt 0; do diff --git a/mysql-test/r/ctype_latin1_de.result b/mysql-test/r/ctype_latin1_de.result index 71bed79891a..44a1757209e 100644 --- a/mysql-test/r/ctype_latin1_de.result +++ b/mysql-test/r/ctype_latin1_de.result @@ -9,6 +9,8 @@ aeae 33 ääa 32 aeb 6 Äc 5 +é 38 +É 39 eä 28 o 37 oc 15 @@ -36,8 +38,6 @@ ueb 12 üc 7 uf 13 uü 29 -é 38 -É 39 a b a 35 ac 2 @@ -49,6 +49,8 @@ aeae 33 ääa 32 aeb 6 Äc 5 +é 38 +É 39 eä 28 o 37 oc 15 @@ -76,11 +78,7 @@ ueb 12 üc 7 uf 13 uü 29 -é 38 -É 39 a -É -é uü uf üc @@ -108,6 +106,8 @@ od oc o eä +É +é Äc aeb ääa @@ -121,11 +121,11 @@ a Table Op Msg_type Msg_text test.t1 check status OK a b +ö 14 Öa 16 Öc 19 öo 30 a b -é 38 É 39 a b a 35 @@ -166,3 +166,10 @@ strcmp('ßa','ss') strcmp('ssa','ß') strcmp('sssb','sßa') strcmp('ß','s') 1 1 1 1 strcmp('u','öa') strcmp('u','ö') 1 1 +a +abc +abcd +a +test +a +test diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result index 78bede19762..a6c28daae88 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -2,6 +2,9 @@ a abc abcd a +abc +abcd +a test a test diff --git a/mysql-test/t/ctype_latin1_de.test b/mysql-test/t/ctype_latin1_de.test index 1df700340da..d39d7f6e5dd 100644 --- a/mysql-test/t/ctype_latin1_de.test +++ b/mysql-test/t/ctype_latin1_de.test @@ -14,7 +14,7 @@ select a,b from t1 order by upper(a),b; select a from t1 order by a desc; check table t1; select * from t1 where a like "ö%"; -select * from t1 where a like "%É%"; +select * from t1 where a like binary "%É%"; select * from t1 where a like "%Á%"; select * from t1 where a like "%U%"; select * from t1 where a like "%ss%"; @@ -34,3 +34,13 @@ select strcmp('af','ä'),strcmp('ä','a'),strcmp('aeq','ää'),strcmp('aeaeq','ää'); select strcmp('ßa','ss'),strcmp('ssa','ß'),strcmp('sssb','sßa'),strcmp('ß','s'); select strcmp('u','öa'),strcmp('u','ö'); +# +# Some other simple tests with the current character set +# + +create table t1 (a varchar(10), key(a)); +insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); +select * from t1 where a like "abc%"; +select * from t1 where a like "test%"; +select * from t1 where a like "te_t"; +drop table t1; diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test index d160b04176c..e0f1f0db9ce 100644 --- a/mysql-test/t/func_like.test +++ b/mysql-test/t/func_like.test @@ -2,9 +2,11 @@ # Test of like # +drop table if exists t1; create table t1 (a varchar(10), key(a)); insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); select * from t1 where a like "abc%"; +select * from t1 where a like "ABC%"; select * from t1 where a like "test%"; select * from t1 where a like "te_t"; drop table t1; |