summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.com>2001-02-15 03:43:14 +0200
committerunknown <monty@donna.mysql.com>2001-02-15 03:43:14 +0200
commitc1488c7e5896920e5f66e28de38964ae9b5ff22e (patch)
tree48461790e73014dbea005fbd6ef8d48e83cc6f14 /mysql-test
parent8ece82e4dcef6b7dd097350890e27b593ec079b1 (diff)
downloadmariadb-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.result2
-rw-r--r--mysql-test/r/bdb.result4
-rw-r--r--mysql-test/r/fulltext.result4
-rw-r--r--mysql-test/t/backup.test8
-rw-r--r--mysql-test/t/bdb.test10
-rw-r--r--mysql-test/t/status.test3
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;