Merge lp:~tsarev/percona-server/5.5_bug_838725_fix into lp:percona-server/5.5
- 5.5_bug_838725_fix
- Merge into 5.5
Proposed by
Oleg Tsarev
Status: | Merged |
---|---|
Merged at revision: | 159 |
Proposed branch: | lp:~tsarev/percona-server/5.5_bug_838725_fix |
Merge into: | lp:percona-server/5.5 |
Diff against target: |
18162 lines (+8788/-8504) 158 files modified
Makefile (+1/-4) install_tests (+0/-37) mysql-test/have_response_time_distribution.inc (+0/-4) mysql-test/have_response_time_distribution.require (+0/-2) mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result (+0/-28) mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test (+0/-61) mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt (+0/-1) mysql-test/log_connection_error.patch/percona_log_connection_error.result (+0/-15) mysql-test/log_connection_error.patch/percona_log_connection_error.test (+0/-54) mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt (+0/-1) mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result (+0/-31) mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test (+0/-47) mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result (+0/-952) mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test (+0/-642) mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result (+0/-14) mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test (+0/-19) mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result (+0/-132) mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test (+0/-16) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result (+0/-58) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test (+0/-64) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result (+0/-12) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test (+0/-15) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result (+0/-12) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test (+0/-15) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result (+0/-15) mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test (+0/-19) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result (+0/-9) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test (+0/-15) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result (+0/-19) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test (+0/-19) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result (+0/-18) mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test (+0/-20) mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result (+0/-7) mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test (+0/-14) mysql-test/memory_dynamic_rows.patch/percona_heap_var.result (+0/-194) mysql-test/memory_dynamic_rows.patch/percona_heap_var.test (+0/-85) mysql-test/percona_innodb_buffer_pool_shm-master.opt (+0/-1) mysql-test/percona_innodb_buffer_pool_shm.result (+0/-4) mysql-test/percona_innodb_buffer_pool_shm.test (+0/-2) mysql-test/percona_innodb_doublewrite_file-master.opt (+0/-1) mysql-test/percona_innodb_doublewrite_file.result (+0/-4) mysql-test/percona_innodb_doublewrite_file.test (+0/-2) mysql-test/percona_innodb_use_sys_stats_table-master.opt (+0/-1) mysql-test/percona_innodb_use_sys_stats_table.result (+0/-3) mysql-test/percona_innodb_use_sys_stats_table.test (+0/-2) mysql-test/percona_server_variables.inc (+0/-3) mysql-test/percona_server_variables_debug.result (+0/-372) mysql-test/percona_server_variables_debug.test (+0/-2) mysql-test/percona_server_variables_release.result (+0/-369) mysql-test/percona_server_variables_release.test (+0/-2) mysql-test/percona_show_temp_tables.result (+0/-58) mysql-test/percona_show_temp_tables.test (+0/-65) mysql-test/percona_xtradb_admin_command.result (+0/-6) mysql-test/percona_xtradb_admin_command.test (+0/-3) mysql-test/percona_xtradb_bug317074.result (+0/-5) mysql-test/percona_xtradb_bug317074.test (+0/-47) mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result (+0/-70) mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test (+0/-79) mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc (+0/-7) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc (+0/-95) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup (+0/-88) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result (+0/-866) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test (+0/-5) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc (+0/-12) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc (+0/-5) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result (+0/-21) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test (+0/-22) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result (+0/-865) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test (+0/-3) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc (+0/-3) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc (+0/-7) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result (+0/-396) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test (+0/-208) mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc (+0/-8) mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result (+0/-23) mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test (+0/-31) mysql-test/response_time_distribution.patch/percona_query_response_time-replication.result (+0/-66) mysql-test/response_time_distribution.patch/percona_query_response_time-replication.test (+0/-61) mysql-test/response_time_distribution.patch/percona_query_response_time-stored.result (+0/-306) mysql-test/response_time_distribution.patch/percona_query_response_time-stored.test (+0/-85) mysql-test/response_time_distribution.patch/percona_query_response_time.result (+0/-377) mysql-test/response_time_distribution.patch/percona_query_response_time.test (+0/-71) mysql-test/response_time_distribution.patch/percona_query_response_time_flush.inc (+0/-1) mysql-test/response_time_distribution.patch/percona_query_response_time_show.inc (+0/-8) mysql-test/response_time_distribution.patch/percona_query_response_time_sleep.inc (+0/-19) mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result (+0/-21) mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test (+0/-53) mysql-test/slow_extended.patch/grep.inc (+0/-16) mysql-test/slow_extended.patch/percona_bug643149.result (+0/-21) mysql-test/slow_extended.patch/percona_bug643149.test (+0/-49) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.result (+0/-25) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.test (+0/-32) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+0/-3) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+0/-9) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+0/-3) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.result (+0/-9) mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.test (+0/-12) mysql-test/slow_extended.patch/percona_slow_extended-long_query_time-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.result (+0/-24) mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.test (+0/-23) mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.result (+0/-13) mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.test (+0/-23) mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.result (+0/-25) mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.test (+0/-32) mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-slave.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result (+0/-22) mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.test (+0/-51) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-slave.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.result (+0/-89) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+0/-107) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-slave.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.result (+0/-94) mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+0/-133) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+0/-3) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl.result (+0/-3) mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl.test (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-use_global_control-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-use_global_control.result (+0/-12) mysql-test/slow_extended.patch/percona_slow_extended-use_global_control.test (+0/-12) mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-master.opt (+0/-1) mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result (+0/-46) mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.test (+0/-40) mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result (+0/-12) mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test (+0/-11) mysql-test/userstat_bug602047.result (+0/-15) mysql-test/userstat_bug602047.test (+0/-11) patches/innodb_admin_command_base.patch (+15/-0) patches/innodb_buffer_pool_shm.patch (+16/-0) patches/innodb_deadlock_count.patch (+95/-0) patches/innodb_separate_doublewrite.patch (+16/-0) patches/innodb_show_sys_tables.patch (+15/-0) patches/log_connection_error.patch (+79/-0) patches/log_warnings_suppress.patch (+88/-0) patches/memory_dynamic_rows.patch (+2458/-0) patches/mysql-test.diff (+763/-0) patches/processlist_row_stats.patch (+165/-0) patches/query_cache_enhance.patch (+2618/-0) patches/response_time_distribution.patch (+1033/-0) patches/series (+1/-0) patches/show_slave_status_nolock.patch (+81/-0) patches/show_temp.patch (+129/-0) patches/slow_extended.patch (+1095/-0) patches/sql_no_fcache.patch (+29/-0) patches/userstat.patch (+33/-0) patches/xtradb_bug317074.patch (+58/-0) |
To merge this branch: | bzr merge lp:~tsarev/percona-server/5.5_bug_838725_fix |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email: mp+73945@code.launchpad.net |
This proposal supersedes a proposal from 2011-09-03.
Commit message
Description of the change
1) move tests from mysql-test/ to patches
2) remove install_tests script and call of script from Makefile
To post a comment you must log in.
Revision history for this message
Oleg Tsarev (tsarev) wrote : | # |
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
LGTM
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'Makefile' |
2 | --- Makefile 2011-08-22 17:26:45 +0000 |
3 | +++ Makefile 2011-09-03 15:21:28 +0000 |
4 | @@ -22,7 +22,7 @@ |
5 | REVS = $(shell bzr log | grep rev | head -1 ) |
6 | REV = $(word 2, $(REVS) ) |
7 | |
8 | -all: main handlersocket maatkit-udf install-lic tests misc |
9 | +all: main handlersocket maatkit-udf install-lic misc |
10 | @echo "" |
11 | @echo "Percona Server source code is ready" |
12 | @echo "Now change directory to $(PERCONA_SERVER) define variables as show below" |
13 | @@ -92,9 +92,6 @@ |
14 | @echo "Downloading MySQL sources from $(MASTER_SITE)" |
15 | $(FETCH_CMD) $(MASTER_SITE)/mysql-$(MYSQL_VERSION).tar.gz |
16 | |
17 | -tests: |
18 | - PERCONA_SERVER=${PERCONA_SERVER} sh install_tests |
19 | - |
20 | misc: |
21 | @echo "Installing other files" |
22 | install -m 644 lrusort.py $(PERCONA_SERVER)/scripts |
23 | |
24 | === removed file 'install_tests' |
25 | --- install_tests 2011-07-27 11:13:05 +0000 |
26 | +++ install_tests 1970-01-01 00:00:00 +0000 |
27 | @@ -1,37 +0,0 @@ |
28 | -#!/bin/sh |
29 | - |
30 | -set -u |
31 | - |
32 | -MYSQL_VERSION="$(grep ^MYSQL_VERSION= "Makefile" \ |
33 | - | cut -d = -f 2)" |
34 | -PERCONA_SERVER_VERSION="$(grep ^PERCONA_SERVER_VERSION= "Makefile" \ |
35 | - | cut -d = -f 2)" |
36 | -PERCONA_SERVER="Percona-Server-${MYSQL_VERSION}-${PERCONA_SERVER_VERSION}" |
37 | - |
38 | -install_file_type() |
39 | -{ |
40 | - for file in `ls $1/*.$2 2>/dev/null`; do |
41 | - test -f $file && install -m 644 $file ${PERCONA_SERVER}/mysql-test/$3 |
42 | - done; |
43 | -} |
44 | -do_install_path() |
45 | -{ |
46 | - install_file_type $1 test t |
47 | - install_file_type $1 opt t |
48 | - install_file_type $1 result r |
49 | - install_file_type $1 require r |
50 | - install_file_type $1 inc include |
51 | -} |
52 | -install_path() |
53 | -{ |
54 | - echo "[$3/$4] Installing mysql-test files: $2" |
55 | - test -d $1 && do_install_path $1 $2 |
56 | -} |
57 | -current=0; |
58 | -count=`wc -l patches/series`; |
59 | -install_path mysql-test "global" $current $count |
60 | -for test_name in `cat patches/series`; do |
61 | - current=$((current+1)); |
62 | - install_path mysql-test/$test_name $test_name $current $count |
63 | -done |
64 | -echo "Done" |
65 | |
66 | === removed directory 'mysql-test' |
67 | === removed file 'mysql-test/have_response_time_distribution.inc' |
68 | --- mysql-test/have_response_time_distribution.inc 2011-01-17 01:49:51 +0000 |
69 | +++ mysql-test/have_response_time_distribution.inc 1970-01-01 00:00:00 +0000 |
70 | @@ -1,4 +0,0 @@ |
71 | --- require r/have_response_time_distribution.require |
72 | -disable_query_log; |
73 | -show variables like 'have_response_time_distribution'; |
74 | -enable_query_log; |
75 | |
76 | === removed file 'mysql-test/have_response_time_distribution.require' |
77 | --- mysql-test/have_response_time_distribution.require 2011-01-17 01:49:51 +0000 |
78 | +++ mysql-test/have_response_time_distribution.require 1970-01-01 00:00:00 +0000 |
79 | @@ -1,2 +0,0 @@ |
80 | -Variable_name Value |
81 | -have_response_time_distribution YES |
82 | |
83 | === removed directory 'mysql-test/innodb_deadlock_count.patch' |
84 | === removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result' |
85 | --- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 2011-06-22 10:13:43 +0000 |
86 | +++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 1970-01-01 00:00:00 +0000 |
87 | @@ -1,28 +0,0 @@ |
88 | -# Establish connection con1 (user=root) |
89 | -# Establish connection con2 (user=root) |
90 | -# Establish connection con3 (user=root) |
91 | -# Drop test table |
92 | -drop table if exists t; |
93 | -# Create test table |
94 | -create table t(a INT PRIMARY KEY, b INT) engine=InnoDB; |
95 | -# Insert two rows to test table |
96 | -insert into t values(2,1); |
97 | -insert into t values(1,2); |
98 | -# Switch to connection con1 |
99 | -BEGIN; |
100 | -SELECT b FROM t WHERE a=1 FOR UPDATE; |
101 | -# Switch to connection con2 |
102 | -BEGIN; |
103 | -SELECT b FROM t WHERE a=2 FOR UPDATE; |
104 | -# Switch to connection con1 |
105 | -SELECT b FROM t WHERE a=2 FOR UPDATE; |
106 | -# Switch to connection con2 |
107 | -SELECT b FROM t WHERE a=1 FOR UPDATE; |
108 | -# Switch to connection con1 |
109 | -ROLLBACK; |
110 | -# Switch to connection con2 |
111 | -ROLLBACK; |
112 | -# Switch to connection con3 |
113 | -Deadlocks: 1 |
114 | -# Drop test table |
115 | -drop table t; |
116 | |
117 | === removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test' |
118 | --- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 2011-06-22 10:13:43 +0000 |
119 | +++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 1970-01-01 00:00:00 +0000 |
120 | @@ -1,61 +0,0 @@ |
121 | ---source include/have_innodb.inc |
122 | ---echo # Establish connection con1 (user=root) |
123 | -connect (con1,localhost,root,,); |
124 | ---echo # Establish connection con2 (user=root) |
125 | -connect (con2,localhost,root,,); |
126 | ---echo # Establish connection con3 (user=root) |
127 | -connect (con3,localhost,root,,); |
128 | ---echo # Drop test table |
129 | ---disable_warnings |
130 | -drop table if exists t; |
131 | ---enable_warnings |
132 | - |
133 | ---echo # Create test table |
134 | -create table t(a INT PRIMARY KEY, b INT) engine=InnoDB; |
135 | ---echo # Insert two rows to test table |
136 | -insert into t values(2,1); |
137 | -insert into t values(1,2); |
138 | - |
139 | -#--echo # Save current deadlock count |
140 | -let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`; |
141 | - |
142 | ---disable_result_log |
143 | - |
144 | ---echo # Switch to connection con1 |
145 | -connection con1; |
146 | -BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE; |
147 | - |
148 | ---echo # Switch to connection con2 |
149 | -connection con2; |
150 | -BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE; |
151 | - |
152 | ---echo # Switch to connection con1 |
153 | -connection con1; |
154 | -SEND SELECT b FROM t WHERE a=2 FOR UPDATE; |
155 | - |
156 | ---echo # Switch to connection con2 |
157 | -connection con2; |
158 | -SEND SELECT b FROM t WHERE a=1 FOR UPDATE; |
159 | - |
160 | ---echo # Switch to connection con1 |
161 | -connection con1; |
162 | ---error 0, ER_LOCK_DEADLOCK |
163 | -reap; |
164 | -ROLLBACK; |
165 | - |
166 | ---echo # Switch to connection con2 |
167 | -connection con2; |
168 | ---error 0, ER_LOCK_DEADLOCK |
169 | -reap; |
170 | -ROLLBACK; |
171 | - |
172 | ---echo # Switch to connection con3 |
173 | -connection con3; |
174 | -let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`; |
175 | - |
176 | ---enable_result_log |
177 | - |
178 | -let $diff = `SELECT $result - $current`; |
179 | -echo Deadlocks: $diff; |
180 | ---echo # Drop test table |
181 | -drop table t; |
182 | |
183 | === removed directory 'mysql-test/log_connection_error.patch' |
184 | === removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt' |
185 | --- mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt 2010-12-09 18:30:58 +0000 |
186 | +++ mysql-test/log_connection_error.patch/percona_log_connection_error-master.opt 1970-01-01 00:00:00 +0000 |
187 | @@ -1,1 +0,0 @@ |
188 | ---log-error |
189 | |
190 | === removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error.result' |
191 | --- mysql-test/log_connection_error.patch/percona_log_connection_error.result 2010-12-09 18:30:58 +0000 |
192 | +++ mysql-test/log_connection_error.patch/percona_log_connection_error.result 1970-01-01 00:00:00 +0000 |
193 | @@ -1,15 +0,0 @@ |
194 | -SET @old_max_connections = @@max_connections; |
195 | -SET @old_log_warnings = @@log_warnings; |
196 | -SET GLOBAL max_connections=2; |
197 | -SET GLOBAL LOG_WARNINGS = 0; |
198 | -connect(localhost,root,,test,port,socket); |
199 | -ERROR HY000: Too many connections |
200 | -SET GLOBAL LOG_WARNINGS = 1; |
201 | -connect(localhost,root,,test,port,socket); |
202 | -ERROR HY000: Too many connections |
203 | -SET GLOBAL LOG_WARNINGS = 0; |
204 | -connect(localhost,root,,test,port,socket); |
205 | -ERROR HY000: Too many connections |
206 | -SET GLOBAL max_connections = @old_max_connections; |
207 | -SET GLOBAL log_warnings = @old_log_warnings; |
208 | -1 |
209 | |
210 | === removed file 'mysql-test/log_connection_error.patch/percona_log_connection_error.test' |
211 | --- mysql-test/log_connection_error.patch/percona_log_connection_error.test 2011-04-09 15:41:52 +0000 |
212 | +++ mysql-test/log_connection_error.patch/percona_log_connection_error.test 1970-01-01 00:00:00 +0000 |
213 | @@ -1,54 +0,0 @@ |
214 | ---source include/not_embedded.inc |
215 | - |
216 | -connect (main,localhost,root,,); |
217 | -connection main; |
218 | -SET @old_max_connections = @@max_connections; |
219 | -SET @old_log_warnings = @@log_warnings; |
220 | -SET GLOBAL max_connections=2; |
221 | -let $port=`SELECT Variable_value FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name LIKE 'port'`; |
222 | -let $socket=`SELECT Variable_value FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name LIKE 'socket'`; |
223 | - |
224 | -SET GLOBAL LOG_WARNINGS = 0; |
225 | ---connect (conn0,localhost,root,,) |
226 | -connection conn0; |
227 | -replace_result $port port $socket socket; |
228 | ---error 1040 |
229 | ---connect(conn1,localhost,root,,) |
230 | -disconnect conn0; |
231 | -SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right |
232 | - |
233 | -connection main; |
234 | -SET GLOBAL LOG_WARNINGS = 1; |
235 | ---connect (conn1,localhost,root,,) |
236 | -replace_result $port port $socket socket; |
237 | ---error 1040 |
238 | ---connect (conn0,localhost,root,,) |
239 | -disconnect conn1; |
240 | -SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right |
241 | - |
242 | -connection main; |
243 | -SET GLOBAL LOG_WARNINGS = 0; |
244 | ---connect (conn0,localhost,root,,) |
245 | -replace_result $port port $socket socket; |
246 | ---error 1040 |
247 | ---connect(conn1,localhost,root,,) |
248 | -disconnect conn0; |
249 | -SLEEP 0.1; # tsarev: hack, but i don't know (and didn't find) how right |
250 | - |
251 | -connection main; |
252 | -SET GLOBAL max_connections = @old_max_connections; |
253 | -SET GLOBAL log_warnings = @old_log_warnings; |
254 | -let $log_error_= `SELECT @@GLOBAL.log_error`; |
255 | -if(!`select LENGTH('$log_error_')`) |
256 | -{ |
257 | - # MySQL Server on windows is started with --console and thus |
258 | - # does not know the location of its .err log, use default location |
259 | - let $log_error_ = $MYSQLTEST_VARDIR/log/mysqld.1.err; |
260 | -} |
261 | -# Assign env variable LOG_ERROR |
262 | -let LOG_ERROR=$log_error_; |
263 | - |
264 | ---let grep_file = $log_error |
265 | ---let grep_pattern = Too many connections |
266 | ---source include/grep.inc |
267 | -exec $cmd; |
268 | |
269 | === removed directory 'mysql-test/log_warnings_suppress.patch' |
270 | === removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt' |
271 | --- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt 2011-02-21 13:56:22 +0000 |
272 | +++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress-master.opt 1970-01-01 00:00:00 +0000 |
273 | @@ -1,1 +0,0 @@ |
274 | ---log-error |
275 | |
276 | === removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result' |
277 | --- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result 2011-02-21 13:56:22 +0000 |
278 | +++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.result 1970-01-01 00:00:00 +0000 |
279 | @@ -1,31 +0,0 @@ |
280 | -SET @old_log_warnings = @@log_warnings; |
281 | -SET @old_log_warnings_suppress = @@log_warnings_suppress; |
282 | -DROP TABLE IF EXISTS t1; |
283 | -CREATE TABLE t1 (a VARCHAR(36), b VARCHAR(20)); |
284 | -SET GLOBAL log_warnings_suppress=''; |
285 | -SET GLOBAL LOG_WARNINGS=0; |
286 | -SHOW GLOBAL VARIABLES LIKE 'log_warnings_suppress'; |
287 | -Variable_name Value |
288 | -log_warnings_suppress |
289 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
290 | -Warnings: |
291 | -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. |
292 | -SET GLOBAL LOG_WARNINGS=1; |
293 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
294 | -Warnings: |
295 | -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. |
296 | -SET GLOBAL log_warnings_suppress='1592'; |
297 | -SET GLOBAL LOG_WARNINGS=0; |
298 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
299 | -Warnings: |
300 | -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. |
301 | -SET GLOBAL LOG_WARNINGS=1; |
302 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
303 | -Warnings: |
304 | -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. |
305 | -DROP TABLE t1; |
306 | -SET GLOBAL log_warnings = @old_log_warnings; |
307 | -SET GLOBAL log_warnings_suppress = @old_log_warnings_suppress; |
308 | -# Count the number of times the "Unsafe" message was printed |
309 | -# to the error log. |
310 | -Occurrences: 1 |
311 | |
312 | === removed file 'mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test' |
313 | --- mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test 2011-02-21 13:56:22 +0000 |
314 | +++ mysql-test/log_warnings_suppress.patch/percona_log_warnings_suppress.test 1970-01-01 00:00:00 +0000 |
315 | @@ -1,47 +0,0 @@ |
316 | --- source include/have_log_bin.inc |
317 | --- source include/have_binlog_format_statement.inc |
318 | - |
319 | -SET @old_log_warnings = @@log_warnings; |
320 | -SET @old_log_warnings_suppress = @@log_warnings_suppress; |
321 | - |
322 | ---disable_warnings |
323 | -DROP TABLE IF EXISTS t1; |
324 | ---enable_warnings |
325 | -CREATE TABLE t1 (a VARCHAR(36), b VARCHAR(20)); |
326 | -SET GLOBAL log_warnings_suppress=''; |
327 | -SET GLOBAL LOG_WARNINGS=0; |
328 | -SHOW GLOBAL VARIABLES LIKE 'log_warnings_suppress'; |
329 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
330 | -SET GLOBAL LOG_WARNINGS=1; |
331 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
332 | -SET GLOBAL log_warnings_suppress='1592'; |
333 | -SET GLOBAL LOG_WARNINGS=0; |
334 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
335 | -SET GLOBAL LOG_WARNINGS=1; |
336 | -INSERT INTO t1 VALUES(UUID(), 'suppress_1592'); |
337 | -DROP TABLE t1; |
338 | - |
339 | -SET GLOBAL log_warnings = @old_log_warnings; |
340 | -SET GLOBAL log_warnings_suppress = @old_log_warnings_suppress; |
341 | - |
342 | -let $log_error_= `SELECT @@GLOBAL.log_error`; |
343 | -if(!`select LENGTH('$log_error_')`) |
344 | -{ |
345 | - # MySQL Server on windows is started with --console and thus |
346 | - # does not know the location of its .err log, use default location |
347 | - let $log_error_ = $MYSQLTEST_VARDIR/log/mysqld.1.err; |
348 | -} |
349 | -# Assign env variable LOG_ERROR |
350 | -let LOG_ERROR=$log_error_; |
351 | - |
352 | ---echo # Count the number of times the "Unsafe" message was printed |
353 | ---echo # to the error log. |
354 | - |
355 | -perl; |
356 | - use strict; |
357 | - my $log_error= $ENV{'LOG_ERROR'} or die "LOG_ERROR not set"; |
358 | - open(FILE, "$log_error") or die("Unable to open $log_error: $!\n"); |
359 | - my $count = () = grep(/suppress_1592/g,<FILE>); |
360 | - print "Occurrences: $count\n"; |
361 | - close(FILE); |
362 | -EOF |
363 | |
364 | === removed directory 'mysql-test/memory_dynamic_rows.patch' |
365 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result' |
366 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result 2011-06-06 10:34:16 +0000 |
367 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result 1970-01-01 00:00:00 +0000 |
368 | @@ -1,952 +0,0 @@ |
369 | -SET @old_default_storage_engine=@@default_storage_engine; |
370 | -SET default_storage_engine=MEMORY; |
371 | -drop table if exists t1,t2,t3,t4,t5,t6,t7; |
372 | -CREATE TABLE t1 (a blob, b text, c blob(250), d text(70000), e text(70000000)); |
373 | -show columns from t1; |
374 | -Field Type Null Key Default Extra |
375 | -a blob YES NULL |
376 | -b text YES NULL |
377 | -c tinyblob YES NULL |
378 | -d mediumtext YES NULL |
379 | -e longtext YES NULL |
380 | -CREATE TABLE t2 (a char(255), b varbinary(70000), c varchar(70000000)); |
381 | -Warnings: |
382 | -Note 1246 Converting column 'b' from VARBINARY to BLOB |
383 | -Note 1246 Converting column 'c' from VARCHAR to TEXT |
384 | -CREATE TABLE t4 (c varchar(65530) character set utf8 not null); |
385 | -Warnings: |
386 | -Note 1246 Converting column 'c' from VARCHAR to TEXT |
387 | -show columns from t2; |
388 | -Field Type Null Key Default Extra |
389 | -a char(255) YES NULL |
390 | -b mediumblob YES NULL |
391 | -c longtext YES NULL |
392 | -create table t3 (a long, b long byte); |
393 | -show create TABLE t3; |
394 | -Table Create Table |
395 | -t3 CREATE TABLE `t3` ( |
396 | - `a` mediumtext, |
397 | - `b` mediumblob |
398 | -) ENGINE=MEMORY DEFAULT CHARSET=latin1 |
399 | -show create TABLE t4; |
400 | -Table Create Table |
401 | -t4 CREATE TABLE `t4` ( |
402 | - `c` mediumtext CHARACTER SET utf8 NOT NULL |
403 | -) ENGINE=MEMORY DEFAULT CHARSET=latin1 |
404 | -drop table t1,t2,t3,t4; |
405 | -CREATE TABLE t1 (a char(257) default "hello"); |
406 | -ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead |
407 | -CREATE TABLE t2 (a char(256)); |
408 | -ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead |
409 | -CREATE TABLE t1 (a varchar(70000) default "hello"); |
410 | -ERROR 42000: Column length too big for column 'a' (max = 65535); use BLOB or TEXT instead |
411 | -CREATE TABLE t2 (a blob default "hello"); |
412 | -ERROR 42000: BLOB/TEXT column 'a' can't have a default value |
413 | -drop table if exists t1,t2; |
414 | -create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr)); |
415 | -insert into t1 values (null,"a","A"); |
416 | -insert into t1 values (null,"bbb","BBB"); |
417 | -insert into t1 values (null,"ccc","CCC"); |
418 | -select last_insert_id(); |
419 | -last_insert_id() |
420 | -3 |
421 | -select * from t1,t1 as t2; |
422 | -nr b str nr b str |
423 | -1 a A 1 a A |
424 | -2 bbb BBB 1 a A |
425 | -3 ccc CCC 1 a A |
426 | -1 a A 2 bbb BBB |
427 | -2 bbb BBB 2 bbb BBB |
428 | -3 ccc CCC 2 bbb BBB |
429 | -1 a A 3 ccc CCC |
430 | -2 bbb BBB 3 ccc CCC |
431 | -3 ccc CCC 3 ccc CCC |
432 | -drop table t1; |
433 | -create table t1 (a text); |
434 | -insert into t1 values ('where'); |
435 | -update t1 set a='Where'; |
436 | -select * from t1; |
437 | -a |
438 | -Where |
439 | -drop table t1; |
440 | -create table t1 (t text,c char(10),b blob, d varbinary(10)); |
441 | -insert into t1 values (NULL,NULL,NULL,NULL); |
442 | -insert into t1 values ("","","",""); |
443 | -insert into t1 values ("hello","hello","hello","hello"); |
444 | -insert into t1 values ("HELLO","HELLO","HELLO","HELLO"); |
445 | -insert into t1 values ("HELLO MY","HELLO MY","HELLO MY","HELLO MY"); |
446 | -insert into t1 values ("a","a","a","a"); |
447 | -insert into t1 values (1,1,1,1); |
448 | -insert into t1 values (NULL,NULL,NULL,NULL); |
449 | -update t1 set c="",b=null where c="1"; |
450 | -lock tables t1 READ; |
451 | -show full fields from t1; |
452 | -Field Type Collation Null Key Default Extra Privileges Comment |
453 | -t text latin1_swedish_ci YES NULL # |
454 | -c char(10) latin1_swedish_ci YES NULL # |
455 | -b blob NULL YES NULL # |
456 | -d varbinary(10) NULL YES NULL # |
457 | -lock tables t1 WRITE; |
458 | -show full fields from t1; |
459 | -Field Type Collation Null Key Default Extra Privileges Comment |
460 | -t text latin1_swedish_ci YES NULL # |
461 | -c char(10) latin1_swedish_ci YES NULL # |
462 | -b blob NULL YES NULL # |
463 | -d varbinary(10) NULL YES NULL # |
464 | -unlock tables; |
465 | -select t from t1 where t like "hello"; |
466 | -t |
467 | -hello |
468 | -HELLO |
469 | -select c from t1 where c like "hello"; |
470 | -c |
471 | -hello |
472 | -HELLO |
473 | -select b from t1 where b like "hello"; |
474 | -b |
475 | -hello |
476 | -select d from t1 where d like "hello"; |
477 | -d |
478 | -hello |
479 | -select c from t1 having c like "hello"; |
480 | -c |
481 | -hello |
482 | -HELLO |
483 | -select d from t1 having d like "hello"; |
484 | -d |
485 | -hello |
486 | -select t from t1 where t like "%HELLO%"; |
487 | -t |
488 | -hello |
489 | -HELLO |
490 | -HELLO MY |
491 | -select c from t1 where c like "%HELLO%"; |
492 | -c |
493 | -hello |
494 | -HELLO |
495 | -HELLO MY |
496 | -select b from t1 where b like "%HELLO%"; |
497 | -b |
498 | -HELLO |
499 | -HELLO MY |
500 | -select d from t1 where d like "%HELLO%"; |
501 | -d |
502 | -HELLO |
503 | -HELLO MY |
504 | -select c from t1 having c like "%HELLO%"; |
505 | -c |
506 | -hello |
507 | -HELLO |
508 | -HELLO MY |
509 | -select d from t1 having d like "%HELLO%"; |
510 | -d |
511 | -HELLO |
512 | -HELLO MY |
513 | -select d from t1 having d like "%HE%LLO%"; |
514 | -d |
515 | -HELLO |
516 | -HELLO MY |
517 | -select t from t1 order by t; |
518 | -t |
519 | -NULL |
520 | -NULL |
521 | - |
522 | -1 |
523 | -a |
524 | -hello |
525 | -HELLO |
526 | -HELLO MY |
527 | -select c from t1 order by c; |
528 | -c |
529 | -NULL |
530 | -NULL |
531 | - |
532 | - |
533 | -a |
534 | -hello |
535 | -HELLO |
536 | -HELLO MY |
537 | -select b from t1 order by b; |
538 | -b |
539 | -NULL |
540 | -NULL |
541 | -NULL |
542 | - |
543 | -HELLO |
544 | -HELLO MY |
545 | -a |
546 | -hello |
547 | -select d from t1 order by d; |
548 | -d |
549 | -NULL |
550 | -NULL |
551 | - |
552 | -1 |
553 | -HELLO |
554 | -HELLO MY |
555 | -a |
556 | -hello |
557 | -select distinct t from t1; |
558 | -t |
559 | -NULL |
560 | - |
561 | -hello |
562 | -HELLO MY |
563 | -a |
564 | -1 |
565 | -select distinct b from t1; |
566 | -b |
567 | -NULL |
568 | - |
569 | -hello |
570 | -HELLO |
571 | -HELLO MY |
572 | -a |
573 | -select distinct t from t1 order by t; |
574 | -t |
575 | -NULL |
576 | - |
577 | -1 |
578 | -a |
579 | -hello |
580 | -HELLO MY |
581 | -select distinct b from t1 order by b; |
582 | -b |
583 | -NULL |
584 | - |
585 | -HELLO |
586 | -HELLO MY |
587 | -a |
588 | -hello |
589 | -select t from t1 group by t; |
590 | -t |
591 | -NULL |
592 | - |
593 | -1 |
594 | -a |
595 | -hello |
596 | -HELLO MY |
597 | -select b from t1 group by b; |
598 | -b |
599 | -NULL |
600 | - |
601 | -HELLO |
602 | -HELLO MY |
603 | -a |
604 | -hello |
605 | -set option sql_big_tables=1; |
606 | -select distinct t from t1; |
607 | -t |
608 | -NULL |
609 | - |
610 | -hello |
611 | -HELLO MY |
612 | -a |
613 | -1 |
614 | -select distinct b from t1; |
615 | -b |
616 | -NULL |
617 | - |
618 | -hello |
619 | -HELLO |
620 | -HELLO MY |
621 | -a |
622 | -select distinct t from t1 order by t; |
623 | -t |
624 | -NULL |
625 | - |
626 | -1 |
627 | -a |
628 | -hello |
629 | -HELLO MY |
630 | -select distinct b from t1 order by b; |
631 | -b |
632 | -NULL |
633 | - |
634 | -HELLO |
635 | -HELLO MY |
636 | -a |
637 | -hello |
638 | -select distinct c from t1; |
639 | -c |
640 | -NULL |
641 | - |
642 | -hello |
643 | -HELLO MY |
644 | -a |
645 | -select distinct d from t1; |
646 | -d |
647 | -NULL |
648 | - |
649 | -hello |
650 | -HELLO |
651 | -HELLO MY |
652 | -a |
653 | -1 |
654 | -select distinct c from t1 order by c; |
655 | -c |
656 | -NULL |
657 | - |
658 | -a |
659 | -hello |
660 | -HELLO MY |
661 | -select distinct d from t1 order by d; |
662 | -d |
663 | -NULL |
664 | - |
665 | -1 |
666 | -HELLO |
667 | -HELLO MY |
668 | -a |
669 | -hello |
670 | -select c from t1 group by c; |
671 | -c |
672 | -NULL |
673 | - |
674 | -a |
675 | -hello |
676 | -HELLO MY |
677 | -select d from t1 group by d; |
678 | -d |
679 | -NULL |
680 | - |
681 | -1 |
682 | -HELLO |
683 | -HELLO MY |
684 | -a |
685 | -hello |
686 | -set option sql_big_tables=0; |
687 | -select distinct * from t1; |
688 | -t c b d |
689 | -NULL NULL NULL NULL |
690 | - |
691 | -hello hello hello hello |
692 | -HELLO HELLO HELLO HELLO |
693 | -HELLO MY HELLO MY HELLO MY HELLO MY |
694 | -a a a a |
695 | -1 NULL 1 |
696 | -select t,count(*) from t1 group by t; |
697 | -t count(*) |
698 | -NULL 2 |
699 | - 1 |
700 | -1 1 |
701 | -a 1 |
702 | -hello 2 |
703 | -HELLO MY 1 |
704 | -select b,count(*) from t1 group by b; |
705 | -b count(*) |
706 | -NULL 3 |
707 | - 1 |
708 | -HELLO 1 |
709 | -HELLO MY 1 |
710 | -a 1 |
711 | -hello 1 |
712 | -select c,count(*) from t1 group by c; |
713 | -c count(*) |
714 | -NULL 2 |
715 | - 2 |
716 | -a 1 |
717 | -hello 2 |
718 | -HELLO MY 1 |
719 | -select d,count(*) from t1 group by d; |
720 | -d count(*) |
721 | -NULL 2 |
722 | - 1 |
723 | -1 1 |
724 | -HELLO 1 |
725 | -HELLO MY 1 |
726 | -a 1 |
727 | -hello 1 |
728 | -drop table t1; |
729 | -CREATE TABLE t1 ( |
730 | -t1_id bigint(21) NOT NULL auto_increment, |
731 | -_field_72 varchar(128) DEFAULT '' NOT NULL, |
732 | -_field_95 varchar(32), |
733 | -_field_115 tinyint(4) DEFAULT '0' NOT NULL, |
734 | -_field_122 tinyint(4) DEFAULT '0' NOT NULL, |
735 | -_field_126 tinyint(4), |
736 | -_field_134 tinyint(4), |
737 | -PRIMARY KEY (t1_id), |
738 | -UNIQUE _field_72 (_field_72), |
739 | -KEY _field_115 (_field_115), |
740 | -KEY _field_122 (_field_122) |
741 | -); |
742 | -INSERT INTO t1 VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',0,1,NULL,NULL); |
743 | -INSERT INTO t1 VALUES (2,'hroberts','7415275a8c95952901e42b13a6b78566',0,1,NULL,NULL); |
744 | -INSERT INTO t1 VALUES (3,'guest','d41d8cd98f00b204e9800998ecf8427e',1,0,NULL,NULL); |
745 | -CREATE TABLE t2 ( |
746 | -seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
747 | -seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
748 | -PRIMARY KEY (seq_0_id,seq_1_id) |
749 | -); |
750 | -INSERT INTO t2 VALUES (1,1); |
751 | -INSERT INTO t2 VALUES (2,1); |
752 | -INSERT INTO t2 VALUES (2,2); |
753 | -CREATE TABLE t3 ( |
754 | -t3_id bigint(21) NOT NULL auto_increment, |
755 | -_field_131 varchar(128), |
756 | -_field_133 tinyint(4) DEFAULT '0' NOT NULL, |
757 | -_field_135 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
758 | -_field_137 tinyint(4), |
759 | -_field_139 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
760 | -_field_140 blob, |
761 | -_field_142 tinyint(4) DEFAULT '0' NOT NULL, |
762 | -_field_145 tinyint(4) DEFAULT '0' NOT NULL, |
763 | -_field_148 tinyint(4) DEFAULT '0' NOT NULL, |
764 | -PRIMARY KEY (t3_id), |
765 | -KEY _field_133 (_field_133), |
766 | -KEY _field_135 (_field_135), |
767 | -KEY _field_139 (_field_139), |
768 | -KEY _field_142 (_field_142), |
769 | -KEY _field_145 (_field_145), |
770 | -KEY _field_148 (_field_148) |
771 | -); |
772 | -INSERT INTO t3 VALUES (1,'test job 1',0,'0000-00-00 00:00:00',0,'1999-02-25 22:43:32','test\r\njob\r\n1',0,0,0); |
773 | -INSERT INTO t3 VALUES (2,'test job 2',0,'0000-00-00 00:00:00',0,'1999-02-26 21:08:04','',0,0,0); |
774 | -CREATE TABLE t4 ( |
775 | -seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
776 | -seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
777 | -PRIMARY KEY (seq_0_id,seq_1_id) |
778 | -); |
779 | -INSERT INTO t4 VALUES (1,1); |
780 | -INSERT INTO t4 VALUES (2,1); |
781 | -CREATE TABLE t5 ( |
782 | -t5_id bigint(21) NOT NULL auto_increment, |
783 | -_field_149 tinyint(4), |
784 | -_field_156 varchar(128) DEFAULT '' NOT NULL, |
785 | -_field_157 varchar(128) DEFAULT '' NOT NULL, |
786 | -_field_158 varchar(128) DEFAULT '' NOT NULL, |
787 | -_field_159 varchar(128) DEFAULT '' NOT NULL, |
788 | -_field_160 varchar(128) DEFAULT '' NOT NULL, |
789 | -_field_161 varchar(128) DEFAULT '' NOT NULL, |
790 | -PRIMARY KEY (t5_id), |
791 | -KEY _field_156 (_field_156), |
792 | -KEY _field_157 (_field_157), |
793 | -KEY _field_158 (_field_158), |
794 | -KEY _field_159 (_field_159), |
795 | -KEY _field_160 (_field_160), |
796 | -KEY _field_161 (_field_161) |
797 | -); |
798 | -INSERT INTO t5 VALUES (1,0,'tomato','','','','',''); |
799 | -INSERT INTO t5 VALUES (2,0,'cilantro','','','','',''); |
800 | -CREATE TABLE t6 ( |
801 | -seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
802 | -seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
803 | -PRIMARY KEY (seq_0_id,seq_1_id) |
804 | -); |
805 | -INSERT INTO t6 VALUES (1,1); |
806 | -INSERT INTO t6 VALUES (1,2); |
807 | -INSERT INTO t6 VALUES (2,2); |
808 | -CREATE TABLE t7 ( |
809 | -t7_id bigint(21) NOT NULL auto_increment, |
810 | -_field_143 tinyint(4), |
811 | -_field_165 varchar(32), |
812 | -_field_166 smallint(6) DEFAULT '0' NOT NULL, |
813 | -PRIMARY KEY (t7_id), |
814 | -KEY _field_166 (_field_166) |
815 | -); |
816 | -INSERT INTO t7 VALUES (1,0,'High',1); |
817 | -INSERT INTO t7 VALUES (2,0,'Medium',2); |
818 | -INSERT INTO t7 VALUES (3,0,'Low',3); |
819 | -select replace(t3._field_140, "\r","^M"),t3_id,min(t3._field_131), min(t3._field_135), min(t3._field_139), min(t3._field_137), min(link_alias_142._field_165), min(link_alias_133._field_72), min(t3._field_145), min(link_alias_148._field_156), replace(min(t3._field_140), "\r","^M"),t3.t3_id from t3 left join t4 on t4.seq_0_id = t3.t3_id left join t7 link_alias_142 on t4.seq_1_id = link_alias_142.t7_id left join t6 on t6.seq_0_id = t3.t3_id left join t1 link_alias_133 on t6.seq_1_id = link_alias_133.t1_id left join t2 on t2.seq_0_id = t3.t3_id left join t5 link_alias_148 on t2.seq_1_id = link_alias_148.t5_id where t3.t3_id in (1) group by t3.t3_id order by link_alias_142._field_166, _field_139, link_alias_133._field_72, _field_135, link_alias_148._field_156; |
820 | -replace(t3._field_140, "\r","^M") t3_id min(t3._field_131) min(t3._field_135) min(t3._field_139) min(t3._field_137) min(link_alias_142._field_165) min(link_alias_133._field_72) min(t3._field_145) min(link_alias_148._field_156) replace(min(t3._field_140), "\r","^M") t3_id |
821 | -test^M |
822 | -job^M |
823 | -1 1 test job 1 0000-00-00 00:00:00 1999-02-25 22:43:32 0 High admin 0 tomato test^M |
824 | -job^M |
825 | -1 1 |
826 | -drop table t1,t2,t3,t4,t5,t6,t7; |
827 | -create table t1 (a blob); |
828 | -insert into t1 values ("empty"),(""); |
829 | -select a,reverse(a) from t1; |
830 | -a reverse(a) |
831 | -empty ytpme |
832 | - |
833 | -drop table t1; |
834 | -create table t1 (id integer auto_increment unique,imagem LONGBLOB not null default ''); |
835 | -Warnings: |
836 | -Warning 1101 BLOB/TEXT column 'imagem' can't have a default value |
837 | -insert into t1 (id) values (1); |
838 | -select |
839 | -charset(load_file('../../std_data/words.dat')), |
840 | -collation(load_file('../../std_data/words.dat')), |
841 | -coercibility(load_file('../../std_data/words.dat')); |
842 | -charset(load_file('../../std_data/words.dat')) collation(load_file('../../std_data/words.dat')) coercibility(load_file('../../std_data/words.dat')) |
843 | -binary binary 4 |
844 | -explain extended select |
845 | -charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')), |
846 | -collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')), |
847 | -coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat')); |
848 | -id select_type table type possible_keys key key_len ref rows filtered Extra |
849 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
850 | -Warnings: |
851 | -Note 1003 select charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `charset(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `collation(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))`,coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat')) AS `coercibility(load_file('MYSQLTEST_VARDIR/std_data/words.dat'))` |
852 | -update t1 set imagem=load_file('MYSQLTEST_VARDIR/std_data/words.dat') where id=1; |
853 | -select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1; |
854 | -if(imagem is null, "ERROR", "OK") length(imagem) |
855 | -OK 581 |
856 | -drop table t1; |
857 | -create table t1 select load_file('MYSQLTEST_VARDIR/std_data/words.dat') l; |
858 | -show full fields from t1; |
859 | -Field Type Collation Null Key Default Extra Privileges Comment |
860 | -l longblob NULL YES NULL # |
861 | -drop table t1; |
862 | -create table t1 (id integer primary key auto_increment, txt text not null); |
863 | -insert into t1 (txt) values ('Chevy '); |
864 | -select * from t1 where txt='Chevy'; |
865 | -id txt |
866 | -1 Chevy |
867 | -select * from t1 where txt='Chevy '; |
868 | -id txt |
869 | -1 Chevy |
870 | -select * from t1 where txt='Chevy ' or txt='Chevy'; |
871 | -id txt |
872 | -1 Chevy |
873 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
874 | -id txt |
875 | -1 Chevy |
876 | -select * from t1 where id='1' or id='2'; |
877 | -id txt |
878 | -1 Chevy |
879 | -insert into t1 (txt) values('Ford'); |
880 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford'; |
881 | -id txt |
882 | -1 Chevy |
883 | -2 Ford |
884 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
885 | -id txt |
886 | -1 Chevy |
887 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy'; |
888 | -id txt |
889 | -1 Chevy |
890 | -select * from t1 where txt in ('Chevy ','Chevy'); |
891 | -id txt |
892 | -1 Chevy |
893 | -select * from t1 where txt in ('Chevy'); |
894 | -id txt |
895 | -1 Chevy |
896 | -select * from t1 where txt between 'Chevy' and 'Chevy'; |
897 | -id txt |
898 | -1 Chevy |
899 | -select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy '; |
900 | -id txt |
901 | -1 Chevy |
902 | -select * from t1 where txt between 'Chevy' and 'Chevy '; |
903 | -id txt |
904 | -1 Chevy |
905 | -select * from t1 where txt < 'Chevy '; |
906 | -id txt |
907 | -select * from t1 where txt <= 'Chevy'; |
908 | -id txt |
909 | -1 Chevy |
910 | -select * from t1 where txt > 'Chevy'; |
911 | -id txt |
912 | -2 Ford |
913 | -select * from t1 where txt >= 'Chevy'; |
914 | -id txt |
915 | -1 Chevy |
916 | -2 Ford |
917 | -drop table t1; |
918 | -create table t1 (id integer primary key auto_increment, txt text); |
919 | -insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL); |
920 | -select * from t1 where txt='Chevy' or txt is NULL; |
921 | -id txt |
922 | -1 Chevy |
923 | -2 Chevy |
924 | -3 NULL |
925 | -explain select * from t1 where txt='Chevy' or txt is NULL; |
926 | -id select_type table type possible_keys key key_len ref rows Extra |
927 | -1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where |
928 | -select * from t1 where txt='Chevy '; |
929 | -id txt |
930 | -1 Chevy |
931 | -2 Chevy |
932 | -select * from t1 where txt='Chevy ' or txt='Chevy'; |
933 | -id txt |
934 | -1 Chevy |
935 | -2 Chevy |
936 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
937 | -id txt |
938 | -1 Chevy |
939 | -2 Chevy |
940 | -select * from t1 where id='1' or id='2'; |
941 | -id txt |
942 | -1 Chevy |
943 | -2 Chevy |
944 | -insert into t1 (txt) values('Ford'); |
945 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford'; |
946 | -id txt |
947 | -1 Chevy |
948 | -2 Chevy |
949 | -4 Ford |
950 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
951 | -id txt |
952 | -1 Chevy |
953 | -2 Chevy |
954 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy'; |
955 | -id txt |
956 | -1 Chevy |
957 | -2 Chevy |
958 | -select * from t1 where txt in ('Chevy ','Chevy'); |
959 | -id txt |
960 | -1 Chevy |
961 | -2 Chevy |
962 | -select * from t1 where txt in ('Chevy'); |
963 | -id txt |
964 | -1 Chevy |
965 | -2 Chevy |
966 | -select * from t1 where txt between 'Chevy' and 'Chevy'; |
967 | -id txt |
968 | -1 Chevy |
969 | -2 Chevy |
970 | -select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy '; |
971 | -id txt |
972 | -1 Chevy |
973 | -2 Chevy |
974 | -select * from t1 where txt between 'Chevy' and 'Chevy '; |
975 | -id txt |
976 | -1 Chevy |
977 | -2 Chevy |
978 | -select * from t1 where txt < 'Chevy '; |
979 | -id txt |
980 | -select * from t1 where txt < 'Chevy ' or txt is NULL; |
981 | -id txt |
982 | -3 NULL |
983 | -select * from t1 where txt <= 'Chevy'; |
984 | -id txt |
985 | -1 Chevy |
986 | -2 Chevy |
987 | -select * from t1 where txt > 'Chevy'; |
988 | -id txt |
989 | -4 Ford |
990 | -select * from t1 where txt >= 'Chevy'; |
991 | -id txt |
992 | -1 Chevy |
993 | -2 Chevy |
994 | -4 Ford |
995 | -alter table t1 modify column txt blob; |
996 | -explain select * from t1 where txt='Chevy' or txt is NULL; |
997 | -id select_type table type possible_keys key key_len ref rows Extra |
998 | -1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using where |
999 | -select * from t1 where txt='Chevy' or txt is NULL; |
1000 | -id txt |
1001 | -1 Chevy |
1002 | -3 NULL |
1003 | -explain select * from t1 where txt='Chevy' or txt is NULL order by txt; |
1004 | -id select_type table type possible_keys key key_len ref rows Extra |
1005 | -1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using where; Using filesort |
1006 | -select * from t1 where txt='Chevy' or txt is NULL order by txt; |
1007 | -id txt |
1008 | -3 NULL |
1009 | -1 Chevy |
1010 | -drop table t1; |
1011 | -CREATE TABLE t1 ( i int(11) NOT NULL default '0', c text NOT NULL, d varchar(1) NOT NULL DEFAULT ' ', PRIMARY KEY (i)); |
1012 | -INSERT t1 (i, c) VALUES (1,''),(2,''),(3,'asdfh'),(4,''); |
1013 | -select max(i) from t1 where c = ''; |
1014 | -max(i) |
1015 | -4 |
1016 | -drop table t1; |
1017 | -CREATE table t1 (a blob); |
1018 | -insert into t1 values ('b'),('a\0'),('a'),('a '),('aa'),(NULL); |
1019 | -select hex(a) from t1 order by a; |
1020 | -hex(a) |
1021 | -NULL |
1022 | -61 |
1023 | -6100 |
1024 | -6120 |
1025 | -6161 |
1026 | -62 |
1027 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1028 | -b |
1029 | -NULL |
1030 | -6100 |
1031 | -610000 |
1032 | -612000 |
1033 | -616100 |
1034 | -6200 |
1035 | -alter table t1 modify a varbinary(5); |
1036 | -select hex(a) from t1 order by a; |
1037 | -hex(a) |
1038 | -NULL |
1039 | -61 |
1040 | -6100 |
1041 | -6120 |
1042 | -6161 |
1043 | -62 |
1044 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1045 | -b |
1046 | -NULL |
1047 | -6100 |
1048 | -610000 |
1049 | -612000 |
1050 | -616100 |
1051 | -6200 |
1052 | -alter table t1 modify a char(5); |
1053 | -select hex(a) from t1 order by a; |
1054 | -hex(a) |
1055 | -NULL |
1056 | -6100 |
1057 | -61 |
1058 | -61 |
1059 | -6161 |
1060 | -62 |
1061 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1062 | -b |
1063 | -NULL |
1064 | -610000 |
1065 | -6100 |
1066 | -6100 |
1067 | -616100 |
1068 | -6200 |
1069 | -alter table t1 modify a binary(5); |
1070 | -select hex(a) from t1 order by a; |
1071 | -hex(a) |
1072 | -NULL |
1073 | -6100000000 |
1074 | -6100000000 |
1075 | -6100000000 |
1076 | -6161000000 |
1077 | -6200000000 |
1078 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1079 | -b |
1080 | -NULL |
1081 | -610000000000 |
1082 | -610000000000 |
1083 | -610000000000 |
1084 | -616100000000 |
1085 | -620000000000 |
1086 | -drop table t1; |
1087 | -create table t1 (a text default ''); |
1088 | -Warnings: |
1089 | -Warning 1101 BLOB/TEXT column 'a' can't have a default value |
1090 | -show create table t1; |
1091 | -Table Create Table |
1092 | -t1 CREATE TABLE `t1` ( |
1093 | - `a` text |
1094 | -) ENGINE=MEMORY DEFAULT CHARSET=latin1 |
1095 | -insert into t1 values (default); |
1096 | -select * from t1; |
1097 | -a |
1098 | -NULL |
1099 | -drop table t1; |
1100 | -set @@sql_mode='TRADITIONAL'; |
1101 | -create table t1 (a text default ''); |
1102 | -ERROR 42000: BLOB/TEXT column 'a' can't have a default value |
1103 | -set @@sql_mode=''; |
1104 | -CREATE TABLE t (c TEXT CHARSET ASCII); |
1105 | -INSERT INTO t (c) VALUES (REPEAT('1',65537)); |
1106 | -Warnings: |
1107 | -Warning 1265 Data truncated for column 'c' at row 1 |
1108 | -INSERT INTO t (c) VALUES (REPEAT('2',65536)); |
1109 | -Warnings: |
1110 | -Warning 1265 Data truncated for column 'c' at row 1 |
1111 | -INSERT INTO t (c) VALUES (REPEAT('3',65535)); |
1112 | -SELECT LENGTH(c), CHAR_LENGTH(c) FROM t; |
1113 | -LENGTH(c) CHAR_LENGTH(c) |
1114 | -65535 65535 |
1115 | -65535 65535 |
1116 | -65535 65535 |
1117 | -DROP TABLE t; |
1118 | -drop table if exists b15776; |
1119 | -create table b15776 (data blob(2147483647)); |
1120 | -drop table b15776; |
1121 | -create table b15776 (data blob(-1)); |
1122 | -ERROR 42000: 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 '-1))' at line 1 |
1123 | -create table b15776 (data blob(2147483648)); |
1124 | -drop table b15776; |
1125 | -create table b15776 (data blob(4294967294)); |
1126 | -drop table b15776; |
1127 | -create table b15776 (data blob(4294967295)); |
1128 | -drop table b15776; |
1129 | -create table b15776 (data blob(4294967296)); |
1130 | -ERROR 42000: Display width out of range for column 'data' (max = 4294967295) |
1131 | -CREATE TABLE b15776 (a blob(2147483647), b blob(2147483648), c blob(4294967295), a1 text(2147483647), b1 text(2147483648), c1 text(4294967295) ); |
1132 | -show columns from b15776; |
1133 | -Field Type Null Key Default Extra |
1134 | -a longblob YES NULL |
1135 | -b longblob YES NULL |
1136 | -c longblob YES NULL |
1137 | -a1 longtext YES NULL |
1138 | -b1 longtext YES NULL |
1139 | -c1 longtext YES NULL |
1140 | -drop table b15776; |
1141 | -CREATE TABLE b15776 (a blob(4294967296)); |
1142 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1143 | -CREATE TABLE b15776 (a text(4294967296)); |
1144 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1145 | -CREATE TABLE b15776 (a blob(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1146 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1147 | -CREATE TABLE b15776 (a text(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1148 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1149 | -CREATE TABLE b15776 (a int(0)); |
1150 | -INSERT INTO b15776 values (NULL), (1), (42), (654); |
1151 | -SELECT * from b15776 ORDER BY a; |
1152 | -a |
1153 | -NULL |
1154 | -1 |
1155 | -42 |
1156 | -654 |
1157 | -DROP TABLE b15776; |
1158 | -CREATE TABLE b15776 (a int(-1)); |
1159 | -ERROR 42000: 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 '-1))' at line 1 |
1160 | -CREATE TABLE b15776 (a int(255)); |
1161 | -DROP TABLE b15776; |
1162 | -CREATE TABLE b15776 (a int(256)); |
1163 | -ERROR 42000: Display width out of range for column 'a' (max = 255) |
1164 | -CREATE TABLE b15776 (data blob(-1)); |
1165 | -ERROR 42000: 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 '-1))' at line 1 |
1166 | -CREATE TABLE b15776 (a char(2147483647)); |
1167 | -ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead |
1168 | -CREATE TABLE b15776 (a char(2147483648)); |
1169 | -ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead |
1170 | -CREATE TABLE b15776 (a char(4294967295)); |
1171 | -ERROR 42000: Column length too big for column 'a' (max = 255); use BLOB or TEXT instead |
1172 | -CREATE TABLE b15776 (a char(4294967296)); |
1173 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1174 | -CREATE TABLE b15776 (a year(4294967295)); |
1175 | -INSERT INTO b15776 VALUES (42); |
1176 | -SELECT * FROM b15776; |
1177 | -a |
1178 | -2042 |
1179 | -DROP TABLE b15776; |
1180 | -CREATE TABLE b15776 (a year(4294967296)); |
1181 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1182 | -CREATE TABLE b15776 (a year(0)); |
1183 | -DROP TABLE b15776; |
1184 | -CREATE TABLE b15776 (a year(-2)); |
1185 | -ERROR 42000: 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 '-2))' at line 1 |
1186 | -CREATE TABLE b15776 (a int(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1187 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1188 | -CREATE TABLE b15776 (a char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1189 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1190 | -CREATE TABLE b15776 (a year(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1191 | -ERROR 42000: Display width out of range for column 'a' (max = 4294967295) |
1192 | -CREATE TABLE b15776 select cast(null as char(4294967295)); |
1193 | -show columns from b15776; |
1194 | -Field Type Null Key Default Extra |
1195 | -cast(null as char(4294967295)) char(0) YES NULL |
1196 | -drop table b15776; |
1197 | -CREATE TABLE b15776 select cast(null as nchar(4294967295)); |
1198 | -show columns from b15776; |
1199 | -Field Type Null Key Default Extra |
1200 | -cast(null as nchar(4294967295)) char(0) YES NULL |
1201 | -drop table b15776; |
1202 | -CREATE TABLE b15776 select cast(null as binary(4294967295)); |
1203 | -show columns from b15776; |
1204 | -Field Type Null Key Default Extra |
1205 | -cast(null as binary(4294967295)) binary(0) YES NULL |
1206 | -drop table b15776; |
1207 | -explain select cast(1 as char(4294967295)); |
1208 | -id select_type table type possible_keys key key_len ref rows Extra |
1209 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1210 | -explain select cast(1 as nchar(4294967295)); |
1211 | -id select_type table type possible_keys key key_len ref rows Extra |
1212 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1213 | -explain select cast(1 as binary(4294967295)); |
1214 | -id select_type table type possible_keys key key_len ref rows Extra |
1215 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1216 | -explain select cast(1 as char(4294967296)); |
1217 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1218 | -explain select cast(1 as nchar(4294967296)); |
1219 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1220 | -explain select cast(1 as binary(4294967296)); |
1221 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1222 | -explain select cast(1 as decimal(-1)); |
1223 | -ERROR 42000: 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 '-1))' at line 1 |
1224 | -explain select cast(1 as decimal(64, 30)); |
1225 | -id select_type table type possible_keys key key_len ref rows Extra |
1226 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1227 | -explain select cast(1 as decimal(64, 999999999999999999999999999999)); |
1228 | -Got one of the listed errors |
1229 | -explain select cast(1 as decimal(4294967296)); |
1230 | -Got one of the listed errors |
1231 | -explain select cast(1 as decimal(999999999999999999999999999999999999)); |
1232 | -Got one of the listed errors |
1233 | -explain select convert(1, char(4294967295)); |
1234 | -id select_type table type possible_keys key key_len ref rows Extra |
1235 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1236 | -explain select convert(1, char(4294967296)); |
1237 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1238 | -explain select convert(1, char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1239 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1240 | -explain select convert(1, nchar(4294967295)); |
1241 | -id select_type table type possible_keys key key_len ref rows Extra |
1242 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1243 | -explain select convert(1, nchar(4294967296)); |
1244 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1245 | -explain select convert(1, nchar(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1246 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1247 | -explain select convert(1, binary(4294967295)); |
1248 | -id select_type table type possible_keys key key_len ref rows Extra |
1249 | -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used |
1250 | -explain select convert(1, binary(4294967296)); |
1251 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1252 | -explain select convert(1, binary(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1253 | -ERROR 42000: Display width out of range for column 'cast as char' (max = 4294967295) |
1254 | -End of 5.0 tests |
1255 | -CREATE TABLE t1(id INT NOT NULL); |
1256 | -CREATE TABLE t2(id INT NOT NULL, c TEXT NOT NULL); |
1257 | -INSERT INTO t1 VALUES (1); |
1258 | -INSERT INTO t2 VALUES (1, ''); |
1259 | -UPDATE t2 SET c = REPEAT('1', 70000); |
1260 | -Warnings: |
1261 | -Warning 1265 Data truncated for column 'c' at row 1 |
1262 | -SELECT LENGTH(c) FROM t2; |
1263 | -LENGTH(c) |
1264 | -65535 |
1265 | -UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1; |
1266 | -Warnings: |
1267 | -Warning 1265 Data truncated for column 'c' at row 1 |
1268 | -SELECT LENGTH(c) FROM t2; |
1269 | -LENGTH(c) |
1270 | -65535 |
1271 | -DROP TABLE t1, t2; |
1272 | -# Bug #52160: crash and inconsistent results when grouping |
1273 | -# by a function and column |
1274 | -CREATE FUNCTION f1() RETURNS TINYBLOB RETURN 1; |
1275 | -CREATE TABLE t1(a CHAR(1)); |
1276 | -INSERT INTO t1 VALUES ('0'), ('0'); |
1277 | -SELECT COUNT(*) FROM t1 GROUP BY f1(), a; |
1278 | -COUNT(*) |
1279 | -2 |
1280 | -DROP FUNCTION f1; |
1281 | -DROP TABLE t1; |
1282 | -SET default_storage_engine=@old_default_storage_engine; |
1283 | -SET @old_max_heap_table_size = @@global.max_heap_table_size; |
1284 | -SET @old_max_allowed_packet = @@global.max_allowed_packet; |
1285 | -SET GLOBAL max_heap_table_size = 18 * 1024 * 1024; |
1286 | -SET GLOBAL max_allowed_packet = 24 * 1024 * 1024; |
1287 | -drop table if exists t1; |
1288 | -CREATE TABLE t1 (data LONGBLOB) ENGINE=memory; |
1289 | -INSERT INTO t1 (data) VALUES (NULL); |
1290 | -UPDATE t1 set data=repeat('a',18*1024*1024); |
1291 | -select length(data) from t1; |
1292 | -length(data) |
1293 | -18874368 |
1294 | -delete from t1 where left(data,1)='a'; |
1295 | -truncate table t1; |
1296 | -INSERT INTO t1 (data) VALUES (repeat('a',1*1024*1024)); |
1297 | -INSERT INTO t1 (data) VALUES (repeat('b',16*1024*1024-1024)); |
1298 | -delete from t1 where left(data,1)='b'; |
1299 | -UPDATE t1 set data=repeat('c',17*1024*1024); |
1300 | -delete from t1 where left(data,1)='c'; |
1301 | -INSERT INTO t1 set data=repeat('a',18*1024*1024); |
1302 | -select length(data) from t1; |
1303 | -length(data) |
1304 | -18874368 |
1305 | -alter table t1 modify data blob; |
1306 | -select length(data) from t1; |
1307 | -length(data) |
1308 | -0 |
1309 | -drop table t1; |
1310 | -CREATE TABLE t1 (data BLOB) ENGINE=myisam; |
1311 | -INSERT INTO t1 (data) VALUES (NULL); |
1312 | -UPDATE t1 set data=repeat('a',18*1024*1024); |
1313 | -Warnings: |
1314 | -Warning 1265 Data truncated for column 'data' at row 1 |
1315 | -select length(data) from t1; |
1316 | -length(data) |
1317 | -65535 |
1318 | -drop table t1; |
1319 | -SET GLOBAL max_allowed_packet = @old_max_allowed_packet; |
1320 | -SET GLOBAL max_heap_table_size = @old_max_heap_table_size; |
1321 | |
1322 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test' |
1323 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test 2011-08-22 11:28:27 +0000 |
1324 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test 1970-01-01 00:00:00 +0000 |
1325 | @@ -1,642 +0,0 @@ |
1326 | -######################################################################## |
1327 | -# Test blobs with the HEAP/MEMORY storage engine |
1328 | -######################################################################## |
1329 | - |
1330 | -######################################################################## |
1331 | -# Modified tests from type_blob.test |
1332 | -######################################################################## |
1333 | - |
1334 | -SET @old_default_storage_engine=@@default_storage_engine; |
1335 | -SET default_storage_engine=MEMORY; |
1336 | - |
1337 | -# |
1338 | -# Basic cleanup |
1339 | -# |
1340 | ---disable_warnings |
1341 | -drop table if exists t1,t2,t3,t4,t5,t6,t7; |
1342 | ---enable_warnings |
1343 | - |
1344 | - |
1345 | -# |
1346 | -# Check syntax for creating BLOB/TEXT |
1347 | -# |
1348 | - |
1349 | -CREATE TABLE t1 (a blob, b text, c blob(250), d text(70000), e text(70000000)); |
1350 | -show columns from t1; |
1351 | -# PS doesn't give errors on prepare yet |
1352 | -CREATE TABLE t2 (a char(255), b varbinary(70000), c varchar(70000000)); |
1353 | -CREATE TABLE t4 (c varchar(65530) character set utf8 not null); |
1354 | -show columns from t2; |
1355 | -create table t3 (a long, b long byte); |
1356 | -show create TABLE t3; |
1357 | -show create TABLE t4; |
1358 | -drop table t1,t2,t3,t4; |
1359 | - |
1360 | -# |
1361 | -# Check errors with blob |
1362 | -# |
1363 | - |
1364 | ---error 1074 |
1365 | -CREATE TABLE t1 (a char(257) default "hello"); |
1366 | ---error 1074 |
1367 | -CREATE TABLE t2 (a char(256)); |
1368 | ---error 1074 |
1369 | -CREATE TABLE t1 (a varchar(70000) default "hello"); |
1370 | ---error 1101 |
1371 | -CREATE TABLE t2 (a blob default "hello"); |
1372 | - |
1373 | -# Safety to be able to continue with other tests if above fails |
1374 | ---disable_warnings |
1375 | -drop table if exists t1,t2; |
1376 | ---enable_warnings |
1377 | - |
1378 | -# |
1379 | -# test of full join with blob |
1380 | -# |
1381 | - |
1382 | -create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr)); |
1383 | -insert into t1 values (null,"a","A"); |
1384 | -insert into t1 values (null,"bbb","BBB"); |
1385 | -insert into t1 values (null,"ccc","CCC"); |
1386 | -select last_insert_id(); |
1387 | -select * from t1,t1 as t2; |
1388 | - |
1389 | -drop table t1; |
1390 | - |
1391 | -# |
1392 | -# Test of changing TEXT column |
1393 | -# |
1394 | - |
1395 | -create table t1 (a text); |
1396 | -insert into t1 values ('where'); |
1397 | -update t1 set a='Where'; |
1398 | -select * from t1; |
1399 | -drop table t1; |
1400 | - |
1401 | -# |
1402 | -# test of blob, text, char and varbinary |
1403 | -# |
1404 | -create table t1 (t text,c char(10),b blob, d varbinary(10)); |
1405 | -insert into t1 values (NULL,NULL,NULL,NULL); |
1406 | -insert into t1 values ("","","",""); |
1407 | -insert into t1 values ("hello","hello","hello","hello"); |
1408 | -insert into t1 values ("HELLO","HELLO","HELLO","HELLO"); |
1409 | -insert into t1 values ("HELLO MY","HELLO MY","HELLO MY","HELLO MY"); |
1410 | -insert into t1 values ("a","a","a","a"); |
1411 | -insert into t1 values (1,1,1,1); |
1412 | -insert into t1 values (NULL,NULL,NULL,NULL); |
1413 | -update t1 set c="",b=null where c="1"; |
1414 | - |
1415 | -lock tables t1 READ; |
1416 | -# We mask out the Privileges column because it differs for embedded server |
1417 | ---replace_column 8 # |
1418 | -show full fields from t1; |
1419 | -lock tables t1 WRITE; |
1420 | ---replace_column 8 # |
1421 | -show full fields from t1; |
1422 | -unlock tables; |
1423 | - |
1424 | -select t from t1 where t like "hello"; |
1425 | -select c from t1 where c like "hello"; |
1426 | -select b from t1 where b like "hello"; |
1427 | -select d from t1 where d like "hello"; |
1428 | -select c from t1 having c like "hello"; |
1429 | -select d from t1 having d like "hello"; |
1430 | -select t from t1 where t like "%HELLO%"; |
1431 | -select c from t1 where c like "%HELLO%"; |
1432 | -select b from t1 where b like "%HELLO%"; |
1433 | -select d from t1 where d like "%HELLO%"; |
1434 | -select c from t1 having c like "%HELLO%"; |
1435 | -select d from t1 having d like "%HELLO%"; |
1436 | -select d from t1 having d like "%HE%LLO%"; |
1437 | -select t from t1 order by t; |
1438 | -select c from t1 order by c; |
1439 | -select b from t1 order by b; |
1440 | -select d from t1 order by d; |
1441 | -select distinct t from t1; |
1442 | -select distinct b from t1; |
1443 | -select distinct t from t1 order by t; |
1444 | -select distinct b from t1 order by b; |
1445 | -select t from t1 group by t; |
1446 | -select b from t1 group by b; |
1447 | -set option sql_big_tables=1; |
1448 | -select distinct t from t1; |
1449 | -select distinct b from t1; |
1450 | -select distinct t from t1 order by t; |
1451 | -select distinct b from t1 order by b; |
1452 | -select distinct c from t1; |
1453 | -select distinct d from t1; |
1454 | -select distinct c from t1 order by c; |
1455 | -select distinct d from t1 order by d; |
1456 | -select c from t1 group by c; |
1457 | -select d from t1 group by d; |
1458 | -set option sql_big_tables=0; |
1459 | -select distinct * from t1; |
1460 | -select t,count(*) from t1 group by t; |
1461 | -select b,count(*) from t1 group by b; |
1462 | -select c,count(*) from t1 group by c; |
1463 | -select d,count(*) from t1 group by d; |
1464 | -drop table t1; |
1465 | - |
1466 | - |
1467 | -# |
1468 | -# Test of join with blobs and min |
1469 | -# |
1470 | - |
1471 | -CREATE TABLE t1 ( |
1472 | - t1_id bigint(21) NOT NULL auto_increment, |
1473 | - _field_72 varchar(128) DEFAULT '' NOT NULL, |
1474 | - _field_95 varchar(32), |
1475 | - _field_115 tinyint(4) DEFAULT '0' NOT NULL, |
1476 | - _field_122 tinyint(4) DEFAULT '0' NOT NULL, |
1477 | - _field_126 tinyint(4), |
1478 | - _field_134 tinyint(4), |
1479 | - PRIMARY KEY (t1_id), |
1480 | - UNIQUE _field_72 (_field_72), |
1481 | - KEY _field_115 (_field_115), |
1482 | - KEY _field_122 (_field_122) |
1483 | -); |
1484 | - |
1485 | - |
1486 | -INSERT INTO t1 VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',0,1,NULL,NULL); |
1487 | -INSERT INTO t1 VALUES (2,'hroberts','7415275a8c95952901e42b13a6b78566',0,1,NULL,NULL); |
1488 | -INSERT INTO t1 VALUES (3,'guest','d41d8cd98f00b204e9800998ecf8427e',1,0,NULL,NULL); |
1489 | - |
1490 | - |
1491 | -CREATE TABLE t2 ( |
1492 | - seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
1493 | - seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
1494 | - PRIMARY KEY (seq_0_id,seq_1_id) |
1495 | -); |
1496 | - |
1497 | - |
1498 | -INSERT INTO t2 VALUES (1,1); |
1499 | -INSERT INTO t2 VALUES (2,1); |
1500 | -INSERT INTO t2 VALUES (2,2); |
1501 | - |
1502 | -CREATE TABLE t3 ( |
1503 | - t3_id bigint(21) NOT NULL auto_increment, |
1504 | - _field_131 varchar(128), |
1505 | - _field_133 tinyint(4) DEFAULT '0' NOT NULL, |
1506 | - _field_135 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
1507 | - _field_137 tinyint(4), |
1508 | - _field_139 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
1509 | - _field_140 blob, |
1510 | - _field_142 tinyint(4) DEFAULT '0' NOT NULL, |
1511 | - _field_145 tinyint(4) DEFAULT '0' NOT NULL, |
1512 | - _field_148 tinyint(4) DEFAULT '0' NOT NULL, |
1513 | - PRIMARY KEY (t3_id), |
1514 | - KEY _field_133 (_field_133), |
1515 | - KEY _field_135 (_field_135), |
1516 | - KEY _field_139 (_field_139), |
1517 | - KEY _field_142 (_field_142), |
1518 | - KEY _field_145 (_field_145), |
1519 | - KEY _field_148 (_field_148) |
1520 | -); |
1521 | - |
1522 | - |
1523 | -INSERT INTO t3 VALUES (1,'test job 1',0,'0000-00-00 00:00:00',0,'1999-02-25 22:43:32','test\r\njob\r\n1',0,0,0); |
1524 | -INSERT INTO t3 VALUES (2,'test job 2',0,'0000-00-00 00:00:00',0,'1999-02-26 21:08:04','',0,0,0); |
1525 | - |
1526 | - |
1527 | -CREATE TABLE t4 ( |
1528 | - seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
1529 | - seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
1530 | - PRIMARY KEY (seq_0_id,seq_1_id) |
1531 | -); |
1532 | - |
1533 | - |
1534 | -INSERT INTO t4 VALUES (1,1); |
1535 | -INSERT INTO t4 VALUES (2,1); |
1536 | - |
1537 | -CREATE TABLE t5 ( |
1538 | - t5_id bigint(21) NOT NULL auto_increment, |
1539 | - _field_149 tinyint(4), |
1540 | - _field_156 varchar(128) DEFAULT '' NOT NULL, |
1541 | - _field_157 varchar(128) DEFAULT '' NOT NULL, |
1542 | - _field_158 varchar(128) DEFAULT '' NOT NULL, |
1543 | - _field_159 varchar(128) DEFAULT '' NOT NULL, |
1544 | - _field_160 varchar(128) DEFAULT '' NOT NULL, |
1545 | - _field_161 varchar(128) DEFAULT '' NOT NULL, |
1546 | - PRIMARY KEY (t5_id), |
1547 | - KEY _field_156 (_field_156), |
1548 | - KEY _field_157 (_field_157), |
1549 | - KEY _field_158 (_field_158), |
1550 | - KEY _field_159 (_field_159), |
1551 | - KEY _field_160 (_field_160), |
1552 | - KEY _field_161 (_field_161) |
1553 | -); |
1554 | - |
1555 | - |
1556 | -INSERT INTO t5 VALUES (1,0,'tomato','','','','',''); |
1557 | -INSERT INTO t5 VALUES (2,0,'cilantro','','','','',''); |
1558 | - |
1559 | -CREATE TABLE t6 ( |
1560 | - seq_0_id bigint(21) DEFAULT '0' NOT NULL, |
1561 | - seq_1_id bigint(21) DEFAULT '0' NOT NULL, |
1562 | - PRIMARY KEY (seq_0_id,seq_1_id) |
1563 | -); |
1564 | - |
1565 | -INSERT INTO t6 VALUES (1,1); |
1566 | -INSERT INTO t6 VALUES (1,2); |
1567 | -INSERT INTO t6 VALUES (2,2); |
1568 | - |
1569 | -CREATE TABLE t7 ( |
1570 | - t7_id bigint(21) NOT NULL auto_increment, |
1571 | - _field_143 tinyint(4), |
1572 | - _field_165 varchar(32), |
1573 | - _field_166 smallint(6) DEFAULT '0' NOT NULL, |
1574 | - PRIMARY KEY (t7_id), |
1575 | - KEY _field_166 (_field_166) |
1576 | -); |
1577 | - |
1578 | - |
1579 | -INSERT INTO t7 VALUES (1,0,'High',1); |
1580 | -INSERT INTO t7 VALUES (2,0,'Medium',2); |
1581 | -INSERT INTO t7 VALUES (3,0,'Low',3); |
1582 | - |
1583 | -select replace(t3._field_140, "\r","^M"),t3_id,min(t3._field_131), min(t3._field_135), min(t3._field_139), min(t3._field_137), min(link_alias_142._field_165), min(link_alias_133._field_72), min(t3._field_145), min(link_alias_148._field_156), replace(min(t3._field_140), "\r","^M"),t3.t3_id from t3 left join t4 on t4.seq_0_id = t3.t3_id left join t7 link_alias_142 on t4.seq_1_id = link_alias_142.t7_id left join t6 on t6.seq_0_id = t3.t3_id left join t1 link_alias_133 on t6.seq_1_id = link_alias_133.t1_id left join t2 on t2.seq_0_id = t3.t3_id left join t5 link_alias_148 on t2.seq_1_id = link_alias_148.t5_id where t3.t3_id in (1) group by t3.t3_id order by link_alias_142._field_166, _field_139, link_alias_133._field_72, _field_135, link_alias_148._field_156; |
1584 | - |
1585 | -drop table t1,t2,t3,t4,t5,t6,t7; |
1586 | - |
1587 | -# |
1588 | -# Test of reverse with empty blob |
1589 | -# |
1590 | - |
1591 | -create table t1 (a blob); |
1592 | -insert into t1 values ("empty"),(""); |
1593 | -select a,reverse(a) from t1; |
1594 | -drop table t1; |
1595 | - |
1596 | -# |
1597 | -# Bug when blob is updated |
1598 | -# |
1599 | - |
1600 | -create table t1 (id integer auto_increment unique,imagem LONGBLOB not null default ''); |
1601 | -insert into t1 (id) values (1); |
1602 | -# We have to clean up the path in the results for safe comparison |
1603 | -eval select |
1604 | - charset(load_file('../../std_data/words.dat')), |
1605 | - collation(load_file('../../std_data/words.dat')), |
1606 | - coercibility(load_file('../../std_data/words.dat')); |
1607 | ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR |
1608 | -eval explain extended select |
1609 | - charset(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')), |
1610 | - collation(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')), |
1611 | - coercibility(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')); |
1612 | ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR |
1613 | -eval update t1 set imagem=load_file('$MYSQLTEST_VARDIR/std_data/words.dat') where id=1; |
1614 | -select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1; |
1615 | -drop table t1; |
1616 | ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR |
1617 | -eval create table t1 select load_file('$MYSQLTEST_VARDIR/std_data/words.dat') l; |
1618 | -# We mask out the Privileges column because it differs for embedded server |
1619 | ---replace_column 8 # |
1620 | -show full fields from t1; |
1621 | -drop table t1; |
1622 | - |
1623 | -# |
1624 | -# Test blob's with end space (Bug #1651) |
1625 | -# This is a bit changed since we now have true varchar |
1626 | -# |
1627 | - |
1628 | -create table t1 (id integer primary key auto_increment, txt text not null); |
1629 | -insert into t1 (txt) values ('Chevy '); |
1630 | -select * from t1 where txt='Chevy'; |
1631 | -select * from t1 where txt='Chevy '; |
1632 | -select * from t1 where txt='Chevy ' or txt='Chevy'; |
1633 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
1634 | -select * from t1 where id='1' or id='2'; |
1635 | -insert into t1 (txt) values('Ford'); |
1636 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford'; |
1637 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
1638 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy'; |
1639 | -select * from t1 where txt in ('Chevy ','Chevy'); |
1640 | -select * from t1 where txt in ('Chevy'); |
1641 | -select * from t1 where txt between 'Chevy' and 'Chevy'; |
1642 | -select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy '; |
1643 | -select * from t1 where txt between 'Chevy' and 'Chevy '; |
1644 | -select * from t1 where txt < 'Chevy '; |
1645 | -select * from t1 where txt <= 'Chevy'; |
1646 | -select * from t1 where txt > 'Chevy'; |
1647 | -select * from t1 where txt >= 'Chevy'; |
1648 | -drop table t1; |
1649 | - |
1650 | -create table t1 (id integer primary key auto_increment, txt text); |
1651 | -insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL); |
1652 | -select * from t1 where txt='Chevy' or txt is NULL; |
1653 | -explain select * from t1 where txt='Chevy' or txt is NULL; |
1654 | -select * from t1 where txt='Chevy '; |
1655 | -select * from t1 where txt='Chevy ' or txt='Chevy'; |
1656 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
1657 | -select * from t1 where id='1' or id='2'; |
1658 | -insert into t1 (txt) values('Ford'); |
1659 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt='Ford'; |
1660 | -select * from t1 where txt='Chevy' or txt='Chevy '; |
1661 | -select * from t1 where txt='Chevy' or txt='Chevy ' or txt=' Chevy'; |
1662 | -select * from t1 where txt in ('Chevy ','Chevy'); |
1663 | -select * from t1 where txt in ('Chevy'); |
1664 | -select * from t1 where txt between 'Chevy' and 'Chevy'; |
1665 | -select * from t1 where txt between 'Chevy' and 'Chevy' or txt='Chevy '; |
1666 | -select * from t1 where txt between 'Chevy' and 'Chevy '; |
1667 | -select * from t1 where txt < 'Chevy '; |
1668 | -select * from t1 where txt < 'Chevy ' or txt is NULL; |
1669 | -select * from t1 where txt <= 'Chevy'; |
1670 | -select * from t1 where txt > 'Chevy'; |
1671 | -select * from t1 where txt >= 'Chevy'; |
1672 | -alter table t1 modify column txt blob; |
1673 | -explain select * from t1 where txt='Chevy' or txt is NULL; |
1674 | -select * from t1 where txt='Chevy' or txt is NULL; |
1675 | -explain select * from t1 where txt='Chevy' or txt is NULL order by txt; |
1676 | -select * from t1 where txt='Chevy' or txt is NULL order by txt; |
1677 | -drop table t1; |
1678 | - |
1679 | -CREATE TABLE t1 ( i int(11) NOT NULL default '0', c text NOT NULL, d varchar(1) NOT NULL DEFAULT ' ', PRIMARY KEY (i)); |
1680 | -INSERT t1 (i, c) VALUES (1,''),(2,''),(3,'asdfh'),(4,''); |
1681 | -select max(i) from t1 where c = ''; |
1682 | -drop table t1; |
1683 | - |
1684 | -# End of 4.1 tests |
1685 | - |
1686 | -# |
1687 | -# Test that blob's and varbinary are sorted according to length |
1688 | -# |
1689 | - |
1690 | -CREATE table t1 (a blob); |
1691 | -insert into t1 values ('b'),('a\0'),('a'),('a '),('aa'),(NULL); |
1692 | -select hex(a) from t1 order by a; |
1693 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1694 | -alter table t1 modify a varbinary(5); |
1695 | -select hex(a) from t1 order by a; |
1696 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1697 | -alter table t1 modify a char(5); |
1698 | -select hex(a) from t1 order by a; |
1699 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1700 | -alter table t1 modify a binary(5); |
1701 | -select hex(a) from t1 order by a; |
1702 | -select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0'); |
1703 | -drop table t1; |
1704 | - |
1705 | -# |
1706 | -# Bug #19489: Inconsistent support for DEFAULT in TEXT columns |
1707 | -# |
1708 | -create table t1 (a text default ''); |
1709 | -show create table t1; |
1710 | -insert into t1 values (default); |
1711 | -select * from t1; |
1712 | -drop table t1; |
1713 | -set @@sql_mode='TRADITIONAL'; |
1714 | ---error ER_BLOB_CANT_HAVE_DEFAULT |
1715 | -create table t1 (a text default ''); |
1716 | -set @@sql_mode=''; |
1717 | - |
1718 | -# |
1719 | -# Bug #32282: TEXT silently truncates when value is exactly 65536 bytes |
1720 | -# |
1721 | - |
1722 | -CREATE TABLE t (c TEXT CHARSET ASCII); |
1723 | -INSERT INTO t (c) VALUES (REPEAT('1',65537)); |
1724 | -INSERT INTO t (c) VALUES (REPEAT('2',65536)); |
1725 | -INSERT INTO t (c) VALUES (REPEAT('3',65535)); |
1726 | -SELECT LENGTH(c), CHAR_LENGTH(c) FROM t; |
1727 | -DROP TABLE t; |
1728 | -# Bug#15776: 32-bit signed int used for length of blob |
1729 | -# """LONGBLOB: A BLOB column with a maximum length of 4,294,967,295 or 4GB.""" |
1730 | -# |
1731 | -# Conditions should be in this order: |
1732 | -# A size is not in the allowed bounds. |
1733 | -# If the type is char-ish AND size is within the max blob size: |
1734 | -# raise ER_TOO_BIG_FIELDLENGTH (suggest using BLOB) |
1735 | -# If size is too small: |
1736 | -# raise ER_PARSE_ERROR |
1737 | -# raise ER_TOO_BIG_DISPLAYWIDTH |
1738 | - |
1739 | -# BLOB and TEXT types |
1740 | ---disable_warnings |
1741 | -drop table if exists b15776; |
1742 | ---enable_warnings |
1743 | -create table b15776 (data blob(2147483647)); |
1744 | -drop table b15776; |
1745 | ---error ER_PARSE_ERROR |
1746 | -create table b15776 (data blob(-1)); |
1747 | -create table b15776 (data blob(2147483648)); |
1748 | -drop table b15776; |
1749 | -create table b15776 (data blob(4294967294)); |
1750 | -drop table b15776; |
1751 | -create table b15776 (data blob(4294967295)); |
1752 | -drop table b15776; |
1753 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1754 | -create table b15776 (data blob(4294967296)); |
1755 | - |
1756 | -CREATE TABLE b15776 (a blob(2147483647), b blob(2147483648), c blob(4294967295), a1 text(2147483647), b1 text(2147483648), c1 text(4294967295) ); |
1757 | -show columns from b15776; |
1758 | -drop table b15776; |
1759 | - |
1760 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1761 | -CREATE TABLE b15776 (a blob(4294967296)); |
1762 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1763 | -CREATE TABLE b15776 (a text(4294967296)); |
1764 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1765 | -CREATE TABLE b15776 (a blob(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1766 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1767 | -CREATE TABLE b15776 (a text(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1768 | - |
1769 | -# Int types |
1770 | -# "Another extension is supported by MySQL for optionally specifying the |
1771 | -# display width of integer data types in parentheses following the base keyword |
1772 | -# for the type (for example, INT(4)). This optional display width is used to |
1773 | -# display integer values having a width less than the width specified for the |
1774 | -# column by left-padding them with spaces." § Numeric Types |
1775 | -CREATE TABLE b15776 (a int(0)); # 0 is special case, means default size |
1776 | -INSERT INTO b15776 values (NULL), (1), (42), (654); |
1777 | -SELECT * from b15776 ORDER BY a; |
1778 | -DROP TABLE b15776; |
1779 | ---error ER_PARSE_ERROR |
1780 | -CREATE TABLE b15776 (a int(-1)); |
1781 | -CREATE TABLE b15776 (a int(255)); |
1782 | -DROP TABLE b15776; |
1783 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1784 | -CREATE TABLE b15776 (a int(256)); |
1785 | ---error ER_PARSE_ERROR |
1786 | -CREATE TABLE b15776 (data blob(-1)); |
1787 | - |
1788 | -# Char types |
1789 | -# Recommend BLOB |
1790 | ---error ER_TOO_BIG_FIELDLENGTH |
1791 | -CREATE TABLE b15776 (a char(2147483647)); |
1792 | ---error ER_TOO_BIG_FIELDLENGTH |
1793 | -CREATE TABLE b15776 (a char(2147483648)); |
1794 | ---error ER_TOO_BIG_FIELDLENGTH |
1795 | -CREATE TABLE b15776 (a char(4294967295)); |
1796 | -# Even BLOB won't hold |
1797 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1798 | -CREATE TABLE b15776 (a char(4294967296)); |
1799 | - |
1800 | - |
1801 | -# Other numeric-ish types |
1802 | -## For year, widths not "2" or "4" are silently rewritten to "4". But |
1803 | -## When we complain about it, we say that the max is 255. We may be |
1804 | -## talking about different things. It's confusing. |
1805 | -CREATE TABLE b15776 (a year(4294967295)); |
1806 | -INSERT INTO b15776 VALUES (42); |
1807 | -SELECT * FROM b15776; |
1808 | -DROP TABLE b15776; |
1809 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1810 | -CREATE TABLE b15776 (a year(4294967296)); |
1811 | -CREATE TABLE b15776 (a year(0)); # 0 is special case, means default size |
1812 | -DROP TABLE b15776; |
1813 | ---error ER_PARSE_ERROR |
1814 | -CREATE TABLE b15776 (a year(-2)); |
1815 | - |
1816 | - |
1817 | -# We've already tested the case, but this should visually show that |
1818 | -# widths that are too large to be interpreted cause DISPLAYWIDTH errors. |
1819 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1820 | -CREATE TABLE b15776 (a int(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1821 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1822 | -CREATE TABLE b15776 (a char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1823 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1824 | -CREATE TABLE b15776 (a year(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1825 | - |
1826 | -## Do not select, too much memory needed. |
1827 | -CREATE TABLE b15776 select cast(null as char(4294967295)); |
1828 | -show columns from b15776; |
1829 | -drop table b15776; |
1830 | -CREATE TABLE b15776 select cast(null as nchar(4294967295)); |
1831 | -show columns from b15776; |
1832 | -drop table b15776; |
1833 | -CREATE TABLE b15776 select cast(null as binary(4294967295)); |
1834 | -show columns from b15776; |
1835 | -drop table b15776; |
1836 | - |
1837 | -explain select cast(1 as char(4294967295)); |
1838 | -explain select cast(1 as nchar(4294967295)); |
1839 | -explain select cast(1 as binary(4294967295)); |
1840 | - |
1841 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1842 | -explain select cast(1 as char(4294967296)); |
1843 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1844 | -explain select cast(1 as nchar(4294967296)); |
1845 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1846 | -explain select cast(1 as binary(4294967296)); |
1847 | - |
1848 | ---error ER_PARSE_ERROR |
1849 | -explain select cast(1 as decimal(-1)); |
1850 | -explain select cast(1 as decimal(64, 30)); |
1851 | -# It's not as important which errors are raised for these, since the |
1852 | -# limit is nowhere near 2**32. We may fix these eventually to take |
1853 | -# 4294967295 and still reject it because it's greater than 64 or 30, |
1854 | -# but that's not a high priority and the parser needn't worry about |
1855 | -# such a weird case. |
1856 | ---error ER_TOO_BIG_SCALE,ER_PARSE_ERROR |
1857 | -explain select cast(1 as decimal(64, 999999999999999999999999999999)); |
1858 | ---error ER_TOO_BIG_PRECISION,ER_PARSE_ERROR |
1859 | -explain select cast(1 as decimal(4294967296)); |
1860 | ---error ER_TOO_BIG_PRECISION,ER_PARSE_ERROR |
1861 | -explain select cast(1 as decimal(999999999999999999999999999999999999)); |
1862 | - |
1863 | -explain select convert(1, char(4294967295)); |
1864 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1865 | -explain select convert(1, char(4294967296)); |
1866 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1867 | -explain select convert(1, char(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1868 | -explain select convert(1, nchar(4294967295)); |
1869 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1870 | -explain select convert(1, nchar(4294967296)); |
1871 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1872 | -explain select convert(1, nchar(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1873 | -explain select convert(1, binary(4294967295)); |
1874 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1875 | -explain select convert(1, binary(4294967296)); |
1876 | ---error ER_TOO_BIG_DISPLAYWIDTH |
1877 | -explain select convert(1, binary(999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999)); |
1878 | - |
1879 | ---echo End of 5.0 tests |
1880 | - |
1881 | -# |
1882 | -# Bug #33969: Updating a text field via a left join |
1883 | -# |
1884 | - |
1885 | -CREATE TABLE t1(id INT NOT NULL); |
1886 | -CREATE TABLE t2(id INT NOT NULL, c TEXT NOT NULL); |
1887 | - |
1888 | -INSERT INTO t1 VALUES (1); |
1889 | -INSERT INTO t2 VALUES (1, ''); |
1890 | - |
1891 | -UPDATE t2 SET c = REPEAT('1', 70000); |
1892 | -SELECT LENGTH(c) FROM t2; |
1893 | - |
1894 | -UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1; |
1895 | -SELECT LENGTH(c) FROM t2; |
1896 | - |
1897 | -DROP TABLE t1, t2; |
1898 | - |
1899 | ---echo # Bug #52160: crash and inconsistent results when grouping |
1900 | ---echo # by a function and column |
1901 | - |
1902 | -CREATE FUNCTION f1() RETURNS TINYBLOB RETURN 1; |
1903 | - |
1904 | -CREATE TABLE t1(a CHAR(1)); |
1905 | -INSERT INTO t1 VALUES ('0'), ('0'); |
1906 | - |
1907 | -SELECT COUNT(*) FROM t1 GROUP BY f1(), a; |
1908 | - |
1909 | -DROP FUNCTION f1; |
1910 | -DROP TABLE t1; |
1911 | - |
1912 | - |
1913 | - |
1914 | -SET default_storage_engine=@old_default_storage_engine; |
1915 | - |
1916 | - |
1917 | -######################################################################## |
1918 | -# Modified test from myisam-blob.test |
1919 | -######################################################################## |
1920 | - |
1921 | -SET @old_max_heap_table_size = @@global.max_heap_table_size; |
1922 | -SET @old_max_allowed_packet = @@global.max_allowed_packet; |
1923 | -SET GLOBAL max_heap_table_size = 18 * 1024 * 1024; |
1924 | -SET GLOBAL max_allowed_packet = 24 * 1024 * 1024; |
1925 | - |
1926 | -connect(con1, localhost, root,,); |
1927 | -connection con1; |
1928 | - |
1929 | ---disable_warnings |
1930 | -drop table if exists t1; |
1931 | ---enable_warnings |
1932 | - |
1933 | -# Bug #2159 (Problem with update of blob to > 16M) |
1934 | - |
1935 | -CREATE TABLE t1 (data LONGBLOB) ENGINE=memory; |
1936 | -INSERT INTO t1 (data) VALUES (NULL); |
1937 | -UPDATE t1 set data=repeat('a',18*1024*1024); |
1938 | -select length(data) from t1; |
1939 | -delete from t1 where left(data,1)='a'; |
1940 | -truncate table t1; |
1941 | -INSERT INTO t1 (data) VALUES (repeat('a',1*1024*1024)); |
1942 | -INSERT INTO t1 (data) VALUES (repeat('b',16*1024*1024-1024)); |
1943 | -delete from t1 where left(data,1)='b'; |
1944 | - |
1945 | -# now we have two blocks in the table, first is a 1M record and second is |
1946 | -# a 16M delete block. |
1947 | - |
1948 | -UPDATE t1 set data=repeat('c',17*1024*1024); |
1949 | -delete from t1 where left(data,1)='c'; |
1950 | - |
1951 | -INSERT INTO t1 set data=repeat('a',18*1024*1024); |
1952 | -select length(data) from t1; |
1953 | -alter table t1 modify data blob; |
1954 | -select length(data) from t1; |
1955 | -drop table t1; |
1956 | - |
1957 | -CREATE TABLE t1 (data BLOB) ENGINE=myisam; |
1958 | -INSERT INTO t1 (data) VALUES (NULL); |
1959 | -UPDATE t1 set data=repeat('a',18*1024*1024); |
1960 | -select length(data) from t1; |
1961 | -drop table t1; |
1962 | - |
1963 | -disconnect con1; |
1964 | -connection default; |
1965 | - |
1966 | -SET GLOBAL max_allowed_packet = @old_max_allowed_packet; |
1967 | -SET GLOBAL max_heap_table_size = @old_max_heap_table_size; |
1968 | |
1969 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result' |
1970 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result 2011-06-06 10:34:16 +0000 |
1971 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result 1970-01-01 00:00:00 +0000 |
1972 | @@ -1,14 +0,0 @@ |
1973 | -drop table if exists t1; |
1974 | -CREATE TABLE t1 ( |
1975 | -f1 VARCHAR ( 128 ) , |
1976 | -f2 VARCHAR ( 32 ), |
1977 | -PRIMARY KEY ( f2 ( 2 ) , f1 ) |
1978 | -) |
1979 | -ENGINE=HEAP KEY_BLOCK_SIZE = 512; |
1980 | -INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' ); |
1981 | -Warnings: |
1982 | -Warning 1048 Column 'f1' cannot be null |
1983 | -INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' ); |
1984 | -Warnings: |
1985 | -Warning 1048 Column 'f1' cannot be null |
1986 | -DROP TABLE t1; |
1987 | |
1988 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test' |
1989 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test 2011-08-22 11:28:27 +0000 |
1990 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test 1970-01-01 00:00:00 +0000 |
1991 | @@ -1,19 +0,0 @@ |
1992 | -# |
1993 | -# Test for bug lp:783366 |
1994 | -# |
1995 | - |
1996 | ---disable_warnings |
1997 | -drop table if exists t1; |
1998 | ---enable_warnings |
1999 | - |
2000 | -CREATE TABLE t1 ( |
2001 | - f1 VARCHAR ( 128 ) , |
2002 | - f2 VARCHAR ( 32 ), |
2003 | - PRIMARY KEY ( f2 ( 2 ) , f1 ) |
2004 | -) |
2005 | -ENGINE=HEAP KEY_BLOCK_SIZE = 512; |
2006 | -INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' ); |
2007 | -INSERT IGNORE INTO t1 VALUES ( 'te' , 'm') , ( NULL , 'think' ); |
2008 | - |
2009 | -DROP TABLE t1; |
2010 | - |
2011 | |
2012 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result' |
2013 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result 2011-06-06 10:34:16 +0000 |
2014 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result 1970-01-01 00:00:00 +0000 |
2015 | @@ -1,132 +0,0 @@ |
2016 | -DROP TABLE IF EXISTS local_1_1; |
2017 | -CREATE TABLE IF NOT EXISTS local_1_1 ( f1 VARCHAR ( 32 ) NOT NULL , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'cboepfaobilcchabvglgjdbynog' , f3 VARCHAR ( 32 ) NOT NULL , f4 VARBINARY ( 32 ) NOT NULL , f5 VARBINARY ( 1024 ) DEFAULT 'ycboepfao' , KEY ( f1 /* ( 2 ) */ , f2 /* ( 2 ) */ ) ) ENGINE=HEAP KEY_BLOCK_SIZE = 512; |
2018 | -INSERT IGNORE INTO local_1_1 VALUES ( REPEAT( 'ervydbimvmbqmsowdbsa' , 1 ) , 'v' , NULL , NULL , REPEAT( 'mervydbimvmbqms' , 5 ) ) , ( 'p' , 6 , 'n' , REPEAT( 'imervydbimvmbqmsowdbs' , 4 ) , 'do' ) , ( NULL , NULL , REPEAT( 'himervydbimvmbqmsowdbsaybudvwaamvhempuublmia' , 6 ) , REPEAT('X', POW(2, 20) * 2) , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , REPEAT( 'Y' , 763 ) , NULL , REPEAT('X', POW(2, 20) * 2) , NULL ) , ( REPEAT('X', POW(2, 20) * 2) , 'time' , 'how' , 2 , REPEAT( 'Y' , 107 ) ) , ( REPEAT( 'hyshimervydbimvmbqmsowdbsaybud' , 5 ) , 2 , 8 , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( 'come' , NULL , 'i' , NULL , REPEAT('X', POW(2, 20) * 2) ); |
2019 | -Warnings: |
2020 | -Warning 1048 Column 'f3' cannot be null |
2021 | -Warning 1048 Column 'f4' cannot be null |
2022 | -Warning 1265 Data truncated for column 'f4' at row 2 |
2023 | -Warning 1048 Column 'f1' cannot be null |
2024 | -Warning 1048 Column 'f2' cannot be null |
2025 | -Warning 1265 Data truncated for column 'f3' at row 3 |
2026 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2027 | -Warning 1048 Column 'f4' cannot be null |
2028 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2029 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2030 | -Warning 1048 Column 'f1' cannot be null |
2031 | -Warning 1265 Data truncated for column 'f2' at row 4 |
2032 | -Warning 1048 Column 'f3' cannot be null |
2033 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2034 | -Warning 1048 Column 'f4' cannot be null |
2035 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2036 | -Warning 1048 Column 'f1' cannot be null |
2037 | -Warning 1265 Data truncated for column 'f1' at row 6 |
2038 | -Warning 1048 Column 'f4' cannot be null |
2039 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2040 | -Warning 1048 Column 'f2' cannot be null |
2041 | -Warning 1048 Column 'f4' cannot be null |
2042 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2043 | -INSERT IGNORE INTO local_1_1 VALUES ( 'ok' , NULL , REPEAT( 'Y' , 651 ) , 2 , 5 ) , ( REPEAT( 'zylcdzkfrqpihyshimervydbimvmbqmsowdbsaybu' , 3 ) , REPEAT( 'Y' , 282 ) , REPEAT( 'X' , 0 ) , REPEAT( 'Y' , 369 ) , 'g' ) , ( 'think' , REPEAT('X', POW(2, 20) * 2), NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT( 'Y' , 468 ) , REPEAT( 'dfvbrzylcd' , 6 ) , REPEAT( 'Y' , 264 ) , NULL , 'c' ) , ( NULL , NULL , REPEAT( 'srdfvbrzylcdzkfrqpihyshimervydbimvmbqms' , 0 ) , REPEAT( 'Y' , 244 ) , 7 ) , ( REPEAT( 'Y' , 0 ) , 'how' , 'going' , 'q' , NULL ); |
2044 | -Warnings: |
2045 | -Warning 1048 Column 'f2' cannot be null |
2046 | -Warning 1265 Data truncated for column 'f3' at row 1 |
2047 | -Warning 1265 Data truncated for column 'f1' at row 2 |
2048 | -Warning 1265 Data truncated for column 'f2' at row 2 |
2049 | -Warning 1265 Data truncated for column 'f4' at row 2 |
2050 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2051 | -Warning 1048 Column 'f2' cannot be null |
2052 | -Warning 1048 Column 'f3' cannot be null |
2053 | -Warning 1048 Column 'f4' cannot be null |
2054 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2055 | -Warning 1265 Data truncated for column 'f1' at row 4 |
2056 | -Warning 1265 Data truncated for column 'f3' at row 4 |
2057 | -Warning 1048 Column 'f4' cannot be null |
2058 | -Warning 1048 Column 'f1' cannot be null |
2059 | -Warning 1048 Column 'f2' cannot be null |
2060 | -Warning 1265 Data truncated for column 'f4' at row 5 |
2061 | -INSERT IGNORE INTO local_1_1 VALUES ( REPEAT('X', POW(2, 20) * 2) , NULL , NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , NULL , REPEAT('X', POW(2, 20) * 2) , 'this' , 'e' ) , ( NULL , 'think' , NULL , 'were' , NULL ) , ( 9 , 'l' , 'c' , 3 , REPEAT( 'geysrdfvbrzylcdzkfrqpihyshimervydbi' , 5 ) ) , ( NULL , NULL , NULL , 'h' , 'w' ); |
2062 | -Warnings: |
2063 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2064 | -Warning 1048 Column 'f1' cannot be null |
2065 | -Warning 1048 Column 'f2' cannot be null |
2066 | -Warning 1048 Column 'f3' cannot be null |
2067 | -Warning 1048 Column 'f4' cannot be null |
2068 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2069 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2070 | -Warning 1048 Column 'f1' cannot be null |
2071 | -Warning 1048 Column 'f2' cannot be null |
2072 | -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated |
2073 | -Warning 1048 Column 'f3' cannot be null |
2074 | -Warning 1048 Column 'f1' cannot be null |
2075 | -Warning 1048 Column 'f3' cannot be null |
2076 | -Warning 1048 Column 'f1' cannot be null |
2077 | -Warning 1048 Column 'f2' cannot be null |
2078 | -Warning 1048 Column 'f3' cannot be null |
2079 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2080 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2081 | -UPDATE local_1_1 SET f5 = REPEAT ('X', 215566); |
2082 | -Warnings: |
2083 | -Warning 1265 Data truncated for column 'f5' at row 1 |
2084 | -Warning 1265 Data truncated for column 'f5' at row 2 |
2085 | -Warning 1265 Data truncated for column 'f5' at row 3 |
2086 | -Warning 1265 Data truncated for column 'f5' at row 4 |
2087 | -Warning 1265 Data truncated for column 'f5' at row 5 |
2088 | -Warning 1265 Data truncated for column 'f5' at row 6 |
2089 | -Warning 1265 Data truncated for column 'f5' at row 7 |
2090 | -Warning 1265 Data truncated for column 'f5' at row 8 |
2091 | -Warning 1265 Data truncated for column 'f5' at row 9 |
2092 | -Warning 1265 Data truncated for column 'f5' at row 10 |
2093 | -Warning 1265 Data truncated for column 'f5' at row 11 |
2094 | -Warning 1265 Data truncated for column 'f5' at row 12 |
2095 | -Warning 1265 Data truncated for column 'f5' at row 13 |
2096 | -Warning 1265 Data truncated for column 'f5' at row 14 |
2097 | -Warning 1265 Data truncated for column 'f5' at row 15 |
2098 | -Warning 1265 Data truncated for column 'f5' at row 16 |
2099 | -Warning 1265 Data truncated for column 'f5' at row 17 |
2100 | -Warning 1265 Data truncated for column 'f5' at row 18 |
2101 | -Warning 1265 Data truncated for column 'f5' at row 19 |
2102 | -Warning 1265 Data truncated for column 'f5' at row 20 |
2103 | -Warning 1265 Data truncated for column 'f5' at row 21 |
2104 | -Warning 1265 Data truncated for column 'f5' at row 22 |
2105 | -Warning 1265 Data truncated for column 'f5' at row 23 |
2106 | -Warning 1265 Data truncated for column 'f5' at row 24 |
2107 | -Warning 1265 Data truncated for column 'f5' at row 25 |
2108 | -Warning 1265 Data truncated for column 'f5' at row 26 |
2109 | -Warning 1265 Data truncated for column 'f5' at row 27 |
2110 | -Warning 1265 Data truncated for column 'f5' at row 28 |
2111 | -Warning 1265 Data truncated for column 'f5' at row 29 |
2112 | -Warning 1265 Data truncated for column 'f5' at row 30 |
2113 | -Warning 1265 Data truncated for column 'f5' at row 31 |
2114 | -Warning 1265 Data truncated for column 'f5' at row 32 |
2115 | -Warning 1265 Data truncated for column 'f5' at row 33 |
2116 | -Warning 1265 Data truncated for column 'f5' at row 34 |
2117 | -Warning 1265 Data truncated for column 'f5' at row 35 |
2118 | -Warning 1265 Data truncated for column 'f5' at row 36 |
2119 | -Warning 1265 Data truncated for column 'f5' at row 37 |
2120 | -Warning 1265 Data truncated for column 'f5' at row 38 |
2121 | -Warning 1265 Data truncated for column 'f5' at row 39 |
2122 | -Warning 1265 Data truncated for column 'f5' at row 40 |
2123 | -Warning 1265 Data truncated for column 'f5' at row 41 |
2124 | -Warning 1265 Data truncated for column 'f5' at row 42 |
2125 | -Warning 1265 Data truncated for column 'f5' at row 43 |
2126 | -Warning 1265 Data truncated for column 'f5' at row 44 |
2127 | -Warning 1265 Data truncated for column 'f5' at row 45 |
2128 | -Warning 1265 Data truncated for column 'f5' at row 46 |
2129 | -Warning 1265 Data truncated for column 'f5' at row 47 |
2130 | -Warning 1265 Data truncated for column 'f5' at row 48 |
2131 | -Warning 1265 Data truncated for column 'f5' at row 49 |
2132 | -Warning 1265 Data truncated for column 'f5' at row 50 |
2133 | -Warning 1265 Data truncated for column 'f5' at row 51 |
2134 | -Warning 1265 Data truncated for column 'f5' at row 52 |
2135 | -Warning 1265 Data truncated for column 'f5' at row 53 |
2136 | -Warning 1265 Data truncated for column 'f5' at row 54 |
2137 | -Warning 1265 Data truncated for column 'f5' at row 55 |
2138 | -Warning 1265 Data truncated for column 'f5' at row 56 |
2139 | -Warning 1265 Data truncated for column 'f5' at row 57 |
2140 | -Warning 1265 Data truncated for column 'f5' at row 58 |
2141 | -Warning 1265 Data truncated for column 'f5' at row 59 |
2142 | -Warning 1265 Data truncated for column 'f5' at row 60 |
2143 | -Warning 1265 Data truncated for column 'f5' at row 61 |
2144 | -Warning 1265 Data truncated for column 'f5' at row 62 |
2145 | -Warning 1265 Data truncated for column 'f5' at row 63 |
2146 | -Warning 1265 Data truncated for column 'f5' at row 64 |
2147 | -DROP TABLE local_1_1; |
2148 | |
2149 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test' |
2150 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test 2011-08-22 11:28:27 +0000 |
2151 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test 1970-01-01 00:00:00 +0000 |
2152 | @@ -1,16 +0,0 @@ |
2153 | -# Testcase for the bug https://bugs.launchpad.net/percona-projects-qa/+bug/783451 |
2154 | -# With dynamic row format in HEAP and the UPDATE statement that significantly |
2155 | -# increases the data size, the table scan in-progress desyncs its table position state. |
2156 | -# Run with Valgrind if it does not crash for you. |
2157 | ---disable_warnings |
2158 | -DROP TABLE IF EXISTS local_1_1; |
2159 | ---enable_warnings |
2160 | -CREATE TABLE IF NOT EXISTS local_1_1 ( f1 VARCHAR ( 32 ) NOT NULL , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'cboepfaobilcchabvglgjdbynog' , f3 VARCHAR ( 32 ) NOT NULL , f4 VARBINARY ( 32 ) NOT NULL , f5 VARBINARY ( 1024 ) DEFAULT 'ycboepfao' , KEY ( f1 /* ( 2 ) */ , f2 /* ( 2 ) */ ) ) ENGINE=HEAP KEY_BLOCK_SIZE = 512; |
2161 | -INSERT IGNORE INTO local_1_1 VALUES ( REPEAT( 'ervydbimvmbqmsowdbsa' , 1 ) , 'v' , NULL , NULL , REPEAT( 'mervydbimvmbqms' , 5 ) ) , ( 'p' , 6 , 'n' , REPEAT( 'imervydbimvmbqmsowdbs' , 4 ) , 'do' ) , ( NULL , NULL , REPEAT( 'himervydbimvmbqmsowdbsaybudvwaamvhempuublmia' , 6 ) , REPEAT('X', POW(2, 20) * 2) , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , REPEAT( 'Y' , 763 ) , NULL , REPEAT('X', POW(2, 20) * 2) , NULL ) , ( REPEAT('X', POW(2, 20) * 2) , 'time' , 'how' , 2 , REPEAT( 'Y' , 107 ) ) , ( REPEAT( 'hyshimervydbimvmbqmsowdbsaybud' , 5 ) , 2 , 8 , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( 'come' , NULL , 'i' , NULL , REPEAT('X', POW(2, 20) * 2) ); |
2162 | -INSERT IGNORE INTO local_1_1 VALUES ( 'ok' , NULL , REPEAT( 'Y' , 651 ) , 2 , 5 ) , ( REPEAT( 'zylcdzkfrqpihyshimervydbimvmbqmsowdbsaybu' , 3 ) , REPEAT( 'Y' , 282 ) , REPEAT( 'X' , 0 ) , REPEAT( 'Y' , 369 ) , 'g' ) , ( 'think' , REPEAT('X', POW(2, 20) * 2), NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT( 'Y' , 468 ) , REPEAT( 'dfvbrzylcd' , 6 ) , REPEAT( 'Y' , 264 ) , NULL , 'c' ) , ( NULL , NULL , REPEAT( 'srdfvbrzylcdzkfrqpihyshimervydbimvmbqms' , 0 ) , REPEAT( 'Y' , 244 ) , 7 ) , ( REPEAT( 'Y' , 0 ) , 'how' , 'going' , 'q' , NULL ); |
2163 | -INSERT IGNORE INTO local_1_1 VALUES ( REPEAT('X', POW(2, 20) * 2) , NULL , NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , NULL , REPEAT('X', POW(2, 20) * 2) , 'this' , 'e' ) , ( NULL , 'think' , NULL , 'were' , NULL ) , ( 9 , 'l' , 'c' , 3 , REPEAT( 'geysrdfvbrzylcdzkfrqpihyshimervydbi' , 5 ) ) , ( NULL , NULL , NULL , 'h' , 'w' ); |
2164 | ---enable_warnings |
2165 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2166 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2167 | -UPDATE local_1_1 SET f5 = REPEAT ('X', 215566); |
2168 | -DROP TABLE local_1_1; |
2169 | |
2170 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result' |
2171 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result 2011-08-22 11:28:27 +0000 |
2172 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result 1970-01-01 00:00:00 +0000 |
2173 | @@ -1,58 +0,0 @@ |
2174 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2175 | -PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2176 | -SHOW TABLE STATUS LIKE 't1'; |
2177 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2178 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC |
2179 | -DROP TABLE t1; |
2180 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2181 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2182 | -ERROR 42000: Incorrect usage/placement of 'key_block_size' |
2183 | -SHOW TABLE STATUS LIKE 't1'; |
2184 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2185 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2186 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2187 | -SHOW TABLE STATUS LIKE 't1'; |
2188 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2189 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=34 |
2190 | -DROP TABLE t1; |
2191 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2192 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=123 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2193 | -SHOW TABLE STATUS LIKE 't1'; |
2194 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2195 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=123 |
2196 | -DROP TABLE t1; |
2197 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2198 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2199 | -SHOW TABLE STATUS LIKE 't1'; |
2200 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2201 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=1000 |
2202 | -DROP TABLE t1; |
2203 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2204 | -PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2205 | -SHOW TABLE STATUS LIKE 't1'; |
2206 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2207 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC |
2208 | -DROP TABLE t1; |
2209 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2210 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2211 | -ERROR 42000: Incorrect usage/placement of 'key_block_size' |
2212 | -SHOW TABLE STATUS LIKE 't1'; |
2213 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2214 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2215 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2216 | -SHOW TABLE STATUS LIKE 't1'; |
2217 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2218 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=34 |
2219 | -DROP TABLE t1; |
2220 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2221 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=121 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2222 | -SHOW TABLE STATUS LIKE 't1'; |
2223 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2224 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=121 |
2225 | -DROP TABLE t1; |
2226 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2227 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2228 | -SHOW TABLE STATUS LIKE 't1'; |
2229 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2230 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=1000 |
2231 | -DROP TABLE t1; |
2232 | |
2233 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test' |
2234 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test 2011-08-22 11:28:27 +0000 |
2235 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test 1970-01-01 00:00:00 +0000 |
2236 | @@ -1,64 +0,0 @@ |
2237 | -# |
2238 | -# Bug #784464: Silent conversion from Dynamic to Fixed row_format for certain |
2239 | -# values of key_block_size. |
2240 | -# Also see percona_heap_bug784464_32bit and percona_heap_bug784464_64bit tests. |
2241 | -# |
2242 | - |
2243 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2244 | - PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2245 | ---replace_column 6 X 8 X |
2246 | -SHOW TABLE STATUS LIKE 't1'; |
2247 | -DROP TABLE t1; |
2248 | - |
2249 | ---error ER_CANT_USE_OPTION_HERE |
2250 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2251 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2252 | -SHOW TABLE STATUS LIKE 't1'; |
2253 | - |
2254 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2255 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2256 | ---replace_column 6 X 8 X |
2257 | -SHOW TABLE STATUS LIKE 't1'; |
2258 | -DROP TABLE t1; |
2259 | - |
2260 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2261 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=123 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2262 | ---replace_column 6 X 8 X |
2263 | -SHOW TABLE STATUS LIKE 't1'; |
2264 | -DROP TABLE t1; |
2265 | - |
2266 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2267 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2268 | ---replace_column 6 X 8 X |
2269 | -SHOW TABLE STATUS LIKE 't1'; |
2270 | -DROP TABLE t1; |
2271 | - |
2272 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2273 | - PRIMARY KEY (f1)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2274 | ---replace_column 6 X 8 X |
2275 | -SHOW TABLE STATUS LIKE 't1'; |
2276 | -DROP TABLE t1; |
2277 | - |
2278 | ---error ER_CANT_USE_OPTION_HERE |
2279 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2280 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=33 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2281 | -SHOW TABLE STATUS LIKE 't1'; |
2282 | - |
2283 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2284 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=34 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2285 | ---replace_column 6 X 8 X |
2286 | -SHOW TABLE STATUS LIKE 't1'; |
2287 | -DROP TABLE t1; |
2288 | - |
2289 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2290 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=121 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2291 | ---replace_column 6 X 8 X |
2292 | -SHOW TABLE STATUS LIKE 't1'; |
2293 | -DROP TABLE t1; |
2294 | - |
2295 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2296 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=1000 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2297 | ---replace_column 6 X 8 X |
2298 | -SHOW TABLE STATUS LIKE 't1'; |
2299 | -DROP TABLE t1; |
2300 | - |
2301 | |
2302 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result' |
2303 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result 2011-08-22 11:28:27 +0000 |
2304 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.result 1970-01-01 00:00:00 +0000 |
2305 | @@ -1,12 +0,0 @@ |
2306 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2307 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2308 | -SHOW TABLE STATUS LIKE 't1'; |
2309 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2310 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=124 |
2311 | -DROP TABLE t1; |
2312 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2313 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2314 | -SHOW TABLE STATUS LIKE 't1'; |
2315 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2316 | -t1 MEMORY 10 Dynamic 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=122 |
2317 | -DROP TABLE t1; |
2318 | |
2319 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test' |
2320 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test 2011-08-22 11:28:27 +0000 |
2321 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_32bit.test 1970-01-01 00:00:00 +0000 |
2322 | @@ -1,15 +0,0 @@ |
2323 | -# 32-bit platform specific parts of tests for LP bug #784464 |
2324 | - |
2325 | ---source include/have_32bit.inc |
2326 | - |
2327 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2328 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2329 | ---replace_column 6 X 8 X |
2330 | -SHOW TABLE STATUS LIKE 't1'; |
2331 | -DROP TABLE t1; |
2332 | - |
2333 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2334 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2335 | ---replace_column 6 X 8 X |
2336 | -SHOW TABLE STATUS LIKE 't1'; |
2337 | -DROP TABLE t1; |
2338 | |
2339 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result' |
2340 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result 2011-08-22 11:28:27 +0000 |
2341 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.result 1970-01-01 00:00:00 +0000 |
2342 | @@ -1,12 +0,0 @@ |
2343 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2344 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2345 | -SHOW TABLE STATUS LIKE 't1'; |
2346 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2347 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=124 |
2348 | -DROP TABLE t1; |
2349 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2350 | -PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2351 | -SHOW TABLE STATUS LIKE 't1'; |
2352 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2353 | -t1 MEMORY 10 Fixed 0 X 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC KEY_BLOCK_SIZE=122 |
2354 | -DROP TABLE t1; |
2355 | |
2356 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test' |
2357 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test 2011-08-22 11:28:27 +0000 |
2358 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464_64bit.test 1970-01-01 00:00:00 +0000 |
2359 | @@ -1,15 +0,0 @@ |
2360 | -# 64-bit platform specific parts of tests for LP bug #784464 |
2361 | - |
2362 | ---source include/have_64bit.inc |
2363 | - |
2364 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(32), f3 VARCHAR(32), f4 VARCHAR(32), |
2365 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=124 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2366 | ---replace_column 6 X 8 X |
2367 | -SHOW TABLE STATUS LIKE 't1'; |
2368 | -DROP TABLE t1; |
2369 | - |
2370 | -CREATE TABLE t1 (f1 VARCHAR(32), f2 VARCHAR(96), |
2371 | - PRIMARY KEY (f1)) KEY_BLOCK_SIZE=122 ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2372 | ---replace_column 6 X 8 X |
2373 | -SHOW TABLE STATUS LIKE 't1'; |
2374 | -DROP TABLE t1; |
2375 | |
2376 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result' |
2377 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result 2011-08-22 11:28:27 +0000 |
2378 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result 1970-01-01 00:00:00 +0000 |
2379 | @@ -1,15 +0,0 @@ |
2380 | -CREATE TABLE t1 ( f1 VARCHAR(30)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2381 | -SHOW TABLE STATUS LIKE 't1'; |
2382 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2383 | -t1 MEMORY 10 Fixed 0 32 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC |
2384 | -DROP TABLE t1; |
2385 | -CREATE TABLE t1 ( f1 VARCHAR(31)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2386 | -SHOW TABLE STATUS LIKE 't1'; |
2387 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2388 | -t1 MEMORY 10 Fixed 0 33 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC |
2389 | -DROP TABLE t1; |
2390 | -CREATE TABLE t1 ( f1 VARCHAR(32)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2391 | -SHOW TABLE STATUS LIKE 't1'; |
2392 | -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment |
2393 | -t1 MEMORY 10 Fixed 0 34 0 X 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC |
2394 | -DROP TABLE t1; |
2395 | |
2396 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test' |
2397 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test 2011-08-22 11:28:27 +0000 |
2398 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test 1970-01-01 00:00:00 +0000 |
2399 | @@ -1,19 +0,0 @@ |
2400 | -# |
2401 | -# Bug #784468: Tables with VARCHAR(<31) are created as row_format = Fixed |
2402 | -# |
2403 | - |
2404 | -CREATE TABLE t1 ( f1 VARCHAR(30)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2405 | ---replace_column 8 X |
2406 | -SHOW TABLE STATUS LIKE 't1'; |
2407 | -DROP TABLE t1; |
2408 | - |
2409 | -CREATE TABLE t1 ( f1 VARCHAR(31)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2410 | ---replace_column 8 X |
2411 | -SHOW TABLE STATUS LIKE 't1'; |
2412 | -DROP TABLE t1; |
2413 | - |
2414 | -CREATE TABLE t1 ( f1 VARCHAR(32)) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2415 | ---replace_column 8 X |
2416 | -SHOW TABLE STATUS LIKE 't1'; |
2417 | -DROP TABLE t1; |
2418 | - |
2419 | |
2420 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result' |
2421 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result 2011-06-06 10:34:16 +0000 |
2422 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result 1970-01-01 00:00:00 +0000 |
2423 | @@ -1,9 +0,0 @@ |
2424 | -CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP; |
2425 | -INSERT INTO t1 VALUES ('a', NULL, NULL), |
2426 | -('b' , REPEAT('a' , 593338), REPEAT('a', 800)); |
2427 | -UPDATE t1 SET f2 = 'c' WHERE f4 = 'd'; |
2428 | -SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1; |
2429 | -LENGTH(f2) LENGTH(f4) LENGTH(f5) |
2430 | -1 NULL NULL |
2431 | -1 593338 800 |
2432 | -DROP TABLE t1; |
2433 | |
2434 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test' |
2435 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test 2011-08-22 11:28:27 +0000 |
2436 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test 1970-01-01 00:00:00 +0000 |
2437 | @@ -1,15 +0,0 @@ |
2438 | -# |
2439 | -# Bug #788544: Valgrind warnings/crash in mysql-55-eb-blobs in |
2440 | -# hp_extract_record / hp_process_field_data_to_chunkset |
2441 | -# |
2442 | - |
2443 | -CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP; |
2444 | - |
2445 | -INSERT INTO t1 VALUES ('a', NULL, NULL), |
2446 | - ('b' , REPEAT('a' , 593338), REPEAT('a', 800)); |
2447 | - |
2448 | -UPDATE t1 SET f2 = 'c' WHERE f4 = 'd'; |
2449 | - |
2450 | -SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1; |
2451 | - |
2452 | -DROP TABLE t1; |
2453 | |
2454 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result' |
2455 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result 2011-06-06 10:34:16 +0000 |
2456 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result 1970-01-01 00:00:00 +0000 |
2457 | @@ -1,19 +0,0 @@ |
2458 | -CREATE TABLE t1 (f1 VARCHAR (32), f2 VARCHAR (128), f3 VARBINARY (128), |
2459 | -f4 VARBINARY (512), f5 VARBINARY (1024), |
2460 | -KEY (f2(1))) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2461 | -INSERT IGNORE INTO t1 VALUES (2, NULL, 6, REPEAT('glugcgqk', 5), 'look'), |
2462 | -(REPEAT( 'kglugcgqkin', 6), 'if', 'was', NULL, NULL), |
2463 | -(NULL, NULL, NULL, NULL, 7); |
2464 | -Warnings: |
2465 | -Warning 1265 Data truncated for column 'f1' at row 2 |
2466 | -SELECT * FROM t1; |
2467 | -f1 f2 f3 f4 f5 |
2468 | -2 NULL 6 glugcgqkglugcgqkglugcgqkglugcgqkglugcgqk look |
2469 | -kglugcgqkinkglugcgqkinkglugcgqki if was NULL NULL |
2470 | -NULL NULL NULL NULL 7 |
2471 | -DELETE FROM t1 WHERE f5 <=> NULL; |
2472 | -SELECT * FROM t1; |
2473 | -f1 f2 f3 f4 f5 |
2474 | -2 NULL 6 glugcgqkglugcgqkglugcgqkglugcgqkglugcgqk look |
2475 | -NULL NULL NULL NULL 7 |
2476 | -DROP TABLE t1; |
2477 | |
2478 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test' |
2479 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test 2011-08-22 11:28:27 +0000 |
2480 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test 1970-01-01 00:00:00 +0000 |
2481 | @@ -1,19 +0,0 @@ |
2482 | -# |
2483 | -# Bug #788576: Second crash in hp_movelink with mysql-55-eb |
2484 | -# |
2485 | - |
2486 | -CREATE TABLE t1 (f1 VARCHAR (32), f2 VARCHAR (128), f3 VARBINARY (128), |
2487 | - f4 VARBINARY (512), f5 VARBINARY (1024), |
2488 | - KEY (f2(1))) ENGINE=HEAP ROW_FORMAT=DYNAMIC; |
2489 | - |
2490 | -INSERT IGNORE INTO t1 VALUES (2, NULL, 6, REPEAT('glugcgqk', 5), 'look'), |
2491 | - (REPEAT( 'kglugcgqkin', 6), 'if', 'was', NULL, NULL), |
2492 | - (NULL, NULL, NULL, NULL, 7); |
2493 | - |
2494 | -SELECT * FROM t1; |
2495 | - |
2496 | -DELETE FROM t1 WHERE f5 <=> NULL; |
2497 | - |
2498 | -SELECT * FROM t1; |
2499 | - |
2500 | -DROP TABLE t1; |
2501 | |
2502 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result' |
2503 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result 2011-06-06 10:34:16 +0000 |
2504 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result 1970-01-01 00:00:00 +0000 |
2505 | @@ -1,18 +0,0 @@ |
2506 | -CREATE TABLE IF NOT EXISTS local_1_1 (f1 VARCHAR (32) NOT NULL, |
2507 | -f2 VARCHAR (128) NOT NULL, |
2508 | -f3 BLOB NOT NULL, |
2509 | -f4 TEXT, |
2510 | -f5 BLOB (1024), |
2511 | -PRIMARY KEY (f1), |
2512 | -KEY (f1 , f2) |
2513 | -) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE = 2048; |
2514 | -INSERT IGNORE INTO local_1_1 VALUES |
2515 | -(REPEAT('egqeqfxwaejpqixuvvtentruyqadxiybjdfqjspfbyjdjczrrwjnagkzsoagatqookhsgtrvvbxacppljfzaseidqggxvuirm' , 5), NULL, NULL, NULL, REPEAT('hegqeqfxwaejpqixuvvtentruyqadxiy', 1)), |
2516 | -('you', NULL, 0, REPEAT("X", 2048) , 0); |
2517 | -Warnings: |
2518 | -Warning 1265 Data truncated for column 'f1' at row 1 |
2519 | -Warning 1048 Column 'f2' cannot be null |
2520 | -Warning 1048 Column 'f3' cannot be null |
2521 | -Warning 1048 Column 'f2' cannot be null |
2522 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2523 | -DROP TABLE local_1_1; |
2524 | |
2525 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test' |
2526 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test 2011-08-22 11:28:27 +0000 |
2527 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test 1970-01-01 00:00:00 +0000 |
2528 | @@ -1,20 +0,0 @@ |
2529 | -# |
2530 | -# Bug #788722: Second valgrind warning around hp_extract_record in mysql-55-eb-blobs |
2531 | -# |
2532 | - |
2533 | -CREATE TABLE IF NOT EXISTS local_1_1 (f1 VARCHAR (32) NOT NULL, |
2534 | - f2 VARCHAR (128) NOT NULL, |
2535 | - f3 BLOB NOT NULL, |
2536 | - f4 TEXT, |
2537 | - f5 BLOB (1024), |
2538 | - PRIMARY KEY (f1), |
2539 | - KEY (f1 , f2) |
2540 | -) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE = 2048; |
2541 | - |
2542 | -INSERT IGNORE INTO local_1_1 VALUES |
2543 | - (REPEAT('egqeqfxwaejpqixuvvtentruyqadxiybjdfqjspfbyjdjczrrwjnagkzsoagatqookhsgtrvvbxacppljfzaseidqggxvuirm' , 5), NULL, NULL, NULL, REPEAT('hegqeqfxwaejpqixuvvtentruyqadxiy', 1)), |
2544 | - ('you', NULL, 0, REPEAT("X", 2048) , 0); |
2545 | - |
2546 | -INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1; |
2547 | - |
2548 | -DROP TABLE local_1_1; |
2549 | |
2550 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result' |
2551 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result 2011-06-06 10:34:16 +0000 |
2552 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result 1970-01-01 00:00:00 +0000 |
2553 | @@ -1,7 +0,0 @@ |
2554 | -CREATE TABLE t1 (f1 VARCHAR (128), f2 VARCHAR (128), f3 VARBINARY (512), |
2555 | -f4 TEXT (65525), f5 VARCHAR (128), KEY (f1(1))) ENGINE=HEAP; |
2556 | -INSERT IGNORE INTO t1 VALUES |
2557 | -( 'o' , "" , NULL , "" , 0 ) , |
2558 | -(NULL, "" , "" , "" , 'f' ) ; |
2559 | -INSERT IGNORE INTO t1 SELECT * FROM t1; |
2560 | -DROP TABLE t1; |
2561 | |
2562 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test' |
2563 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test 2011-08-22 11:28:27 +0000 |
2564 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test 1970-01-01 00:00:00 +0000 |
2565 | @@ -1,14 +0,0 @@ |
2566 | -# |
2567 | -# Bug #789131: Valgrind warning in MyISAM in mysql-55-eb-blobs |
2568 | -# |
2569 | - |
2570 | -CREATE TABLE t1 (f1 VARCHAR (128), f2 VARCHAR (128), f3 VARBINARY (512), |
2571 | - f4 TEXT (65525), f5 VARCHAR (128), KEY (f1(1))) ENGINE=HEAP; |
2572 | - |
2573 | -INSERT IGNORE INTO t1 VALUES |
2574 | - ( 'o' , "" , NULL , "" , 0 ) , |
2575 | - (NULL, "" , "" , "" , 'f' ) ; |
2576 | - |
2577 | -INSERT IGNORE INTO t1 SELECT * FROM t1; |
2578 | - |
2579 | -DROP TABLE t1; |
2580 | \ No newline at end of file |
2581 | |
2582 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_var.result' |
2583 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_var.result 2011-08-22 11:28:27 +0000 |
2584 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_var.result 1970-01-01 00:00:00 +0000 |
2585 | @@ -1,194 +0,0 @@ |
2586 | -drop table if exists t1; |
2587 | -set @@session.max_heap_table_size=16*1024*1024; |
2588 | -create table t1 (a int not null, b varchar(400), c int, primary key (a), key (c)) engine=heap comment="testing heaps" key_block_size=128; |
2589 | -ERROR 42000: Incorrect usage/placement of 'key_block_size' |
2590 | -create table t1 (a int not null, b int, c varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=4; |
2591 | -ERROR 42000: Incorrect usage/placement of 'key_block_size' |
2592 | -create table t1 (a int not null, b int, c varchar(400), d varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=24; |
2593 | -show table status like "t1"; |
2594 | -Name t1 |
2595 | -Engine MEMORY |
2596 | -Version 10 |
2597 | -Row_format Dynamic |
2598 | -Rows 0 |
2599 | -Avg_row_length X |
2600 | -Data_length X |
2601 | -Max_data_length X |
2602 | -Index_length X |
2603 | -Data_free X |
2604 | -Auto_increment X |
2605 | -Create_time X |
2606 | -Update_time X |
2607 | -Check_time X |
2608 | -Collation latin1_swedish_ci |
2609 | -Checksum NULL |
2610 | -Create_options KEY_BLOCK_SIZE=24 |
2611 | -Comment testing heaps |
2612 | -insert into t1 values (1,1,'012',NULL), (2,2,'0123456789',NULL), (3,3,'012345678901234567890123456789',NULL), (4,4,NULL,'0123456789012345678901234567890123456789012345678901234567890123456789'); |
2613 | -select * from t1; |
2614 | -a b c d |
2615 | -1 1 012 NULL |
2616 | -2 2 0123456789 NULL |
2617 | -3 3 012345678901234567890123456789 NULL |
2618 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2619 | -delete from t1 where a = 3; |
2620 | -select * from t1; |
2621 | -a b c d |
2622 | -1 1 012 NULL |
2623 | -2 2 0123456789 NULL |
2624 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2625 | -insert into t1 values (5,5,NULL,'0123'), (6,6,NULL,'0123'); |
2626 | -select * from t1; |
2627 | -a b c d |
2628 | -1 1 012 NULL |
2629 | -2 2 0123456789 NULL |
2630 | -6 6 NULL 0123 |
2631 | -5 5 NULL 0123 |
2632 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2633 | -update t1 set c = '012345678901234567890123456789' where a = 2; |
2634 | -select * from t1; |
2635 | -a b c d |
2636 | -1 1 012 NULL |
2637 | -2 2 012345678901234567890123456789 NULL |
2638 | -6 6 NULL 0123 |
2639 | -5 5 NULL 0123 |
2640 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2641 | -update t1 set c = '0123456789' where a = 2; |
2642 | -select * from t1; |
2643 | -a b c d |
2644 | -1 1 012 NULL |
2645 | -2 2 0123456789 NULL |
2646 | -6 6 NULL 0123 |
2647 | -5 5 NULL 0123 |
2648 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2649 | -insert into t1 values (7,7,'0123',NULL), (8,8,'0123',NULL); |
2650 | -select * from t1; |
2651 | -a b c d |
2652 | -1 1 012 NULL |
2653 | -2 2 0123456789 NULL |
2654 | -6 6 NULL 0123 |
2655 | -5 5 NULL 0123 |
2656 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2657 | -7 7 0123 NULL |
2658 | -8 8 0123 NULL |
2659 | -show table status like "t1"; |
2660 | -Name t1 |
2661 | -Engine MEMORY |
2662 | -Version 10 |
2663 | -Row_format Dynamic |
2664 | -Rows 7 |
2665 | -Avg_row_length X |
2666 | -Data_length X |
2667 | -Max_data_length X |
2668 | -Index_length X |
2669 | -Data_free X |
2670 | -Auto_increment X |
2671 | -Create_time X |
2672 | -Update_time X |
2673 | -Check_time X |
2674 | -Collation latin1_swedish_ci |
2675 | -Checksum NULL |
2676 | -Create_options KEY_BLOCK_SIZE=24 |
2677 | -Comment testing heaps |
2678 | -alter table t1 key_block_size = 0; |
2679 | -show table status like "t1"; |
2680 | -Name t1 |
2681 | -Engine MEMORY |
2682 | -Version 10 |
2683 | -Row_format Dynamic |
2684 | -Rows 7 |
2685 | -Avg_row_length X |
2686 | -Data_length X |
2687 | -Max_data_length X |
2688 | -Index_length X |
2689 | -Data_free X |
2690 | -Auto_increment X |
2691 | -Create_time X |
2692 | -Update_time X |
2693 | -Check_time X |
2694 | -Collation latin1_swedish_ci |
2695 | -Checksum NULL |
2696 | -Create_options |
2697 | -Comment testing heaps |
2698 | -alter table t1 row_format = dynamic; |
2699 | -show table status like "t1"; |
2700 | -Name t1 |
2701 | -Engine MEMORY |
2702 | -Version 10 |
2703 | -Row_format Dynamic |
2704 | -Rows 7 |
2705 | -Avg_row_length X |
2706 | -Data_length X |
2707 | -Max_data_length X |
2708 | -Index_length X |
2709 | -Data_free X |
2710 | -Auto_increment X |
2711 | -Create_time X |
2712 | -Update_time X |
2713 | -Check_time X |
2714 | -Collation latin1_swedish_ci |
2715 | -Checksum NULL |
2716 | -Create_options row_format=DYNAMIC KEY_BLOCK_SIZE=X |
2717 | -Comment testing heaps |
2718 | -alter table t1 key_block_size = 128, max_rows = 10001; |
2719 | -show table status like "t1"; |
2720 | -Name t1 |
2721 | -Engine MEMORY |
2722 | -Version 10 |
2723 | -Row_format Dynamic |
2724 | -Rows 7 |
2725 | -Avg_row_length X |
2726 | -Data_length X |
2727 | -Max_data_length X |
2728 | -Index_length X |
2729 | -Data_free X |
2730 | -Auto_increment X |
2731 | -Create_time X |
2732 | -Update_time X |
2733 | -Check_time X |
2734 | -Collation latin1_swedish_ci |
2735 | -Checksum NULL |
2736 | -Create_options max_rows=10001 row_format=DYNAMIC KEY_BLOCK_SIZE=128 |
2737 | -Comment testing heaps |
2738 | -select * from t1; |
2739 | -a b c d |
2740 | -1 1 012 NULL |
2741 | -2 2 0123456789 NULL |
2742 | -6 6 NULL 0123 |
2743 | -5 5 NULL 0123 |
2744 | -4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
2745 | -7 7 0123 NULL |
2746 | -8 8 0123 NULL |
2747 | -delete from t1; |
2748 | -select * from t1; |
2749 | -a b c d |
2750 | -call mtr.add_suppression("The table 't1' is full"); |
2751 | -select count(*) from t1; |
2752 | -count(*) |
2753 | -10001 |
2754 | -insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123'); |
2755 | -ERROR HY000: The table 't1' is full |
2756 | -show table status like "t1"; |
2757 | -Name t1 |
2758 | -Engine MEMORY |
2759 | -Version 10 |
2760 | -Row_format Dynamic |
2761 | -Rows 10001 |
2762 | -Avg_row_length X |
2763 | -Data_length X |
2764 | -Max_data_length X |
2765 | -Index_length X |
2766 | -Data_free X |
2767 | -Auto_increment X |
2768 | -Create_time X |
2769 | -Update_time X |
2770 | -Check_time X |
2771 | -Collation latin1_swedish_ci |
2772 | -Checksum NULL |
2773 | -Create_options max_rows=10001 row_format=DYNAMIC KEY_BLOCK_SIZE=128 |
2774 | -Comment testing heaps |
2775 | -select count(*) from t1; |
2776 | -count(*) |
2777 | -10001 |
2778 | -set @@session.max_heap_table_size=default; |
2779 | -drop table t1; |
2780 | |
2781 | === removed file 'mysql-test/memory_dynamic_rows.patch/percona_heap_var.test' |
2782 | --- mysql-test/memory_dynamic_rows.patch/percona_heap_var.test 2011-08-22 11:28:27 +0000 |
2783 | +++ mysql-test/memory_dynamic_rows.patch/percona_heap_var.test 1970-01-01 00:00:00 +0000 |
2784 | @@ -1,85 +0,0 @@ |
2785 | -# |
2786 | -# Test heap tables with variable-sized records. |
2787 | -# |
2788 | - |
2789 | ---disable_warnings |
2790 | -drop table if exists t1; |
2791 | ---enable_warnings |
2792 | - |
2793 | -set @@session.max_heap_table_size=16*1024*1024; |
2794 | - |
2795 | ---error 1234 |
2796 | -create table t1 (a int not null, b varchar(400), c int, primary key (a), key (c)) engine=heap comment="testing heaps" key_block_size=128; |
2797 | - |
2798 | ---error 1234 |
2799 | -create table t1 (a int not null, b int, c varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=4; |
2800 | - |
2801 | -create table t1 (a int not null, b int, c varchar(400), d varchar(400), primary key (a), key (b)) engine=heap comment="testing heaps" key_block_size=24; |
2802 | - |
2803 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2804 | ---query_vertical show table status like "t1" |
2805 | - |
2806 | -insert into t1 values (1,1,'012',NULL), (2,2,'0123456789',NULL), (3,3,'012345678901234567890123456789',NULL), (4,4,NULL,'0123456789012345678901234567890123456789012345678901234567890123456789'); |
2807 | -select * from t1; |
2808 | - |
2809 | -delete from t1 where a = 3; |
2810 | -select * from t1; |
2811 | - |
2812 | -insert into t1 values (5,5,NULL,'0123'), (6,6,NULL,'0123'); |
2813 | -select * from t1; |
2814 | - |
2815 | -update t1 set c = '012345678901234567890123456789' where a = 2; |
2816 | -select * from t1; |
2817 | - |
2818 | -update t1 set c = '0123456789' where a = 2; |
2819 | -select * from t1; |
2820 | - |
2821 | -insert into t1 values (7,7,'0123',NULL), (8,8,'0123',NULL); |
2822 | -select * from t1; |
2823 | - |
2824 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2825 | ---query_vertical show table status like "t1" |
2826 | -alter table t1 key_block_size = 0; |
2827 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2828 | ---query_vertical show table status like "t1" |
2829 | -alter table t1 row_format = dynamic; |
2830 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2831 | ---replace_regex /KEY_BLOCK_SIZE=[[:digit:]]+/KEY_BLOCK_SIZE=X/ |
2832 | ---query_vertical show table status like "t1" |
2833 | -alter table t1 key_block_size = 128, max_rows = 10001; |
2834 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2835 | ---query_vertical show table status like "t1" |
2836 | - |
2837 | -select * from t1; |
2838 | - |
2839 | -delete from t1; |
2840 | -select * from t1; |
2841 | - |
2842 | -let $1=10001; |
2843 | - |
2844 | -call mtr.add_suppression("The table 't1' is full"); |
2845 | - |
2846 | -disable_query_log; |
2847 | - |
2848 | -while ($1) |
2849 | -{ |
2850 | - |
2851 | - eval insert into t1 values ($1,$1,$1,$1); |
2852 | - |
2853 | - dec $1; |
2854 | - |
2855 | -} |
2856 | -enable_query_log; |
2857 | - |
2858 | -select count(*) from t1; |
2859 | - |
2860 | ---error 1114 |
2861 | -insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123'); |
2862 | - |
2863 | ---replace_column 6 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X |
2864 | ---query_vertical show table status like "t1" |
2865 | -select count(*) from t1; |
2866 | - |
2867 | -set @@session.max_heap_table_size=default; |
2868 | - |
2869 | -drop table t1; |
2870 | |
2871 | === removed file 'mysql-test/percona_innodb_buffer_pool_shm-master.opt' |
2872 | --- mysql-test/percona_innodb_buffer_pool_shm-master.opt 2010-12-09 18:30:58 +0000 |
2873 | +++ mysql-test/percona_innodb_buffer_pool_shm-master.opt 1970-01-01 00:00:00 +0000 |
2874 | @@ -1,1 +0,0 @@ |
2875 | ---innodb_buffer_pool_shm_key=123456 |
2876 | |
2877 | === removed file 'mysql-test/percona_innodb_buffer_pool_shm.result' |
2878 | --- mysql-test/percona_innodb_buffer_pool_shm.result 2011-06-22 02:59:28 +0000 |
2879 | +++ mysql-test/percona_innodb_buffer_pool_shm.result 1970-01-01 00:00:00 +0000 |
2880 | @@ -1,4 +0,0 @@ |
2881 | -show variables like 'innodb_buffer_pool_shm%'; |
2882 | -Variable_name Value |
2883 | -innodb_buffer_pool_shm_checksum ON |
2884 | -innodb_buffer_pool_shm_key 123456 |
2885 | |
2886 | === removed file 'mysql-test/percona_innodb_buffer_pool_shm.test' |
2887 | --- mysql-test/percona_innodb_buffer_pool_shm.test 2011-06-22 02:59:28 +0000 |
2888 | +++ mysql-test/percona_innodb_buffer_pool_shm.test 1970-01-01 00:00:00 +0000 |
2889 | @@ -1,2 +0,0 @@ |
2890 | ---source include/have_innodb.inc |
2891 | -show variables like 'innodb_buffer_pool_shm%'; |
2892 | |
2893 | === removed file 'mysql-test/percona_innodb_doublewrite_file-master.opt' |
2894 | --- mysql-test/percona_innodb_doublewrite_file-master.opt 2010-12-09 18:30:58 +0000 |
2895 | +++ mysql-test/percona_innodb_doublewrite_file-master.opt 1970-01-01 00:00:00 +0000 |
2896 | @@ -1,1 +0,0 @@ |
2897 | ---innodb_doublewrite_file=ib_doublewrite |
2898 | |
2899 | === removed file 'mysql-test/percona_innodb_doublewrite_file.result' |
2900 | --- mysql-test/percona_innodb_doublewrite_file.result 2010-12-09 18:30:58 +0000 |
2901 | +++ mysql-test/percona_innodb_doublewrite_file.result 1970-01-01 00:00:00 +0000 |
2902 | @@ -1,4 +0,0 @@ |
2903 | -show variables like 'innodb_doublewrite%'; |
2904 | -Variable_name Value |
2905 | -innodb_doublewrite ON |
2906 | -innodb_doublewrite_file ib_doublewrite |
2907 | |
2908 | === removed file 'mysql-test/percona_innodb_doublewrite_file.test' |
2909 | --- mysql-test/percona_innodb_doublewrite_file.test 2010-12-09 18:30:58 +0000 |
2910 | +++ mysql-test/percona_innodb_doublewrite_file.test 1970-01-01 00:00:00 +0000 |
2911 | @@ -1,2 +0,0 @@ |
2912 | ---source include/have_innodb.inc |
2913 | -show variables like 'innodb_doublewrite%'; |
2914 | |
2915 | === removed file 'mysql-test/percona_innodb_use_sys_stats_table-master.opt' |
2916 | --- mysql-test/percona_innodb_use_sys_stats_table-master.opt 2010-12-09 18:30:58 +0000 |
2917 | +++ mysql-test/percona_innodb_use_sys_stats_table-master.opt 1970-01-01 00:00:00 +0000 |
2918 | @@ -1,1 +0,0 @@ |
2919 | ---innodb_use_sys_stats_table |
2920 | |
2921 | === removed file 'mysql-test/percona_innodb_use_sys_stats_table.result' |
2922 | --- mysql-test/percona_innodb_use_sys_stats_table.result 2010-12-09 18:30:58 +0000 |
2923 | +++ mysql-test/percona_innodb_use_sys_stats_table.result 1970-01-01 00:00:00 +0000 |
2924 | @@ -1,3 +0,0 @@ |
2925 | -show variables like 'innodb_use_sys_stats%'; |
2926 | -Variable_name Value |
2927 | -innodb_use_sys_stats_table ON |
2928 | |
2929 | === removed file 'mysql-test/percona_innodb_use_sys_stats_table.test' |
2930 | --- mysql-test/percona_innodb_use_sys_stats_table.test 2010-12-09 18:30:58 +0000 |
2931 | +++ mysql-test/percona_innodb_use_sys_stats_table.test 1970-01-01 00:00:00 +0000 |
2932 | @@ -1,2 +0,0 @@ |
2933 | ---source include/have_innodb.inc |
2934 | -show variables like 'innodb_use_sys_stats%'; |
2935 | |
2936 | === removed file 'mysql-test/percona_server_variables.inc' |
2937 | --- mysql-test/percona_server_variables.inc 2011-06-23 02:11:07 +0000 |
2938 | +++ mysql-test/percona_server_variables.inc 1970-01-01 00:00:00 +0000 |
2939 | @@ -1,3 +0,0 @@ |
2940 | ---source include/have_response_time_distribution.inc |
2941 | ---source include/have_innodb.inc |
2942 | -SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1; |
2943 | |
2944 | === removed file 'mysql-test/percona_server_variables_debug.result' |
2945 | --- mysql-test/percona_server_variables_debug.result 2011-08-04 23:23:45 +0000 |
2946 | +++ mysql-test/percona_server_variables_debug.result 1970-01-01 00:00:00 +0000 |
2947 | @@ -1,372 +0,0 @@ |
2948 | -SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1; |
2949 | -Variable_name |
2950 | -AUTOCOMMIT |
2951 | -AUTOMATIC_SP_PRIVILEGES |
2952 | -AUTO_INCREMENT_INCREMENT |
2953 | -AUTO_INCREMENT_OFFSET |
2954 | -BACK_LOG |
2955 | -BASEDIR |
2956 | -BIG_TABLES |
2957 | -BINLOG_CACHE_SIZE |
2958 | -BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES |
2959 | -BINLOG_FORMAT |
2960 | -BINLOG_STMT_CACHE_SIZE |
2961 | -BULK_INSERT_BUFFER_SIZE |
2962 | -CHARACTER_SETS_DIR |
2963 | -CHARACTER_SET_CLIENT |
2964 | -CHARACTER_SET_CONNECTION |
2965 | -CHARACTER_SET_DATABASE |
2966 | -CHARACTER_SET_FILESYSTEM |
2967 | -CHARACTER_SET_RESULTS |
2968 | -CHARACTER_SET_SERVER |
2969 | -CHARACTER_SET_SYSTEM |
2970 | -COLLATION_CONNECTION |
2971 | -COLLATION_DATABASE |
2972 | -COLLATION_SERVER |
2973 | -COMPLETION_TYPE |
2974 | -CONCURRENT_INSERT |
2975 | -CONNECT_TIMEOUT |
2976 | -DATADIR |
2977 | -DATETIME_FORMAT |
2978 | -DATE_FORMAT |
2979 | -DEBUG |
2980 | -DEBUG_SYNC |
2981 | -DEFAULT_STORAGE_ENGINE |
2982 | -DEFAULT_WEEK_FORMAT |
2983 | -DELAYED_INSERT_LIMIT |
2984 | -DELAYED_INSERT_TIMEOUT |
2985 | -DELAYED_QUEUE_SIZE |
2986 | -DELAY_KEY_WRITE |
2987 | -DIV_PRECISION_INCREMENT |
2988 | -ENGINE_CONDITION_PUSHDOWN |
2989 | -ERROR_COUNT |
2990 | -EVENT_SCHEDULER |
2991 | -EXPIRE_LOGS_DAYS |
2992 | -EXTERNAL_USER |
2993 | -FAST_INDEX_CREATION |
2994 | -FLUSH |
2995 | -FLUSH_TIME |
2996 | -FOREIGN_KEY_CHECKS |
2997 | -FT_BOOLEAN_SYNTAX |
2998 | -FT_MAX_WORD_LEN |
2999 | -FT_MIN_WORD_LEN |
3000 | -FT_QUERY_EXPANSION_LIMIT |
3001 | -FT_STOPWORD_FILE |
3002 | -GENERAL_LOG |
3003 | -GENERAL_LOG_FILE |
3004 | -GROUP_CONCAT_MAX_LEN |
3005 | -HAVE_COMPRESS |
3006 | -HAVE_CRYPT |
3007 | -HAVE_CSV |
3008 | -HAVE_DYNAMIC_LOADING |
3009 | -HAVE_GEOMETRY |
3010 | -HAVE_INNODB |
3011 | -HAVE_NDBCLUSTER |
3012 | -HAVE_OPENSSL |
3013 | -HAVE_PARTITIONING |
3014 | -HAVE_PROFILING |
3015 | -HAVE_QUERY_CACHE |
3016 | -HAVE_RESPONSE_TIME_DISTRIBUTION |
3017 | -HAVE_RTREE_KEYS |
3018 | -HAVE_SSL |
3019 | -HAVE_SYMLINK |
3020 | -HOSTNAME |
3021 | -IDENTITY |
3022 | -IGNORE_BUILTIN_INNODB |
3023 | -INIT_CONNECT |
3024 | -INIT_FILE |
3025 | -INIT_SLAVE |
3026 | -INNODB_ADAPTIVE_FLUSHING |
3027 | -INNODB_ADAPTIVE_FLUSHING_METHOD |
3028 | -INNODB_ADAPTIVE_HASH_INDEX |
3029 | -INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS |
3030 | -INNODB_ADDITIONAL_MEM_POOL_SIZE |
3031 | -INNODB_AUTOEXTEND_INCREMENT |
3032 | -INNODB_AUTOINC_LOCK_MODE |
3033 | -INNODB_BUFFER_POOL_INSTANCES |
3034 | -INNODB_BUFFER_POOL_RESTORE_AT_STARTUP |
3035 | -INNODB_BUFFER_POOL_SHM_CHECKSUM |
3036 | -INNODB_BUFFER_POOL_SHM_KEY |
3037 | -INNODB_BUFFER_POOL_SIZE |
3038 | -INNODB_CHANGE_BUFFERING |
3039 | -INNODB_CHANGE_BUFFERING_DEBUG |
3040 | -INNODB_CHECKPOINT_AGE_TARGET |
3041 | -INNODB_CHECKSUMS |
3042 | -INNODB_COMMIT_CONCURRENCY |
3043 | -INNODB_CONCURRENCY_TICKETS |
3044 | -INNODB_CORRUPT_TABLE_ACTION |
3045 | -INNODB_DATA_FILE_PATH |
3046 | -INNODB_DATA_HOME_DIR |
3047 | -INNODB_DICT_SIZE_LIMIT |
3048 | -INNODB_DOUBLEWRITE |
3049 | -INNODB_DOUBLEWRITE_FILE |
3050 | -INNODB_FAST_CHECKSUM |
3051 | -INNODB_FAST_SHUTDOWN |
3052 | -INNODB_FILE_FORMAT |
3053 | -INNODB_FILE_FORMAT_CHECK |
3054 | -INNODB_FILE_FORMAT_MAX |
3055 | -INNODB_FILE_PER_TABLE |
3056 | -INNODB_FLUSH_LOG_AT_TRX_COMMIT |
3057 | -INNODB_FLUSH_METHOD |
3058 | -INNODB_FLUSH_NEIGHBOR_PAGES |
3059 | -INNODB_FORCE_RECOVERY |
3060 | -INNODB_IBUF_ACCEL_RATE |
3061 | -INNODB_IBUF_ACTIVE_CONTRACT |
3062 | -INNODB_IBUF_MAX_SIZE |
3063 | -INNODB_IMPORT_TABLE_FROM_XTRABACKUP |
3064 | -INNODB_IO_CAPACITY |
3065 | -INNODB_LARGE_PREFIX |
3066 | -INNODB_LAZY_DROP_TABLE |
3067 | -INNODB_LOCKS_UNSAFE_FOR_BINLOG |
3068 | -INNODB_LOCK_WAIT_TIMEOUT |
3069 | -INNODB_LOG_BLOCK_SIZE |
3070 | -INNODB_LOG_BUFFER_SIZE |
3071 | -INNODB_LOG_FILES_IN_GROUP |
3072 | -INNODB_LOG_FILE_SIZE |
3073 | -INNODB_LOG_GROUP_HOME_DIR |
3074 | -INNODB_MAX_DIRTY_PAGES_PCT |
3075 | -INNODB_MAX_PURGE_LAG |
3076 | -INNODB_MIRRORED_LOG_GROUPS |
3077 | -INNODB_OLD_BLOCKS_PCT |
3078 | -INNODB_OLD_BLOCKS_TIME |
3079 | -INNODB_OPEN_FILES |
3080 | -INNODB_PAGE_SIZE |
3081 | -INNODB_PURGE_BATCH_SIZE |
3082 | -INNODB_PURGE_THREADS |
3083 | -INNODB_READ_AHEAD |
3084 | -INNODB_READ_AHEAD_THRESHOLD |
3085 | -INNODB_READ_IO_THREADS |
3086 | -INNODB_RECOVERY_STATS |
3087 | -INNODB_RECOVERY_UPDATE_RELAY_LOG |
3088 | -INNODB_REPLICATION_DELAY |
3089 | -INNODB_ROLLBACK_ON_TIMEOUT |
3090 | -INNODB_ROLLBACK_SEGMENTS |
3091 | -INNODB_SHOW_LOCKS_HELD |
3092 | -INNODB_SHOW_VERBOSE_LOCKS |
3093 | -INNODB_SPIN_WAIT_DELAY |
3094 | -INNODB_STATS_AUTO_UPDATE |
3095 | -INNODB_STATS_METHOD |
3096 | -INNODB_STATS_ON_METADATA |
3097 | -INNODB_STATS_SAMPLE_PAGES |
3098 | -INNODB_STATS_UPDATE_NEED_LOCK |
3099 | -INNODB_STRICT_MODE |
3100 | -INNODB_SUPPORT_XA |
3101 | -INNODB_SYNC_SPIN_LOOPS |
3102 | -INNODB_TABLE_LOCKS |
3103 | -INNODB_THREAD_CONCURRENCY |
3104 | -INNODB_THREAD_CONCURRENCY_TIMER_BASED |
3105 | -INNODB_THREAD_SLEEP_DELAY |
3106 | -INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT |
3107 | -INNODB_USE_NATIVE_AIO |
3108 | -INNODB_USE_SYS_MALLOC |
3109 | -INNODB_USE_SYS_STATS_TABLE |
3110 | -INNODB_VERSION |
3111 | -INNODB_WRITE_IO_THREADS |
3112 | -INSERT_ID |
3113 | -INTERACTIVE_TIMEOUT |
3114 | -JOIN_BUFFER_SIZE |
3115 | -KEEP_FILES_ON_CREATE |
3116 | -KEY_BUFFER_SIZE |
3117 | -KEY_CACHE_AGE_THRESHOLD |
3118 | -KEY_CACHE_BLOCK_SIZE |
3119 | -KEY_CACHE_DIVISION_LIMIT |
3120 | -LARGE_FILES_SUPPORT |
3121 | -LARGE_PAGES |
3122 | -LARGE_PAGE_SIZE |
3123 | -LAST_INSERT_ID |
3124 | -LC_MESSAGES |
3125 | -LC_MESSAGES_DIR |
3126 | -LC_TIME_NAMES |
3127 | -LICENSE |
3128 | -LOCAL_INFILE |
3129 | -LOCKED_IN_MEMORY |
3130 | -LOCK_WAIT_TIMEOUT |
3131 | -LOG |
3132 | -LOG_BIN |
3133 | -LOG_BIN_TRUST_FUNCTION_CREATORS |
3134 | -LOG_ERROR |
3135 | -LOG_OUTPUT |
3136 | -LOG_QUERIES_NOT_USING_INDEXES |
3137 | -LOG_SLAVE_UPDATES |
3138 | -LOG_SLOW_FILTER |
3139 | -LOG_SLOW_QUERIES |
3140 | -LOG_SLOW_RATE_LIMIT |
3141 | -LOG_SLOW_SLAVE_STATEMENTS |
3142 | -LOG_SLOW_SP_STATEMENTS |
3143 | -LOG_SLOW_VERBOSITY |
3144 | -LOG_WARNINGS |
3145 | -LOG_WARNINGS_SUPPRESS |
3146 | -LONG_QUERY_TIME |
3147 | -LOWER_CASE_FILE_SYSTEM |
3148 | -LOWER_CASE_TABLE_NAMES |
3149 | -LOW_PRIORITY_UPDATES |
3150 | -MAX_ALLOWED_PACKET |
3151 | -MAX_BINLOG_CACHE_SIZE |
3152 | -MAX_BINLOG_SIZE |
3153 | -MAX_BINLOG_STMT_CACHE_SIZE |
3154 | -MAX_CONNECTIONS |
3155 | -MAX_CONNECT_ERRORS |
3156 | -MAX_DELAYED_THREADS |
3157 | -MAX_ERROR_COUNT |
3158 | -MAX_HEAP_TABLE_SIZE |
3159 | -MAX_INSERT_DELAYED_THREADS |
3160 | -MAX_JOIN_SIZE |
3161 | -MAX_LENGTH_FOR_SORT_DATA |
3162 | -MAX_LONG_DATA_SIZE |
3163 | -MAX_PREPARED_STMT_COUNT |
3164 | -MAX_RELAY_LOG_SIZE |
3165 | -MAX_SEEKS_FOR_KEY |
3166 | -MAX_SORT_LENGTH |
3167 | -MAX_SP_RECURSION_DEPTH |
3168 | -MAX_TMP_TABLES |
3169 | -MAX_USER_CONNECTIONS |
3170 | -MAX_WRITE_LOCK_COUNT |
3171 | -MIN_EXAMINED_ROW_LIMIT |
3172 | -MULTI_RANGE_COUNT |
3173 | -MYISAM_DATA_POINTER_SIZE |
3174 | -MYISAM_MAX_SORT_FILE_SIZE |
3175 | -MYISAM_MMAP_SIZE |
3176 | -MYISAM_RECOVER_OPTIONS |
3177 | -MYISAM_REPAIR_THREADS |
3178 | -MYISAM_SORT_BUFFER_SIZE |
3179 | -MYISAM_STATS_METHOD |
3180 | -MYISAM_USE_MMAP |
3181 | -NET_BUFFER_LENGTH |
3182 | -NET_READ_TIMEOUT |
3183 | -NET_RETRY_COUNT |
3184 | -NET_WRITE_TIMEOUT |
3185 | -NEW |
3186 | -OLD |
3187 | -OLD_ALTER_TABLE |
3188 | -OLD_PASSWORDS |
3189 | -OPEN_FILES_LIMIT |
3190 | -OPTIMIZER_FIX |
3191 | -OPTIMIZER_PRUNE_LEVEL |
3192 | -OPTIMIZER_SEARCH_DEPTH |
3193 | -OPTIMIZER_SWITCH |
3194 | -PERFORMANCE_SCHEMA |
3195 | -PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE |
3196 | -PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE |
3197 | -PERFORMANCE_SCHEMA_MAX_COND_CLASSES |
3198 | -PERFORMANCE_SCHEMA_MAX_COND_INSTANCES |
3199 | -PERFORMANCE_SCHEMA_MAX_FILE_CLASSES |
3200 | -PERFORMANCE_SCHEMA_MAX_FILE_HANDLES |
3201 | -PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES |
3202 | -PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES |
3203 | -PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES |
3204 | -PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES |
3205 | -PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES |
3206 | -PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES |
3207 | -PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES |
3208 | -PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES |
3209 | -PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES |
3210 | -PID_FILE |
3211 | -PLUGIN_DIR |
3212 | -PORT |
3213 | -PRELOAD_BUFFER_SIZE |
3214 | -PROFILING |
3215 | -PROFILING_HISTORY_SIZE |
3216 | -PROTOCOL_VERSION |
3217 | -PROXY_USER |
3218 | -PSEUDO_THREAD_ID |
3219 | -QUERY_ALLOC_BLOCK_SIZE |
3220 | -QUERY_CACHE_LIMIT |
3221 | -QUERY_CACHE_MIN_RES_UNIT |
3222 | -QUERY_CACHE_SIZE |
3223 | -QUERY_CACHE_STRIP_COMMENTS |
3224 | -QUERY_CACHE_TYPE |
3225 | -QUERY_CACHE_WLOCK_INVALIDATE |
3226 | -QUERY_PREALLOC_SIZE |
3227 | -QUERY_RESPONSE_TIME_RANGE_BASE |
3228 | -QUERY_RESPONSE_TIME_STATS |
3229 | -RAND_SEED1 |
3230 | -RAND_SEED2 |
3231 | -RANGE_ALLOC_BLOCK_SIZE |
3232 | -READ_BUFFER_SIZE |
3233 | -READ_ONLY |
3234 | -READ_RND_BUFFER_SIZE |
3235 | -RELAY_LOG |
3236 | -RELAY_LOG_INDEX |
3237 | -RELAY_LOG_INFO_FILE |
3238 | -RELAY_LOG_PURGE |
3239 | -RELAY_LOG_RECOVERY |
3240 | -RELAY_LOG_SPACE_LIMIT |
3241 | -REPORT_HOST |
3242 | -REPORT_PASSWORD |
3243 | -REPORT_PORT |
3244 | -REPORT_USER |
3245 | -RPL_RECOVERY_RANK |
3246 | -SECURE_AUTH |
3247 | -SECURE_FILE_PRIV |
3248 | -SERVER_ID |
3249 | -SKIP_EXTERNAL_LOCKING |
3250 | -SKIP_NAME_RESOLVE |
3251 | -SKIP_NETWORKING |
3252 | -SKIP_SHOW_DATABASE |
3253 | -SLAVE_COMPRESSED_PROTOCOL |
3254 | -SLAVE_EXEC_MODE |
3255 | -SLAVE_LOAD_TMPDIR |
3256 | -SLAVE_NET_TIMEOUT |
3257 | -SLAVE_SKIP_ERRORS |
3258 | -SLAVE_TRANSACTION_RETRIES |
3259 | -SLAVE_TYPE_CONVERSIONS |
3260 | -SLOW_LAUNCH_TIME |
3261 | -SLOW_QUERY_LOG |
3262 | -SLOW_QUERY_LOG_FILE |
3263 | -SLOW_QUERY_LOG_TIMESTAMP_ALWAYS |
3264 | -SLOW_QUERY_LOG_TIMESTAMP_PRECISION |
3265 | -SLOW_QUERY_LOG_USE_GLOBAL_CONTROL |
3266 | -SOCKET |
3267 | -SORT_BUFFER_SIZE |
3268 | -SQL_AUTO_IS_NULL |
3269 | -SQL_BIG_SELECTS |
3270 | -SQL_BIG_TABLES |
3271 | -SQL_BUFFER_RESULT |
3272 | -SQL_LOG_BIN |
3273 | -SQL_LOG_OFF |
3274 | -SQL_LOW_PRIORITY_UPDATES |
3275 | -SQL_MAX_JOIN_SIZE |
3276 | -SQL_MODE |
3277 | -SQL_NOTES |
3278 | -SQL_QUOTE_SHOW_CREATE |
3279 | -SQL_SAFE_UPDATES |
3280 | -SQL_SELECT_LIMIT |
3281 | -SQL_SLAVE_SKIP_COUNTER |
3282 | -SQL_WARNINGS |
3283 | -SSL_CA |
3284 | -SSL_CAPATH |
3285 | -SSL_CERT |
3286 | -SSL_CIPHER |
3287 | -SSL_KEY |
3288 | -STORAGE_ENGINE |
3289 | -SYNC_BINLOG |
3290 | -SYNC_FRM |
3291 | -SYNC_MASTER_INFO |
3292 | -SYNC_RELAY_LOG |
3293 | -SYNC_RELAY_LOG_INFO |
3294 | -SYSTEM_TIME_ZONE |
3295 | -TABLE_DEFINITION_CACHE |
3296 | -TABLE_OPEN_CACHE |
3297 | -THREAD_CACHE_SIZE |
3298 | -THREAD_CONCURRENCY |
3299 | -THREAD_HANDLING |
3300 | -THREAD_STACK |
3301 | -THREAD_STATISTICS |
3302 | -TIMED_MUTEXES |
3303 | -TIMESTAMP |
3304 | -TIME_FORMAT |
3305 | -TIME_ZONE |
3306 | -TMPDIR |
3307 | -TMP_TABLE_SIZE |
3308 | -TRANSACTION_ALLOC_BLOCK_SIZE |
3309 | -TRANSACTION_PREALLOC_SIZE |
3310 | -TX_ISOLATION |
3311 | -UNIQUE_CHECKS |
3312 | -UPDATABLE_VIEWS_WITH_LIMIT |
3313 | -USERSTAT |
3314 | -VERSION |
3315 | -VERSION_COMMENT |
3316 | -VERSION_COMPILE_MACHINE |
3317 | -VERSION_COMPILE_OS |
3318 | -WAIT_TIMEOUT |
3319 | -WARNING_COUNT |
3320 | |
3321 | === removed file 'mysql-test/percona_server_variables_debug.test' |
3322 | --- mysql-test/percona_server_variables_debug.test 2011-06-23 02:11:07 +0000 |
3323 | +++ mysql-test/percona_server_variables_debug.test 1970-01-01 00:00:00 +0000 |
3324 | @@ -1,2 +0,0 @@ |
3325 | ---source include/have_debug.inc |
3326 | ---source include/percona_server_variables.inc |
3327 | |
3328 | === removed file 'mysql-test/percona_server_variables_release.result' |
3329 | --- mysql-test/percona_server_variables_release.result 2011-08-04 19:16:18 +0000 |
3330 | +++ mysql-test/percona_server_variables_release.result 1970-01-01 00:00:00 +0000 |
3331 | @@ -1,369 +0,0 @@ |
3332 | -SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1; |
3333 | -Variable_name |
3334 | -AUTOCOMMIT |
3335 | -AUTOMATIC_SP_PRIVILEGES |
3336 | -AUTO_INCREMENT_INCREMENT |
3337 | -AUTO_INCREMENT_OFFSET |
3338 | -BACK_LOG |
3339 | -BASEDIR |
3340 | -BIG_TABLES |
3341 | -BINLOG_CACHE_SIZE |
3342 | -BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES |
3343 | -BINLOG_FORMAT |
3344 | -BINLOG_STMT_CACHE_SIZE |
3345 | -BULK_INSERT_BUFFER_SIZE |
3346 | -CHARACTER_SETS_DIR |
3347 | -CHARACTER_SET_CLIENT |
3348 | -CHARACTER_SET_CONNECTION |
3349 | -CHARACTER_SET_DATABASE |
3350 | -CHARACTER_SET_FILESYSTEM |
3351 | -CHARACTER_SET_RESULTS |
3352 | -CHARACTER_SET_SERVER |
3353 | -CHARACTER_SET_SYSTEM |
3354 | -COLLATION_CONNECTION |
3355 | -COLLATION_DATABASE |
3356 | -COLLATION_SERVER |
3357 | -COMPLETION_TYPE |
3358 | -CONCURRENT_INSERT |
3359 | -CONNECT_TIMEOUT |
3360 | -DATADIR |
3361 | -DATETIME_FORMAT |
3362 | -DATE_FORMAT |
3363 | -DEFAULT_STORAGE_ENGINE |
3364 | -DEFAULT_WEEK_FORMAT |
3365 | -DELAYED_INSERT_LIMIT |
3366 | -DELAYED_INSERT_TIMEOUT |
3367 | -DELAYED_QUEUE_SIZE |
3368 | -DELAY_KEY_WRITE |
3369 | -DIV_PRECISION_INCREMENT |
3370 | -ENGINE_CONDITION_PUSHDOWN |
3371 | -ERROR_COUNT |
3372 | -EVENT_SCHEDULER |
3373 | -EXPIRE_LOGS_DAYS |
3374 | -EXTERNAL_USER |
3375 | -FAST_INDEX_CREATION |
3376 | -FLUSH |
3377 | -FLUSH_TIME |
3378 | -FOREIGN_KEY_CHECKS |
3379 | -FT_BOOLEAN_SYNTAX |
3380 | -FT_MAX_WORD_LEN |
3381 | -FT_MIN_WORD_LEN |
3382 | -FT_QUERY_EXPANSION_LIMIT |
3383 | -FT_STOPWORD_FILE |
3384 | -GENERAL_LOG |
3385 | -GENERAL_LOG_FILE |
3386 | -GROUP_CONCAT_MAX_LEN |
3387 | -HAVE_COMPRESS |
3388 | -HAVE_CRYPT |
3389 | -HAVE_CSV |
3390 | -HAVE_DYNAMIC_LOADING |
3391 | -HAVE_GEOMETRY |
3392 | -HAVE_INNODB |
3393 | -HAVE_NDBCLUSTER |
3394 | -HAVE_OPENSSL |
3395 | -HAVE_PARTITIONING |
3396 | -HAVE_PROFILING |
3397 | -HAVE_QUERY_CACHE |
3398 | -HAVE_RESPONSE_TIME_DISTRIBUTION |
3399 | -HAVE_RTREE_KEYS |
3400 | -HAVE_SSL |
3401 | -HAVE_SYMLINK |
3402 | -HOSTNAME |
3403 | -IDENTITY |
3404 | -IGNORE_BUILTIN_INNODB |
3405 | -INIT_CONNECT |
3406 | -INIT_FILE |
3407 | -INIT_SLAVE |
3408 | -INNODB_ADAPTIVE_FLUSHING |
3409 | -INNODB_ADAPTIVE_FLUSHING_METHOD |
3410 | -INNODB_ADAPTIVE_HASH_INDEX |
3411 | -INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS |
3412 | -INNODB_ADDITIONAL_MEM_POOL_SIZE |
3413 | -INNODB_AUTOEXTEND_INCREMENT |
3414 | -INNODB_AUTOINC_LOCK_MODE |
3415 | -INNODB_BUFFER_POOL_INSTANCES |
3416 | -INNODB_BUFFER_POOL_RESTORE_AT_STARTUP |
3417 | -INNODB_BUFFER_POOL_SHM_CHECKSUM |
3418 | -INNODB_BUFFER_POOL_SHM_KEY |
3419 | -INNODB_BUFFER_POOL_SIZE |
3420 | -INNODB_CHANGE_BUFFERING |
3421 | -INNODB_CHECKPOINT_AGE_TARGET |
3422 | -INNODB_CHECKSUMS |
3423 | -INNODB_COMMIT_CONCURRENCY |
3424 | -INNODB_CONCURRENCY_TICKETS |
3425 | -INNODB_CORRUPT_TABLE_ACTION |
3426 | -INNODB_DATA_FILE_PATH |
3427 | -INNODB_DATA_HOME_DIR |
3428 | -INNODB_DICT_SIZE_LIMIT |
3429 | -INNODB_DOUBLEWRITE |
3430 | -INNODB_DOUBLEWRITE_FILE |
3431 | -INNODB_FAST_CHECKSUM |
3432 | -INNODB_FAST_SHUTDOWN |
3433 | -INNODB_FILE_FORMAT |
3434 | -INNODB_FILE_FORMAT_CHECK |
3435 | -INNODB_FILE_FORMAT_MAX |
3436 | -INNODB_FILE_PER_TABLE |
3437 | -INNODB_FLUSH_LOG_AT_TRX_COMMIT |
3438 | -INNODB_FLUSH_METHOD |
3439 | -INNODB_FLUSH_NEIGHBOR_PAGES |
3440 | -INNODB_FORCE_RECOVERY |
3441 | -INNODB_IBUF_ACCEL_RATE |
3442 | -INNODB_IBUF_ACTIVE_CONTRACT |
3443 | -INNODB_IBUF_MAX_SIZE |
3444 | -INNODB_IMPORT_TABLE_FROM_XTRABACKUP |
3445 | -INNODB_IO_CAPACITY |
3446 | -INNODB_LARGE_PREFIX |
3447 | -INNODB_LAZY_DROP_TABLE |
3448 | -INNODB_LOCKS_UNSAFE_FOR_BINLOG |
3449 | -INNODB_LOCK_WAIT_TIMEOUT |
3450 | -INNODB_LOG_BLOCK_SIZE |
3451 | -INNODB_LOG_BUFFER_SIZE |
3452 | -INNODB_LOG_FILES_IN_GROUP |
3453 | -INNODB_LOG_FILE_SIZE |
3454 | -INNODB_LOG_GROUP_HOME_DIR |
3455 | -INNODB_MAX_DIRTY_PAGES_PCT |
3456 | -INNODB_MAX_PURGE_LAG |
3457 | -INNODB_MIRRORED_LOG_GROUPS |
3458 | -INNODB_OLD_BLOCKS_PCT |
3459 | -INNODB_OLD_BLOCKS_TIME |
3460 | -INNODB_OPEN_FILES |
3461 | -INNODB_PAGE_SIZE |
3462 | -INNODB_PURGE_BATCH_SIZE |
3463 | -INNODB_PURGE_THREADS |
3464 | -INNODB_READ_AHEAD |
3465 | -INNODB_READ_AHEAD_THRESHOLD |
3466 | -INNODB_READ_IO_THREADS |
3467 | -INNODB_RECOVERY_STATS |
3468 | -INNODB_RECOVERY_UPDATE_RELAY_LOG |
3469 | -INNODB_REPLICATION_DELAY |
3470 | -INNODB_ROLLBACK_ON_TIMEOUT |
3471 | -INNODB_ROLLBACK_SEGMENTS |
3472 | -INNODB_SHOW_LOCKS_HELD |
3473 | -INNODB_SHOW_VERBOSE_LOCKS |
3474 | -INNODB_SPIN_WAIT_DELAY |
3475 | -INNODB_STATS_AUTO_UPDATE |
3476 | -INNODB_STATS_METHOD |
3477 | -INNODB_STATS_ON_METADATA |
3478 | -INNODB_STATS_SAMPLE_PAGES |
3479 | -INNODB_STATS_UPDATE_NEED_LOCK |
3480 | -INNODB_STRICT_MODE |
3481 | -INNODB_SUPPORT_XA |
3482 | -INNODB_SYNC_SPIN_LOOPS |
3483 | -INNODB_TABLE_LOCKS |
3484 | -INNODB_THREAD_CONCURRENCY |
3485 | -INNODB_THREAD_CONCURRENCY_TIMER_BASED |
3486 | -INNODB_THREAD_SLEEP_DELAY |
3487 | -INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT |
3488 | -INNODB_USE_NATIVE_AIO |
3489 | -INNODB_USE_SYS_MALLOC |
3490 | -INNODB_USE_SYS_STATS_TABLE |
3491 | -INNODB_VERSION |
3492 | -INNODB_WRITE_IO_THREADS |
3493 | -INSERT_ID |
3494 | -INTERACTIVE_TIMEOUT |
3495 | -JOIN_BUFFER_SIZE |
3496 | -KEEP_FILES_ON_CREATE |
3497 | -KEY_BUFFER_SIZE |
3498 | -KEY_CACHE_AGE_THRESHOLD |
3499 | -KEY_CACHE_BLOCK_SIZE |
3500 | -KEY_CACHE_DIVISION_LIMIT |
3501 | -LARGE_FILES_SUPPORT |
3502 | -LARGE_PAGES |
3503 | -LARGE_PAGE_SIZE |
3504 | -LAST_INSERT_ID |
3505 | -LC_MESSAGES |
3506 | -LC_MESSAGES_DIR |
3507 | -LC_TIME_NAMES |
3508 | -LICENSE |
3509 | -LOCAL_INFILE |
3510 | -LOCKED_IN_MEMORY |
3511 | -LOCK_WAIT_TIMEOUT |
3512 | -LOG |
3513 | -LOG_BIN |
3514 | -LOG_BIN_TRUST_FUNCTION_CREATORS |
3515 | -LOG_ERROR |
3516 | -LOG_OUTPUT |
3517 | -LOG_QUERIES_NOT_USING_INDEXES |
3518 | -LOG_SLAVE_UPDATES |
3519 | -LOG_SLOW_FILTER |
3520 | -LOG_SLOW_QUERIES |
3521 | -LOG_SLOW_RATE_LIMIT |
3522 | -LOG_SLOW_SLAVE_STATEMENTS |
3523 | -LOG_SLOW_SP_STATEMENTS |
3524 | -LOG_SLOW_VERBOSITY |
3525 | -LOG_WARNINGS |
3526 | -LOG_WARNINGS_SUPPRESS |
3527 | -LONG_QUERY_TIME |
3528 | -LOWER_CASE_FILE_SYSTEM |
3529 | -LOWER_CASE_TABLE_NAMES |
3530 | -LOW_PRIORITY_UPDATES |
3531 | -MAX_ALLOWED_PACKET |
3532 | -MAX_BINLOG_CACHE_SIZE |
3533 | -MAX_BINLOG_SIZE |
3534 | -MAX_BINLOG_STMT_CACHE_SIZE |
3535 | -MAX_CONNECTIONS |
3536 | -MAX_CONNECT_ERRORS |
3537 | -MAX_DELAYED_THREADS |
3538 | -MAX_ERROR_COUNT |
3539 | -MAX_HEAP_TABLE_SIZE |
3540 | -MAX_INSERT_DELAYED_THREADS |
3541 | -MAX_JOIN_SIZE |
3542 | -MAX_LENGTH_FOR_SORT_DATA |
3543 | -MAX_LONG_DATA_SIZE |
3544 | -MAX_PREPARED_STMT_COUNT |
3545 | -MAX_RELAY_LOG_SIZE |
3546 | -MAX_SEEKS_FOR_KEY |
3547 | -MAX_SORT_LENGTH |
3548 | -MAX_SP_RECURSION_DEPTH |
3549 | -MAX_TMP_TABLES |
3550 | -MAX_USER_CONNECTIONS |
3551 | -MAX_WRITE_LOCK_COUNT |
3552 | -MIN_EXAMINED_ROW_LIMIT |
3553 | -MULTI_RANGE_COUNT |
3554 | -MYISAM_DATA_POINTER_SIZE |
3555 | -MYISAM_MAX_SORT_FILE_SIZE |
3556 | -MYISAM_MMAP_SIZE |
3557 | -MYISAM_RECOVER_OPTIONS |
3558 | -MYISAM_REPAIR_THREADS |
3559 | -MYISAM_SORT_BUFFER_SIZE |
3560 | -MYISAM_STATS_METHOD |
3561 | -MYISAM_USE_MMAP |
3562 | -NET_BUFFER_LENGTH |
3563 | -NET_READ_TIMEOUT |
3564 | -NET_RETRY_COUNT |
3565 | -NET_WRITE_TIMEOUT |
3566 | -NEW |
3567 | -OLD |
3568 | -OLD_ALTER_TABLE |
3569 | -OLD_PASSWORDS |
3570 | -OPEN_FILES_LIMIT |
3571 | -OPTIMIZER_FIX |
3572 | -OPTIMIZER_PRUNE_LEVEL |
3573 | -OPTIMIZER_SEARCH_DEPTH |
3574 | -OPTIMIZER_SWITCH |
3575 | -PERFORMANCE_SCHEMA |
3576 | -PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE |
3577 | -PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE |
3578 | -PERFORMANCE_SCHEMA_MAX_COND_CLASSES |
3579 | -PERFORMANCE_SCHEMA_MAX_COND_INSTANCES |
3580 | -PERFORMANCE_SCHEMA_MAX_FILE_CLASSES |
3581 | -PERFORMANCE_SCHEMA_MAX_FILE_HANDLES |
3582 | -PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES |
3583 | -PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES |
3584 | -PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES |
3585 | -PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES |
3586 | -PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES |
3587 | -PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES |
3588 | -PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES |
3589 | -PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES |
3590 | -PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES |
3591 | -PID_FILE |
3592 | -PLUGIN_DIR |
3593 | -PORT |
3594 | -PRELOAD_BUFFER_SIZE |
3595 | -PROFILING |
3596 | -PROFILING_HISTORY_SIZE |
3597 | -PROTOCOL_VERSION |
3598 | -PROXY_USER |
3599 | -PSEUDO_THREAD_ID |
3600 | -QUERY_ALLOC_BLOCK_SIZE |
3601 | -QUERY_CACHE_LIMIT |
3602 | -QUERY_CACHE_MIN_RES_UNIT |
3603 | -QUERY_CACHE_SIZE |
3604 | -QUERY_CACHE_STRIP_COMMENTS |
3605 | -QUERY_CACHE_TYPE |
3606 | -QUERY_CACHE_WLOCK_INVALIDATE |
3607 | -QUERY_PREALLOC_SIZE |
3608 | -QUERY_RESPONSE_TIME_RANGE_BASE |
3609 | -QUERY_RESPONSE_TIME_STATS |
3610 | -RAND_SEED1 |
3611 | -RAND_SEED2 |
3612 | -RANGE_ALLOC_BLOCK_SIZE |
3613 | -READ_BUFFER_SIZE |
3614 | -READ_ONLY |
3615 | -READ_RND_BUFFER_SIZE |
3616 | -RELAY_LOG |
3617 | -RELAY_LOG_INDEX |
3618 | -RELAY_LOG_INFO_FILE |
3619 | -RELAY_LOG_PURGE |
3620 | -RELAY_LOG_RECOVERY |
3621 | -RELAY_LOG_SPACE_LIMIT |
3622 | -REPORT_HOST |
3623 | -REPORT_PASSWORD |
3624 | -REPORT_PORT |
3625 | -REPORT_USER |
3626 | -RPL_RECOVERY_RANK |
3627 | -SECURE_AUTH |
3628 | -SECURE_FILE_PRIV |
3629 | -SERVER_ID |
3630 | -SKIP_EXTERNAL_LOCKING |
3631 | -SKIP_NAME_RESOLVE |
3632 | -SKIP_NETWORKING |
3633 | -SKIP_SHOW_DATABASE |
3634 | -SLAVE_COMPRESSED_PROTOCOL |
3635 | -SLAVE_EXEC_MODE |
3636 | -SLAVE_LOAD_TMPDIR |
3637 | -SLAVE_NET_TIMEOUT |
3638 | -SLAVE_SKIP_ERRORS |
3639 | -SLAVE_TRANSACTION_RETRIES |
3640 | -SLAVE_TYPE_CONVERSIONS |
3641 | -SLOW_LAUNCH_TIME |
3642 | -SLOW_QUERY_LOG |
3643 | -SLOW_QUERY_LOG_FILE |
3644 | -SLOW_QUERY_LOG_TIMESTAMP_ALWAYS |
3645 | -SLOW_QUERY_LOG_TIMESTAMP_PRECISION |
3646 | -SLOW_QUERY_LOG_USE_GLOBAL_CONTROL |
3647 | -SOCKET |
3648 | -SORT_BUFFER_SIZE |
3649 | -SQL_AUTO_IS_NULL |
3650 | -SQL_BIG_SELECTS |
3651 | -SQL_BIG_TABLES |
3652 | -SQL_BUFFER_RESULT |
3653 | -SQL_LOG_BIN |
3654 | -SQL_LOG_OFF |
3655 | -SQL_LOW_PRIORITY_UPDATES |
3656 | -SQL_MAX_JOIN_SIZE |
3657 | -SQL_MODE |
3658 | -SQL_NOTES |
3659 | -SQL_QUOTE_SHOW_CREATE |
3660 | -SQL_SAFE_UPDATES |
3661 | -SQL_SELECT_LIMIT |
3662 | -SQL_SLAVE_SKIP_COUNTER |
3663 | -SQL_WARNINGS |
3664 | -SSL_CA |
3665 | -SSL_CAPATH |
3666 | -SSL_CERT |
3667 | -SSL_CIPHER |
3668 | -SSL_KEY |
3669 | -STORAGE_ENGINE |
3670 | -SYNC_BINLOG |
3671 | -SYNC_FRM |
3672 | -SYNC_MASTER_INFO |
3673 | -SYNC_RELAY_LOG |
3674 | -SYNC_RELAY_LOG_INFO |
3675 | -SYSTEM_TIME_ZONE |
3676 | -TABLE_DEFINITION_CACHE |
3677 | -TABLE_OPEN_CACHE |
3678 | -THREAD_CACHE_SIZE |
3679 | -THREAD_CONCURRENCY |
3680 | -THREAD_HANDLING |
3681 | -THREAD_STACK |
3682 | -THREAD_STATISTICS |
3683 | -TIMED_MUTEXES |
3684 | -TIMESTAMP |
3685 | -TIME_FORMAT |
3686 | -TIME_ZONE |
3687 | -TMPDIR |
3688 | -TMP_TABLE_SIZE |
3689 | -TRANSACTION_ALLOC_BLOCK_SIZE |
3690 | -TRANSACTION_PREALLOC_SIZE |
3691 | -TX_ISOLATION |
3692 | -UNIQUE_CHECKS |
3693 | -UPDATABLE_VIEWS_WITH_LIMIT |
3694 | -USERSTAT |
3695 | -VERSION |
3696 | -VERSION_COMMENT |
3697 | -VERSION_COMPILE_MACHINE |
3698 | -VERSION_COMPILE_OS |
3699 | -WAIT_TIMEOUT |
3700 | -WARNING_COUNT |
3701 | |
3702 | === removed file 'mysql-test/percona_server_variables_release.test' |
3703 | --- mysql-test/percona_server_variables_release.test 2011-06-23 02:11:07 +0000 |
3704 | +++ mysql-test/percona_server_variables_release.test 1970-01-01 00:00:00 +0000 |
3705 | @@ -1,2 +0,0 @@ |
3706 | ---source include/have_nodebug.inc |
3707 | ---source include/percona_server_variables.inc |
3708 | |
3709 | === removed file 'mysql-test/percona_show_temp_tables.result' |
3710 | --- mysql-test/percona_show_temp_tables.result 2010-12-09 18:30:58 +0000 |
3711 | +++ mysql-test/percona_show_temp_tables.result 1970-01-01 00:00:00 +0000 |
3712 | @@ -1,58 +0,0 @@ |
3713 | -drop table if exists t1,t2,t3; |
3714 | -drop database if exists showtemp; |
3715 | -create database if not exists showtemp; |
3716 | -use test; |
3717 | -create temporary table t1(id int); |
3718 | -create temporary table t2(id int); |
3719 | -create temporary table showtemp.t3(id int); |
3720 | -insert into t1 values(10),(20),(30),(40); |
3721 | -insert into showtemp.t3 values(999); |
3722 | -show temporary tables; |
3723 | -Temp_tables_in_test |
3724 | -t2 |
3725 | -t1 |
3726 | -show temporary tables from test; |
3727 | -Temp_tables_in_test |
3728 | -t2 |
3729 | -t1 |
3730 | -show temporary tables in showtemp; |
3731 | -Temp_tables_in_showtemp |
3732 | -t3 |
3733 | -select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables; |
3734 | -table_schema table_name engine table_rows |
3735 | -showtemp t3 MyISAM 1 |
3736 | -test t2 MyISAM 0 |
3737 | -test t1 MyISAM 4 |
3738 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3739 | -table_schema table_name engine table_rows |
3740 | -showtemp t3 MyISAM 1 |
3741 | -test t2 MyISAM 0 |
3742 | -test t1 MyISAM 4 |
3743 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp'; |
3744 | -table_schema table_name engine table_rows |
3745 | -showtemp t3 MyISAM 1 |
3746 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp'; |
3747 | -table_schema table_name engine table_rows |
3748 | -drop table if exists showtemp.t2; |
3749 | -create temporary table t1(id int); |
3750 | -create temporary table showtemp.t2(id int); |
3751 | -show temporary tables; |
3752 | -Temp_tables_in_test |
3753 | -t1 |
3754 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3755 | -table_schema table_name engine table_rows |
3756 | -showtemp t2 MyISAM 0 |
3757 | -test t1 MyISAM 0 |
3758 | -showtemp t3 MyISAM 1 |
3759 | -test t2 MyISAM 0 |
3760 | -test t1 MyISAM 4 |
3761 | -drop table showtemp.t2; |
3762 | -drop table t1; |
3763 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3764 | -table_schema table_name engine table_rows |
3765 | -showtemp t3 MyISAM 1 |
3766 | -test t2 MyISAM 0 |
3767 | -test t1 MyISAM 4 |
3768 | -drop table t1, t2; |
3769 | -drop table showtemp.t3; |
3770 | -drop database showtemp; |
3771 | |
3772 | === removed file 'mysql-test/percona_show_temp_tables.test' |
3773 | --- mysql-test/percona_show_temp_tables.test 2010-12-09 18:30:58 +0000 |
3774 | +++ mysql-test/percona_show_temp_tables.test 1970-01-01 00:00:00 +0000 |
3775 | @@ -1,65 +0,0 @@ |
3776 | -# Uses GRANT commands that usually disabled in embedded server |
3777 | --- source include/not_embedded.inc |
3778 | - |
3779 | -# Save the initial number of concurrent sessions |
3780 | ---source include/count_sessions.inc |
3781 | - |
3782 | -# |
3783 | -# Test of SHOW [GLOBAL] TEMPORARY TABLES [FROM/IN] DB and |
3784 | -# Information_schema.temporary_tables and global_temporary_tables |
3785 | -# |
3786 | - |
3787 | -connect(stcon1,localhost,root,,test); |
3788 | -connect(stcon2,localhost,root,,test); |
3789 | - |
3790 | -connection stcon1; |
3791 | - |
3792 | ---disable_warnings |
3793 | -drop table if exists t1,t2,t3; |
3794 | -drop database if exists showtemp; |
3795 | -create database if not exists showtemp; |
3796 | ---enable_warnings |
3797 | - |
3798 | -use test; |
3799 | -create temporary table t1(id int); |
3800 | -create temporary table t2(id int); |
3801 | -create temporary table showtemp.t3(id int); |
3802 | -insert into t1 values(10),(20),(30),(40); |
3803 | -insert into showtemp.t3 values(999); |
3804 | - |
3805 | -show temporary tables; |
3806 | -# "Session" is not same value always. mysql-test cannot test it always. |
3807 | -#show global temporary tables; |
3808 | -show temporary tables from test; |
3809 | -show temporary tables in showtemp; |
3810 | -select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables; |
3811 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3812 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp'; |
3813 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp'; |
3814 | - |
3815 | -connection stcon2; |
3816 | - |
3817 | ---disable_warnings |
3818 | -drop table if exists showtemp.t2; |
3819 | ---enable_warnings |
3820 | -create temporary table t1(id int); |
3821 | -create temporary table showtemp.t2(id int); |
3822 | -show temporary tables; |
3823 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3824 | -drop table showtemp.t2; |
3825 | -drop table t1; |
3826 | - |
3827 | -disconnect stcon2; |
3828 | - |
3829 | -connection stcon1; |
3830 | -select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables; |
3831 | - |
3832 | -drop table t1, t2; |
3833 | -drop table showtemp.t3; |
3834 | -drop database showtemp; |
3835 | - |
3836 | -connection default; |
3837 | -disconnect stcon1; |
3838 | - |
3839 | -# Wait till all disconnects are completed |
3840 | ---source include/wait_until_count_sessions.inc |
3841 | |
3842 | === removed file 'mysql-test/percona_xtradb_admin_command.result' |
3843 | --- mysql-test/percona_xtradb_admin_command.result 2010-12-09 18:30:58 +0000 |
3844 | +++ mysql-test/percona_xtradb_admin_command.result 1970-01-01 00:00:00 +0000 |
3845 | @@ -1,6 +0,0 @@ |
3846 | -select * from information_schema.XTRADB_ADMIN_COMMAND; |
3847 | -result_message |
3848 | -No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL. |
3849 | -select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/; |
3850 | -result_message |
3851 | -Hello! |
3852 | |
3853 | === removed file 'mysql-test/percona_xtradb_admin_command.test' |
3854 | --- mysql-test/percona_xtradb_admin_command.test 2010-12-09 18:30:58 +0000 |
3855 | +++ mysql-test/percona_xtradb_admin_command.test 1970-01-01 00:00:00 +0000 |
3856 | @@ -1,3 +0,0 @@ |
3857 | ---source include/have_innodb.inc |
3858 | -select * from information_schema.XTRADB_ADMIN_COMMAND; |
3859 | -select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/; |
3860 | |
3861 | === removed file 'mysql-test/percona_xtradb_bug317074.result' |
3862 | --- mysql-test/percona_xtradb_bug317074.result 2011-01-13 04:34:53 +0000 |
3863 | +++ mysql-test/percona_xtradb_bug317074.result 1970-01-01 00:00:00 +0000 |
3864 | @@ -1,5 +0,0 @@ |
3865 | -SET @old_innodb_file_format=@@innodb_file_format; |
3866 | -SET @old_innodb_file_format_max=@@innodb_file_format_max; |
3867 | -SET @old_innodb_file_per_table=@@innodb_file_per_table; |
3868 | -SET GLOBAL innodb_file_format='Barracuda'; |
3869 | -SET GLOBAL innodb_file_per_table=ON; |
3870 | |
3871 | === removed file 'mysql-test/percona_xtradb_bug317074.test' |
3872 | --- mysql-test/percona_xtradb_bug317074.test 2011-01-13 04:34:53 +0000 |
3873 | +++ mysql-test/percona_xtradb_bug317074.test 1970-01-01 00:00:00 +0000 |
3874 | @@ -1,47 +0,0 @@ |
3875 | --- source include/have_innodb.inc |
3876 | - |
3877 | -SET @old_innodb_file_format=@@innodb_file_format; |
3878 | -SET @old_innodb_file_format_max=@@innodb_file_format_max; |
3879 | -SET @old_innodb_file_per_table=@@innodb_file_per_table; |
3880 | -SET GLOBAL innodb_file_format='Barracuda'; |
3881 | -SET GLOBAL innodb_file_per_table=ON; |
3882 | - |
3883 | --- disable_query_log |
3884 | --- disable_result_log |
3885 | - |
3886 | -DROP TABLE IF EXISTS `test1`; |
3887 | -CREATE TABLE IF NOT EXISTS `test1` ( |
3888 | - `a` int primary key auto_increment, |
3889 | - `b` int default 0, |
3890 | - `c` char(100) default 'testtest' |
3891 | -) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; |
3892 | - |
3893 | -delimiter |; |
3894 | -CREATE PROCEDURE insert_many(p1 int) |
3895 | -BEGIN |
3896 | -SET @x = 0; |
3897 | -SET @y = 0; |
3898 | -start transaction; |
3899 | -REPEAT |
3900 | - insert into test1 set b=1; |
3901 | - SET @x = @x + 1; |
3902 | - SET @y = @y + 1; |
3903 | - IF @y >= 1000 THEN |
3904 | - commit; |
3905 | - start transaction; |
3906 | - SET @y = 0; |
3907 | - END IF; |
3908 | -UNTIL @x >= p1 END REPEAT; |
3909 | -commit; |
3910 | -END| |
3911 | -delimiter ;| |
3912 | -call insert_many(100000); |
3913 | -DROP PROCEDURE insert_many; |
3914 | - |
3915 | -# The bug is hangup at the following statement |
3916 | -ALTER TABLE test1 ENGINE=MyISAM; |
3917 | - |
3918 | -DROP TABLE test1; |
3919 | -SET GLOBAL innodb_file_format=@old_innodb_file_format; |
3920 | -SET GLOBAL innodb_file_format_max=@old_innodb_file_format_max; |
3921 | -SET GLOBAL innodb_file_per_table=@old_innodb_file_per_table; |
3922 | |
3923 | === removed directory 'mysql-test/processlist_row_stats.patch' |
3924 | === removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result' |
3925 | --- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result 2011-08-03 16:08:46 +0000 |
3926 | +++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result 1970-01-01 00:00:00 +0000 |
3927 | @@ -1,70 +0,0 @@ |
3928 | -DROP TABLE IF EXISTS t1; |
3929 | -DROP TABLE IF EXISTS t2; |
3930 | -CREATE TABLE t2 (a INT); |
3931 | -INSERT INTO t2 VALUES(10); |
3932 | -INSERT INTO t2 VALUES(10); |
3933 | -INSERT INTO t2 VALUES(20); |
3934 | -INSERT INTO t2 VALUES(10); |
3935 | -INSERT INTO t2 VALUES(20); |
3936 | -SET DEBUG_SYNC= 'locked_table_name SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
3937 | -CREATE TABLE t1 (a INT); |
3938 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
3939 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
3940 | -SELECT a FROM t2 WHERE a > 15; |
3941 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
3942 | -SHOW PROCESSLIST; |
3943 | -Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read |
3944 | -### root ### test Query ### ### SHOW PROCESSLIST 0 0 2 |
3945 | -### root ### test Query ### ### CREATE TABLE t1 (a INT) 0 0 1 |
3946 | -### root ### test Query ### ### SELECT a FROM t2 WHERE a > 15 2 5 6 |
3947 | -SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; |
3948 | -id info rows_sent rows_examined rows_read |
3949 | -### SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id 0 0 1 |
3950 | -### CREATE TABLE t1 (a INT) 0 0 1 |
3951 | -### SELECT a FROM t2 WHERE a > 15 2 5 6 |
3952 | -SET DEBUG_SYNC= 'now SIGNAL threads_dumped'; |
3953 | -a |
3954 | -20 |
3955 | -20 |
3956 | -SET DEBUG_SYNC= 'sent_row SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
3957 | -SELECT a FROM t2 WHERE a < 15; |
3958 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
3959 | -SET DEBUG_SYNC= 'sent_row SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
3960 | -SELECT a FROM t2 WHERE a > 15; |
3961 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
3962 | -SHOW PROCESSLIST; |
3963 | -Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read |
3964 | -### root ### test Query ### ### SHOW PROCESSLIST 0 0 4 |
3965 | -### root ### test Query ### ### SELECT a FROM t2 WHERE a < 15 1 0 1 |
3966 | -### root ### test Query ### ### SELECT a FROM t2 WHERE a > 15 1 0 3 |
3967 | -SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; |
3968 | -id info rows_sent rows_examined rows_read |
3969 | -### SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id 0 0 1 |
3970 | -### SELECT a FROM t2 WHERE a < 15 1 0 1 |
3971 | -### SELECT a FROM t2 WHERE a > 15 1 0 3 |
3972 | -SET DEBUG_SYNC= 'now SIGNAL threads_dumped'; |
3973 | -a |
3974 | -10 |
3975 | -10 |
3976 | -10 |
3977 | -a |
3978 | -20 |
3979 | -20 |
3980 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
3981 | -UPDATE t2 SET a = 15 WHERE a = 20; |
3982 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
3983 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
3984 | -UPDATE t2 SET a = 15 WHERE a = 10; |
3985 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
3986 | -SHOW PROCESSLIST; |
3987 | -Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read |
3988 | -### root ### test Query ### ### SHOW PROCESSLIST 0 0 4 |
3989 | -### root ### test Query ### ### UPDATE t2 SET a = 15 WHERE a = 20 0 5 6 |
3990 | -### root ### test Query ### ### UPDATE t2 SET a = 15 WHERE a = 10 0 5 6 |
3991 | -SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; |
3992 | -id info rows_sent rows_examined rows_read |
3993 | -### SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id 0 0 1 |
3994 | -### UPDATE t2 SET a = 15 WHERE a = 20 0 5 6 |
3995 | -### UPDATE t2 SET a = 15 WHERE a = 10 0 5 6 |
3996 | -SET DEBUG_SYNC= 'now SIGNAL threads_dumped'; |
3997 | -DROP TABLES t1, t2; |
3998 | |
3999 | === removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test' |
4000 | --- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test 2011-08-03 16:08:46 +0000 |
4001 | +++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test 1970-01-01 00:00:00 +0000 |
4002 | @@ -1,79 +0,0 @@ |
4003 | -# Testing of INFORMATION_SCHEMA.PROCESSLIST fields ROWS_SENT, ROWS_EXAMINED, ROWS_READ |
4004 | ---source include/have_debug_sync.inc |
4005 | - |
4006 | ---disable_warnings |
4007 | -DROP TABLE IF EXISTS t1; |
4008 | -DROP TABLE IF EXISTS t2; |
4009 | ---enable_warnings |
4010 | - |
4011 | -CREATE TABLE t2 (a INT); |
4012 | -INSERT INTO t2 VALUES(10); |
4013 | -INSERT INTO t2 VALUES(10); |
4014 | -INSERT INTO t2 VALUES(20); |
4015 | -INSERT INTO t2 VALUES(10); |
4016 | -INSERT INTO t2 VALUES(20); |
4017 | - |
4018 | ---connect (conn1, localhost, root, ,) |
4019 | ---connect (conn2, localhost, root, ,) |
4020 | - |
4021 | ---connection conn1 |
4022 | -SET DEBUG_SYNC= 'locked_table_name SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
4023 | -send CREATE TABLE t1 (a INT); |
4024 | ---connection default |
4025 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
4026 | - |
4027 | ---connection conn2 |
4028 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
4029 | -send SELECT a FROM t2 WHERE a > 15; |
4030 | ---connection default |
4031 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
4032 | - |
4033 | ---source include/percona_processlist_row_stats_show.inc |
4034 | - |
4035 | ---connection conn1 |
4036 | -reap; |
4037 | ---connection conn2 |
4038 | -reap; |
4039 | - |
4040 | ---connection conn1 |
4041 | -SET DEBUG_SYNC= 'sent_row SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
4042 | -send SELECT a FROM t2 WHERE a < 15; |
4043 | ---connection default |
4044 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
4045 | - |
4046 | ---connection conn2 |
4047 | -SET DEBUG_SYNC= 'sent_row SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
4048 | -send SELECT a FROM t2 WHERE a > 15; |
4049 | ---connection default |
4050 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
4051 | - |
4052 | ---source include/percona_processlist_row_stats_show.inc |
4053 | - |
4054 | ---connection conn1 |
4055 | -reap; |
4056 | ---connection conn2 |
4057 | -reap; |
4058 | - |
4059 | ---connection conn1 |
4060 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread1_ready WAIT_FOR threads_dumped'; |
4061 | -send UPDATE t2 SET a = 15 WHERE a = 20; |
4062 | ---connection default |
4063 | -SET DEBUG_SYNC= 'now WAIT_FOR thread1_ready'; |
4064 | - |
4065 | ---connection conn2 |
4066 | -SET DEBUG_SYNC= 'execute_command_after_close_tables SIGNAL thread2_ready WAIT_FOR threads_dumped'; |
4067 | -send UPDATE t2 SET a = 15 WHERE a = 10; |
4068 | ---connection default |
4069 | -SET DEBUG_SYNC= 'now WAIT_FOR thread2_ready'; |
4070 | - |
4071 | ---source include/percona_processlist_row_stats_show.inc |
4072 | - |
4073 | ---connection conn1 |
4074 | -reap; |
4075 | ---connection conn2 |
4076 | -reap; |
4077 | - |
4078 | ---connection default |
4079 | -disconnect conn1; |
4080 | -disconnect conn2; |
4081 | -DROP TABLES t1, t2; |
4082 | |
4083 | === removed file 'mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc' |
4084 | --- mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc 2011-08-03 16:08:46 +0000 |
4085 | +++ mysql-test/processlist_row_stats.patch/percona_processlist_row_stats_show.inc 1970-01-01 00:00:00 +0000 |
4086 | @@ -1,7 +0,0 @@ |
4087 | ---replace_column 1 ### 3 ### 6 ### 7 ### |
4088 | -SHOW PROCESSLIST; |
4089 | - |
4090 | ---replace_column 1 ### |
4091 | -SELECT id, info, rows_sent, rows_examined, rows_read FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; |
4092 | - |
4093 | -SET DEBUG_SYNC= 'now SIGNAL threads_dumped'; |
4094 | |
4095 | === removed directory 'mysql-test/query_cache_enhance.patch' |
4096 | === removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc' |
4097 | --- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 2010-12-09 18:30:58 +0000 |
4098 | +++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 1970-01-01 00:00:00 +0000 |
4099 | @@ -1,95 +0,0 @@ |
4100 | ---source include/percona_query_cache_with_comments_clear.inc |
4101 | -let $query=/* with comment first */select * from t1; |
4102 | -eval $query; |
4103 | ---source include/percona_query_cache_with_comments_eval.inc |
4104 | - |
4105 | -let $query=# with comment first |
4106 | -select * from t1; |
4107 | ---source include/percona_query_cache_with_comments_eval.inc |
4108 | - |
4109 | -let $query=-- with comment first |
4110 | -select * from t1; |
4111 | ---source include/percona_query_cache_with_comments_eval.inc |
4112 | - |
4113 | -let $query=/* with comment first and "quote" */select * from t1; |
4114 | ---source include/percona_query_cache_with_comments_eval.inc |
4115 | - |
4116 | -let $query=# with comment first and "quote" |
4117 | -select * from t1; |
4118 | ---source include/percona_query_cache_with_comments_eval.inc |
4119 | - |
4120 | -let $query=-- with comment first and "quote" |
4121 | -select * from t1; |
4122 | ---source include/percona_query_cache_with_comments_eval.inc |
4123 | - |
4124 | -let $query= |
4125 | - /* with comment and whitespaces first */select * from t1; |
4126 | ---source include/percona_query_cache_with_comments_eval.inc |
4127 | - |
4128 | -let $query= |
4129 | - # with comment and whitespaces first |
4130 | -select * from t1; |
4131 | ---source include/percona_query_cache_with_comments_eval.inc |
4132 | - |
4133 | -let $query= |
4134 | - -- with comment and whitespaces first |
4135 | -select * from t1; |
4136 | ---source include/percona_query_cache_with_comments_eval.inc |
4137 | - |
4138 | -let $internal=* internal comment *; |
4139 | - |
4140 | -let $query=select * /$internal/ from t1; |
4141 | ---source include/percona_query_cache_with_comments_eval.inc |
4142 | -let $query=select */$internal/ from t1; |
4143 | ---source include/percona_query_cache_with_comments_eval.inc |
4144 | -let $query=select */$internal/from t1; |
4145 | ---source include/percona_query_cache_with_comments_eval.inc |
4146 | - |
4147 | -let $internal=* internal comment with "quote" *; |
4148 | - |
4149 | -let $query=select * /$internal/ from t1; |
4150 | ---source include/percona_query_cache_with_comments_eval.inc |
4151 | -let $query=select */$internal/ from t1; |
4152 | ---source include/percona_query_cache_with_comments_eval.inc |
4153 | -let $query=select */$internal/from t1; |
4154 | ---source include/percona_query_cache_with_comments_eval.inc |
4155 | - |
4156 | -let $query=select * from t1 |
4157 | -; |
4158 | ---source include/percona_query_cache_with_comments_eval.inc |
4159 | - |
4160 | -let $query=select * from t1 ; |
4161 | ---source include/percona_query_cache_with_comments_eval.inc |
4162 | - |
4163 | -let $query=select * from t1 ; |
4164 | ---source include/percona_query_cache_with_comments_eval.inc |
4165 | - |
4166 | -let $query=select * from t1 |
4167 | -/* comment in the end */; |
4168 | ---source include/percona_query_cache_with_comments_eval.inc |
4169 | - |
4170 | -let $query=select * from t1 |
4171 | -/* *\/ */; |
4172 | ---source include/percona_query_cache_with_comments_eval.inc |
4173 | - |
4174 | -let $query=select * from t1 |
4175 | -/* comment in the end */ |
4176 | -; |
4177 | ---source include/percona_query_cache_with_comments_eval.inc |
4178 | - |
4179 | -let $query=select * from t1 #comment in the end; |
4180 | ---source include/percona_query_cache_with_comments_eval.inc |
4181 | - |
4182 | -let $query=select * from t1 #comment in the end |
4183 | -; |
4184 | ---source include/percona_query_cache_with_comments_eval.inc |
4185 | - |
4186 | -let $query=select * from t1 -- comment in the end; |
4187 | ---source include/percona_query_cache_with_comments_eval.inc |
4188 | - |
4189 | -let $query=select * from t1 -- comment in the end |
4190 | -; |
4191 | ---source include/percona_query_cache_with_comments_eval.inc |
4192 | - |
4193 | -let $query=select ' \' ' from t1; |
4194 | ---source include/percona_query_cache_with_comments_eval.inc |
4195 | |
4196 | === removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup' |
4197 | --- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 2010-12-09 18:30:58 +0000 |
4198 | +++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 1970-01-01 00:00:00 +0000 |
4199 | @@ -1,88 +0,0 @@ |
4200 | ---source include/percona_query_cache_with_comments_clear.inc |
4201 | -let $query=/* with comment first */select * from t1; |
4202 | -eval $query; |
4203 | ---source include/percona_query_cache_with_comments_eval.inc |
4204 | - |
4205 | -let $query=# with comment first |
4206 | -select * from t1; |
4207 | ---source include/percona_query_cache_with_comments_eval.inc |
4208 | - |
4209 | -let $query=-- with comment first |
4210 | -select * from t1; |
4211 | ---source include/percona_query_cache_with_comments_eval.inc |
4212 | - |
4213 | -let $query=/* with comment first and "quote" */select * from t1; |
4214 | ---source include/percona_query_cache_with_comments_eval.inc |
4215 | - |
4216 | -let $query=# with comment first and "quote" |
4217 | -select * from t1; |
4218 | ---source include/percona_query_cache_with_comments_eval.inc |
4219 | - |
4220 | -let $query=-- with comment first and "quote" |
4221 | -select * from t1; |
4222 | ---source include/percona_query_cache_with_comments_eval.inc |
4223 | - |
4224 | -let $query= |
4225 | - /* with comment and whitespaces first */select * from t1; |
4226 | ---source include/percona_query_cache_with_comments_eval.inc |
4227 | - |
4228 | -let $query= |
4229 | - # with comment and whitespaces first |
4230 | -select * from t1; |
4231 | ---source include/percona_query_cache_with_comments_eval.inc |
4232 | - |
4233 | -let $query= |
4234 | - -- with comment and whitespaces first |
4235 | -select * from t1; |
4236 | ---source include/percona_query_cache_with_comments_eval.inc |
4237 | - |
4238 | -let $internal=* internal comment *; |
4239 | - |
4240 | -let $query=select * /$internal/ from t1; |
4241 | ---source include/percona_query_cache_with_comments_eval.inc |
4242 | -let $query=select */$internal/ from t1; |
4243 | ---source include/percona_query_cache_with_comments_eval.inc |
4244 | -let $query=select */$internal/from t1; |
4245 | ---source include/percona_query_cache_with_comments_eval.inc |
4246 | - |
4247 | -let $internal=* internal comment with "quote" *; |
4248 | - |
4249 | -let $query=select * /$internal/ from t1; |
4250 | ---source include/percona_query_cache_with_comments_eval.inc |
4251 | -let $query=select */$internal/ from t1; |
4252 | ---source include/percona_query_cache_with_comments_eval.inc |
4253 | -let $query=select */$internal/from t1; |
4254 | ---source include/percona_query_cache_with_comments_eval.inc |
4255 | - |
4256 | -let $query=select * from t1 |
4257 | -; |
4258 | ---source include/percona_query_cache_with_comments_eval.inc |
4259 | - |
4260 | -let $query=select * from t1 ; |
4261 | ---source include/percona_query_cache_with_comments_eval.inc |
4262 | - |
4263 | -let $query=select * from t1 ; |
4264 | ---source include/percona_query_cache_with_comments_eval.inc |
4265 | - |
4266 | -let $query=select * from t1 |
4267 | -/* comment in the end */; |
4268 | ---source include/percona_query_cache_with_comments_eval.inc |
4269 | - |
4270 | -let $query=select * from t1 |
4271 | -/* comment in the end */ |
4272 | -; |
4273 | ---source include/percona_query_cache_with_comments_eval.inc |
4274 | - |
4275 | -let $query=select * from t1 #comment in the end; |
4276 | ---source include/percona_query_cache_with_comments_eval.inc |
4277 | - |
4278 | -let $query=select * from t1 #comment in the end |
4279 | -; |
4280 | ---source include/percona_query_cache_with_comments_eval.inc |
4281 | - |
4282 | -let $query=select * from t1 -- comment in the end; |
4283 | ---source include/percona_query_cache_with_comments_eval.inc |
4284 | - |
4285 | -let $query=select * from t1 -- comment in the end |
4286 | -; |
4287 | ---source include/percona_query_cache_with_comments_eval.inc |
4288 | |
4289 | === removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result' |
4290 | --- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 2010-12-09 18:30:58 +0000 |
4291 | +++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 1970-01-01 00:00:00 +0000 |
4292 | @@ -1,866 +0,0 @@ |
4293 | -set global query_cache_strip_comments=ON; |
4294 | -set GLOBAL query_cache_size=1355776; |
4295 | -drop table if exists t1; |
4296 | -create table t1 (a int not null); |
4297 | -insert into t1 values (1),(2),(3); |
4298 | -flush query cache; |
4299 | -flush query cache; |
4300 | -reset query cache; |
4301 | -flush status; |
4302 | -flush query cache; |
4303 | -flush query cache; |
4304 | -reset query cache; |
4305 | -flush status; |
4306 | -/* with comment first */select * from t1; |
4307 | -a |
4308 | -1 |
4309 | -2 |
4310 | -3 |
4311 | ------------------------------------------------------ |
4312 | -/* with comment first */select * from t1 |
4313 | ------------------------------------------------------ |
4314 | -show status like "Qcache_queries_in_cache"; |
4315 | -Variable_name Value |
4316 | -Qcache_queries_in_cache 1 |
4317 | -show status like "Qcache_inserts"; |
4318 | -Variable_name Value |
4319 | -Qcache_inserts 1 |
4320 | -show status like "Qcache_hits"; |
4321 | -Variable_name Value |
4322 | -Qcache_hits 0 |
4323 | -/* with comment first */select * from t1; |
4324 | -a |
4325 | -1 |
4326 | -2 |
4327 | -3 |
4328 | -/* with comment first */select * from t1; |
4329 | -a |
4330 | -1 |
4331 | -2 |
4332 | -3 |
4333 | -show status like "Qcache_queries_in_cache"; |
4334 | -Variable_name Value |
4335 | -Qcache_queries_in_cache 1 |
4336 | -show status like "Qcache_inserts"; |
4337 | -Variable_name Value |
4338 | -Qcache_inserts 1 |
4339 | -show status like "Qcache_hits"; |
4340 | -Variable_name Value |
4341 | -Qcache_hits 2 |
4342 | ------------------------------------------------------ |
4343 | -# with comment first |
4344 | -select * from t1 |
4345 | ------------------------------------------------------ |
4346 | -show status like "Qcache_queries_in_cache"; |
4347 | -Variable_name Value |
4348 | -Qcache_queries_in_cache 1 |
4349 | -show status like "Qcache_inserts"; |
4350 | -Variable_name Value |
4351 | -Qcache_inserts 1 |
4352 | -show status like "Qcache_hits"; |
4353 | -Variable_name Value |
4354 | -Qcache_hits 2 |
4355 | -# with comment first |
4356 | -select * from t1; |
4357 | -a |
4358 | -1 |
4359 | -2 |
4360 | -3 |
4361 | -# with comment first |
4362 | -select * from t1; |
4363 | -a |
4364 | -1 |
4365 | -2 |
4366 | -3 |
4367 | -show status like "Qcache_queries_in_cache"; |
4368 | -Variable_name Value |
4369 | -Qcache_queries_in_cache 1 |
4370 | -show status like "Qcache_inserts"; |
4371 | -Variable_name Value |
4372 | -Qcache_inserts 1 |
4373 | -show status like "Qcache_hits"; |
4374 | -Variable_name Value |
4375 | -Qcache_hits 4 |
4376 | ------------------------------------------------------ |
4377 | --- with comment first |
4378 | -select * from t1 |
4379 | ------------------------------------------------------ |
4380 | -show status like "Qcache_queries_in_cache"; |
4381 | -Variable_name Value |
4382 | -Qcache_queries_in_cache 1 |
4383 | -show status like "Qcache_inserts"; |
4384 | -Variable_name Value |
4385 | -Qcache_inserts 1 |
4386 | -show status like "Qcache_hits"; |
4387 | -Variable_name Value |
4388 | -Qcache_hits 4 |
4389 | --- with comment first |
4390 | -select * from t1; |
4391 | -a |
4392 | -1 |
4393 | -2 |
4394 | -3 |
4395 | --- with comment first |
4396 | -select * from t1; |
4397 | -a |
4398 | -1 |
4399 | -2 |
4400 | -3 |
4401 | -show status like "Qcache_queries_in_cache"; |
4402 | -Variable_name Value |
4403 | -Qcache_queries_in_cache 1 |
4404 | -show status like "Qcache_inserts"; |
4405 | -Variable_name Value |
4406 | -Qcache_inserts 1 |
4407 | -show status like "Qcache_hits"; |
4408 | -Variable_name Value |
4409 | -Qcache_hits 6 |
4410 | ------------------------------------------------------ |
4411 | -/* with comment first and "quote" */select * from t1 |
4412 | ------------------------------------------------------ |
4413 | -show status like "Qcache_queries_in_cache"; |
4414 | -Variable_name Value |
4415 | -Qcache_queries_in_cache 1 |
4416 | -show status like "Qcache_inserts"; |
4417 | -Variable_name Value |
4418 | -Qcache_inserts 1 |
4419 | -show status like "Qcache_hits"; |
4420 | -Variable_name Value |
4421 | -Qcache_hits 6 |
4422 | -/* with comment first and "quote" */select * from t1; |
4423 | -a |
4424 | -1 |
4425 | -2 |
4426 | -3 |
4427 | -/* with comment first and "quote" */select * from t1; |
4428 | -a |
4429 | -1 |
4430 | -2 |
4431 | -3 |
4432 | -show status like "Qcache_queries_in_cache"; |
4433 | -Variable_name Value |
4434 | -Qcache_queries_in_cache 1 |
4435 | -show status like "Qcache_inserts"; |
4436 | -Variable_name Value |
4437 | -Qcache_inserts 1 |
4438 | -show status like "Qcache_hits"; |
4439 | -Variable_name Value |
4440 | -Qcache_hits 8 |
4441 | ------------------------------------------------------ |
4442 | -# with comment first and "quote" |
4443 | -select * from t1 |
4444 | ------------------------------------------------------ |
4445 | -show status like "Qcache_queries_in_cache"; |
4446 | -Variable_name Value |
4447 | -Qcache_queries_in_cache 1 |
4448 | -show status like "Qcache_inserts"; |
4449 | -Variable_name Value |
4450 | -Qcache_inserts 1 |
4451 | -show status like "Qcache_hits"; |
4452 | -Variable_name Value |
4453 | -Qcache_hits 8 |
4454 | -# with comment first and "quote" |
4455 | -select * from t1; |
4456 | -a |
4457 | -1 |
4458 | -2 |
4459 | -3 |
4460 | -# with comment first and "quote" |
4461 | -select * from t1; |
4462 | -a |
4463 | -1 |
4464 | -2 |
4465 | -3 |
4466 | -show status like "Qcache_queries_in_cache"; |
4467 | -Variable_name Value |
4468 | -Qcache_queries_in_cache 1 |
4469 | -show status like "Qcache_inserts"; |
4470 | -Variable_name Value |
4471 | -Qcache_inserts 1 |
4472 | -show status like "Qcache_hits"; |
4473 | -Variable_name Value |
4474 | -Qcache_hits 10 |
4475 | ------------------------------------------------------ |
4476 | --- with comment first and "quote" |
4477 | -select * from t1 |
4478 | ------------------------------------------------------ |
4479 | -show status like "Qcache_queries_in_cache"; |
4480 | -Variable_name Value |
4481 | -Qcache_queries_in_cache 1 |
4482 | -show status like "Qcache_inserts"; |
4483 | -Variable_name Value |
4484 | -Qcache_inserts 1 |
4485 | -show status like "Qcache_hits"; |
4486 | -Variable_name Value |
4487 | -Qcache_hits 10 |
4488 | --- with comment first and "quote" |
4489 | -select * from t1; |
4490 | -a |
4491 | -1 |
4492 | -2 |
4493 | -3 |
4494 | --- with comment first and "quote" |
4495 | -select * from t1; |
4496 | -a |
4497 | -1 |
4498 | -2 |
4499 | -3 |
4500 | -show status like "Qcache_queries_in_cache"; |
4501 | -Variable_name Value |
4502 | -Qcache_queries_in_cache 1 |
4503 | -show status like "Qcache_inserts"; |
4504 | -Variable_name Value |
4505 | -Qcache_inserts 1 |
4506 | -show status like "Qcache_hits"; |
4507 | -Variable_name Value |
4508 | -Qcache_hits 12 |
4509 | ------------------------------------------------------ |
4510 | -/* with comment and whitespaces first */select * from t1 |
4511 | ------------------------------------------------------ |
4512 | -show status like "Qcache_queries_in_cache"; |
4513 | -Variable_name Value |
4514 | -Qcache_queries_in_cache 1 |
4515 | -show status like "Qcache_inserts"; |
4516 | -Variable_name Value |
4517 | -Qcache_inserts 1 |
4518 | -show status like "Qcache_hits"; |
4519 | -Variable_name Value |
4520 | -Qcache_hits 12 |
4521 | -/* with comment and whitespaces first */select * from t1; |
4522 | -a |
4523 | -1 |
4524 | -2 |
4525 | -3 |
4526 | -/* with comment and whitespaces first */select * from t1; |
4527 | -a |
4528 | -1 |
4529 | -2 |
4530 | -3 |
4531 | -show status like "Qcache_queries_in_cache"; |
4532 | -Variable_name Value |
4533 | -Qcache_queries_in_cache 1 |
4534 | -show status like "Qcache_inserts"; |
4535 | -Variable_name Value |
4536 | -Qcache_inserts 1 |
4537 | -show status like "Qcache_hits"; |
4538 | -Variable_name Value |
4539 | -Qcache_hits 14 |
4540 | ------------------------------------------------------ |
4541 | -# with comment and whitespaces first |
4542 | -select * from t1 |
4543 | ------------------------------------------------------ |
4544 | -show status like "Qcache_queries_in_cache"; |
4545 | -Variable_name Value |
4546 | -Qcache_queries_in_cache 1 |
4547 | -show status like "Qcache_inserts"; |
4548 | -Variable_name Value |
4549 | -Qcache_inserts 1 |
4550 | -show status like "Qcache_hits"; |
4551 | -Variable_name Value |
4552 | -Qcache_hits 14 |
4553 | -# with comment and whitespaces first |
4554 | -select * from t1; |
4555 | -a |
4556 | -1 |
4557 | -2 |
4558 | -3 |
4559 | -# with comment and whitespaces first |
4560 | -select * from t1; |
4561 | -a |
4562 | -1 |
4563 | -2 |
4564 | -3 |
4565 | -show status like "Qcache_queries_in_cache"; |
4566 | -Variable_name Value |
4567 | -Qcache_queries_in_cache 1 |
4568 | -show status like "Qcache_inserts"; |
4569 | -Variable_name Value |
4570 | -Qcache_inserts 1 |
4571 | -show status like "Qcache_hits"; |
4572 | -Variable_name Value |
4573 | -Qcache_hits 16 |
4574 | ------------------------------------------------------ |
4575 | --- with comment and whitespaces first |
4576 | -select * from t1 |
4577 | ------------------------------------------------------ |
4578 | -show status like "Qcache_queries_in_cache"; |
4579 | -Variable_name Value |
4580 | -Qcache_queries_in_cache 1 |
4581 | -show status like "Qcache_inserts"; |
4582 | -Variable_name Value |
4583 | -Qcache_inserts 1 |
4584 | -show status like "Qcache_hits"; |
4585 | -Variable_name Value |
4586 | -Qcache_hits 16 |
4587 | --- with comment and whitespaces first |
4588 | -select * from t1; |
4589 | -a |
4590 | -1 |
4591 | -2 |
4592 | -3 |
4593 | --- with comment and whitespaces first |
4594 | -select * from t1; |
4595 | -a |
4596 | -1 |
4597 | -2 |
4598 | -3 |
4599 | -show status like "Qcache_queries_in_cache"; |
4600 | -Variable_name Value |
4601 | -Qcache_queries_in_cache 1 |
4602 | -show status like "Qcache_inserts"; |
4603 | -Variable_name Value |
4604 | -Qcache_inserts 1 |
4605 | -show status like "Qcache_hits"; |
4606 | -Variable_name Value |
4607 | -Qcache_hits 18 |
4608 | ------------------------------------------------------ |
4609 | -select * /* internal comment */ from t1 |
4610 | ------------------------------------------------------ |
4611 | -show status like "Qcache_queries_in_cache"; |
4612 | -Variable_name Value |
4613 | -Qcache_queries_in_cache 1 |
4614 | -show status like "Qcache_inserts"; |
4615 | -Variable_name Value |
4616 | -Qcache_inserts 1 |
4617 | -show status like "Qcache_hits"; |
4618 | -Variable_name Value |
4619 | -Qcache_hits 18 |
4620 | -select * /* internal comment */ from t1; |
4621 | -a |
4622 | -1 |
4623 | -2 |
4624 | -3 |
4625 | -select * /* internal comment */ from t1; |
4626 | -a |
4627 | -1 |
4628 | -2 |
4629 | -3 |
4630 | -show status like "Qcache_queries_in_cache"; |
4631 | -Variable_name Value |
4632 | -Qcache_queries_in_cache 1 |
4633 | -show status like "Qcache_inserts"; |
4634 | -Variable_name Value |
4635 | -Qcache_inserts 1 |
4636 | -show status like "Qcache_hits"; |
4637 | -Variable_name Value |
4638 | -Qcache_hits 20 |
4639 | ------------------------------------------------------ |
4640 | -select */* internal comment */ from t1 |
4641 | ------------------------------------------------------ |
4642 | -show status like "Qcache_queries_in_cache"; |
4643 | -Variable_name Value |
4644 | -Qcache_queries_in_cache 1 |
4645 | -show status like "Qcache_inserts"; |
4646 | -Variable_name Value |
4647 | -Qcache_inserts 1 |
4648 | -show status like "Qcache_hits"; |
4649 | -Variable_name Value |
4650 | -Qcache_hits 20 |
4651 | -select */* internal comment */ from t1; |
4652 | -a |
4653 | -1 |
4654 | -2 |
4655 | -3 |
4656 | -select */* internal comment */ from t1; |
4657 | -a |
4658 | -1 |
4659 | -2 |
4660 | -3 |
4661 | -show status like "Qcache_queries_in_cache"; |
4662 | -Variable_name Value |
4663 | -Qcache_queries_in_cache 1 |
4664 | -show status like "Qcache_inserts"; |
4665 | -Variable_name Value |
4666 | -Qcache_inserts 1 |
4667 | -show status like "Qcache_hits"; |
4668 | -Variable_name Value |
4669 | -Qcache_hits 22 |
4670 | ------------------------------------------------------ |
4671 | -select */* internal comment */from t1 |
4672 | ------------------------------------------------------ |
4673 | -show status like "Qcache_queries_in_cache"; |
4674 | -Variable_name Value |
4675 | -Qcache_queries_in_cache 1 |
4676 | -show status like "Qcache_inserts"; |
4677 | -Variable_name Value |
4678 | -Qcache_inserts 1 |
4679 | -show status like "Qcache_hits"; |
4680 | -Variable_name Value |
4681 | -Qcache_hits 22 |
4682 | -select */* internal comment */from t1; |
4683 | -a |
4684 | -1 |
4685 | -2 |
4686 | -3 |
4687 | -select */* internal comment */from t1; |
4688 | -a |
4689 | -1 |
4690 | -2 |
4691 | -3 |
4692 | -show status like "Qcache_queries_in_cache"; |
4693 | -Variable_name Value |
4694 | -Qcache_queries_in_cache 1 |
4695 | -show status like "Qcache_inserts"; |
4696 | -Variable_name Value |
4697 | -Qcache_inserts 1 |
4698 | -show status like "Qcache_hits"; |
4699 | -Variable_name Value |
4700 | -Qcache_hits 24 |
4701 | ------------------------------------------------------ |
4702 | -select * /* internal comment with "quote" */ from t1 |
4703 | ------------------------------------------------------ |
4704 | -show status like "Qcache_queries_in_cache"; |
4705 | -Variable_name Value |
4706 | -Qcache_queries_in_cache 1 |
4707 | -show status like "Qcache_inserts"; |
4708 | -Variable_name Value |
4709 | -Qcache_inserts 1 |
4710 | -show status like "Qcache_hits"; |
4711 | -Variable_name Value |
4712 | -Qcache_hits 24 |
4713 | -select * /* internal comment with "quote" */ from t1; |
4714 | -a |
4715 | -1 |
4716 | -2 |
4717 | -3 |
4718 | -select * /* internal comment with "quote" */ from t1; |
4719 | -a |
4720 | -1 |
4721 | -2 |
4722 | -3 |
4723 | -show status like "Qcache_queries_in_cache"; |
4724 | -Variable_name Value |
4725 | -Qcache_queries_in_cache 1 |
4726 | -show status like "Qcache_inserts"; |
4727 | -Variable_name Value |
4728 | -Qcache_inserts 1 |
4729 | -show status like "Qcache_hits"; |
4730 | -Variable_name Value |
4731 | -Qcache_hits 26 |
4732 | ------------------------------------------------------ |
4733 | -select */* internal comment with "quote" */ from t1 |
4734 | ------------------------------------------------------ |
4735 | -show status like "Qcache_queries_in_cache"; |
4736 | -Variable_name Value |
4737 | -Qcache_queries_in_cache 1 |
4738 | -show status like "Qcache_inserts"; |
4739 | -Variable_name Value |
4740 | -Qcache_inserts 1 |
4741 | -show status like "Qcache_hits"; |
4742 | -Variable_name Value |
4743 | -Qcache_hits 26 |
4744 | -select */* internal comment with "quote" */ from t1; |
4745 | -a |
4746 | -1 |
4747 | -2 |
4748 | -3 |
4749 | -select */* internal comment with "quote" */ from t1; |
4750 | -a |
4751 | -1 |
4752 | -2 |
4753 | -3 |
4754 | -show status like "Qcache_queries_in_cache"; |
4755 | -Variable_name Value |
4756 | -Qcache_queries_in_cache 1 |
4757 | -show status like "Qcache_inserts"; |
4758 | -Variable_name Value |
4759 | -Qcache_inserts 1 |
4760 | -show status like "Qcache_hits"; |
4761 | -Variable_name Value |
4762 | -Qcache_hits 28 |
4763 | ------------------------------------------------------ |
4764 | -select */* internal comment with "quote" */from t1 |
4765 | ------------------------------------------------------ |
4766 | -show status like "Qcache_queries_in_cache"; |
4767 | -Variable_name Value |
4768 | -Qcache_queries_in_cache 1 |
4769 | -show status like "Qcache_inserts"; |
4770 | -Variable_name Value |
4771 | -Qcache_inserts 1 |
4772 | -show status like "Qcache_hits"; |
4773 | -Variable_name Value |
4774 | -Qcache_hits 28 |
4775 | -select */* internal comment with "quote" */from t1; |
4776 | -a |
4777 | -1 |
4778 | -2 |
4779 | -3 |
4780 | -select */* internal comment with "quote" */from t1; |
4781 | -a |
4782 | -1 |
4783 | -2 |
4784 | -3 |
4785 | -show status like "Qcache_queries_in_cache"; |
4786 | -Variable_name Value |
4787 | -Qcache_queries_in_cache 1 |
4788 | -show status like "Qcache_inserts"; |
4789 | -Variable_name Value |
4790 | -Qcache_inserts 1 |
4791 | -show status like "Qcache_hits"; |
4792 | -Variable_name Value |
4793 | -Qcache_hits 30 |
4794 | ------------------------------------------------------ |
4795 | -select * from t1 |
4796 | - |
4797 | ------------------------------------------------------ |
4798 | -show status like "Qcache_queries_in_cache"; |
4799 | -Variable_name Value |
4800 | -Qcache_queries_in_cache 1 |
4801 | -show status like "Qcache_inserts"; |
4802 | -Variable_name Value |
4803 | -Qcache_inserts 1 |
4804 | -show status like "Qcache_hits"; |
4805 | -Variable_name Value |
4806 | -Qcache_hits 30 |
4807 | -select * from t1 |
4808 | -; |
4809 | -a |
4810 | -1 |
4811 | -2 |
4812 | -3 |
4813 | -select * from t1 |
4814 | -; |
4815 | -a |
4816 | -1 |
4817 | -2 |
4818 | -3 |
4819 | -show status like "Qcache_queries_in_cache"; |
4820 | -Variable_name Value |
4821 | -Qcache_queries_in_cache 1 |
4822 | -show status like "Qcache_inserts"; |
4823 | -Variable_name Value |
4824 | -Qcache_inserts 1 |
4825 | -show status like "Qcache_hits"; |
4826 | -Variable_name Value |
4827 | -Qcache_hits 32 |
4828 | ------------------------------------------------------ |
4829 | -select * from t1 |
4830 | ------------------------------------------------------ |
4831 | -show status like "Qcache_queries_in_cache"; |
4832 | -Variable_name Value |
4833 | -Qcache_queries_in_cache 1 |
4834 | -show status like "Qcache_inserts"; |
4835 | -Variable_name Value |
4836 | -Qcache_inserts 1 |
4837 | -show status like "Qcache_hits"; |
4838 | -Variable_name Value |
4839 | -Qcache_hits 32 |
4840 | -select * from t1 ; |
4841 | -a |
4842 | -1 |
4843 | -2 |
4844 | -3 |
4845 | -select * from t1 ; |
4846 | -a |
4847 | -1 |
4848 | -2 |
4849 | -3 |
4850 | -show status like "Qcache_queries_in_cache"; |
4851 | -Variable_name Value |
4852 | -Qcache_queries_in_cache 1 |
4853 | -show status like "Qcache_inserts"; |
4854 | -Variable_name Value |
4855 | -Qcache_inserts 1 |
4856 | -show status like "Qcache_hits"; |
4857 | -Variable_name Value |
4858 | -Qcache_hits 34 |
4859 | ------------------------------------------------------ |
4860 | -select * from t1 |
4861 | ------------------------------------------------------ |
4862 | -show status like "Qcache_queries_in_cache"; |
4863 | -Variable_name Value |
4864 | -Qcache_queries_in_cache 1 |
4865 | -show status like "Qcache_inserts"; |
4866 | -Variable_name Value |
4867 | -Qcache_inserts 1 |
4868 | -show status like "Qcache_hits"; |
4869 | -Variable_name Value |
4870 | -Qcache_hits 34 |
4871 | -select * from t1 ; |
4872 | -a |
4873 | -1 |
4874 | -2 |
4875 | -3 |
4876 | -select * from t1 ; |
4877 | -a |
4878 | -1 |
4879 | -2 |
4880 | -3 |
4881 | -show status like "Qcache_queries_in_cache"; |
4882 | -Variable_name Value |
4883 | -Qcache_queries_in_cache 1 |
4884 | -show status like "Qcache_inserts"; |
4885 | -Variable_name Value |
4886 | -Qcache_inserts 1 |
4887 | -show status like "Qcache_hits"; |
4888 | -Variable_name Value |
4889 | -Qcache_hits 36 |
4890 | ------------------------------------------------------ |
4891 | -select * from t1 |
4892 | -/* comment in the end */ |
4893 | ------------------------------------------------------ |
4894 | -show status like "Qcache_queries_in_cache"; |
4895 | -Variable_name Value |
4896 | -Qcache_queries_in_cache 1 |
4897 | -show status like "Qcache_inserts"; |
4898 | -Variable_name Value |
4899 | -Qcache_inserts 1 |
4900 | -show status like "Qcache_hits"; |
4901 | -Variable_name Value |
4902 | -Qcache_hits 36 |
4903 | -select * from t1 |
4904 | -/* comment in the end */; |
4905 | -a |
4906 | -1 |
4907 | -2 |
4908 | -3 |
4909 | -select * from t1 |
4910 | -/* comment in the end */; |
4911 | -a |
4912 | -1 |
4913 | -2 |
4914 | -3 |
4915 | -show status like "Qcache_queries_in_cache"; |
4916 | -Variable_name Value |
4917 | -Qcache_queries_in_cache 1 |
4918 | -show status like "Qcache_inserts"; |
4919 | -Variable_name Value |
4920 | -Qcache_inserts 1 |
4921 | -show status like "Qcache_hits"; |
4922 | -Variable_name Value |
4923 | -Qcache_hits 38 |
4924 | ------------------------------------------------------ |
4925 | -select * from t1 |
4926 | -/* *\/ */ |
4927 | ------------------------------------------------------ |
4928 | -show status like "Qcache_queries_in_cache"; |
4929 | -Variable_name Value |
4930 | -Qcache_queries_in_cache 1 |
4931 | -show status like "Qcache_inserts"; |
4932 | -Variable_name Value |
4933 | -Qcache_inserts 1 |
4934 | -show status like "Qcache_hits"; |
4935 | -Variable_name Value |
4936 | -Qcache_hits 38 |
4937 | -select * from t1 |
4938 | -/* *\/ */; |
4939 | -a |
4940 | -1 |
4941 | -2 |
4942 | -3 |
4943 | -select * from t1 |
4944 | -/* *\/ */; |
4945 | -a |
4946 | -1 |
4947 | -2 |
4948 | -3 |
4949 | -show status like "Qcache_queries_in_cache"; |
4950 | -Variable_name Value |
4951 | -Qcache_queries_in_cache 1 |
4952 | -show status like "Qcache_inserts"; |
4953 | -Variable_name Value |
4954 | -Qcache_inserts 1 |
4955 | -show status like "Qcache_hits"; |
4956 | -Variable_name Value |
4957 | -Qcache_hits 40 |
4958 | ------------------------------------------------------ |
4959 | -select * from t1 |
4960 | -/* comment in the end */ |
4961 | - |
4962 | ------------------------------------------------------ |
4963 | -show status like "Qcache_queries_in_cache"; |
4964 | -Variable_name Value |
4965 | -Qcache_queries_in_cache 1 |
4966 | -show status like "Qcache_inserts"; |
4967 | -Variable_name Value |
4968 | -Qcache_inserts 1 |
4969 | -show status like "Qcache_hits"; |
4970 | -Variable_name Value |
4971 | -Qcache_hits 40 |
4972 | -select * from t1 |
4973 | -/* comment in the end */ |
4974 | -; |
4975 | -a |
4976 | -1 |
4977 | -2 |
4978 | -3 |
4979 | -select * from t1 |
4980 | -/* comment in the end */ |
4981 | -; |
4982 | -a |
4983 | -1 |
4984 | -2 |
4985 | -3 |
4986 | -show status like "Qcache_queries_in_cache"; |
4987 | -Variable_name Value |
4988 | -Qcache_queries_in_cache 1 |
4989 | -show status like "Qcache_inserts"; |
4990 | -Variable_name Value |
4991 | -Qcache_inserts 1 |
4992 | -show status like "Qcache_hits"; |
4993 | -Variable_name Value |
4994 | -Qcache_hits 42 |
4995 | ------------------------------------------------------ |
4996 | -select * from t1 #comment in the end |
4997 | ------------------------------------------------------ |
4998 | -show status like "Qcache_queries_in_cache"; |
4999 | -Variable_name Value |
5000 | -Qcache_queries_in_cache 1 |
The diff has been truncated for viewing.
I checked by
bzr update -r 158 && make all && mv Percona-Server-*-* 158
bzr update -r 159 && make all && mv Percona-Server-*-* 159
diff -ruN 158 159