1 # name : mysql-test.diff
6 # Any small change to this file in the main branch
7 # should be done or reviewed by the maintainer!
8 diff -ruN a/mysql-test/include/default_mysqld.cnf b/mysql-test/include/default_mysqld.cnf
9 --- a/mysql-test/include/default_mysqld.cnf 2010-11-03 07:01:11.000000000 +0900
10 +++ b/mysql-test/include/default_mysqld.cnf 2010-12-10 16:48:10.996387047 +0900
12 max_heap_table_size= 1M
14 loose-innodb_data_file_path= ibdata1:10M:autoextend
15 -loose-innodb_buffer_pool_size= 8M
16 +loose-innodb_buffer_pool_size= 32M
17 loose-innodb_write_io_threads= 2
18 loose-innodb_read_io_threads= 2
19 loose-innodb_log_buffer_size= 1M
20 diff -ruN a/mysql-test/r/connect.result b/mysql-test/r/connect.result
21 --- a/mysql-test/r/connect.result 2010-11-03 07:01:12.000000000 +0900
22 +++ b/mysql-test/r/connect.result 2010-12-10 16:48:10.997386982 +0900
24 +set global log_warnings=0;
25 drop table if exists t1,t2;
29 # ------------------------------------------------------------------
31 # ------------------------------------------------------------------
32 +set global log_warnings=1;
33 diff -ruN a/mysql-test/r/create.result b/mysql-test/r/create.result
34 --- a/mysql-test/r/create.result 2010-11-03 07:01:12.000000000 +0900
35 +++ b/mysql-test/r/create.result 2010-12-10 16:48:11.001009442 +0900
37 `COMMAND` varchar(16) NOT NULL DEFAULT '',
38 `TIME` int(7) NOT NULL DEFAULT '0',
39 `STATE` varchar(64) DEFAULT NULL,
42 + `TIME_MS` bigint(21) NOT NULL DEFAULT '0'
43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8
45 create temporary table t1 like information_schema.processlist;
47 `COMMAND` varchar(16) NOT NULL DEFAULT '',
48 `TIME` int(7) NOT NULL DEFAULT '0',
49 `STATE` varchar(64) DEFAULT NULL,
52 + `TIME_MS` bigint(21) NOT NULL DEFAULT '0'
53 ) ENGINE=MyISAM DEFAULT CHARSET=utf8
55 create table t1 like information_schema.character_sets;
56 diff -ruN a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result
57 --- a/mysql-test/r/information_schema.result 2010-12-03 20:58:24.000000000 +0300
58 +++ b/mysql-test/r/information_schema.result 2011-01-10 23:02:09.000000000 +0300
65 COLLATION_CHARACTER_SET_APPLICABILITY
73 +GLOBAL_TEMPORARY_TABLES
79 REFERENTIAL_CONSTRAINTS
101 TABLESPACES TABLESPACES
102 TABLE_CONSTRAINTS TABLE_CONSTRAINTS
103 TABLE_PRIVILEGES TABLE_PRIVILEGES
104 +TABLE_STATISTICS TABLE_STATISTICS
105 +TEMPORARY_TABLES TEMPORARY_TABLES
106 +THREAD_STATISTICS THREAD_STATISTICS
108 tables_priv tables_priv
111 TABLESPACES TABLESPACES
112 TABLE_CONSTRAINTS TABLE_CONSTRAINTS
113 TABLE_PRIVILEGES TABLE_PRIVILEGES
114 +TABLE_STATISTICS TABLE_STATISTICS
115 +TEMPORARY_TABLES TEMPORARY_TABLES
116 +THREAD_STATISTICS THREAD_STATISTICS
118 tables_priv tables_priv
121 TABLESPACES TABLESPACES
122 TABLE_CONSTRAINTS TABLE_CONSTRAINTS
123 TABLE_PRIVILEGES TABLE_PRIVILEGES
124 +TABLE_STATISTICS TABLE_STATISTICS
125 +TEMPORARY_TABLES TEMPORARY_TABLES
126 +THREAD_STATISTICS THREAD_STATISTICS
128 tables_priv tables_priv
130 @@ -634,13 +652,16 @@
131 where table_schema='information_schema' limit 2;
132 TABLE_NAME TABLE_TYPE ENGINE
133 CHARACTER_SETS SYSTEM VIEW MEMORY
134 -COLLATIONS SYSTEM VIEW MEMORY
135 +CLIENT_STATISTICS SYSTEM VIEW MEMORY
136 show tables from information_schema like "T%";
137 Tables_in_information_schema (T%)
146 create database information_schema;
147 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
149 TABLESPACES SYSTEM VIEW
150 TABLE_CONSTRAINTS SYSTEM VIEW
151 TABLE_PRIVILEGES SYSTEM VIEW
152 +TABLE_STATISTICS SYSTEM VIEW
153 +TEMPORARY_TABLES SYSTEM VIEW
154 +THREAD_STATISTICS SYSTEM VIEW
156 create table t1(a int);
157 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
166 select table_name from tables where table_name='user';
169 FILES CREATE_TIME datetime
170 FILES UPDATE_TIME datetime
171 FILES CHECK_TIME datetime
172 +GLOBAL_TEMPORARY_TABLES CREATE_TIME datetime
173 +GLOBAL_TEMPORARY_TABLES UPDATE_TIME datetime
174 PARTITIONS CREATE_TIME datetime
175 PARTITIONS UPDATE_TIME datetime
176 PARTITIONS CHECK_TIME datetime
178 TABLES CREATE_TIME datetime
179 TABLES UPDATE_TIME datetime
180 TABLES CHECK_TIME datetime
181 +TEMPORARY_TABLES CREATE_TIME datetime
182 +TEMPORARY_TABLES UPDATE_TIME datetime
183 TRIGGERS CREATED datetime
184 event execute_at datetime
185 event last_executed datetime
187 TABLE_NAME COLUMN_NAME PRIVILEGES
188 COLUMNS TABLE_NAME select
189 COLUMN_PRIVILEGES TABLE_NAME select
190 +INDEX_STATISTICS TABLE_NAME select
191 FILES TABLE_NAME select
192 +GLOBAL_TEMPORARY_TABLES TABLE_NAME select
193 KEY_COLUMN_USAGE TABLE_NAME select
194 PARTITIONS TABLE_NAME select
195 REFERENTIAL_CONSTRAINTS TABLE_NAME select
197 TABLES TABLE_NAME select
198 TABLE_CONSTRAINTS TABLE_NAME select
199 TABLE_PRIVILEGES TABLE_NAME select
200 +TABLE_STATISTICS TABLE_NAME select
201 +TEMPORARY_TABLES TABLE_NAME select
202 VIEWS TABLE_NAME select
203 +INNODB_TABLE_STATS table_name select
204 +INNODB_INDEX_STATS table_name select
205 delete from mysql.user where user='mysqltest_4';
206 delete from mysql.db where user='mysqltest_4';
209 AND table_name not like 'ndb%' AND table_name not like 'innodb_%'
210 GROUP BY TABLE_SCHEMA;
211 table_schema count(*)
212 -information_schema 30
213 +information_schema 39
215 create table t1 (i int, j int);
216 create trigger trg1 before insert on t1 for each row
217 @@ -1245,12 +1282,12 @@
218 DROP USER mysql_bug20230@localhost;
219 SELECT MAX(table_name) FROM information_schema.tables WHERE table_schema IN ('mysql', 'INFORMATION_SCHEMA', 'test');
222 +XTRADB_ADMIN_COMMAND
223 SELECT table_name from information_schema.tables
224 WHERE table_name=(SELECT MAX(table_name)
225 FROM information_schema.tables WHERE table_schema IN ('mysql', 'INFORMATION_SCHEMA', 'test'));
228 +XTRADB_ADMIN_COMMAND
229 DROP TABLE IF EXISTS bug23037;
230 DROP FUNCTION IF EXISTS get_value;
231 SELECT COLUMN_NAME, MD5(COLUMN_DEFAULT), LENGTH(COLUMN_DEFAULT) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='bug23037';
232 @@ -1311,6 +1348,7 @@
233 group by t.table_name order by num1, t.table_name;
234 table_name group_concat(t.table_schema, '.', t.table_name) num1
235 CHARACTER_SETS information_schema.CHARACTER_SETS 1
236 +CLIENT_STATISTICS information_schema.CLIENT_STATISTICS 1
237 COLLATIONS information_schema.COLLATIONS 1
238 COLLATION_CHARACTER_SET_APPLICABILITY information_schema.COLLATION_CHARACTER_SET_APPLICABILITY 1
239 COLUMNS information_schema.COLUMNS 1
240 @@ -1319,13 +1357,16 @@
241 EVENTS information_schema.EVENTS 1
242 FILES information_schema.FILES 1
243 GLOBAL_STATUS information_schema.GLOBAL_STATUS 1
244 +GLOBAL_TEMPORARY_TABLES information_schema.GLOBAL_TEMPORARY_TABLES 1
245 GLOBAL_VARIABLES information_schema.GLOBAL_VARIABLES 1
246 +INDEX_STATISTICS information_schema.INDEX_STATISTICS 1
247 KEY_COLUMN_USAGE information_schema.KEY_COLUMN_USAGE 1
248 PARAMETERS information_schema.PARAMETERS 1
249 PARTITIONS information_schema.PARTITIONS 1
250 PLUGINS information_schema.PLUGINS 1
251 PROCESSLIST information_schema.PROCESSLIST 1
252 PROFILING information_schema.PROFILING 1
253 +QUERY_RESPONSE_TIME information_schema.QUERY_RESPONSE_TIME 1
254 REFERENTIAL_CONSTRAINTS information_schema.REFERENTIAL_CONSTRAINTS 1
255 ROUTINES information_schema.ROUTINES 1
256 SCHEMATA information_schema.SCHEMATA 1
257 @@ -1337,8 +1378,12 @@
258 TABLESPACES information_schema.TABLESPACES 1
259 TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1
260 TABLE_PRIVILEGES information_schema.TABLE_PRIVILEGES 1
261 +TABLE_STATISTICS information_schema.TABLE_STATISTICS 1
262 +TEMPORARY_TABLES information_schema.TEMPORARY_TABLES 1
263 +THREAD_STATISTICS information_schema.THREAD_STATISTICS 1
264 TRIGGERS information_schema.TRIGGERS 1
265 USER_PRIVILEGES information_schema.USER_PRIVILEGES 1
266 +USER_STATISTICS information_schema.USER_STATISTICS 1
267 VIEWS information_schema.VIEWS 1
268 create table t1(f1 int);
269 create view v1 as select f1+1 as a from t1;
270 diff -ruN a/mysql-test/r/information_schema_db.result b/mysql-test/r/information_schema_db.result
271 --- a/mysql-test/r/information_schema_db.result 2010-12-03 20:58:24.000000000 +0300
272 +++ b/mysql-test/r/information_schema_db.result 2011-01-10 23:06:43.000000000 +0300
274 show tables where Tables_in_information_schema NOT LIKE 'Innodb%';
275 Tables_in_information_schema
279 COLLATION_CHARACTER_SET_APPLICABILITY
287 +GLOBAL_TEMPORARY_TABLES
293 REFERENTIAL_CONSTRAINTS
310 +XTRADB_ADMIN_COMMAND
311 show tables from INFORMATION_SCHEMA like 'T%';
312 Tables_in_information_schema (T%)
321 create database `inf%`;
322 create database mbase;
323 diff -ruN a/mysql-test/r/mysqld--help-notwin.result b/mysql-test/r/mysqld--help-notwin.result
324 --- a/mysql-test/r/mysqld--help-notwin.result 2011-01-20 00:37:09.000000000 +0200
325 +++ b/mysql-test/r/mysqld--help-notwin.result 2011-02-18 13:14:44.701736864 +0200
326 @@ -249,21 +249,43 @@
327 --log-slow-admin-statements
328 Log slow OPTIMIZE, ANALYZE, ALTER and other
329 administrative statements to the slow log if it is open.
330 + --log-slow-filter=name
331 + Log only the queries that followed certain execution
332 + plan. Multiple flags allowed in a comma-separated string.
333 + [qc_miss, full_scan, full_join, tmp_table,
334 + tmp_table_on_disk, filesort, filesort_on_disk]
335 --log-slow-queries[=name]
336 Log slow queries to a table or log file. Defaults logging
337 to table mysql.slow_log or hostname-slow.log if
338 --log-output=file is used. Must be enabled to activate
339 other slow log options. Deprecated option, use
340 --slow-query-log/--slow-query-log-file instead.
341 + --log-slow-rate-limit=#
342 + Rate limit statement writes to slow log to only those
343 + from every (1/log_slow_rate_limit) session.
344 --log-slow-slave-statements
345 - Log slow statements executed by slave thread to the slow
347 + Log queries replayed be the slave SQL thread
348 + --log-slow-sp-statements
349 + Log slow statements executed by stored procedure to the
350 + slow log if it is open.
351 + (Defaults to on; use --skip-log-slow-sp-statements to disable.)
352 + --log-slow-timestamp-every
353 + Timestamp is printed for all records of the slow log even
354 + if they are same time.
355 + --log-slow-verbosity=name
356 + Choose how verbose the messages to your slow log will be.
357 + Multiple flags allowed in a comma-separated string.
358 + [microtime, query_plan, innodb, profiling,
359 + profiling_use_getrusage]
360 --log-tc=name Path to transaction coordinator log (used for
361 transactions that affect more than one storage engine,
362 when binary log is disabled).
363 --log-tc-size=# Size of transaction coordinator log.
364 -W, --log-warnings[=#]
365 Log some not critical warnings to the log file
366 + --log-warnings-silence=name
367 + disable logging of enumerated warnings: 1592: unsafe
368 + statements for binary logging; possible values : [1592]
369 --long-query-time=# Log all queries that have taken more than long_query_time
370 seconds to execute to file. The argument will be treated
371 as a decimal value with microsecond precision
373 The minimum size for blocks allocated by the query cache
375 The memory allocated to store results from old queries
376 + --query-cache-strip-comments
377 + Enable and disable optimisation "strip comment for query
378 + cache" - optimisation strip all comments from query while
379 + search query result in query cache
380 --query-cache-type=name
381 OFF = Don't cache or retrieve results. ON = Cache all
382 results except SELECT SQL_NO_CACHE ... queries. DEMAND =
384 Invalidate queries in query cache on LOCK for write
385 --query-prealloc-size=#
386 Persistent buffer for query parsing and execution
387 + --query-response-time-range-base=#
388 + Select base of log for query_response_time ranges.
389 + WARNING: variable change affect only after flush
390 + --query-response-time-stats
391 + Enable or disable query response time statisics
393 --range-alloc-block-size=#
394 Allocation block size for storing ranges during
397 Log slow queries to given log file. Defaults logging to
398 hostname-slow.log. Must be enabled to activate other slow
400 + --slow-query-log-microseconds-timestamp
401 + Log slow statements executed by stored procedure to the
402 + slow log if it is open.
403 --socket=name Socket file to use for connection
405 Each thread that needs to do a sort allocates a buffer of
407 Define threads usage for handling queries, one of
408 one-thread-per-connection, no-threads, loaded-dynamically
409 --thread-stack=# The stack size for each thread
410 + --thread-statistics Control TABLE_STATISTICS running, when userstat_running
412 --time-format=name The TIME format (ignored)
413 --timed-mutexes Specify whether to time mutexes (only InnoDB mutexes are
415 @@ -721,11 +758,24 @@
416 Prohibit update of a VIEW, which does not contain a key
417 of the underlying table and the query uses a LIMIT clause
418 (usually get from GUI tools)
419 + --use-global-log-slow-control=name
420 + Choose flags, wich always use the global variables.
421 + Multiple flags allowed in a comma-separated string.
422 + [none, log_slow_filter, log_slow_rate_limit,
423 + log_slow_verbosity, long_query_time,
424 + min_examined_row_limit, all]
425 -u, --user=name Run mysqld daemon as user.
426 + --userstat-running Control USER_STATISTICS, CLIENT_STATISTICS,
427 + THREAD_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
429 -v, --verbose Used with --help option for detailed help.
430 -V, --version Output version information and exit.
431 --wait-timeout=# The number of seconds the server waits for activity on a
432 connection before closing it
433 + --xtradb-admin-command[=name]
434 + Enable or disable XTRADB_ADMIN_COMMAND plugin. Possible
435 + values are ON, OFF, FORCE (don't start if the plugin
438 Variables (--variable-name=value)
439 abort-slave-event-count 0
440 @@ -807,10 +857,16 @@
441 log-short-format FALSE
442 log-slave-updates FALSE
443 log-slow-admin-statements FALSE
445 +log-slow-rate-limit 1
446 log-slow-slave-statements FALSE
447 +log-slow-sp-statements TRUE
448 +log-slow-timestamp-every FALSE
453 +log-warnings-silence
455 low-priority-updates FALSE
456 lower-case-table-names 1
458 query-cache-limit 1048576
459 query-cache-min-res-unit 4096
461 +query-cache-strip-comments FALSE
463 query-cache-wlock-invalidate FALSE
464 query-prealloc-size 8192
465 +query-response-time-range-base 10
466 +query-response-time-stats FALSE
467 range-alloc-block-size 4096
468 read-buffer-size 131072
471 slave-type-conversions
474 +slow-query-log-microseconds-timestamp FALSE
475 sort-buffer-size 2097152
476 sporadic-binlog-dump-fail FALSE
480 thread-handling one-thread-per-connection
482 +thread-statistics FALSE
485 tmp-table-size 16777216
486 @@ -946,8 +1007,11 @@
487 transaction-isolation REPEATABLE-READ
488 transaction-prealloc-size 4096
489 updatable-views-with-limit YES
490 +use-global-log-slow-control
491 +userstat-running FALSE
494 +xtradb-admin-command ON
496 To see what values a running MySQL server is using, type
497 'mysqladmin variables' instead of 'mysqld --verbose --help'.
498 diff -ruN a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result
499 --- a/mysql-test/r/mysqldump.result 2010-11-03 07:01:12.000000000 +0900
500 +++ b/mysql-test/r/mysqldump.result 2010-12-10 16:48:11.013968901 +0900
501 @@ -1832,7 +1832,7 @@
502 # Bug#21288 mysqldump segmentation fault when using --where
504 create table t1 (a int);
505 -mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `t1` WHERE xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 (1064)
506 +mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM `t1` WHERE xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 (1064)
507 mysqldump: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 when retrieving data from server
509 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
510 diff -ruN a/mysql-test/r/mysqlshow.result b/mysql-test/r/mysqlshow.result
511 --- a/mysql-test/r/mysqlshow.result 2010-12-03 20:58:24.000000000 +0300
512 +++ b/mysql-test/r/mysqlshow.result 2011-01-11 16:41:03.000000000 +0300
515 +---------------------------------------+
517 +| CLIENT_STATISTICS |
519 | COLLATION_CHARACTER_SET_APPLICABILITY |
521 | COLUMN_PRIVILEGES |
522 +| INDEX_STATISTICS |
527 +| GLOBAL_TEMPORARY_TABLES |
533 | REFERENTIAL_CONSTRAINTS |
535 +| QUERY_RESPONSE_TIME |
537 | SCHEMA_PRIVILEGES |
539 @@ -106,30 +110,52 @@
541 | TABLE_CONSTRAINTS |
543 +| TABLE_STATISTICS |
544 +| TEMPORARY_TABLES |
545 +| THREAD_STATISTICS |
550 -| INNODB_CMP_RESET |
551 +| INNODB_SYS_COLUMNS |
555 -| INNODB_CMPMEM_RESET |
556 +| INNODB_SYS_TABLESTATS |
557 | INNODB_LOCK_WAITS |
560 +| XTRADB_ADMIN_COMMAND |
562 +| INNODB_SYS_FOREIGN_COLS |
563 +| INNODB_CMP_RESET |
564 +| INNODB_BUFFER_POOL_PAGES |
565 +| INNODB_SYS_TABLES |
566 +| INNODB_BUFFER_POOL_PAGES_INDEX |
568 +| INNODB_BUFFER_POOL_PAGES_BLOB |
569 +| INNODB_CMPMEM_RESET |
570 +| INNODB_SYS_FIELDS |
571 +| INNODB_TABLE_STATS |
572 +| INNODB_SYS_STATS |
573 +| INNODB_SYS_FOREIGN |
574 +| INNODB_SYS_INDEXES |
575 +| INNODB_INDEX_STATS |
576 +---------------------------------------+
577 Database: INFORMATION_SCHEMA
578 +---------------------------------------+
580 +---------------------------------------+
582 +| CLIENT_STATISTICS |
584 | COLLATION_CHARACTER_SET_APPLICABILITY |
586 | COLUMN_PRIVILEGES |
587 +| INDEX_STATISTICS |
592 +| GLOBAL_TEMPORARY_TABLES |
598 | REFERENTIAL_CONSTRAINTS |
600 +| QUERY_RESPONSE_TIME |
602 | SCHEMA_PRIVILEGES |
604 @@ -148,16 +175,35 @@
606 | TABLE_CONSTRAINTS |
608 +| TABLE_STATISTICS |
609 +| TEMPORARY_TABLES |
610 +| THREAD_STATISTICS |
615 -| INNODB_CMP_RESET |
616 +| INNODB_SYS_COLUMNS |
620 -| INNODB_CMPMEM_RESET |
621 +| INNODB_SYS_TABLESTATS |
622 | INNODB_LOCK_WAITS |
625 +| XTRADB_ADMIN_COMMAND |
627 +| INNODB_SYS_FOREIGN_COLS |
628 +| INNODB_CMP_RESET |
629 +| INNODB_BUFFER_POOL_PAGES |
630 +| INNODB_SYS_TABLES |
631 +| INNODB_BUFFER_POOL_PAGES_INDEX |
633 +| INNODB_BUFFER_POOL_PAGES_BLOB |
634 +| INNODB_CMPMEM_RESET |
635 +| INNODB_SYS_FIELDS |
636 +| INNODB_TABLE_STATS |
637 +| INNODB_SYS_STATS |
638 +| INNODB_SYS_FOREIGN |
639 +| INNODB_SYS_INDEXES |
640 +| INNODB_INDEX_STATS |
641 +---------------------------------------+
642 Wildcard: inf_rmation_schema
643 +--------------------+
644 diff -ruN a/mysql-test/r/select.result b/mysql-test/r/select.result
645 --- a/mysql-test/r/select.result 2010-11-03 07:01:12.000000000 +0900
646 +++ b/mysql-test/r/select.result 2010-12-10 16:48:11.023052909 +0900
647 @@ -2196,10 +2196,10 @@
648 select * from (t1 as t2 left join t1 as t3 using (a)) inner join t1 on t1.a>1;
658 select * from t1 inner join (t1 as t2 left join t1 as t3 using (a)) on t1.a>1;
660 diff -ruN a/mysql-test/suite/innodb/r/innodb.result b/mysql-test/suite/innodb/r/innodb.result
661 --- a/mysql-test/suite/innodb/r/innodb.result 2010-11-03 07:01:12.000000000 +0900
662 +++ b/mysql-test/suite/innodb/r/innodb.result 2010-12-10 16:48:11.026994635 +0900
663 @@ -1664,7 +1664,7 @@
665 SELECT variable_value FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_buffer_pool_pages_total';
669 SELECT variable_value FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_page_size';
672 diff -ruN a/mysql-test/suite/sys_vars/r/all_vars.result b/mysql-test/suite/sys_vars/r/all_vars.result
673 --- a/mysql-test/suite/sys_vars/r/all_vars.result 2011-01-20 00:37:09.000000000 +0200
674 +++ b/mysql-test/suite/sys_vars/r/all_vars.result 2011-02-18 13:04:56.205855418 +0200
676 select variable_name as `There should be *no* variables listed below:` from t2
677 left join t1 on variable_name=test_name where test_name is null;
678 There should be *no* variables listed below:
679 +QUERY_CACHE_STRIP_COMMENTS
680 +LOG_SLOW_SP_STATEMENTS
681 +INNODB_THREAD_CONCURRENCY_TIMER_BASED
682 +LOG_SLOW_TIMESTAMP_EVERY
683 +INNODB_LOG_BLOCK_SIZE
686 +INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
687 +INNODB_PASS_CORRUPT_TABLE
688 +QUERY_RESPONSE_TIME_STATS
689 +INNODB_FLUSH_NEIGHBOR_PAGES
690 +INNODB_BUFFER_POOL_SHM_CHECKSUM
692 +INNODB_SHOW_LOCKS_HELD
693 +INNODB_IBUF_ACCEL_RATE
694 +INNODB_EXPAND_IMPORT
695 +INNODB_CHECKPOINT_AGE_TARGET
696 +INNODB_ADAPTIVE_FLUSHING_METHOD
698 +HAVE_RESPONSE_TIME_DISTRIBUTION
703 +USE_GLOBAL_LOG_SLOW_CONTROL
704 +INNODB_IBUF_MAX_SIZE
705 +INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
706 +SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
707 +INNODB_BUFFER_POOL_SHM_KEY
708 +INNODB_FAST_CHECKSUM
709 +INNODB_USE_SYS_STATS_TABLE
710 +INNODB_STATS_UPDATE_NEED_LOCK
711 +INNODB_RECOVERY_STATS
713 +QUERY_RESPONSE_TIME_RANGE_BASE
714 +INNODB_IBUF_ACTIVE_CONTRACT
715 +INNODB_AUTO_LRU_DUMP
716 +INNODB_DOUBLEWRITE_FILE
717 +INNODB_STATS_AUTO_UPDATE
718 +INNODB_DICT_SIZE_LIMIT
719 INNODB_FILE_FORMAT_MAX
720 +LOG_WARNINGS_SILENCE
722 +INNODB_SHOW_VERBOSE_LOCKS
723 +INNODB_EXTRA_RSEGMENTS
724 +INNODB_OVERWRITE_RELAY_LOG_INFO
725 +LOG_SLOW_SLAVE_STATEMENTS
726 +QUERY_CACHE_STRIP_COMMENTS
727 +LOG_SLOW_SP_STATEMENTS
728 +INNODB_THREAD_CONCURRENCY_TIMER_BASED
729 +LOG_SLOW_TIMESTAMP_EVERY
730 +INNODB_LOG_BLOCK_SIZE
733 +INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
734 +INNODB_PASS_CORRUPT_TABLE
735 +QUERY_RESPONSE_TIME_STATS
736 +INNODB_FLUSH_NEIGHBOR_PAGES
737 +INNODB_BUFFER_POOL_SHM_CHECKSUM
739 +INNODB_SHOW_LOCKS_HELD
740 +INNODB_IBUF_ACCEL_RATE
741 +INNODB_EXPAND_IMPORT
742 +INNODB_CHECKPOINT_AGE_TARGET
743 +INNODB_ADAPTIVE_FLUSHING_METHOD
745 +HAVE_RESPONSE_TIME_DISTRIBUTION
750 +USE_GLOBAL_LOG_SLOW_CONTROL
751 +INNODB_IBUF_MAX_SIZE
752 +INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
753 +SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
754 +INNODB_BUFFER_POOL_SHM_KEY
755 +INNODB_FAST_CHECKSUM
756 +INNODB_USE_SYS_STATS_TABLE
757 +INNODB_STATS_UPDATE_NEED_LOCK
758 +INNODB_RECOVERY_STATS
760 +QUERY_RESPONSE_TIME_RANGE_BASE
761 +INNODB_IBUF_ACTIVE_CONTRACT
762 +INNODB_AUTO_LRU_DUMP
763 +INNODB_DOUBLEWRITE_FILE
764 +INNODB_STATS_AUTO_UPDATE
765 +INNODB_DICT_SIZE_LIMIT
766 INNODB_FILE_FORMAT_MAX
767 +LOG_WARNINGS_SILENCE
769 +INNODB_SHOW_VERBOSE_LOCKS
770 +INNODB_EXTRA_RSEGMENTS
771 +INNODB_OVERWRITE_RELAY_LOG_INFO
772 +LOG_SLOW_SLAVE_STATEMENTS
775 diff -ruN a/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_basic.result b/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_basic.result
776 --- a/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_basic.result 2010-11-03 07:01:13.000000000 +0900
777 +++ b/mysql-test/suite/sys_vars/r/innodb_adaptive_flushing_basic.result 2010-12-10 16:48:11.031065741 +0900
779 SET @start_global_value = @@global.innodb_adaptive_flushing;
780 SELECT @start_global_value;
784 Valid values are 'ON' and 'OFF'
785 select @@global.innodb_adaptive_flushing in (0, 1);
786 @@global.innodb_adaptive_flushing in (0, 1)
788 select @@global.innodb_adaptive_flushing;
789 @@global.innodb_adaptive_flushing
792 select @@session.innodb_adaptive_flushing;
793 ERROR HY000: Variable 'innodb_adaptive_flushing' is a GLOBAL variable
794 show global variables like 'innodb_adaptive_flushing';
796 -innodb_adaptive_flushing ON
797 +innodb_adaptive_flushing OFF
798 show session variables like 'innodb_adaptive_flushing';
800 -innodb_adaptive_flushing ON
801 +innodb_adaptive_flushing OFF
802 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
803 VARIABLE_NAME VARIABLE_VALUE
804 -INNODB_ADAPTIVE_FLUSHING ON
805 +INNODB_ADAPTIVE_FLUSHING OFF
806 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
807 VARIABLE_NAME VARIABLE_VALUE
808 -INNODB_ADAPTIVE_FLUSHING ON
809 +INNODB_ADAPTIVE_FLUSHING OFF
810 set global innodb_adaptive_flushing='OFF';
811 select @@global.innodb_adaptive_flushing;
812 @@global.innodb_adaptive_flushing
814 SET @@global.innodb_adaptive_flushing = @start_global_value;
815 SELECT @@global.innodb_adaptive_flushing;
816 @@global.innodb_adaptive_flushing
819 diff -ruN a/mysql-test/suite/sys_vars/r/plugin_dir_basic.result b/mysql-test/suite/sys_vars/r/plugin_dir_basic.result
820 --- a/mysql-test/suite/sys_vars/r/plugin_dir_basic.result 2010-11-03 07:01:13.000000000 +0900
821 +++ b/mysql-test/suite/sys_vars/r/plugin_dir_basic.result 2010-12-10 16:48:11.033057415 +0900
823 select @@global.plugin_dir;
826 +MYSQL_LIBDIR64/plugin
827 select @@session.plugin_dir;
828 ERROR HY000: Variable 'plugin_dir' is a GLOBAL variable
829 show global variables like 'plugin_dir';
831 -plugin_dir MYSQL_LIBDIR/plugin
832 +plugin_dir MYSQL_LIBDIR64/plugin
833 show session variables like 'plugin_dir';
835 -plugin_dir MYSQL_LIBDIR/plugin
836 +plugin_dir MYSQL_LIBDIR64/plugin
837 select * from information_schema.global_variables where variable_name='plugin_dir';
838 VARIABLE_NAME VARIABLE_VALUE
839 -PLUGIN_DIR MYSQL_LIBDIR/plugin
840 +PLUGIN_DIR MYSQL_LIBDIR64/plugin
841 select * from information_schema.session_variables where variable_name='plugin_dir';
842 VARIABLE_NAME VARIABLE_VALUE
843 -PLUGIN_DIR MYSQL_LIBDIR/plugin
844 +PLUGIN_DIR MYSQL_LIBDIR64/plugin
845 set global plugin_dir=1;
846 ERROR HY000: Variable 'plugin_dir' is a read only variable
847 set session plugin_dir=1;
848 diff -ruN a/mysql-test/t/connect.test b/mysql-test/t/connect.test
849 --- a/mysql-test/t/connect.test 2010-11-03 07:01:12.000000000 +0900
850 +++ b/mysql-test/t/connect.test 2010-12-10 16:48:11.034065111 +0900
852 +set global log_warnings=0;
854 # This test is to check various cases of connections
855 # with right and wrong password, with and without database
856 # Unfortunately the check is incomplete as we can't connect without database
858 # Wait till all disconnects are completed
859 --source include/wait_until_count_sessions.inc
861 +set global log_warnings=1;