From 9d78adc16fa0141921395be232348af8ef8c9181 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 17 Mar 2004 10:35:03 +0100 Subject: Fix for BUG#2922 "Crash (signal11) after "load data from master"" with a testcase. We needed to init_master_info before we flush_master_info in LOAD DATA FROM MASTER. mysql-test/r/rpl000009.result: result update mysql-test/t/rpl000009.test: adding a test for RESET SLAVE + LOAD DATA FROM MASTER sql/repl_failsafe.cc: LOAD DATA FROM MASTER udpates the master info in the slave, so needs to ensure that it is properly inited first (otherwise, after RESET SLAVE, we are flush_io_cache()ing an uninitialized IO_CACHE master.info). Note that it master info is already inited (active_mi->inited==1), init_master_info() will do nothing, which is what we want. --- mysql-test/r/rpl000009.result | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/r') diff --git a/mysql-test/r/rpl000009.result b/mysql-test/r/rpl000009.result index 569dd301143..a4611cf7d42 100644 --- a/mysql-test/r/rpl000009.result +++ b/mysql-test/r/rpl000009.result @@ -111,6 +111,18 @@ n s 2 two bar 3 three bar 4 four bar +stop slave; +reset slave; +load data from master; +start slave; +insert into bar.t1 values (5, 'five bar'); +select * from bar.t1; +n s +1 one bar +2 two bar +3 three bar +4 four bar +5 five bar load table bar.t1 from master; Table 't1' already exists drop table bar.t1; -- cgit v1.2.1 From 6b465557670093b038cb3d2be930e6a036292192 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 19 Mar 2004 15:03:12 +0200 Subject: Removed \r --- mysql-test/r/system_mysql_db_refs.result | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/r') diff --git a/mysql-test/r/system_mysql_db_refs.result b/mysql-test/r/system_mysql_db_refs.result index a08b46ffbbb..e15934b03ac 100644 --- a/mysql-test/r/system_mysql_db_refs.result +++ b/mysql-test/r/system_mysql_db_refs.result @@ -17,7 +17,7 @@ insert into test_tables_priv (Host,Db,User,Table_name) values (@name,@name,@name create table test_columns_priv select * from mysql.columns_priv; delete from test_columns_priv; insert into test_columns_priv (Host,Db,User,Table_name,Column_name) values (@name,@name,@name,@name,@name); -select +select if(isnull(test_db.Host),'WRONG!!!','ok') as test_db_Host, if(isnull(test_host.Host),'WRONG!!!','ok') as test_host_Host, if(isnull(test_user.Host),'WRONG!!!','ok') as test_user_Host, @@ -30,7 +30,7 @@ left join test_tables_priv on test_db.Host=test_tables_priv.Host left join test_columns_priv on test_db.Host=test_columns_priv.Host; test_db_Host test_host_Host test_user_Host test_tables_priv_Host test_columns_priv_Host ok ok ok ok ok -select +select if(isnull(test_db.Db),'WRONG!!!','ok') as test_db_Db, if(isnull(test_host.Db),'WRONG!!!','ok') as test_host_Db, if(isnull(test_tables_priv.Db),'WRONG!!!','ok') as test_tables_priv_Db, -- cgit v1.2.1 From 86ae07cd2477506513a47a8c0d7600f59422c7e1 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 19 Mar 2004 18:26:02 +0200 Subject: Portability fixes Fixed some wrong column specifications in mysql_fix_privilege_tables mysql-test/mysql-test-run.sh: Portability fix mysql-test/r/func_math.result: portability fix mysql-test/r/rpl_error_ignored_table.result: portability fix mysql-test/t/func_math.test: portability fix mysql-test/t/rpl_error_ignored_table.test: portability fix scripts/mysql_fix_privilege_tables.sh: func.name was not generated correctly scripts/mysql_fix_privilege_tables.sql: Fixed some wrong column specifications --- mysql-test/r/func_math.result | 9 --------- mysql-test/r/rpl_error_ignored_table.result | 2 +- 2 files changed, 1 insertion(+), 10 deletions(-) (limited to 'mysql-test/r') diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index 04dabcb5481..46ad7a14e25 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -59,12 +59,3 @@ ASIN(0.8+0.2) SELECT ASIN(1.2-0.2); ASIN(1.2-0.2) 1.570796 -select floor(log(4)/log(2)); -floor(log(4)/log(2)) -2 -select floor(log(8)/log(2)); -floor(log(8)/log(2)) -3 -select floor(log(16)/log(2)); -floor(log(16)/log(2)) -4 diff --git a/mysql-test/r/rpl_error_ignored_table.result b/mysql-test/r/rpl_error_ignored_table.result index 0e7ac72041c..329af301073 100644 --- a/mysql-test/r/rpl_error_ignored_table.result +++ b/mysql-test/r/rpl_error_ignored_table.result @@ -26,7 +26,7 @@ select (@id := id) - id from t3; 0 kill @id; drop table t2,t3; -Server shutdown in progress +Got one of the listed errors show binlog events from 79; Log_name Pos Event_type Server_id Orig_log_pos Info master-bin.001 79 Query 1 79 use `test`; create table t1 (a int primary key) -- cgit v1.2.1 From 28813a9ea9b5149b7c370f616232ea60dadf852c Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 19 Mar 2004 18:33:38 +0200 Subject: Added test to show bug in current union implementation After merge fixes Portability fixes client/mysqltest.c: Fixed that unget() is done properly (needed for QNX where one can't do many ungetc() in a row) include/errmsg.h: After merge fixes mysql-test/mysql-test-run.sh: merge fix mysql-test/r/system_mysql_db.result: Updated results for 4.1 mysql-test/r/union.result: Added new test mysql-test/t/derived.test: Portability fix (for Mac OS X) mysql-test/t/system_mysql_db_refs.test: Remove warnings mysql-test/t/union.test: Added test to show bug in current union implementation (to be fixed in 4.1) scripts/mysql_create_system_tables.sh: Fix wrong column define scripts/mysql_fix_privilege_tables.sh: Fix for mysql-test-run scripts/mysql_fix_privilege_tables.sql: Merge with 4.0 to get comments. Updated so that it works with privilege tables for MySQL 3.23. sql/repl_failsafe.cc: After merge fix --- mysql-test/r/system_mysql_db.result | 24 ++++++++++++++---------- mysql-test/r/union.result | 15 +++++++++++++++ 2 files changed, 29 insertions(+), 10 deletions(-) (limited to 'mysql-test/r') diff --git a/mysql-test/r/system_mysql_db.result b/mysql-test/r/system_mysql_db.result index 257b3b13f08..8da46564619 100644 --- a/mysql-test/r/system_mysql_db.result +++ b/mysql-test/r/system_mysql_db.result @@ -3,6 +3,10 @@ Tables_in_db columns_priv db func +help_category +help_keyword +help_relation +help_topic host tables_priv user @@ -26,7 +30,7 @@ db CREATE TABLE `db` ( `Lock_tables_priv` enum('N','Y') NOT NULL default 'N', PRIMARY KEY (`Host`,`Db`,`User`), KEY `User` (`User`) -) TYPE=MyISAM COMMENT='Database privileges' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Database privileges' show create table host; Table Create Table host CREATE TABLE `host` ( @@ -45,13 +49,13 @@ host CREATE TABLE `host` ( `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N', `Lock_tables_priv` enum('N','Y') NOT NULL default 'N', PRIMARY KEY (`Host`,`Db`) -) TYPE=MyISAM COMMENT='Host privileges; Merged with database privileges' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Host privileges; Merged with database privileges' show create table user; Table Create Table user CREATE TABLE `user` ( `Host` varchar(60) binary NOT NULL default '', `User` varchar(16) binary NOT NULL default '', - `Password` varchar(16) binary NOT NULL default '', + `Password` varchar(41) binary NOT NULL default '', `Select_priv` enum('N','Y') NOT NULL default 'N', `Insert_priv` enum('N','Y') NOT NULL default 'N', `Update_priv` enum('N','Y') NOT NULL default 'N', @@ -81,16 +85,16 @@ user CREATE TABLE `user` ( `max_updates` int(11) unsigned NOT NULL default '0', `max_connections` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`Host`,`User`) -) TYPE=MyISAM COMMENT='Users and global privileges' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Users and global privileges' show create table func; Table Create Table func CREATE TABLE `func` ( - `name` char(64) NOT NULL default '', + `name` char(64) binary NOT NULL default '', `ret` tinyint(1) NOT NULL default '0', `dl` char(128) NOT NULL default '', `type` enum('function','aggregate') NOT NULL default 'function', PRIMARY KEY (`name`) -) TYPE=MyISAM COMMENT='User defined functions' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User defined functions' show create table tables_priv; Table Create Table tables_priv CREATE TABLE `tables_priv` ( @@ -99,12 +103,12 @@ tables_priv CREATE TABLE `tables_priv` ( `User` char(16) binary NOT NULL default '', `Table_name` char(64) binary NOT NULL default '', `Grantor` char(77) NOT NULL default '', - `Timestamp` timestamp(14) NOT NULL, + `Timestamp` timestamp NOT NULL, `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') NOT NULL default '', `Column_priv` set('Select','Insert','Update','References') NOT NULL default '', PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`), KEY `Grantor` (`Grantor`) -) TYPE=MyISAM COMMENT='Table privileges' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table privileges' show create table columns_priv; Table Create Table columns_priv CREATE TABLE `columns_priv` ( @@ -113,7 +117,7 @@ columns_priv CREATE TABLE `columns_priv` ( `User` char(16) binary NOT NULL default '', `Table_name` char(64) binary NOT NULL default '', `Column_name` char(64) binary NOT NULL default '', - `Timestamp` timestamp(14) NOT NULL, + `Timestamp` timestamp NOT NULL, `Column_priv` set('Select','Insert','Update','References') NOT NULL default '', PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`) -) TYPE=MyISAM COMMENT='Column privileges' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Column privileges' diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index f89d41aa982..5eb447ab223 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -907,3 +907,18 @@ n 9 10 drop table t1; +create table t1 (i int); +insert into t1 values (1); +select * from t1 UNION select * from t1; +i +1 +select * from t1 UNION ALL select * from t1; +i +1 +1 +select * from t1 UNION select * from t1 UNION ALL select * from t1; +i +1 +1 +1 +drop table t1; -- cgit v1.2.1 From 609df311978e24db03d74a6c0d2cdf7003ac57b3 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 20 Mar 2004 12:48:14 +0200 Subject: Ensure that we use unix file format (no \r\n) for all new files Portability fixes mysql-test/resolve-stack: Turn off EOLN_NATIVE flag mysql-test/t/ansi.test: Turn off EOLN_NATIVE flag mysql-test/t/backup-master.sh: Turn off EOLN_NATIVE flag mysql-test/t/bdb-alter-table-2-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/bdb-deadlock.test: Turn off EOLN_NATIVE flag mysql-test/t/bdb_cache-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/bdb_cache.test: Turn off EOLN_NATIVE flag mysql-test/t/bool.test: Turn off EOLN_NATIVE flag mysql-test/t/cast.test: Turn off EOLN_NATIVE flag mysql-test/t/connect.test: Turn off EOLN_NATIVE flag mysql-test/t/constraints.test: Turn off EOLN_NATIVE flag mysql-test/t/count_distinct3.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_big5.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_collate.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_cp1251-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/ctype_cp1251.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_create.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_latin1_de-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/ctype_latin1_de.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_many.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_mb.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_recoding.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_tis620-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/ctype_tis620.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_ucs.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_ujis.test: Turn off EOLN_NATIVE flag mysql-test/t/ctype_utf8.test: Turn off EOLN_NATIVE flag mysql-test/t/date_formats-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/date_formats.test: Turn off EOLN_NATIVE flag mysql-test/t/drop_temp_table.test: Turn off EOLN_NATIVE flag mysql-test/t/fulltext2.test: Turn off EOLN_NATIVE flag mysql-test/t/func_compress.test: Turn off EOLN_NATIVE flag mysql-test/t/func_concat.test: Turn off EOLN_NATIVE flag mysql-test/t/func_default.test: Turn off EOLN_NATIVE flag mysql-test/t/func_encrypt-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/func_gconcat.test: Turn off EOLN_NATIVE flag mysql-test/t/func_if.test: Turn off EOLN_NATIVE flag mysql-test/t/func_isnull.test: Turn off EOLN_NATIVE flag mysql-test/t/func_sapdb.test: Turn off EOLN_NATIVE flag mysql-test/t/gcc296.test: Turn off EOLN_NATIVE flag mysql-test/t/gis-rtree.test: Turn off EOLN_NATIVE flag mysql-test/t/gis.test: Turn off EOLN_NATIVE flag mysql-test/t/grant.test: Turn off EOLN_NATIVE flag mysql-test/t/grant2.test: Turn off EOLN_NATIVE flag mysql-test/t/grant_cache-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/grant_cache.test: Turn off EOLN_NATIVE flag mysql-test/t/heap_auto_increment.test: Turn off EOLN_NATIVE flag mysql-test/t/heap_btree.test: Turn off EOLN_NATIVE flag mysql-test/t/heap_hash.test: Turn off EOLN_NATIVE flag mysql-test/t/help.test: Turn off EOLN_NATIVE flag mysql-test/t/init_connect-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/init_connect.test: Turn off EOLN_NATIVE flag mysql-test/t/init_file-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/init_file.test: Turn off EOLN_NATIVE flag mysql-test/t/innodb-deadlock.test: Turn off EOLN_NATIVE flag mysql-test/t/innodb_cache-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/innodb_cache.test: Turn off EOLN_NATIVE flag mysql-test/t/innodb_handler.test: Turn off EOLN_NATIVE flag mysql-test/t/insert_update.test: Turn off EOLN_NATIVE flag mysql-test/t/isam.test: Turn off EOLN_NATIVE flag mysql-test/t/key_cache-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/key_cache.test: Turn off EOLN_NATIVE flag mysql-test/t/loaddata.test: Turn off EOLN_NATIVE flag mysql-test/t/lock_multi.test: Turn off EOLN_NATIVE flag mysql-test/t/lock_tables_lost_commit-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/lock_tables_lost_commit.test: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table.test: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table2.test: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table3-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table3.test: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table_qcache-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/lowercase_table_qcache.test: Turn off EOLN_NATIVE flag mysql-test/t/mix_innodb_myisam_binlog.test: Turn off EOLN_NATIVE flag mysql-test/t/multi_statement.test: Turn off EOLN_NATIVE flag mysql-test/t/multi_update-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/myisam-blob-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/myisam-blob.test: Turn off EOLN_NATIVE flag mysql-test/t/mysqlbinlog-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/mysqlbinlog.test: Turn off EOLN_NATIVE flag mysql-test/t/mysqldump.test: Turn off EOLN_NATIVE flag mysql-test/t/negation_elimination.test: Turn off EOLN_NATIVE flag mysql-test/t/packet.test: Turn off EOLN_NATIVE flag mysql-test/t/preload.test: Turn off EOLN_NATIVE flag mysql-test/t/query_cache.test: Turn off EOLN_NATIVE flag mysql-test/t/query_cache_merge.test: Turn off EOLN_NATIVE flag mysql-test/t/repair_part1.test: Turn off EOLN_NATIVE flag mysql-test/t/repair_part2-master.sh: Turn off EOLN_NATIVE flag mysql-test/t/repair_part2.test: Turn off EOLN_NATIVE flag mysql-test/t/row.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl000001-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_EE_error.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_alter.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_chain_temp_table.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_change_master.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_do_grant.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_empty_master_crash.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_error_ignored_table-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_error_ignored_table.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_failsafe.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_log_loop-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_log_loop-master.sh: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_log_loop-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_log_loop-slave.sh: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_log_loop.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_flush_tables.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_get_lock.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_heap.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_ignore_grant-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_ignore_grant.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_init_slave-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_init_slave.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_insert_id-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_insert_id.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddata.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddata_rule_m-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddata_rule_m.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddata_rule_s-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddata_rule_s.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_loaddatalocal.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_log-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_log-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_master_pos_wait.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_max_relay_size.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_misc_functions-slave.sh: Turn off EOLN_NATIVE flag mysql-test/t/rpl_misc_functions.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_multi_delete-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_multi_delete.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_multi_update.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_openssl.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_optimize.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_relayrotate-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_relayrotate.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_relayspace-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_relayspace.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_reset_slave.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_skip_error-slave.opt: Turn off EOLN_NATIVE flag mysql-test/t/rpl_skip_error.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_temporary.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_trunc_binlog.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_until.test: Turn off EOLN_NATIVE flag mysql-test/t/rpl_user_variables.test: Turn off EOLN_NATIVE flag mysql-test/t/sql_mode.test: Turn off EOLN_NATIVE flag mysql-test/t/subselect.test: Turn off EOLN_NATIVE flag mysql-test/t/subselect2.test: Turn off EOLN_NATIVE flag mysql-test/t/subselect_innodb.test: Turn off EOLN_NATIVE flag mysql-test/t/system_mysql_db.test: Turn off EOLN_NATIVE flag mysql-test/t/system_mysql_db_fix-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/system_mysql_db_fix.test: Turn off EOLN_NATIVE flag mysql-test/t/system_mysql_db_refs.test: Turn off EOLN_NATIVE flag mysql-test/t/timezone-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/timezone.test: Turn off EOLN_NATIVE flag mysql-test/t/type_nchar.test: Turn off EOLN_NATIVE flag mysql-test/t/type_set.test: Turn off EOLN_NATIVE flag mysql-test/t/union-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/variables-master.opt: Turn off EOLN_NATIVE flag mysql-test/t/warnings-master.opt: Turn off EOLN_NATIVE flag mysql-test/r/ansi.result: Turn off EOLN_NATIVE flag mysql-test/r/bdb-deadlock.result: Turn off EOLN_NATIVE flag mysql-test/r/bdb_cache.result: Turn off EOLN_NATIVE flag mysql-test/r/bool.result: Turn off EOLN_NATIVE flag mysql-test/r/cast.result: Turn off EOLN_NATIVE flag mysql-test/r/check_var_limit.require: Turn off EOLN_NATIVE flag mysql-test/r/connect.result: Turn off EOLN_NATIVE flag mysql-test/r/constraints.result: Turn off EOLN_NATIVE flag mysql-test/r/count_distinct3.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_big5.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_collate.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_cp1251.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_create.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_latin1_de.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_mb.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_recoding.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_tis620.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_ucs.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_ujis.result: Turn off EOLN_NATIVE flag mysql-test/r/ctype_utf8.result: Turn off EOLN_NATIVE flag mysql-test/r/date_formats.result: Turn off EOLN_NATIVE flag mysql-test/r/delete.result: Turn off EOLN_NATIVE flag mysql-test/r/drop_temp_table.result: Turn off EOLN_NATIVE flag mysql-test/r/errors.result: Turn off EOLN_NATIVE flag mysql-test/r/foreign_key.result: Turn off EOLN_NATIVE flag mysql-test/r/fulltext2.result: Turn off EOLN_NATIVE flag mysql-test/r/func_compress.result: Turn off EOLN_NATIVE flag mysql-test/r/func_concat.result: Turn off EOLN_NATIVE flag mysql-test/r/func_default.result: Turn off EOLN_NATIVE flag mysql-test/r/func_gconcat.result: Turn off EOLN_NATIVE flag mysql-test/r/func_if.result: Turn off EOLN_NATIVE flag mysql-test/r/func_isnull.result: Turn off EOLN_NATIVE flag mysql-test/r/func_sapdb.result: Turn off EOLN_NATIVE flag mysql-test/r/gcc296.result: Turn off EOLN_NATIVE flag mysql-test/r/gis-rtree.result: Turn off EOLN_NATIVE flag mysql-test/r/gis.result: Turn off EOLN_NATIVE flag mysql-test/r/grant.result: Turn off EOLN_NATIVE flag mysql-test/r/grant2.result: Turn off EOLN_NATIVE flag mysql-test/r/grant_cache.result: Turn off EOLN_NATIVE flag mysql-test/r/have_big5.require: Turn off EOLN_NATIVE flag mysql-test/r/have_compress.require: Turn off EOLN_NATIVE flag mysql-test/r/have_crypt.require: Turn off EOLN_NATIVE flag mysql-test/r/have_met_timezone.require: Turn off EOLN_NATIVE flag mysql-test/r/have_query_cache.require: Turn off EOLN_NATIVE flag mysql-test/r/have_tis620.require: Turn off EOLN_NATIVE flag mysql-test/r/have_ucs2.require: Turn off EOLN_NATIVE flag mysql-test/r/have_ujis.require: Turn off EOLN_NATIVE flag mysql-test/r/heap_auto_increment.result: Turn off EOLN_NATIVE flag mysql-test/r/heap_btree.result: Turn off EOLN_NATIVE flag mysql-test/r/heap_hash.result: Turn off EOLN_NATIVE flag mysql-test/r/help.result: Turn off EOLN_NATIVE flag mysql-test/r/init_connect.result: Turn off EOLN_NATIVE flag mysql-test/r/innodb-deadlock.result: Turn off EOLN_NATIVE flag mysql-test/r/innodb_cache.result: Turn off EOLN_NATIVE flag mysql-test/r/innodb_handler.result: Turn off EOLN_NATIVE flag mysql-test/r/insert_update.result: Turn off EOLN_NATIVE flag mysql-test/r/isam.result: Turn off EOLN_NATIVE flag mysql-test/r/key_cache.result: Turn off EOLN_NATIVE flag mysql-test/r/loaddata.result: Turn off EOLN_NATIVE flag mysql-test/r/lock_multi.result: Turn off EOLN_NATIVE flag mysql-test/r/lock_tables_lost_commit.result: Turn off EOLN_NATIVE flag mysql-test/r/lowercase0.require: Turn off EOLN_NATIVE flag mysql-test/r/lowercase2.require: Turn off EOLN_NATIVE flag mysql-test/r/lowercase_table.result: Turn off EOLN_NATIVE flag mysql-test/r/lowercase_table2.result: Turn off EOLN_NATIVE flag mysql-test/r/lowercase_table3.result: Turn off EOLN_NATIVE flag mysql-test/r/lowercase_table_qcache.result: Turn off EOLN_NATIVE flag mysql-test/r/mix_innodb_myisam_binlog.result: Turn off EOLN_NATIVE flag mysql-test/r/multi_statement.result: Turn off EOLN_NATIVE flag mysql-test/r/myisam-blob.result: Turn off EOLN_NATIVE flag mysql-test/r/mysqlbinlog.result: Turn off EOLN_NATIVE flag mysql-test/r/mysqldump.result: Turn off EOLN_NATIVE flag mysql-test/r/negation_elimination.result: Turn off EOLN_NATIVE flag mysql-test/r/not_embedded.require: Turn off EOLN_NATIVE flag mysql-test/r/overflow.result: Turn off EOLN_NATIVE flag mysql-test/r/packet.result: Turn off EOLN_NATIVE flag mysql-test/r/preload.result: Turn off EOLN_NATIVE flag mysql-test/r/query_cache.result: Turn off EOLN_NATIVE flag mysql-test/r/query_cache_merge.result: Turn off EOLN_NATIVE flag mysql-test/r/repair_part1.result: Turn off EOLN_NATIVE flag mysql-test/r/repair_part2.result: Turn off EOLN_NATIVE flag mysql-test/r/row.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_EE_error.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_alter.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_chain_temp_table.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_change_master.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_do_grant.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_empty_master_crash.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_error_ignored_table.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_failsafe.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_flush_log_loop.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_flush_tables.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_get_lock.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_heap.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_ignore_grant.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_init_slave.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_insert_id.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_loaddata.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_loaddata_rule_m.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_loaddata_rule_s.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_loaddatalocal.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_master_pos_wait.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_max_relay_size.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_misc_functions.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_multi_delete.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_multi_update.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_openssl.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_optimize.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_relayrotate.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_relayspace.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_reset_slave.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_skip_error.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_temporary.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_trunc_binlog.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_until.result: Turn off EOLN_NATIVE flag mysql-test/r/rpl_user_variables.result: Turn off EOLN_NATIVE flag mysql-test/r/sql_mode.result: Turn off EOLN_NATIVE flag mysql-test/r/subselect.result: Turn off EOLN_NATIVE flag mysql-test/r/subselect2.result: Turn off EOLN_NATIVE flag mysql-test/r/subselect_innodb.result: Turn off EOLN_NATIVE flag mysql-test/r/system_mysql_db.result: Turn off EOLN_NATIVE flag mysql-test/r/system_mysql_db_refs.result: Turn off EOLN_NATIVE flag mysql-test/r/timezone.result: Turn off EOLN_NATIVE flag mysql-test/r/true.require: Turn off EOLN_NATIVE flag mysql-test/r/type_nchar.result: Turn off EOLN_NATIVE flag mysql-test/r/type_set.result: Turn off EOLN_NATIVE flag mysql-test/r/warnings.result: Turn off EOLN_NATIVE flag BitKeeper/etc/config: Ensure that we use unix file format (no \r\n) for all new files client/mysqltest.c: Fix for previous push (long delimiters) mysql-test/r/derived.result: Fixed results mysql-test/r/rpl000009.result: Fixed results mysql-test/t/derived.test: Make test portable (for lower_case_table_names=2) mysql-test/t/rpl000009.test: After merge fix --- mysql-test/r/derived.result | 4 ++-- mysql-test/r/rpl000009.result | 12 ++++++++++++ 2 files changed, 14 insertions(+), 2 deletions(-) (limited to 'mysql-test/r') diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 7e5c519e108..f5754bb3332 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -271,8 +271,8 @@ delete P1.* from `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Cou select * from t1; N M 3 0 -delete P1.*,P2.* from `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N; -ERROR HY000: The target table P2 of the DELETE is not updatable +delete P1.*,p2.* from `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS p2 ON P1.N = p2.N; +ERROR HY000: The target table p2 of the DELETE is not updatable delete P1.* from `t1` AS P1 INNER JOIN (SELECT aaa FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N; ERROR 42S22: Unknown column 'aaa' in 'field list' drop table t1; diff --git a/mysql-test/r/rpl000009.result b/mysql-test/r/rpl000009.result index 1f78a505280..bb82dcb1e6a 100644 --- a/mysql-test/r/rpl000009.result +++ b/mysql-test/r/rpl000009.result @@ -112,6 +112,18 @@ n s 2 two test 3 three test 4 four test +stop slave; +reset slave; +load data from master; +start slave; +insert into mysqltest.t1 values (5, 'five bar'); +select * from mysqltest.t1; +n s +1 one test +2 two test +3 three test +4 four test +5 five bar load table mysqltest.t1 from master; ERROR 42S01: Table 't1' already exists drop table mysqltest.t1; -- cgit v1.2.1