diff options
author | unknown <monty@donna.mysql.com> | 2001-02-15 03:43:14 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.com> | 2001-02-15 03:43:14 +0200 |
commit | c1488c7e5896920e5f66e28de38964ae9b5ff22e (patch) | |
tree | 48461790e73014dbea005fbd6ef8d48e83cc6f14 /mysql-test | |
parent | 8ece82e4dcef6b7dd097350890e27b593ec079b1 (diff) | |
download | mariadb-git-c1488c7e5896920e5f66e28de38964ae9b5ff22e.tar.gz |
Changed --replace to --replace_result in mysqltest
Changed errmsg -> my_errmsg (portability issue)
Fixed that mysqlbinlog writes SET TIMESTAMP before all queries
Fixed comments in default my.cnf files
Docs/manual.texi:
Updated information about character sets
client/mysqladmin.c:
Added missing help text
client/mysqltest.c:
Changed --replace to --replace_result to not conflict with SQL replace command
include/my_sys.h:
change errmsg -> my_errmsg (portability issue)
libmysql/errmsg.c:
change errmsg -> my_errmsg (portability issue)
myisam/mi_cache.c:
Changed seek+read to pread
myisam/mi_check.c:
Fix bug that caused myisamchk to be very slow under some specific error conditions
myisam/mi_dynrec.c:
cleanup
myisam/myisamchk.c:
Write out value of checksum
myisam/myisamdef.h:
cleanup
mysql-test/r/backup.result:
Fixed the case where backup caused different error messages
mysql-test/r/bdb.result:
Added new test case
mysql-test/r/fulltext.result:
Fix for new CREATE TABLE format
mysql-test/t/backup.test:
Use --replace_result and --send
mysql-test/t/bdb.test:
New test case
mysql-test/t/status.test:
Use --send
mysys/errors.c:
change errmsg -> my_errmsg (portability issue)
mysys/my_error.c:
change errmsg -> my_errmsg (portability issue)
mysys/typelib.c:
Only accept full type names
sql/derror.cc:
change errmsg -> my_errmsg (portability issue)
sql/ha_berkeley.cc:
Fixed bug when using key parts that could be NULL
sql/log_event.cc:
Log SET TIMESTAMP before all queries
sql/mysqlbinlog.cc:
Incremented version number
sql/mysqld.cc:
change errmsg -> my_errmsg (portability issue)
Always accept --skip-gemeni, --skip-bdb and --skip-innobase
sql/slave.cc:
cleanup
sql/sql_base.cc:
cleanup
sql/sql_db.cc:
cleanup
support-files/my-huge.cnf.sh:
Remove usage of # at end of line
support-files/my-large.cnf.sh:
Remove usage of # at end of line
support-files/my-medium.cnf.sh:
Remove usage of # at end of line
support-files/my-small.cnf.sh:
Remove usage of # at end of line
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/backup.result | 2 | ||||
-rw-r--r-- | mysql-test/r/bdb.result | 4 | ||||
-rw-r--r-- | mysql-test/r/fulltext.result | 4 | ||||
-rw-r--r-- | mysql-test/t/backup.test | 8 | ||||
-rw-r--r-- | mysql-test/t/bdb.test | 10 | ||||
-rw-r--r-- | mysql-test/t/status.test | 3 |
6 files changed, 24 insertions, 7 deletions
diff --git a/mysql-test/r/backup.result b/mysql-test/r/backup.result index 4b7b62f3ee8..5bfa1e9013e 100644 --- a/mysql-test/r/backup.result +++ b/mysql-test/r/backup.result @@ -1,5 +1,5 @@ Table Op Msg_type Msg_text -t1 backup error Failed copying .frm file: errno = 2 +t1 backup error Failed copying .frm file: errno = X test.t1 backup status Operation failed Table Op Msg_type Msg_text test.t1 backup status OK diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result index 00423b7e9e0..085a4214f35 100644 --- a/mysql-test/r/bdb.result +++ b/mysql-test/r/bdb.result @@ -477,3 +477,7 @@ Table Op Msg_type Msg_text test.t1 optimize status OK Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t1 0 PRIMARY 1 a A 2 NULL NULL +i j +1 2 +i j +1 2 diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index a08b5da99a4..025cd022cd4 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -17,6 +17,6 @@ Table Create Table t2 CREATE TABLE `t2` ( `ticket` int(11) default NULL, `inhalt` text, - KEY `tig`(`ticket`), - FULLTEXT KEY `tix`(`inhalt`) + KEY `tig` (`ticket`), + FULLTEXT KEY `tix` (`inhalt`) ) TYPE=MyISAM diff --git a/mysql-test/t/backup.test b/mysql-test/t/backup.test index 1bd57d68b49..22ec4b6f2f1 100644 --- a/mysql-test/t/backup.test +++ b/mysql-test/t/backup.test @@ -4,7 +4,7 @@ connection con1; set SQL_LOG_BIN=0; drop table if exists t1; create table t1(n int); ---replace "errno = 2" "errno = X" "errno = 22" "errno = X" +--replace_result "errno = 2" "errno = X" "errno = 22" "errno = X" backup table t1 to '../bogus'; backup table t1 to '../tmp'; drop table t1; @@ -29,9 +29,11 @@ select k from t3; drop table t1,t2,t3; restore table t1 from '../tmp'; connection con2; -send lock tables t1 write; +--send +lock tables t1 write; connection con1; -send backup table t1 to '../tmp'; +--send +backup table t1 to '../tmp'; connection con2; reap; unlock tables; diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 5f8ef3ff18e..f4b4d17e180 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -419,3 +419,13 @@ select * from t1 order by b desc; optimize table t1; show keys from t1; drop table t1; + +# +# Test of bug in create index with NULL columns +# +create table t1 (i int, j int )TYPE=BDB; +insert into t1 values (1,2); +select * from t1 where i=1 and j=2; +create index ax1 on t1 (i,j); +select * from t1 where i=1 and j=2; +drop table t1; diff --git a/mysql-test/t/status.test b/mysql-test/t/status.test index 7c825469f09..8b5ab3565ad 100644 --- a/mysql-test/t/status.test +++ b/mysql-test/t/status.test @@ -13,7 +13,8 @@ lock tables t1 read; unlock tables; lock tables t1 read; connection con1; -send update t1 set n = 3; +--send +update t1 set n = 3; connection con2; sleep 0.5; unlock tables; |