Merge lp:~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109 into lp:ubuntu/precise/mysql-5.5

Proposed by Ubuntu Package Importer
Status: Rejected
Rejected by: James Westby
Proposed branch: lp:~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109
Merge into: lp:ubuntu/precise/mysql-5.5
Diff against target: 10401 lines (+10317/-0) (has conflicts)
10 files modified
.pc/38_scripts__mysqld_safe.sh__signals.patch/scripts/mysqld_safe.sh (+825/-0)
.pc/62_disable_tests.patch/mysql-test/t/disabled.def (+17/-0)
.pc/70_mysql_va_list.patch/sql-common/client_plugin.c (+472/-0)
.pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl/t/disabled.def (+17/-0)
.pc/72_fix_standalone_tests.patch/mysql-test/lib/mtr_cases.pm (+1265/-0)
.pc/applied-patches (+6/-0)
.pc/fix-mysqldump-test.patch/mysql-test/r/mysqldump.result (+5207/-0)
.pc/fix-mysqldump-test.patch/mysql-test/t/mysqldump.test (+2369/-0)
debian/patches/fix-mysqldump-test.patch (+53/-0)
debian/patches/link-clientprograms-dynamically.patch (+86/-0)
Conflict adding file .pc/38_scripts__mysqld_safe.sh__signals.patch.  Moved existing file to .pc/38_scripts__mysqld_safe.sh__signals.patch.moved.
Conflict adding file .pc/62_disable_tests.patch.  Moved existing file to .pc/62_disable_tests.patch.moved.
Conflict adding file .pc/70_mysql_va_list.patch.  Moved existing file to .pc/70_mysql_va_list.patch.moved.
Conflict adding file .pc/71_disable_rpl_tests.patch.  Moved existing file to .pc/71_disable_rpl_tests.patch.moved.
Conflict adding file .pc/72_fix_standalone_tests.patch.  Moved existing file to .pc/72_fix_standalone_tests.patch.moved.
Conflict adding file .pc/applied-patches.  Moved existing file to .pc/applied-patches.moved.
Conflict adding file .pc/fix-mysqldump-test.patch.  Moved existing file to .pc/fix-mysqldump-test.patch.moved.
Conflict adding file debian/patches/fix-mysqldump-test.patch.  Moved existing file to debian/patches/fix-mysqldump-test.patch.moved.
Conflict adding file debian/patches/link-clientprograms-dynamically.patch.  Moved existing file to debian/patches/link-clientprograms-dynamically.patch.moved.
To merge this branch: bzr merge lp:~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109
Reviewer Review Type Date Requested Status
Ubuntu Development Team Pending
Review via email: mp+100062@code.launchpad.net

Description of the change

The package importer has detected a possible inconsistency between the package history in the archive and the history in bzr. As the archive is authoritative the importer has made lp:ubuntu/precise/mysql-5.5 reflect what is in the archive and the old bzr branch has been pushed to lp:~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109. This merge proposal was created so that an Ubuntu developer can review the situations and perform a merge/upload if necessary. There are three typical cases where this can happen.
  1. Where someone pushes a change to bzr and someone else uploads the package without that change. This is the reason that this check is done by the importer. If this appears to be the case then a merge/upload should be done if the changes that were in bzr are still desirable.
  2. The importer incorrectly detected the above situation when someone made a change in bzr and then uploaded it.
  3. The importer incorrectly detected the above situation when someone just uploaded a package and didn't touch bzr.

If this case doesn't appear to be the first situation then set the status of the merge proposal to "Rejected" and help avoid the problem in future by filing a bug at https://bugs.launchpad.net/udd linking to this merge proposal.

(this is an automatically generated message)

To post a comment you must log in.

Unmerged revisions

25. By Clint Byrum

releasing version 5.5.22-0ubuntu1

24. By Clint Byrum

New upstream release (LP: #965523)

23. By Clint Byrum

Reverting dynamic linking patch since upstream is unsure about it

22. By Clint Byrum

d/control: Re-add empty meta-package for mysql-testsuite so users
will get the 5.5 version on upgrade and when installing
mysql-testsuite. (LP: #959683)

21. By Clint Byrum

d/p/fix-mysqldump-test.patch: Fixes unreliable test introduced in
new upstream version. http://bugs.mysql.com/bug.php?id=64401

20. By Clint Byrum

d/control: Build-Dep on dh-apparmor (LP: #948481)

19. By Clint Byrum

d/patches/link-clientprograms-statically.patch: Does as its name
implies. (LP: #898340)

18. By Clint Byrum

Refreshed patches

17. By Clint Byrum

New upstream bugfix release.

16. By Clint Byrum

d/mysql-server-5.5.mysql.upstart: Add respawn limit and code
to exit ping loop if mysqld needs to be respawned. (LP: #711635)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== added directory '.pc/38_scripts__mysqld_safe.sh__signals.patch'
=== renamed directory '.pc/38_scripts__mysqld_safe.sh__signals.patch' => '.pc/38_scripts__mysqld_safe.sh__signals.patch.moved'
=== added file '.pc/38_scripts__mysqld_safe.sh__signals.patch/.timestamp'
=== added directory '.pc/38_scripts__mysqld_safe.sh__signals.patch/scripts'
=== added file '.pc/38_scripts__mysqld_safe.sh__signals.patch/scripts/mysqld_safe.sh'
--- .pc/38_scripts__mysqld_safe.sh__signals.patch/scripts/mysqld_safe.sh 1970-01-01 00:00:00 +0000
+++ .pc/38_scripts__mysqld_safe.sh__signals.patch/scripts/mysqld_safe.sh 2012-03-30 01:16:23 +0000
@@ -0,0 +1,825 @@
1#!/bin/sh
2# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
3# This file is public domain and comes with NO WARRANTY of any kind
4#
5# Script to start the MySQL daemon and restart it if it dies unexpectedly
6#
7# This should be executed in the MySQL base directory if you are using a
8# binary installation that is not installed in its compile-time default
9# location
10#
11# mysql.server works by first doing a cd to the base directory and from there
12# executing mysqld_safe
13
14# Initialize script globals
15KILL_MYSQLD=1;
16MYSQLD=
17niceness=0
18mysqld_ld_preload=
19mysqld_ld_library_path=
20
21# Initial logging status: error log is not open, and not using syslog
22logging=init
23want_syslog=0
24syslog_tag=
25user='@MYSQLD_USER@'
26pid_file=
27err_log=
28
29syslog_tag_mysqld=mysqld
30syslog_tag_mysqld_safe=mysqld_safe
31
32trap '' 1 2 3 15 # we shouldn't let anyone kill us
33
34umask 007
35
36defaults=
37case "$1" in
38 --no-defaults|--defaults-file=*|--defaults-extra-file=*)
39 defaults="$1"; shift
40 ;;
41esac
42
43usage () {
44 cat <<EOF
45Usage: $0 [OPTIONS]
46 --no-defaults Don't read the system defaults file
47 --defaults-file=FILE Use the specified defaults file
48 --defaults-extra-file=FILE Also use defaults from the specified file
49 --ledir=DIRECTORY Look for mysqld in the specified directory
50 --open-files-limit=LIMIT Limit the number of open files
51 --core-file-size=LIMIT Limit core files to the specified size
52 --timezone=TZ Set the system timezone
53 --malloc-lib=LIB Preload shared library LIB if available
54 --mysqld=FILE Use the specified file as mysqld
55 --mysqld-version=VERSION Use "mysqld-VERSION" as mysqld
56 --nice=NICE Set the scheduling priority of mysqld
57 --plugin-dir=DIR Plugins are under DIR or DIR/VERSION, if
58 VERSION is given
59 --skip-kill-mysqld Don't try to kill stray mysqld processes
60 --syslog Log messages to syslog with 'logger'
61 --skip-syslog Log messages to error log (default)
62 --syslog-tag=TAG Pass -t "mysqld-TAG" to 'logger'
63
64All other options are passed to the mysqld program.
65
66EOF
67 exit 1
68}
69
70my_which ()
71{
72 save_ifs="${IFS-UNSET}"
73 IFS=:
74 ret=0
75 for file
76 do
77 for dir in $PATH
78 do
79 if [ -f "$dir/$file" ]
80 then
81 echo "$dir/$file"
82 continue 2
83 fi
84 done
85
86 ret=1 #signal an error
87 break
88 done
89
90 if [ "$save_ifs" = UNSET ]
91 then
92 unset IFS
93 else
94 IFS="$save_ifs"
95 fi
96 return $ret # Success
97}
98
99log_generic () {
100 priority="$1"
101 shift
102
103 msg="`date +'%y%m%d %H:%M:%S'` mysqld_safe $*"
104 echo "$msg"
105 case $logging in
106 init) ;; # Just echo the message, don't save it anywhere
107 file) echo "$msg" >> "$err_log" ;;
108 syslog) logger -t "$syslog_tag_mysqld_safe" -p "$priority" "$*" ;;
109 *)
110 echo "Internal program error (non-fatal):" \
111 " unknown logging method '$logging'" >&2
112 ;;
113 esac
114}
115
116log_error () {
117 log_generic daemon.error "$@" >&2
118}
119
120log_notice () {
121 log_generic daemon.notice "$@"
122}
123
124eval_log_error () {
125 cmd="$1"
126 case $logging in
127 file) cmd="$cmd >> "`shell_quote_string "$err_log"`" 2>&1" ;;
128 syslog)
129 # mysqld often prefixes its messages with a timestamp, which is
130 # redundant when logging to syslog (which adds its own timestamp)
131 # However, we don't strip the timestamp with sed here, because
132 # sed buffers output (only GNU sed supports a -u (unbuffered) option)
133 # which means that messages may not get sent to syslog until the
134 # mysqld process quits.
135 cmd="$cmd 2>&1 | logger -t '$syslog_tag_mysqld' -p daemon.error"
136 ;;
137 *)
138 echo "Internal program error (non-fatal):" \
139 " unknown logging method '$logging'" >&2
140 ;;
141 esac
142
143 #echo "Running mysqld: [$cmd]"
144 eval "$cmd"
145}
146
147shell_quote_string() {
148 # This sed command makes sure that any special chars are quoted,
149 # so the arg gets passed exactly to the server.
150 echo "$1" | sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
151}
152
153parse_arguments() {
154 # We only need to pass arguments through to the server if we don't
155 # handle them here. So, we collect unrecognized options (passed on
156 # the command line) into the args variable.
157 pick_args=
158 if test "$1" = PICK-ARGS-FROM-ARGV
159 then
160 pick_args=1
161 shift
162 fi
163
164 for arg do
165 # the parameter after "=", or the whole $arg if no match
166 val=`echo "$arg" | sed -e 's;^--[^=]*=;;'`
167 # what's before "=", or the whole $arg if no match
168 optname=`echo "$arg" | sed -e 's/^\(--[^=]*\)=.*$/\1/'`
169 # replace "_" by "-" ; mysqld_safe must accept "_" like mysqld does.
170 optname_subst=`echo "$optname" | sed 's/_/-/g'`
171 arg=`echo $arg | sed "s/^$optname/$optname_subst/"`
172 case "$arg" in
173 # these get passed explicitly to mysqld
174 --basedir=*) MY_BASEDIR_VERSION="$val" ;;
175 --datadir=*) DATADIR="$val" ;;
176 --pid-file=*) pid_file="$val" ;;
177 --plugin-dir=*) PLUGIN_DIR="$val" ;;
178 --user=*) user="$val"; SET_USER=1 ;;
179
180 # these might have been set in a [mysqld_safe] section of my.cnf
181 # they are added to mysqld command line to override settings from my.cnf
182 --log-error=*) err_log="$val" ;;
183 --port=*) mysql_tcp_port="$val" ;;
184 --socket=*) mysql_unix_port="$val" ;;
185
186 # mysqld_safe-specific options - must be set in my.cnf ([mysqld_safe])!
187 --core-file-size=*) core_file_size="$val" ;;
188 --ledir=*) ledir="$val" ;;
189 --malloc-lib=*) set_malloc_lib "$val" ;;
190 --mysqld=*) MYSQLD="$val" ;;
191 --mysqld-version=*)
192 if test -n "$val"
193 then
194 MYSQLD="mysqld-$val"
195 PLUGIN_VARIANT="/$val"
196 else
197 MYSQLD="mysqld"
198 fi
199 ;;
200 --nice=*) niceness="$val" ;;
201 --open-files-limit=*) open_files="$val" ;;
202 --open_files_limit=*) open_files="$val" ;;
203 --skip-kill-mysqld*) KILL_MYSQLD=0 ;;
204 --syslog) want_syslog=1 ;;
205 --skip-syslog) want_syslog=0 ;;
206 --syslog-tag=*) syslog_tag="$val" ;;
207 --timezone=*) TZ="$val"; export TZ; ;;
208
209 --help) usage ;;
210
211 *)
212 if test -n "$pick_args"
213 then
214 append_arg_to_args "$arg"
215 fi
216 ;;
217 esac
218 done
219}
220
221
222# Add a single shared library to the list of libraries which will be added to
223# LD_PRELOAD for mysqld
224#
225# Since LD_PRELOAD is a space-separated value (for historical reasons), if a
226# shared lib's path contains spaces, that path will be prepended to
227# LD_LIBRARY_PATH and stripped from the lib value.
228add_mysqld_ld_preload() {
229 lib_to_add="$1"
230 log_notice "Adding '$lib_to_add' to LD_PRELOAD for mysqld"
231
232 case "$lib_to_add" in
233 *' '*)
234 # Must strip path from lib, and add it to LD_LIBRARY_PATH
235 lib_file=`basename "$lib_to_add"`
236 case "$lib_file" in
237 *' '*)
238 # The lib file itself has a space in its name, and can't
239 # be used in LD_PRELOAD
240 log_error "library name '$lib_to_add' contains spaces and can not be used with LD_PRELOAD"
241 exit 1
242 ;;
243 esac
244 lib_path=`dirname "$lib_to_add"`
245 lib_to_add="$lib_file"
246 [ -n "$mysqld_ld_library_path" ] && mysqld_ld_library_path="$mysqld_ld_library_path:"
247 mysqld_ld_library_path="$mysqld_ld_library_path$lib_path"
248 ;;
249 esac
250
251 # LD_PRELOAD is a space-separated
252 [ -n "$mysqld_ld_preload" ] && mysqld_ld_preload="$mysqld_ld_preload "
253 mysqld_ld_preload="${mysqld_ld_preload}$lib_to_add"
254}
255
256
257# Returns LD_PRELOAD (and LD_LIBRARY_PATH, if needed) text, quoted to be
258# suitable for use in the eval that calls mysqld.
259#
260# All values in mysqld_ld_preload are prepended to LD_PRELOAD.
261mysqld_ld_preload_text() {
262 text=
263
264 if [ -n "$mysqld_ld_preload" ]; then
265 new_text="$mysqld_ld_preload"
266 [ -n "$LD_PRELOAD" ] && new_text="$new_text $LD_PRELOAD"
267 text="${text}LD_PRELOAD="`shell_quote_string "$new_text"`' '
268 fi
269
270 if [ -n "$mysqld_ld_library_path" ]; then
271 new_text="$mysqld_ld_library_path"
272 [ -n "$LD_LIBRARY_PATH" ] && new_text="$new_text:$LD_LIBRARY_PATH"
273 text="${text}LD_LIBRARY_PATH="`shell_quote_string "$new_text"`' '
274 fi
275
276 echo "$text"
277}
278
279
280mysql_config=
281get_mysql_config() {
282 if [ -z "$mysql_config" ]; then
283 mysql_config=`echo "$0" | sed 's,/[^/][^/]*$,/mysql_config,'`
284 if [ ! -x "$mysql_config" ]; then
285 log_error "Can not run mysql_config $@ from '$mysql_config'"
286 exit 1
287 fi
288 fi
289
290 "$mysql_config" "$@"
291}
292
293
294# set_malloc_lib LIB
295# - If LIB is empty, do nothing and return
296# - If LIB is 'tcmalloc', look for tcmalloc shared library in /usr/lib
297# then pkglibdir. tcmalloc is part of the Google perftools project.
298# - If LIB is an absolute path, assume it is a malloc shared library
299#
300# Put LIB in mysqld_ld_preload, which will be added to LD_PRELOAD when
301# running mysqld. See ld.so for details.
302set_malloc_lib() {
303 malloc_lib="$1"
304
305 if [ "$malloc_lib" = tcmalloc ]; then
306 pkglibdir=`get_mysql_config --variable=pkglibdir`
307 malloc_lib=
308 # This list is kept intentionally simple. Simply set --malloc-lib
309 # to a full path if another location is desired.
310 for libdir in /usr/lib "$pkglibdir" "$pkglibdir/mysql"; do
311 for flavor in _minimal '' _and_profiler _debug; do
312 tmp="$libdir/libtcmalloc$flavor.so"
313 #log_notice "DEBUG: Checking for malloc lib '$tmp'"
314 [ -r "$tmp" ] || continue
315 malloc_lib="$tmp"
316 break 2
317 done
318 done
319
320 if [ -z "$malloc_lib" ]; then
321 log_error "no shared library for --malloc-lib=tcmalloc found in /usr/lib or $pkglibdir"
322 exit 1
323 fi
324 fi
325
326 # Allow --malloc-lib='' to override other settings
327 [ -z "$malloc_lib" ] && return
328
329 case "$malloc_lib" in
330 /*)
331 if [ ! -r "$malloc_lib" ]; then
332 log_error "--malloc-lib '$malloc_lib' can not be read and will not be used"
333 exit 1
334 fi
335 ;;
336 *)
337 log_error "--malloc-lib must be an absolute path or 'tcmalloc'; " \
338 "ignoring value '$malloc_lib'"
339 exit 1
340 ;;
341 esac
342
343 add_mysqld_ld_preload "$malloc_lib"
344}
345
346
347#
348# First, try to find BASEDIR and ledir (where mysqld is)
349#
350
351if echo '@pkgdatadir@' | grep '^@prefix@' > /dev/null
352then
353 relpkgdata=`echo '@pkgdatadir@' | sed -e 's,^@prefix@,,' -e 's,^/,,' -e 's,^,./,'`
354else
355 # pkgdatadir is not relative to prefix
356 relpkgdata='@pkgdatadir@'
357fi
358
359MY_PWD=`pwd`
360# Check for the directories we would expect from a binary release install
361if test -n "$MY_BASEDIR_VERSION" -a -d "$MY_BASEDIR_VERSION"
362then
363 # BASEDIR is already overridden on command line. Do not re-set.
364
365 # Use BASEDIR to discover le.
366 if test -x "$MY_BASEDIR_VERSION/libexec/mysqld"
367 then
368 ledir="$MY_BASEDIR_VERSION/libexec"
369 elif test -x "$MY_BASEDIR_VERSION/sbin/mysqld"
370 then
371 ledir="$MY_BASEDIR_VERSION/sbin"
372 else
373 ledir="$MY_BASEDIR_VERSION/bin"
374 fi
375elif test -f "$relpkgdata"/english/errmsg.sys -a -x "$MY_PWD/bin/mysqld"
376then
377 MY_BASEDIR_VERSION="$MY_PWD" # Where bin, share and data are
378 ledir="$MY_PWD/bin" # Where mysqld is
379# Check for the directories we would expect from a source install
380elif test -f "$relpkgdata"/english/errmsg.sys -a -x "$MY_PWD/libexec/mysqld"
381then
382 MY_BASEDIR_VERSION="$MY_PWD" # Where libexec, share and var are
383 ledir="$MY_PWD/libexec" # Where mysqld is
384elif test -f "$relpkgdata"/english/errmsg.sys -a -x "$MY_PWD/sbin/mysqld"
385then
386 MY_BASEDIR_VERSION="$MY_PWD" # Where sbin, share and var are
387 ledir="$MY_PWD/sbin" # Where mysqld is
388# Since we didn't find anything, used the compiled-in defaults
389else
390 MY_BASEDIR_VERSION='@prefix@'
391 ledir='@libexecdir@'
392fi
393
394
395#
396# Second, try to find the data directory
397#
398
399# Try where the binary installs put it
400if test -d $MY_BASEDIR_VERSION/data/mysql
401then
402 DATADIR=$MY_BASEDIR_VERSION/data
403 if test -z "$defaults" -a -r "$DATADIR/my.cnf"
404 then
405 defaults="--defaults-extra-file=$DATADIR/my.cnf"
406 fi
407# Next try where the source installs put it
408elif test -d $MY_BASEDIR_VERSION/var/mysql
409then
410 DATADIR=$MY_BASEDIR_VERSION/var
411# Or just give up and use our compiled-in default
412else
413 DATADIR=@localstatedir@
414fi
415
416#
417# Try to find the plugin directory
418#
419
420# Use user-supplied argument
421if [ -n "${PLUGIN_DIR}" ]; then
422 plugin_dir="${PLUGIN_DIR}"
423else
424 # Try to find plugin dir relative to basedir
425 for dir in lib/mysql/plugin lib/plugin
426 do
427 if [ -d "${MY_BASEDIR_VERSION}/${dir}" ]; then
428 plugin_dir="${MY_BASEDIR_VERSION}/${dir}"
429 break
430 fi
431 done
432 # Give up and use compiled-in default
433 if [ -z "${plugin_dir}" ]; then
434 plugin_dir='@pkgplugindir@'
435 fi
436fi
437plugin_dir="${plugin_dir}${PLUGIN_VARIANT}"
438
439if test -z "$MYSQL_HOME"
440then
441 if test -r "$MY_BASEDIR_VERSION/my.cnf" && test -r "$DATADIR/my.cnf"
442 then
443 log_error "WARNING: Found two instances of my.cnf -
444$MY_BASEDIR_VERSION/my.cnf and
445$DATADIR/my.cnf
446IGNORING $DATADIR/my.cnf"
447
448 MYSQL_HOME=$MY_BASEDIR_VERSION
449 elif test -r "$DATADIR/my.cnf"
450 then
451 log_error "WARNING: Found $DATADIR/my.cnf
452The data directory is a deprecated location for my.cnf, please move it to
453$MY_BASEDIR_VERSION/my.cnf"
454 MYSQL_HOME=$DATADIR
455 else
456 MYSQL_HOME=$MY_BASEDIR_VERSION
457 fi
458fi
459export MYSQL_HOME
460
461
462# Get first arguments from the my.cnf file, groups [mysqld] and [mysqld_safe]
463# and then merge with the command line arguments
464if test -x "$MY_BASEDIR_VERSION/bin/my_print_defaults"
465then
466 print_defaults="$MY_BASEDIR_VERSION/bin/my_print_defaults"
467elif test -x `dirname $0`/my_print_defaults
468then
469 print_defaults="`dirname $0`/my_print_defaults"
470elif test -x ./bin/my_print_defaults
471then
472 print_defaults="./bin/my_print_defaults"
473elif test -x @bindir@/my_print_defaults
474then
475 print_defaults="@bindir@/my_print_defaults"
476elif test -x @bindir@/mysql_print_defaults
477then
478 print_defaults="@bindir@/mysql_print_defaults"
479else
480 print_defaults="my_print_defaults"
481fi
482
483append_arg_to_args () {
484 args="$args "`shell_quote_string "$1"`
485}
486
487args=
488
489SET_USER=2
490parse_arguments `$print_defaults $defaults --loose-verbose mysqld server`
491if test $SET_USER -eq 2
492then
493 SET_USER=0
494fi
495
496parse_arguments `$print_defaults $defaults --loose-verbose mysqld_safe safe_mysqld`
497parse_arguments PICK-ARGS-FROM-ARGV "$@"
498
499# Determine what logging facility to use
500
501# Ensure that 'logger' exists, if it's requested
502if [ $want_syslog -eq 1 ]
503then
504 my_which logger > /dev/null 2>&1
505 if [ $? -ne 0 ]
506 then
507 log_error "--syslog requested, but no 'logger' program found. Please ensure that 'logger' is in your PATH, or do not specify the --syslog option to mysqld_safe."
508 exit 1
509 fi
510fi
511
512if [ -n "$err_log" -o $want_syslog -eq 0 ]
513then
514 if [ -n "$err_log" ]
515 then
516 # mysqld adds ".err" if there is no extension on the --log-error
517 # argument; must match that here, or mysqld_safe will write to a
518 # different log file than mysqld
519
520 # mysqld does not add ".err" to "--log-error=foo."; it considers a
521 # trailing "." as an extension
522 if expr "$err_log" : '.*\.[^/]*$' > /dev/null
523 then
524 :
525 else
526 err_log="$err_log".err
527 fi
528
529 case "$err_log" in
530 /* ) ;;
531 * ) err_log="$DATADIR/$err_log" ;;
532 esac
533 else
534 err_log=$DATADIR/`@HOSTNAME@`.err
535 fi
536
537 append_arg_to_args "--log-error=$err_log"
538
539 if [ $want_syslog -eq 1 ]
540 then
541 # User explicitly asked for syslog, so warn that it isn't used
542 log_error "Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect."
543 fi
544
545 # Log to err_log file
546 log_notice "Logging to '$err_log'."
547 logging=file
548else
549 if [ -n "$syslog_tag" ]
550 then
551 # Sanitize the syslog tag
552 syslog_tag=`echo "$syslog_tag" | sed -e 's/[^a-zA-Z0-9_-]/_/g'`
553 syslog_tag_mysqld_safe="${syslog_tag_mysqld_safe}-$syslog_tag"
554 syslog_tag_mysqld="${syslog_tag_mysqld}-$syslog_tag"
555 fi
556 log_notice "Logging to syslog."
557 logging=syslog
558fi
559
560USER_OPTION=""
561if test -w / -o "$USER" = "root"
562then
563 if test "$user" != "root" -o $SET_USER = 1
564 then
565 USER_OPTION="--user=$user"
566 fi
567 # Change the err log to the right user, if it is in use
568 if [ $want_syslog -eq 0 ]; then
569 touch "$err_log"
570 chown $user "$err_log"
571 fi
572 if test -n "$open_files"
573 then
574 ulimit -n $open_files
575 fi
576fi
577
578if test -n "$open_files"
579then
580 append_arg_to_args "--open-files-limit=$open_files"
581fi
582
583safe_mysql_unix_port=${mysql_unix_port:-${MYSQL_UNIX_PORT:-@MYSQL_UNIX_ADDR@}}
584# Make sure that directory for $safe_mysql_unix_port exists
585mysql_unix_port_dir=`dirname $safe_mysql_unix_port`
586if [ ! -d $mysql_unix_port_dir ]
587then
588 mkdir $mysql_unix_port_dir
589 chown $user $mysql_unix_port_dir
590 chmod 755 $mysql_unix_port_dir
591fi
592
593# If the user doesn't specify a binary, we assume name "mysqld"
594if test -z "$MYSQLD"
595then
596 MYSQLD=mysqld
597fi
598
599if test ! -x "$ledir/$MYSQLD"
600then
601 log_error "The file $ledir/$MYSQLD
602does not exist or is not executable. Please cd to the mysql installation
603directory and restart this script from there as follows:
604./bin/mysqld_safe&
605See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information"
606 exit 1
607fi
608
609if test -z "$pid_file"
610then
611 pid_file="$DATADIR/`@HOSTNAME@`.pid"
612else
613 case "$pid_file" in
614 /* ) ;;
615 * ) pid_file="$DATADIR/$pid_file" ;;
616 esac
617fi
618append_arg_to_args "--pid-file=$pid_file"
619
620if test -n "$mysql_unix_port"
621then
622 append_arg_to_args "--socket=$mysql_unix_port"
623fi
624if test -n "$mysql_tcp_port"
625then
626 append_arg_to_args "--port=$mysql_tcp_port"
627fi
628
629if test $niceness -eq 0
630then
631 NOHUP_NICENESS="nohup"
632else
633 NOHUP_NICENESS="nohup nice -$niceness"
634fi
635
636# Using nice with no args to get the niceness level is GNU-specific.
637# This check could be extended for other operating systems (e.g.,
638# BSD could use "nohup sh -c 'ps -o nice -p $$' | tail -1").
639# But, it also seems that GNU nohup is the only one which messes
640# with the priority, so this is okay.
641if nohup nice > /dev/null 2>&1
642then
643 normal_niceness=`nice`
644 nohup_niceness=`nohup nice 2>/dev/null`
645
646 numeric_nice_values=1
647 for val in $normal_niceness $nohup_niceness
648 do
649 case "$val" in
650 -[0-9] | -[0-9][0-9] | -[0-9][0-9][0-9] | \
651 [0-9] | [0-9][0-9] | [0-9][0-9][0-9] )
652 ;;
653 * )
654 numeric_nice_values=0 ;;
655 esac
656 done
657
658 if test $numeric_nice_values -eq 1
659 then
660 nice_value_diff=`expr $nohup_niceness - $normal_niceness`
661 if test $? -eq 0 && test $nice_value_diff -gt 0 && \
662 nice --$nice_value_diff echo testing > /dev/null 2>&1
663 then
664 # nohup increases the priority (bad), and we are permitted
665 # to lower the priority with respect to the value the user
666 # might have been given
667 niceness=`expr $niceness - $nice_value_diff`
668 NOHUP_NICENESS="nice -$niceness nohup"
669 fi
670 fi
671else
672 if nohup echo testing > /dev/null 2>&1
673 then
674 :
675 else
676 # nohup doesn't work on this system
677 NOHUP_NICENESS=""
678 fi
679fi
680
681# Try to set the core file size (even if we aren't root) because many systems
682# don't specify a hard limit on core file size.
683if test -n "$core_file_size"
684then
685 ulimit -c $core_file_size
686fi
687
688#
689# If there exists an old pid file, check if the daemon is already running
690# Note: The switches to 'ps' may depend on your operating system
691if test -f "$pid_file"
692then
693 PID=`cat "$pid_file"`
694 if @CHECK_PID@
695 then
696 if @FIND_PROC@
697 then # The pid contains a mysqld process
698 log_error "A mysqld process already exists"
699 exit 1
700 fi
701 fi
702 rm -f "$pid_file"
703 if test -f "$pid_file"
704 then
705 log_error "Fatal error: Can't remove the pid file:
706$pid_file
707Please remove it manually and start $0 again;
708mysqld daemon not started"
709 exit 1
710 fi
711fi
712
713#
714# Uncomment the following lines if you want all tables to be automatically
715# checked and repaired during startup. You should add sensible key_buffer
716# and sort_buffer values to my.cnf to improve check performance or require
717# less disk space.
718# Alternatively, you can start mysqld with the "myisam-recover" option. See
719# the manual for details.
720#
721# echo "Checking tables in $DATADIR"
722# $MY_BASEDIR_VERSION/bin/myisamchk --silent --force --fast --medium-check $DATADIR/*/*.MYI
723# $MY_BASEDIR_VERSION/bin/isamchk --silent --force $DATADIR/*/*.ISM
724
725# Does this work on all systems?
726#if type ulimit | grep "shell builtin" > /dev/null
727#then
728# ulimit -n 256 > /dev/null 2>&1 # Fix for BSD and FreeBSD systems
729#fi
730
731cmd="`mysqld_ld_preload_text`$NOHUP_NICENESS"
732
733for i in "$ledir/$MYSQLD" "$defaults" "--basedir=$MY_BASEDIR_VERSION" \
734 "--datadir=$DATADIR" "--plugin-dir=$plugin_dir" "$USER_OPTION"
735do
736 cmd="$cmd "`shell_quote_string "$i"`
737done
738cmd="$cmd $args"
739# Avoid 'nohup: ignoring input' warning
740test -n "$NOHUP_NICENESS" && cmd="$cmd < /dev/null"
741
742log_notice "Starting $MYSQLD daemon with databases from $DATADIR"
743
744# variable to track the current number of "fast" (a.k.a. subsecond) restarts
745fast_restart=0
746# maximum number of restarts before trottling kicks in
747max_fast_restarts=5
748# flag whether a usable sleep command exists
749have_sleep=1
750
751while true
752do
753 rm -f $safe_mysql_unix_port "$pid_file" # Some extra safety
754
755 start_time=`date +%M%S`
756
757 eval_log_error "$cmd"
758
759 end_time=`date +%M%S`
760
761 if test ! -f "$pid_file" # This is removed if normal shutdown
762 then
763 break
764 fi
765
766
767 # sanity check if time reading is sane and there's sleep
768 if test $end_time -gt 0 -a $have_sleep -gt 0
769 then
770 # throttle down the fast restarts
771 if test $end_time -eq $start_time
772 then
773 fast_restart=`expr $fast_restart + 1`
774 if test $fast_restart -ge $max_fast_restarts
775 then
776 log_notice "The server is respawning too fast. Sleeping for 1 second."
777 sleep 1
778 sleep_state=$?
779 if test $sleep_state -gt 0
780 then
781 log_notice "The server is respawning too fast and no working sleep command. Turning off trottling."
782 have_sleep=0
783 fi
784
785 fast_restart=0
786 fi
787 else
788 fast_restart=0
789 fi
790 fi
791
792 if @TARGET_LINUX@ && test $KILL_MYSQLD -eq 1
793 then
794 # Test if one process was hanging.
795 # This is only a fix for Linux (running as base 3 mysqld processes)
796 # but should work for the rest of the servers.
797 # The only thing is ps x => redhat 5 gives warnings when using ps -x.
798 # kill -9 is used or the process won't react on the kill.
799 numofproces=`ps xaww | grep -v "grep" | grep "$ledir/$MYSQLD\>" | grep -c "pid-file=$pid_file"`
800
801 log_notice "Number of processes running now: $numofproces"
802 I=1
803 while test "$I" -le "$numofproces"
804 do
805 PROC=`ps xaww | grep "$ledir/$MYSQLD\>" | grep -v "grep" | grep "pid-file=$pid_file" | sed -n '$p'`
806
807 for T in $PROC
808 do
809 break
810 done
811 # echo "TEST $I - $T **"
812 if kill -9 $T
813 then
814 log_error "$MYSQLD process hanging, pid $T - killed"
815 else
816 break
817 fi
818 I=`expr $I + 1`
819 done
820 fi
821 log_notice "mysqld restarted"
822done
823
824log_notice "mysqld from pid file $pid_file ended"
825
0826
=== added directory '.pc/62_disable_tests.patch'
=== renamed directory '.pc/62_disable_tests.patch' => '.pc/62_disable_tests.patch.moved'
=== added file '.pc/62_disable_tests.patch/.timestamp'
=== added directory '.pc/62_disable_tests.patch/mysql-test'
=== added directory '.pc/62_disable_tests.patch/mysql-test/t'
=== added file '.pc/62_disable_tests.patch/mysql-test/t/disabled.def'
--- .pc/62_disable_tests.patch/mysql-test/t/disabled.def 1970-01-01 00:00:00 +0000
+++ .pc/62_disable_tests.patch/mysql-test/t/disabled.def 2012-03-30 01:16:23 +0000
@@ -0,0 +1,17 @@
1##############################################################################
2#
3# List the test cases that are to be disabled temporarily.
4#
5# Separate the test case name and the comment with ':'.
6#
7# <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
8#
9# Do not use any TAB characters for whitespace.
10#
11##############################################################################
12lowercase_table3 : Bug#11762269 2010-06-30 alik main.lowercase_table3 on Mac OSX
13read_many_rows_innodb : Bug#11748886 2010-11-15 mattiasj report already exists
14sum_distinct-big : Bug#11764126 2010-11-15 mattiasj was not tested
15archive-big : Bug#11817185 2011-03-10 Anitha Disabled since this leads to timeout on Solaris Sparc
16log_tables-big : Bug#11756699 2010-11-15 mattiasj report already exists
17mysql_embedded : Bug#12561297 2011-05-14 Anitha Dependent on PB2 changes - eventum#41836
018
=== added directory '.pc/70_mysql_va_list.patch'
=== renamed directory '.pc/70_mysql_va_list.patch' => '.pc/70_mysql_va_list.patch.moved'
=== added file '.pc/70_mysql_va_list.patch/.timestamp'
=== added directory '.pc/70_mysql_va_list.patch/sql-common'
=== added file '.pc/70_mysql_va_list.patch/sql-common/client_plugin.c'
--- .pc/70_mysql_va_list.patch/sql-common/client_plugin.c 1970-01-01 00:00:00 +0000
+++ .pc/70_mysql_va_list.patch/sql-common/client_plugin.c 2012-03-30 01:16:23 +0000
@@ -0,0 +1,472 @@
1/* Copyright (c) 2010, 2011, Oracle and/or its affiliates. All rights reserved.
2
3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License as published by
5 the Free Software Foundation; version 2 of the License.
6
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
10 GNU General Public License for more details.
11
12 You should have received a copy of the GNU General Public License
13 along with this program; if not, write to the Free Software
14 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
15
16/**
17 @file
18
19 Support code for the client side (libmysql) plugins
20
21 Client plugins are somewhat different from server plugins, they are simpler.
22
23 They do not need to be installed or in any way explicitly loaded on the
24 client, they are loaded automatically on demand.
25 One client plugin per shared object, soname *must* match the plugin name.
26
27 There is no reference counting and no unloading either.
28*/
29
30#include <my_global.h>
31#include "mysql.h"
32#include <my_sys.h>
33#include <m_string.h>
34#include <my_pthread.h>
35
36#include <sql_common.h>
37#include "errmsg.h"
38#include <mysql/client_plugin.h>
39
40struct st_client_plugin_int {
41 struct st_client_plugin_int *next;
42 void *dlhandle;
43 struct st_mysql_client_plugin *plugin;
44};
45
46static my_bool initialized= 0;
47static MEM_ROOT mem_root;
48
49static const char *plugin_declarations_sym= "_mysql_client_plugin_declaration_";
50static uint plugin_version[MYSQL_CLIENT_MAX_PLUGINS]=
51{
52 0, /* these two are taken by Connector/C */
53 0, /* these two are taken by Connector/C */
54 MYSQL_CLIENT_AUTHENTICATION_PLUGIN_INTERFACE_VERSION
55};
56
57/*
58 Loaded plugins are stored in a linked list.
59 The list is append-only, the elements are added to the head (like in a stack).
60 The elements are added under a mutex, but the list can be read and traversed
61 without any mutex because once an element is added to the list, it stays
62 there. The main purpose of a mutex is to prevent two threads from
63 loading the same plugin twice in parallel.
64*/
65struct st_client_plugin_int *plugin_list[MYSQL_CLIENT_MAX_PLUGINS];
66static pthread_mutex_t LOCK_load_client_plugin;
67
68static int is_not_initialized(MYSQL *mysql, const char *name)
69{
70 if (initialized)
71 return 0;
72
73 set_mysql_extended_error(mysql, CR_AUTH_PLUGIN_CANNOT_LOAD,
74 unknown_sqlstate, ER(CR_AUTH_PLUGIN_CANNOT_LOAD),
75 name, "not initialized");
76 return 1;
77}
78
79/**
80 finds a plugin in the list
81
82 @param name plugin name to search for
83 @param type plugin type
84
85 @note this does NOT necessarily need a mutex, take care!
86
87 @retval a pointer to a found plugin or 0
88*/
89static struct st_mysql_client_plugin *
90find_plugin(const char *name, int type)
91{
92 struct st_client_plugin_int *p;
93
94 DBUG_ASSERT(initialized);
95 DBUG_ASSERT(type >= 0 && type < MYSQL_CLIENT_MAX_PLUGINS);
96 if (type < 0 || type >= MYSQL_CLIENT_MAX_PLUGINS)
97 return 0;
98
99 for (p= plugin_list[type]; p; p= p->next)
100 {
101 if (strcmp(p->plugin->name, name) == 0)
102 return p->plugin;
103 }
104 return NULL;
105}
106
107/**
108 verifies the plugin and adds it to the list
109
110 @param mysql MYSQL structure (for error reporting)
111 @param plugin plugin to install
112 @param dlhandle a handle to the shared object (returned by dlopen)
113 or 0 if the plugin was not dynamically loaded
114 @param argc number of arguments in the 'va_list args'
115 @param args arguments passed to the plugin initialization function
116
117 @retval a pointer to an installed plugin or 0
118*/
119static struct st_mysql_client_plugin *
120add_plugin(MYSQL *mysql, struct st_mysql_client_plugin *plugin, void *dlhandle,
121 int argc, va_list args)
122{
123 const char *errmsg;
124 struct st_client_plugin_int plugin_int, *p;
125 char errbuf[1024];
126
127 DBUG_ASSERT(initialized);
128
129 plugin_int.plugin= plugin;
130 plugin_int.dlhandle= dlhandle;
131
132 if (plugin->type >= MYSQL_CLIENT_MAX_PLUGINS)
133 {
134 errmsg= "Unknown client plugin type";
135 goto err1;
136 }
137
138 if (plugin->interface_version < plugin_version[plugin->type] ||
139 (plugin->interface_version >> 8) >
140 (plugin_version[plugin->type] >> 8))
141 {
142 errmsg= "Incompatible client plugin interface";
143 goto err1;
144 }
145
146 /* Call the plugin initialization function, if any */
147 if (plugin->init && plugin->init(errbuf, sizeof(errbuf), argc, args))
148 {
149 errmsg= errbuf;
150 goto err1;
151 }
152
153 p= (struct st_client_plugin_int *)
154 memdup_root(&mem_root, &plugin_int, sizeof(plugin_int));
155
156 if (!p)
157 {
158 errmsg= "Out of memory";
159 goto err2;
160 }
161
162 safe_mutex_assert_owner(&LOCK_load_client_plugin);
163
164 p->next= plugin_list[plugin->type];
165 plugin_list[plugin->type]= p;
166 net_clear_error(&mysql->net);
167
168 return plugin;
169
170err2:
171 if (plugin->deinit)
172 plugin->deinit();
173err1:
174 set_mysql_extended_error(mysql, CR_AUTH_PLUGIN_CANNOT_LOAD, unknown_sqlstate,
175 ER(CR_AUTH_PLUGIN_CANNOT_LOAD), plugin->name,
176 errmsg);
177 if (dlhandle)
178 dlclose(dlhandle);
179 return NULL;
180}
181
182/**
183 Loads plugins which are specified in the environment variable
184 LIBMYSQL_PLUGINS.
185
186 Multiple plugins must be separated by semicolon. This function doesn't
187 return or log an error.
188
189 The function is be called by mysql_client_plugin_init
190
191 @todo
192 Support extended syntax, passing parameters to plugins, for example
193 LIBMYSQL_PLUGINS="plugin1(param1,param2);plugin2;..."
194 or
195 LIBMYSQL_PLUGINS="plugin1=int:param1,str:param2;plugin2;..."
196*/
197static void load_env_plugins(MYSQL *mysql)
198{
199 char *plugs, *free_env, *s= getenv("LIBMYSQL_PLUGINS");
200
201 /* no plugins to load */
202 if(!s)
203 return;
204
205 free_env= plugs= my_strdup(s, MYF(MY_WME));
206
207 do {
208 if ((s= strchr(plugs, ';')))
209 *s= '\0';
210 mysql_load_plugin(mysql, plugs, -1, 0);
211 plugs= s + 1;
212 } while (s);
213
214 my_free(free_env);
215}
216
217/********** extern functions to be used by libmysql *********************/
218
219/**
220 Initializes the client plugin layer.
221
222 This function must be called before any other client plugin function.
223
224 @retval 0 successful
225 @retval != 0 error occured
226*/
227int mysql_client_plugin_init()
228{
229 MYSQL mysql;
230 struct st_mysql_client_plugin **builtin;
231
232 if (initialized)
233 return 0;
234
235 bzero(&mysql, sizeof(mysql)); /* dummy mysql for set_mysql_extended_error */
236
237 pthread_mutex_init(&LOCK_load_client_plugin, MY_MUTEX_INIT_SLOW);
238 init_alloc_root(&mem_root, 128, 128);
239
240 bzero(&plugin_list, sizeof(plugin_list));
241
242 initialized= 1;
243
244 pthread_mutex_lock(&LOCK_load_client_plugin);
245
246 for (builtin= mysql_client_builtins; *builtin; builtin++)
247 add_plugin(&mysql, *builtin, 0, 0, 0);
248
249 pthread_mutex_unlock(&LOCK_load_client_plugin);
250
251 load_env_plugins(&mysql);
252
253 return 0;
254}
255
256/**
257 Deinitializes the client plugin layer.
258
259 Unloades all client plugins and frees any associated resources.
260*/
261void mysql_client_plugin_deinit()
262{
263 int i;
264 struct st_client_plugin_int *p;
265
266 if (!initialized)
267 return;
268
269 for (i=0; i < MYSQL_CLIENT_MAX_PLUGINS; i++)
270 for (p= plugin_list[i]; p; p= p->next)
271 {
272 if (p->plugin->deinit)
273 p->plugin->deinit();
274 if (p->dlhandle)
275 dlclose(p->dlhandle);
276 }
277
278 bzero(&plugin_list, sizeof(plugin_list));
279 initialized= 0;
280 free_root(&mem_root, MYF(0));
281 pthread_mutex_destroy(&LOCK_load_client_plugin);
282}
283
284/************* public facing functions, for client consumption *********/
285
286/* see <mysql/client_plugin.h> for a full description */
287struct st_mysql_client_plugin *
288mysql_client_register_plugin(MYSQL *mysql,
289 struct st_mysql_client_plugin *plugin)
290{
291 if (is_not_initialized(mysql, plugin->name))
292 return NULL;
293
294 pthread_mutex_lock(&LOCK_load_client_plugin);
295
296 /* make sure the plugin wasn't loaded meanwhile */
297 if (find_plugin(plugin->name, plugin->type))
298 {
299 set_mysql_extended_error(mysql, CR_AUTH_PLUGIN_CANNOT_LOAD,
300 unknown_sqlstate, ER(CR_AUTH_PLUGIN_CANNOT_LOAD),
301 plugin->name, "it is already loaded");
302 plugin= NULL;
303 }
304 else
305 plugin= add_plugin(mysql, plugin, 0, 0, 0);
306
307 pthread_mutex_unlock(&LOCK_load_client_plugin);
308 return plugin;
309}
310
311/* see <mysql/client_plugin.h> for a full description */
312struct st_mysql_client_plugin *
313mysql_load_plugin_v(MYSQL *mysql, const char *name, int type,
314 int argc, va_list args)
315{
316 const char *errmsg;
317 char dlpath[FN_REFLEN+1];
318 void *sym, *dlhandle;
319 struct st_mysql_client_plugin *plugin;
320#ifdef _WIN32
321 char win_errormsg[2048];
322#endif
323
324 DBUG_ENTER ("mysql_load_plugin_v");
325 DBUG_PRINT ("entry", ("name=%s type=%d int argc=%d", name, type, argc));
326 if (is_not_initialized(mysql, name))
327 {
328 DBUG_PRINT ("leave", ("mysql not initialized"));
329 DBUG_RETURN (NULL);
330 }
331
332 pthread_mutex_lock(&LOCK_load_client_plugin);
333
334 /* make sure the plugin wasn't loaded meanwhile */
335 if (type >= 0 && find_plugin(name, type))
336 {
337 errmsg= "it is already loaded";
338 goto err;
339 }
340
341 /* Compile dll path */
342 strxnmov(dlpath, sizeof(dlpath) - 1,
343 mysql->options.extension && mysql->options.extension->plugin_dir ?
344 mysql->options.extension->plugin_dir : PLUGINDIR, "/",
345 name, SO_EXT, NullS);
346
347 DBUG_PRINT ("info", ("dlopeninig %s", dlpath));
348 /* Open new dll handle */
349 if (!(dlhandle= dlopen(dlpath, RTLD_NOW)))
350 {
351#if defined(__APPLE__)
352 /* Apple supports plugins with .so also, so try this as well */
353 strxnmov(dlpath, sizeof(dlpath) - 1,
354 mysql->options.extension && mysql->options.extension->plugin_dir ?
355 mysql->options.extension->plugin_dir : PLUGINDIR, "/",
356 name, ".so", NullS);
357 if ((dlhandle= dlopen(dlpath, RTLD_NOW)))
358 goto have_plugin;
359#endif
360
361 DBUG_PRINT ("info", ("failed to dlopen"));
362#ifdef _WIN32
363 if(FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM,
364 0, GetLastError(), 0, win_errormsg, 2048, NULL))
365 errmsg= win_errormsg;
366 else
367 errmsg= "";
368#else
369 errmsg= dlerror();
370#endif
371 goto err;
372 }
373
374#if defined(__APPLE__)
375have_plugin:
376#endif
377 if (!(sym= dlsym(dlhandle, plugin_declarations_sym)))
378 {
379 errmsg= "not a plugin";
380 dlclose(dlhandle);
381 goto err;
382 }
383
384 plugin= (struct st_mysql_client_plugin*)sym;
385
386 if (type >=0 && type != plugin->type)
387 {
388 errmsg= "type mismatch";
389 goto err;
390 }
391
392 if (strcmp(name, plugin->name))
393 {
394 errmsg= "name mismatch";
395 goto err;
396 }
397
398 if (type < 0 && find_plugin(name, plugin->type))
399 {
400 errmsg= "it is already loaded";
401 goto err;
402 }
403
404 plugin= add_plugin(mysql, plugin, dlhandle, argc, args);
405
406 pthread_mutex_unlock(&LOCK_load_client_plugin);
407
408 DBUG_PRINT ("leave", ("plugin loaded ok"));
409 DBUG_RETURN (plugin);
410
411err:
412 pthread_mutex_unlock(&LOCK_load_client_plugin);
413 DBUG_PRINT ("leave", ("plugin load error : %s", errmsg));
414 set_mysql_extended_error(mysql, CR_AUTH_PLUGIN_CANNOT_LOAD, unknown_sqlstate,
415 ER(CR_AUTH_PLUGIN_CANNOT_LOAD), name, errmsg);
416 DBUG_RETURN (NULL);
417}
418
419/* see <mysql/client_plugin.h> for a full description */
420struct st_mysql_client_plugin *
421mysql_load_plugin(MYSQL *mysql, const char *name, int type, int argc, ...)
422{
423 struct st_mysql_client_plugin *p;
424 va_list args;
425 va_start(args, argc);
426 p= mysql_load_plugin_v(mysql, name, type, argc, args);
427 va_end(args);
428 return p;
429}
430
431/* see <mysql/client_plugin.h> for a full description */
432struct st_mysql_client_plugin *
433mysql_client_find_plugin(MYSQL *mysql, const char *name, int type)
434{
435 struct st_mysql_client_plugin *p;
436
437 DBUG_ENTER ("mysql_client_find_plugin");
438 DBUG_PRINT ("entry", ("name=%s, type=%d", name, type));
439 if (is_not_initialized(mysql, name))
440 DBUG_RETURN (NULL);
441
442 if (type < 0 || type >= MYSQL_CLIENT_MAX_PLUGINS)
443 {
444 set_mysql_extended_error(mysql, CR_AUTH_PLUGIN_CANNOT_LOAD, unknown_sqlstate,
445 ER(CR_AUTH_PLUGIN_CANNOT_LOAD), name,
446 "invalid type");
447 }
448
449 if ((p= find_plugin(name, type)))
450 {
451 DBUG_PRINT ("leave", ("found %p", p));
452 DBUG_RETURN (p);
453 }
454
455 /* not found, load it */
456 p= mysql_load_plugin(mysql, name, type, 0);
457 DBUG_PRINT ("leave", ("loaded %p", p));
458 DBUG_RETURN (p);
459}
460
461
462/* see <mysql/client_plugin.h> for a full description */
463int mysql_plugin_options(struct st_mysql_client_plugin *plugin,
464 const char *option,
465 const void *value)
466{
467 DBUG_ENTER("mysql_plugin_options");
468 /* does the plugin support options call? */
469 if (!plugin || !plugin->options)
470 DBUG_RETURN(1);
471 DBUG_RETURN(plugin->options(option, value));
472}
0473
=== added directory '.pc/71_disable_rpl_tests.patch'
=== renamed directory '.pc/71_disable_rpl_tests.patch' => '.pc/71_disable_rpl_tests.patch.moved'
=== added file '.pc/71_disable_rpl_tests.patch/.timestamp'
=== added directory '.pc/71_disable_rpl_tests.patch/mysql-test'
=== added directory '.pc/71_disable_rpl_tests.patch/mysql-test/suite'
=== added directory '.pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl'
=== added directory '.pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl/t'
=== added file '.pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl/t/disabled.def'
--- .pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl/t/disabled.def 1970-01-01 00:00:00 +0000
+++ .pc/71_disable_rpl_tests.patch/mysql-test/suite/rpl/t/disabled.def 2012-03-30 01:16:23 +0000
@@ -0,0 +1,17 @@
1##############################################################################
2#
3# List the test cases that are to be disabled temporarily.
4#
5# Separate the test case name and the comment with ':'.
6#
7# <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
8#
9# Do not use any TAB characters for whitespace.
10#
11##############################################################################
12
13rpl_row_create_table : Bug#11759274 2010-02-27 andrei failed different way than earlier with bug#45576
14rpl_spec_variables : BUG#11755836 2009-10-27 jasonh rpl_spec_variables fails on PB2 hpux
15rpl_get_master_version_and_clock : Bug#11766137 Jan 05 2011 joro Valgrind warnings rpl_get_master_version_and_clock
16rpl_row_until : BUG#59543 Jan 26 2011 alfranio Replication test from eits suite rpl_row_until times out
17rpl_stm_until : BUG#59543 Jan 26 2011 alfranio Replication test from eits suite rpl_row_until times out
018
=== added directory '.pc/72_fix_standalone_tests.patch'
=== renamed directory '.pc/72_fix_standalone_tests.patch' => '.pc/72_fix_standalone_tests.patch.moved'
=== added file '.pc/72_fix_standalone_tests.patch/.timestamp'
=== added directory '.pc/72_fix_standalone_tests.patch/mysql-test'
=== added directory '.pc/72_fix_standalone_tests.patch/mysql-test/lib'
=== added file '.pc/72_fix_standalone_tests.patch/mysql-test/lib/mtr_cases.pm'
--- .pc/72_fix_standalone_tests.patch/mysql-test/lib/mtr_cases.pm 1970-01-01 00:00:00 +0000
+++ .pc/72_fix_standalone_tests.patch/mysql-test/lib/mtr_cases.pm 2012-03-30 01:16:23 +0000
@@ -0,0 +1,1265 @@
1# -*- cperl -*-
2# Copyright (c) 2005, 2011, Oracle and/or its affiliates. All rights reserved.
3#
4# This program is free software; you can redistribute it and/or modify
5# it under the terms of the GNU General Public License as published by
6# the Free Software Foundation; version 2 of the License.
7#
8# This program is distributed in the hope that it will be useful,
9# but WITHOUT ANY WARRANTY; without even the implied warranty of
10# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11# GNU General Public License for more details.
12#
13# You should have received a copy of the GNU General Public License
14# along with this program; if not, write to the Free Software
15# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
16
17# This is a library file used by the Perl version of mysql-test-run,
18# and is part of the translation of the Bourne shell script with the
19# same name.
20
21package mtr_cases;
22use strict;
23
24use base qw(Exporter);
25our @EXPORT= qw(collect_option collect_test_cases);
26
27use mtr_report;
28use mtr_match;
29
30# Options used for the collect phase
31our $start_from;
32our $print_testcases;
33our $skip_rpl;
34our $do_test;
35our $skip_test;
36our $skip_combinations;
37our $binlog_format;
38our $enable_disabled;
39our $default_storage_engine;
40our $opt_with_ndbcluster_only;
41our $defaults_file;
42our $defaults_extra_file;
43our $quick_collect;
44# Set to 1 if you want the tests to override
45# default storage engine settings, and use MyISAM
46# as default. (temporary option used in connection
47# with the change of default storage engine to InnoDB)
48our $default_myisam= 1;
49
50
51sub collect_option {
52 my ($opt, $value)= @_;
53
54 # Evaluate $opt as string to use "Getopt::Long::Callback legacy API"
55 my $opt_name = "$opt";
56
57 # Convert - to _ in option name
58 $opt_name =~ s/-/_/g;
59 no strict 'refs';
60 ${$opt_name}= $value;
61}
62
63use File::Basename;
64use File::Spec::Functions qw / splitdir /;
65use IO::File();
66use My::Config;
67use My::Platform;
68use My::Test;
69use My::Find;
70
71require "mtr_misc.pl";
72
73# Precompiled regex's for tests to do or skip
74my $do_test_reg;
75my $skip_test_reg;
76
77# Related to adding InnoDB plugin combinations
78my $lib_innodb_plugin;
79my $do_innodb_plugin;
80
81# If "Quick collect", set to 1 once a test to run has been found.
82my $some_test_found;
83
84sub init_pattern {
85 my ($from, $what)= @_;
86 return undef unless defined $from;
87 if ( $from =~ /^[a-z0-9\.]*$/ ) {
88 # Does not contain any regex (except . that we allow as
89 # separator betwen suite and testname), make the pattern match
90 # beginning of string
91 $from= "^$from";
92 mtr_verbose("$what='$from'");
93 }
94 # Check that pattern is a valid regex
95 eval { "" =~/$from/; 1 } or
96 mtr_error("Invalid regex '$from' passed to $what\nPerl says: $@");
97 return $from;
98}
99
100
101##############################################################################
102#
103# Collect information about test cases to be run
104#
105##############################################################################
106
107sub collect_test_cases ($$$$) {
108 my $opt_reorder= shift; # True if we're reordering tests
109 my $suites= shift; # Semicolon separated list of test suites
110 my $opt_cases= shift;
111 my $opt_skip_test_list= shift;
112 my $cases= []; # Array of hash(one hash for each testcase)
113
114 # Unit tests off by default also if using --do-test or --start-from
115 $::opt_ctest= 0 if $::opt_ctest == -1 && ($do_test || $start_from);
116
117 $do_test_reg= init_pattern($do_test, "--do-test");
118 $skip_test_reg= init_pattern($skip_test, "--skip-test");
119
120 $lib_innodb_plugin=
121 my_find_file($::basedir,
122 ["storage/innodb_plugin", "storage/innodb_plugin/.libs",
123 "lib/mysql/plugin", "lib/plugin"],
124 ["ha_innodb_plugin.dll", "ha_innodb_plugin.so",
125 "ha_innodb_plugin.sl"],
126 NOT_REQUIRED);
127 $do_innodb_plugin= ($::mysql_version_id >= 50100 &&
128 !(IS_WINDOWS && $::opt_embedded_server) &&
129 $lib_innodb_plugin);
130
131 # If not reordering, we also shouldn't group by suites, unless
132 # no test cases were named.
133 # This also effects some logic in the loop following this.
134 if ($opt_reorder or !@$opt_cases)
135 {
136 foreach my $suite (split(",", $suites))
137 {
138 push(@$cases, collect_one_suite($suite, $opt_cases, $opt_skip_test_list));
139 last if $some_test_found;
140 }
141 }
142
143 if ( @$opt_cases )
144 {
145 # A list of tests was specified on the command line
146 # Check that the tests specified was found
147 # in at least one suite
148 foreach my $test_name_spec ( @$opt_cases )
149 {
150 my $found= 0;
151 my ($sname, $tname, $extension)= split_testname($test_name_spec);
152 foreach my $test ( @$cases )
153 {
154 last unless $opt_reorder;
155 # test->{name} is always in suite.name format
156 if ( $test->{name} =~ /^$sname.*\.$tname$/ )
157 {
158 $found= 1;
159 last;
160 }
161 }
162 if ( not $found )
163 {
164 $sname= "main" if !$opt_reorder and !$sname;
165 mtr_error("Could not find '$tname' in '$suites' suite(s)") unless $sname;
166 # If suite was part of name, find it there, may come with combinations
167 my @this_case = collect_one_suite($sname, [ $tname ]);
168 if (@this_case)
169 {
170 push (@$cases, @this_case);
171 }
172 else
173 {
174 mtr_error("Could not find '$tname' in '$sname' suite");
175 }
176 }
177 }
178 }
179
180 if ( $opt_reorder && !$quick_collect)
181 {
182 # Reorder the test cases in an order that will make them faster to run
183 # Make a mapping of test name to a string that represents how that test
184 # should be sorted among the other tests. Put the most important criterion
185 # first, then a sub-criterion, then sub-sub-criterion, etc.
186 foreach my $tinfo (@$cases)
187 {
188 my @criteria = ();
189
190 #
191 # Append the criteria for sorting, in order of importance.
192 #
193 push(@criteria, "ndb=" . ($tinfo->{'ndb_test'} ? "A" : "B"));
194 push(@criteria, $tinfo->{template_path});
195 # Group test with equal options together.
196 # Ending with "~" makes empty sort later than filled
197 my $opts= $tinfo->{'master_opt'} ? $tinfo->{'master_opt'} : [];
198 push(@criteria, join("!", sort @{$opts}) . "~");
199 # Add slave opts if any
200 if ($tinfo->{'slave_opt'})
201 {
202 push(@criteria, join("!", sort @{$tinfo->{'slave_opt'}}));
203 }
204 # This sorts tests with force-restart *before* identical tests
205 push(@criteria, $tinfo->{force_restart} ? "force-restart" : "no-restart");
206
207 $tinfo->{criteria}= join(" ", @criteria);
208 }
209
210 @$cases = sort {$a->{criteria} cmp $b->{criteria}; } @$cases;
211
212 # For debugging the sort-order
213 # foreach my $tinfo (@$cases)
214 # {
215 # my $tname= $tinfo->{name} . ' ' . $tinfo->{combination};
216 # my $crit= $tinfo->{criteria};
217 # print("$tname\n\t$crit\n");
218 # }
219 }
220
221 if (defined $print_testcases){
222 print_testcases(@$cases);
223 exit(1);
224 }
225
226 return $cases;
227
228}
229
230
231# Returns (suitename, testname, extension)
232sub split_testname {
233 my ($test_name)= @_;
234
235 # If .test file name is used, get rid of directory part
236 $test_name= basename($test_name) if $test_name =~ /\.test$/;
237
238 # Now split name on .'s
239 my @parts= split(/\./, $test_name);
240
241 if (@parts == 1){
242 # Only testname given, ex: alias
243 return (undef , $parts[0], undef);
244 } elsif (@parts == 2) {
245 # Either testname.test or suite.testname given
246 # Ex. main.alias or alias.test
247
248 if ($parts[1] eq "test")
249 {
250 return (undef , $parts[0], $parts[1]);
251 }
252 else
253 {
254 return ($parts[0], $parts[1], undef);
255 }
256
257 } elsif (@parts == 3) {
258 # Fully specified suitename.testname.test
259 # ex main.alias.test
260 return ( $parts[0], $parts[1], $parts[2]);
261 }
262
263 mtr_error("Illegal format of test name: $test_name");
264}
265
266
267sub collect_one_suite($)
268{
269 my $suite= shift; # Test suite name
270 my $opt_cases= shift;
271 my $opt_skip_test_list= shift;
272 my @cases; # Array of hash
273
274 mtr_verbose("Collecting: $suite");
275
276 my $suitedir= "$::glob_mysql_test_dir"; # Default
277 if ( $suite ne "main" )
278 {
279 # Allow suite to be path to "some dir" if $suite has at least
280 # one directory part
281 if ( -d $suite and splitdir($suite) > 1 ){
282 $suitedir= $suite;
283 mtr_report(" - from '$suitedir'");
284
285 }
286 else
287 {
288 $suitedir= my_find_dir($::basedir,
289 ["share/mysql-test/suite",
290 "mysql-test/suite",
291 "mysql-test",
292 # Look in storage engine specific suite dirs
293 "storage/*/mtr",
294 # Look in plugin specific suite dir
295 "plugin/$suite/tests",
296 ],
297 [$suite, "mtr"]);
298 }
299 mtr_verbose("suitedir: $suitedir");
300 }
301
302 my $testdir= "$suitedir/t";
303 my $resdir= "$suitedir/r";
304
305 # Check if t/ exists
306 if (-d $testdir){
307 # t/ exists
308
309 if ( -d $resdir )
310 {
311 # r/exists
312 }
313 else
314 {
315 # No r/, use t/ as result dir
316 $resdir= $testdir;
317 }
318
319 }
320 else {
321 # No t/ dir => there can' be any r/ dir
322 mtr_error("Can't have r/ dir without t/") if -d $resdir;
323
324 # No t/ or r/ => use suitedir
325 $resdir= $testdir= $suitedir;
326 }
327
328 mtr_verbose("testdir: $testdir");
329 mtr_verbose("resdir: $resdir");
330
331 # ----------------------------------------------------------------------
332 # Build a hash of disabled testcases for this suite
333 # ----------------------------------------------------------------------
334 my %disabled;
335 my @disabled_collection= @{$opt_skip_test_list} if defined @{$opt_skip_test_list};
336 unshift (@disabled_collection, "$testdir/disabled.def");
337 for my $skip (@disabled_collection)
338 {
339 if ( open(DISABLED, $skip ) )
340 {
341 # $^O on Windows considered not generic enough
342 my $plat= (IS_WINDOWS) ? 'windows' : $^O;
343
344 while ( <DISABLED> )
345 {
346 chomp;
347 #diasble the test case if platform matches
348 if ( /\@/ )
349 {
350 if ( /\@$plat/ )
351 {
352 /^\s*(\S+)\s*\@$plat.*:\s*(.*?)\s*$/ ;
353 $disabled{$1}= $2 if not exists $disabled{$1};
354 }
355 elsif ( /\@!(\S*)/ )
356 {
357 if ( $1 ne $plat)
358 {
359 /^\s*(\S+)\s*\@!.*:\s*(.*?)\s*$/ ;
360 $disabled{$1}= $2 if not exists $disabled{$1};
361 }
362 }
363 }
364 elsif ( /^\s*(\S+)\s*:\s*(.*?)\s*$/ )
365 {
366 chomp;
367 if ( /^\s*(\S+)\s*:\s*(.*?)\s*$/ )
368 {
369 $disabled{$1}= $2 if not exists $disabled{$1};
370 }
371 }
372 }
373 close DISABLED;
374 }
375 }
376
377 # Read suite.opt file
378 my $suite_opt_file= "$testdir/suite.opt";
379 my $suite_opts= [];
380 if ( -f $suite_opt_file )
381 {
382 $suite_opts= opts_from_file($suite_opt_file);
383 }
384
385 if ( @$opt_cases )
386 {
387 # Collect in specified order
388 foreach my $test_name_spec ( @$opt_cases )
389 {
390 my ($sname, $tname, $extension)= split_testname($test_name_spec);
391
392 # The test name parts have now been defined
393 #print " suite_name: $sname\n";
394 #print " tname: $tname\n";
395 #print " extension: $extension\n";
396
397 # Check cirrect suite if suitename is defined
398 next if (defined $sname and $suite ne $sname);
399
400 if ( defined $extension )
401 {
402 my $full_name= "$testdir/$tname.$extension";
403 # Extension was specified, check if the test exists
404 if ( ! -f $full_name)
405 {
406 # This is only an error if suite was specified, otherwise it
407 # could exist in another suite
408 mtr_error("Test '$full_name' was not found in suite '$sname'")
409 if $sname;
410
411 next;
412 }
413 }
414 else
415 {
416 # No extension was specified, use default
417 $extension= "test";
418 my $full_name= "$testdir/$tname.$extension";
419
420 # Test not found here, could exist in other suite
421 next if ( ! -f $full_name );
422 }
423
424 push(@cases,
425 collect_one_test_case($suitedir,
426 $testdir,
427 $resdir,
428 $suite,
429 $tname,
430 "$tname.$extension",
431 \%disabled,
432 $suite_opts));
433 }
434 }
435 else
436 {
437 opendir(TESTDIR, $testdir) or mtr_error("Can't open dir \"$testdir\": $!");
438
439 foreach my $elem ( sort readdir(TESTDIR) )
440 {
441 my $tname= mtr_match_extension($elem, 'test');
442
443 next unless defined $tname;
444
445 # Skip tests that does not match the --do-test= filter
446 next if ($do_test_reg and not $tname =~ /$do_test_reg/o);
447
448 push(@cases,
449 collect_one_test_case($suitedir,
450 $testdir,
451 $resdir,
452 $suite,
453 $tname,
454 $elem,
455 \%disabled,
456 $suite_opts));
457 }
458 closedir TESTDIR;
459 }
460
461 # Return empty list if no testcases found
462 return if (@cases == 0);
463
464 # ----------------------------------------------------------------------
465 # Read combinations for this suite and build testcases x combinations
466 # if any combinations exists
467 # ----------------------------------------------------------------------
468 if ( ! $skip_combinations && ! $quick_collect )
469 {
470 my @combinations;
471 my $combination_file= "$suitedir/combinations";
472 #print "combination_file: $combination_file\n";
473 if (@::opt_combinations)
474 {
475 # take the combination from command-line
476 mtr_verbose("Take the combination from command line");
477 foreach my $combination (@::opt_combinations) {
478 my $comb= {};
479 $comb->{name}= $combination;
480 push(@{$comb->{comb_opt}}, $combination);
481 push(@combinations, $comb);
482 }
483 }
484 elsif (-f $combination_file )
485 {
486 # Read combinations file in my.cnf format
487 mtr_verbose("Read combinations file");
488 my $config= My::Config->new($combination_file);
489 foreach my $group ($config->groups()) {
490 my $comb= {};
491 $comb->{name}= $group->name();
492 foreach my $option ( $group->options() ) {
493 push(@{$comb->{comb_opt}}, $option->option());
494 }
495 push(@combinations, $comb);
496 }
497 }
498
499 if (@combinations)
500 {
501 print " - adding combinations for $suite\n";
502 #print_testcases(@cases);
503
504 my @new_cases;
505 foreach my $comb (@combinations)
506 {
507 foreach my $test (@cases)
508 {
509
510 next if ( $test->{'skip'} );
511
512 # Skip this combination if the values it provides
513 # already are set in master_opt or slave_opt
514 if (My::Options::is_set($test->{master_opt}, $comb->{comb_opt}) &&
515 My::Options::is_set($test->{slave_opt}, $comb->{comb_opt}) ){
516 next;
517 }
518
519 # Copy test options
520 my $new_test= My::Test->new();
521 while (my ($key, $value) = each(%$test)) {
522 if (ref $value eq "ARRAY") {
523 push(@{$new_test->{$key}}, @$value);
524 } else {
525 $new_test->{$key}= $value;
526 }
527 }
528
529 # Append the combination options to master_opt and slave_opt
530 push(@{$new_test->{master_opt}}, @{$comb->{comb_opt}});
531 push(@{$new_test->{slave_opt}}, @{$comb->{comb_opt}});
532
533 # Add combination name short name
534 $new_test->{combination}= $comb->{name};
535
536 # Add the new test to new test cases list
537 push(@new_cases, $new_test);
538 }
539 }
540
541 # Add the plain test if it was not already added
542 # as part of a combination
543 my %added;
544 foreach my $new_test (@new_cases){
545 $added{$new_test->{name}}= 1;
546 }
547 foreach my $test (@cases){
548 push(@new_cases, $test) unless $added{$test->{name}};
549 }
550
551
552 #print_testcases(@new_cases);
553 @cases= @new_cases;
554 #print_testcases(@cases);
555 }
556 }
557
558 optimize_cases(\@cases);
559 #print_testcases(@cases);
560
561 return @cases;
562}
563
564
565
566#
567# Loop through all test cases
568# - optimize which test to run by skipping unnecessary ones
569# - update settings if necessary
570#
571sub optimize_cases {
572 my ($cases)= @_;
573
574 foreach my $tinfo ( @$cases )
575 {
576 # Skip processing if already marked as skipped
577 next if $tinfo->{skip};
578
579 # =======================================================
580 # If a special binlog format was selected with
581 # --mysqld=--binlog-format=x, skip all test that does not
582 # support it
583 # =======================================================
584 #print "binlog_format: $binlog_format\n";
585 if (defined $binlog_format )
586 {
587 # =======================================================
588 # Fixed --binlog-format=x specified on command line
589 # =======================================================
590 if ( defined $tinfo->{'binlog_formats'} )
591 {
592 #print "binlog_formats: ". join(", ", @{$tinfo->{binlog_formats}})."\n";
593
594 # The test supports different binlog formats
595 # check if the selected one is ok
596 my $supported=
597 grep { $_ eq $binlog_format } @{$tinfo->{'binlog_formats'}};
598 if ( !$supported )
599 {
600 $tinfo->{'skip'}= 1;
601 $tinfo->{'comment'}=
602 "Doesn't support --binlog-format='$binlog_format'";
603 }
604 }
605 }
606 else
607 {
608 # =======================================================
609 # Use dynamic switching of binlog format
610 # =======================================================
611
612 # Get binlog-format used by this test from master_opt
613 my $test_binlog_format;
614 foreach my $opt ( @{$tinfo->{master_opt}} ) {
615 $test_binlog_format=
616 mtr_match_prefix($opt, "--binlog-format=") || $test_binlog_format;
617 }
618
619 if (defined $test_binlog_format and
620 defined $tinfo->{binlog_formats} )
621 {
622 my $supported=
623 grep { $_ eq $test_binlog_format } @{$tinfo->{'binlog_formats'}};
624 if ( !$supported )
625 {
626 $tinfo->{'skip'}= 1;
627 $tinfo->{'comment'}=
628 "Doesn't support --binlog-format='$test_binlog_format'";
629 next;
630 }
631 }
632 }
633
634 # =======================================================
635 # Check that engine selected by
636 # --default-storage-engine=<engine> is supported
637 # =======================================================
638 my %builtin_engines = ('myisam' => 1, 'memory' => 1, 'csv' => 1);
639
640 foreach my $opt ( @{$tinfo->{master_opt}} ) {
641 my $default_engine=
642 mtr_match_prefix($opt, "--default-storage-engine=");
643
644 # Allow use of uppercase, convert to all lower case
645 $default_engine =~ tr/A-Z/a-z/;
646
647 if (defined $default_engine){
648
649 #print " $tinfo->{name}\n";
650 #print " - The test asked to use '$default_engine'\n";
651
652 #my $engine_value= $::mysqld_variables{$default_engine};
653 #print " - The mysqld_variables says '$engine_value'\n";
654
655 if ( ! exists $::mysqld_variables{$default_engine} and
656 ! exists $builtin_engines{$default_engine} )
657 {
658 $tinfo->{'skip'}= 1;
659 $tinfo->{'comment'}=
660 "'$default_engine' not supported";
661 }
662
663 $tinfo->{'ndb_test'}= 1
664 if ( $default_engine =~ /^ndb/i );
665 $tinfo->{'innodb_test'}= 1
666 if ( $default_engine =~ /^innodb/i );
667 }
668 }
669
670 if ($quick_collect && ! $tinfo->{'skip'})
671 {
672 $some_test_found= 1;
673 return;
674 }
675 }
676}
677
678
679#
680# Read options from the given opt file and append them as an array
681# to $tinfo->{$opt_name}
682#
683sub process_opts_file {
684 my ($tinfo, $opt_file, $opt_name)= @_;
685
686 if ( -f $opt_file )
687 {
688 my $opts= opts_from_file($opt_file);
689
690 foreach my $opt ( @$opts )
691 {
692 my $value;
693
694 # The opt file is used both to send special options to the mysqld
695 # as well as pass special test case specific options to this
696 # script
697
698 $value= mtr_match_prefix($opt, "--timezone=");
699 if ( defined $value )
700 {
701 $tinfo->{'timezone'}= $value;
702 next;
703 }
704
705 $value= mtr_match_prefix($opt, "--result-file=");
706 if ( defined $value )
707 {
708 # Specifies the file mysqltest should compare
709 # output against
710 $tinfo->{'result_file'}= "r/$value.result";
711 next;
712 }
713
714 $value= mtr_match_prefix($opt, "--config-file-template=");
715 if ( defined $value)
716 {
717 # Specifies the configuration file to use for this test
718 $tinfo->{'template_path'}= dirname($tinfo->{path})."/$value";
719 next;
720 }
721
722 # If we set default time zone, remove the one we have
723 $value= mtr_match_prefix($opt, "--default-time-zone=");
724 if ( defined $value )
725 {
726 # Set timezone for this test case to something different
727 $tinfo->{'timezone'}= "GMT-8";
728 # Fallthrough, add the --default-time-zone option
729 }
730
731 # The --restart option forces a restart even if no special
732 # option is set. If the options are the same as next testcase
733 # there is no need to restart after the testcase
734 # has completed
735 if ( $opt eq "--force-restart" )
736 {
737 $tinfo->{'force_restart'}= 1;
738 next;
739 }
740
741 $value= mtr_match_prefix($opt, "--testcase-timeout=");
742 if ( defined $value ) {
743 # Overrides test case timeout for this test
744 $tinfo->{'case-timeout'}= $value;
745 next;
746 }
747
748 # Ok, this was a real option, add it
749 push(@{$tinfo->{$opt_name}}, $opt);
750 }
751 }
752}
753
754##############################################################################
755#
756# Collect information about a single test case
757#
758##############################################################################
759
760sub collect_one_test_case {
761 my $suitedir= shift;
762 my $testdir= shift;
763 my $resdir= shift;
764 my $suitename= shift;
765 my $tname= shift;
766 my $filename= shift;
767 my $disabled= shift;
768 my $suite_opts= shift;
769
770 #print "collect_one_test_case\n";
771 #print " suitedir: $suitedir\n";
772 #print " testdir: $testdir\n";
773 #print " resdir: $resdir\n";
774 #print " suitename: $suitename\n";
775 #print " tname: $tname\n";
776 #print " filename: $filename\n";
777
778 # ----------------------------------------------------------------------
779 # Check --start-from
780 # ----------------------------------------------------------------------
781 if ( $start_from )
782 {
783 # start_from can be specified as [suite.].testname_prefix
784 my ($suite, $test, $ext)= split_testname($start_from);
785
786 if ( $suite and $suitename lt $suite){
787 return; # Skip silently
788 }
789 if ( $tname lt $test ){
790 return; # Skip silently
791 }
792 }
793
794 # ----------------------------------------------------------------------
795 # Set defaults
796 # ----------------------------------------------------------------------
797 my $tinfo= My::Test->new
798 (
799 name => "$suitename.$tname",
800 shortname => $tname,
801 path => "$testdir/$filename",
802
803 );
804
805 my $result_file= "$resdir/$tname.result";
806 if (-f $result_file) {
807 # Allow nonexistsing result file
808 # in that case .test must issue "exit" otherwise test
809 # should fail by default
810 $tinfo->{result_file}= $result_file;
811 }
812 else {
813 # No .result file exist
814 # Remember the path where it should be
815 # saved in case of --record
816 $tinfo->{record_file}= $result_file;
817 }
818
819 # ----------------------------------------------------------------------
820 # Skip some tests but include in list, just mark them as skipped
821 # ----------------------------------------------------------------------
822 if ( $skip_test_reg and $tname =~ /$skip_test_reg/o )
823 {
824 $tinfo->{'skip'}= 1;
825 return $tinfo;
826 }
827
828 # ----------------------------------------------------------------------
829 # Check for disabled tests
830 # ----------------------------------------------------------------------
831 my $marked_as_disabled= 0;
832 if ( $disabled->{$tname} or $disabled->{"$suitename.$tname"} )
833 {
834 # Test was marked as disabled in suites disabled.def file
835 $marked_as_disabled= 1;
836 # Test name may have been disabled with or without suite name part
837 $tinfo->{'comment'}= $disabled->{$tname} ||
838 $disabled->{"$suitename.$tname"};
839 }
840
841 my $disabled_file= "$testdir/$tname.disabled";
842 if ( -f $disabled_file )
843 {
844 $marked_as_disabled= 1;
845 $tinfo->{'comment'}= mtr_fromfile($disabled_file);
846 }
847
848 if ( $marked_as_disabled )
849 {
850 if ( $enable_disabled )
851 {
852 # User has selected to run all disabled tests
853 mtr_report(" - $tinfo->{name} wil be run although it's been disabled\n",
854 " due to '$tinfo->{comment}'");
855 }
856 else
857 {
858 $tinfo->{'skip'}= 1;
859 $tinfo->{'disable'}= 1; # Sub type of 'skip'
860 return $tinfo;
861 }
862 }
863
864 # ----------------------------------------------------------------------
865 # Append suite extra options to both master and slave
866 # ----------------------------------------------------------------------
867 push(@{$tinfo->{'master_opt'}}, @$suite_opts);
868 push(@{$tinfo->{'slave_opt'}}, @$suite_opts);
869
870 #-----------------------------------------------------------------------
871 # Check for test specific config file
872 #-----------------------------------------------------------------------
873 my $test_cnf_file= "$testdir/$tname.cnf";
874 if ( -f $test_cnf_file) {
875 # Specifies the configuration file to use for this test
876 $tinfo->{'template_path'}= $test_cnf_file;
877 }
878
879 # ----------------------------------------------------------------------
880 # Check for test specific config file
881 # ----------------------------------------------------------------------
882 my $test_cnf_file= "$testdir/$tname.cnf";
883 if ( -f $test_cnf_file ) {
884 # Specifies the configuration file to use for this test
885 $tinfo->{'template_path'}= $test_cnf_file;
886 }
887
888 # ----------------------------------------------------------------------
889 # master sh
890 # ----------------------------------------------------------------------
891 my $master_sh= "$testdir/$tname-master.sh";
892 if ( -f $master_sh )
893 {
894 if ( IS_WIN32PERL )
895 {
896 $tinfo->{'skip'}= 1;
897 $tinfo->{'comment'}= "No tests with sh scripts on Windows";
898 return $tinfo;
899 }
900 else
901 {
902 $tinfo->{'master_sh'}= $master_sh;
903 }
904 }
905
906 # ----------------------------------------------------------------------
907 # slave sh
908 # ----------------------------------------------------------------------
909 my $slave_sh= "$testdir/$tname-slave.sh";
910 if ( -f $slave_sh )
911 {
912 if ( IS_WIN32PERL )
913 {
914 $tinfo->{'skip'}= 1;
915 $tinfo->{'comment'}= "No tests with sh scripts on Windows";
916 return $tinfo;
917 }
918 else
919 {
920 $tinfo->{'slave_sh'}= $slave_sh;
921 }
922 }
923
924 # ----------------------------------------------------------------------
925 # <tname>.slave-mi
926 # ----------------------------------------------------------------------
927 mtr_error("$tname: slave-mi not supported anymore")
928 if ( -f "$testdir/$tname.slave-mi");
929
930
931 tags_from_test_file($tinfo,"$testdir/${tname}.test");
932
933 if ( defined $default_storage_engine )
934 {
935 # Different default engine is used
936 # tag test to require that engine
937 $tinfo->{'ndb_test'}= 1
938 if ( $default_storage_engine =~ /^ndb/i );
939
940 $tinfo->{'innodb_test'}= 1
941 if ( $default_storage_engine =~ /^innodb/i );
942
943 }
944
945 if ( $tinfo->{'big_test'} and ! $::opt_big_test )
946 {
947 $tinfo->{'skip'}= 1;
948 $tinfo->{'comment'}= "Test needs 'big-test' option";
949 return $tinfo
950 }
951
952 if ( $tinfo->{'need_debug'} && ! $::debug_compiled_binaries )
953 {
954 $tinfo->{'skip'}= 1;
955 $tinfo->{'comment'}= "Test needs debug binaries";
956 return $tinfo
957 }
958
959 if ( $tinfo->{'ndb_test'} )
960 {
961 # This is a NDB test
962 if ( $::opt_skip_ndbcluster == 2 )
963 {
964 # Ndb is not supported, skip it
965 $tinfo->{'skip'}= 1;
966 $tinfo->{'comment'}= "No ndbcluster support or ndb tests not enabled";
967 return $tinfo;
968 }
969 elsif ( $::opt_skip_ndbcluster )
970 {
971 # All ndb test's should be skipped
972 $tinfo->{'skip'}= 1;
973 $tinfo->{'comment'}= "No ndbcluster tests(--skip-ndbcluster)";
974 return $tinfo;
975 }
976 }
977 else
978 {
979 # This is not a ndb test
980 if ( $opt_with_ndbcluster_only )
981 {
982 # Only the ndb test should be run, all other should be skipped
983 $tinfo->{'skip'}= 1;
984 $tinfo->{'comment'}= "Only ndbcluster tests";
985 return $tinfo;
986 }
987 }
988
989 if ($tinfo->{'federated_test'})
990 {
991 # This is a test that needs federated, enable it
992 push(@{$tinfo->{'master_opt'}}, "--loose-federated");
993 push(@{$tinfo->{'slave_opt'}}, "--loose-federated");
994 }
995
996 if ( $tinfo->{'innodb_test'} )
997 {
998 # This is a test that needs innodb
999 if ( $::mysqld_variables{'innodb'} eq "OFF" ||
1000 ! exists $::mysqld_variables{'innodb'} )
1001 {
1002 # innodb is not supported, skip it
1003 $tinfo->{'skip'}= 1;
1004 # This comment is checked for running with innodb plugin (see above),
1005 # please keep that in mind if changing the text.
1006 $tinfo->{'comment'}= "No innodb support";
1007 # But continue processing if we may run it with innodb plugin
1008 return $tinfo unless $do_innodb_plugin;
1009 }
1010 }
1011 elsif ($default_myisam)
1012 {
1013 # This is a temporary fix to allow non-innodb tests to run even if
1014 # the default storage engine is innodb.
1015 push(@{$tinfo->{'master_opt'}}, "--default-storage-engine=MyISAM");
1016 push(@{$tinfo->{'slave_opt'}}, "--default-storage-engine=MyISAM");
1017 }
1018
1019 if ( $tinfo->{'need_binlog'} )
1020 {
1021 if (grep(/^--skip-log-bin/, @::opt_extra_mysqld_opt) )
1022 {
1023 $tinfo->{'skip'}= 1;
1024 $tinfo->{'comment'}= "Test needs binlog";
1025 return $tinfo;
1026 }
1027 }
1028 else
1029 {
1030 # Test does not need binlog, add --skip-binlog to
1031 # the options used when starting
1032 push(@{$tinfo->{'master_opt'}}, "--loose-skip-log-bin");
1033 push(@{$tinfo->{'slave_opt'}}, "--loose-skip-log-bin");
1034 }
1035
1036 if ( $tinfo->{'rpl_test'} )
1037 {
1038 if ( $skip_rpl )
1039 {
1040 $tinfo->{'skip'}= 1;
1041 $tinfo->{'comment'}= "No replication tests(--skip-rpl)";
1042 return $tinfo;
1043 }
1044 }
1045
1046 if ( $::opt_embedded_server )
1047 {
1048 if ( $tinfo->{'not_embedded'} )
1049 {
1050 $tinfo->{'skip'}= 1;
1051 $tinfo->{'comment'}= "Not run for embedded server";
1052 return $tinfo;
1053 }
1054 }
1055
1056 if ( $tinfo->{'need_ssl'} )
1057 {
1058 # This is a test that needs ssl
1059 if ( ! $::opt_ssl_supported ) {
1060 # SSL is not supported, skip it
1061 $tinfo->{'skip'}= 1;
1062 $tinfo->{'comment'}= "No SSL support";
1063 return $tinfo;
1064 }
1065 }
1066
1067 # ----------------------------------------------------------------------
1068 # Find config file to use if not already selected in <testname>.opt file
1069 # ----------------------------------------------------------------------
1070 if (defined $defaults_file) {
1071 # Using same config file for all tests
1072 $tinfo->{template_path}= $defaults_file;
1073 }
1074 elsif (! $tinfo->{template_path} )
1075 {
1076 my $config= "$suitedir/my.cnf";
1077 if (! -f $config )
1078 {
1079 # assume default.cnf will be used
1080 $config= "include/default_my.cnf";
1081
1082 # Suite has no config, autodetect which one to use
1083 if ( $tinfo->{rpl_test} ){
1084 $config= "suite/rpl/my.cnf";
1085 if ( $tinfo->{ndb_test} ){
1086 $config= "suite/rpl_ndb/my.cnf";
1087 }
1088 }
1089 elsif ( $tinfo->{ndb_test} ){
1090 $config= "suite/ndb/my.cnf";
1091 }
1092 }
1093 $tinfo->{template_path}= $config;
1094 }
1095
1096 # Set extra config file to use
1097 if (defined $defaults_extra_file) {
1098 $tinfo->{extra_template_path}= $defaults_extra_file;
1099 }
1100
1101 # ----------------------------------------------------------------------
1102 # Append mysqld extra options to both master and slave
1103 # ----------------------------------------------------------------------
1104 push(@{$tinfo->{'master_opt'}}, @::opt_extra_mysqld_opt);
1105 push(@{$tinfo->{'slave_opt'}}, @::opt_extra_mysqld_opt);
1106
1107 # ----------------------------------------------------------------------
1108 # Add master opts, extra options only for master
1109 # ----------------------------------------------------------------------
1110 process_opts_file($tinfo, "$testdir/$tname-master.opt", 'master_opt');
1111
1112 # ----------------------------------------------------------------------
1113 # Add slave opts, list of extra option only for slave
1114 # ----------------------------------------------------------------------
1115 process_opts_file($tinfo, "$testdir/$tname-slave.opt", 'slave_opt');
1116
1117 return $tinfo;
1118}
1119
1120
1121# List of tags in the .test files that if found should set
1122# the specified value in "tinfo"
1123my @tags=
1124(
1125 ["include/have_binlog_format_row.inc", "binlog_formats", ["row"]],
1126 ["include/have_binlog_format_statement.inc", "binlog_formats", ["statement"]],
1127 ["include/have_binlog_format_mixed.inc", "binlog_formats", ["mixed"]],
1128 ["include/have_binlog_format_mixed_or_row.inc",
1129 "binlog_formats", ["mixed", "row"]],
1130 ["include/have_binlog_format_mixed_or_statement.inc",
1131 "binlog_formats", ["mixed", "statement"]],
1132 ["include/have_binlog_format_row_or_statement.inc",
1133 "binlog_formats", ["row", "statement"]],
1134
1135 ["include/have_log_bin.inc", "need_binlog", 1],
1136
1137 ["include/have_innodb.inc", "innodb_test", 1],
1138 ["include/big_test.inc", "big_test", 1],
1139 ["include/have_debug.inc", "need_debug", 1],
1140 ["include/have_ndb.inc", "ndb_test", 1],
1141 ["include/have_multi_ndb.inc", "ndb_test", 1],
1142 ["include/master-slave.inc", "rpl_test", 1],
1143 ["include/ndb_master-slave.inc", "rpl_test", 1],
1144 ["include/ndb_master-slave.inc", "ndb_test", 1],
1145 ["federated.inc", "federated_test", 1],
1146 ["include/not_embedded.inc", "not_embedded", 1],
1147 ["include/have_ssl.inc", "need_ssl", 1],
1148);
1149
1150
1151sub tags_from_test_file {
1152 my $tinfo= shift;
1153 my $file= shift;
1154 #mtr_verbose("$file");
1155 my $F= IO::File->new($file) or mtr_error("can't open file \"$file\": $!");
1156
1157 while ( my $line= <$F> )
1158 {
1159
1160 # Skip line if it start's with #
1161 next if ( $line =~ /^#/ );
1162
1163 # Match this line against tag in "tags" array
1164 foreach my $tag (@tags)
1165 {
1166 if ( index($line, $tag->[0]) >= 0 )
1167 {
1168 # Tag matched, assign value to "tinfo"
1169 $tinfo->{"$tag->[1]"}= $tag->[2];
1170 }
1171 }
1172
1173 # If test sources another file, open it as well
1174 if ( $line =~ /^\-\-([[:space:]]*)source(.*)$/ or
1175 $line =~ /^([[:space:]]*)source(.*);$/ )
1176 {
1177 my $value= $2;
1178 $value =~ s/^\s+//; # Remove leading space
1179 $value =~ s/[[:space:]]+$//; # Remove ending space
1180
1181 # Sourced file may exist relative to test or
1182 # in global location
1183 foreach my $sourced_file (dirname($file). "/$value",
1184 "$::glob_mysql_test_dir/$value")
1185 {
1186 if ( -f $sourced_file )
1187 {
1188 # Only source the file if it exists, we may get
1189 # false positives in the regexes above if someone
1190 # writes "source nnnn;" in a test case(such as mysqltest.test)
1191 tags_from_test_file($tinfo, $sourced_file);
1192 last;
1193 }
1194 }
1195 }
1196
1197 }
1198}
1199
1200sub unspace {
1201 my $string= shift;
1202 my $quote= shift;
1203 $string =~ s/[ \t]/\x11/g;
1204 return "$quote$string$quote";
1205}
1206
1207
1208sub opts_from_file ($) {
1209 my $file= shift;
1210
1211 open(FILE,"<",$file) or mtr_error("can't open file \"$file\": $!");
1212 my @args;
1213 while ( <FILE> )
1214 {
1215 chomp;
1216
1217 # --init_connect=set @a='a\\0c'
1218 s/^\s+//; # Remove leading space
1219 s/\s+$//; # Remove ending space
1220
1221 # This is strange, but we need to fill whitespace inside
1222 # quotes with something, to remove later. We do this to
1223 # be able to split on space. Else, we have trouble with
1224 # options like
1225 #
1226 # --someopt="--insideopt1 --insideopt2"
1227 #
1228 # But still with this, we are not 100% sure it is right,
1229 # we need a shell to do it right.
1230
1231 s/\'([^\'\"]*)\'/unspace($1,"\x0a")/ge;
1232 s/\"([^\'\"]*)\"/unspace($1,"\x0b")/ge;
1233 s/\'([^\'\"]*)\'/unspace($1,"\x0a")/ge;
1234 s/\"([^\'\"]*)\"/unspace($1,"\x0b")/ge;
1235
1236 foreach my $arg (split(/[ \t]+/))
1237 {
1238 $arg =~ tr/\x11\x0a\x0b/ \'\"/; # Put back real chars
1239 # The outermost quotes has to go
1240 $arg =~ s/^([^\'\"]*)\'(.*)\'([^\'\"]*)$/$1$2$3/
1241 or $arg =~ s/^([^\'\"]*)\"(.*)\"([^\'\"]*)$/$1$2$3/;
1242 $arg =~ s/\\\\/\\/g;
1243
1244 # Do not pass empty string since my_getopt is not capable to handle it.
1245 if (length($arg)) {
1246 push(@args, $arg);
1247 }
1248 }
1249 }
1250 close FILE;
1251 return \@args;
1252}
1253
1254sub print_testcases {
1255 my (@cases)= @_;
1256
1257 print "=" x 60, "\n";
1258 foreach my $test (@cases){
1259 $test->print_test();
1260 }
1261 print "=" x 60, "\n";
1262}
1263
1264
12651;
01266
=== added file '.pc/applied-patches'
--- .pc/applied-patches 1970-01-01 00:00:00 +0000
+++ .pc/applied-patches 2012-03-30 01:16:23 +0000
@@ -0,0 +1,6 @@
138_scripts__mysqld_safe.sh__signals.patch
262_disable_tests.patch
370_mysql_va_list.patch
471_disable_rpl_tests.patch
572_fix_standalone_tests.patch
6fix-mysqldump-test.patch
07
=== renamed file '.pc/applied-patches' => '.pc/applied-patches.moved'
=== added directory '.pc/fix-mysqldump-test.patch'
=== renamed directory '.pc/fix-mysqldump-test.patch' => '.pc/fix-mysqldump-test.patch.moved'
=== added file '.pc/fix-mysqldump-test.patch/.timestamp'
=== added directory '.pc/fix-mysqldump-test.patch/mysql-test'
=== added directory '.pc/fix-mysqldump-test.patch/mysql-test/r'
=== added file '.pc/fix-mysqldump-test.patch/mysql-test/r/mysqldump.result'
--- .pc/fix-mysqldump-test.patch/mysql-test/r/mysqldump.result 1970-01-01 00:00:00 +0000
+++ .pc/fix-mysqldump-test.patch/mysql-test/r/mysqldump.result 2012-03-30 01:16:23 +0000
@@ -0,0 +1,5207 @@
1# Bug#37938 Test "mysqldump" lacks various insert statements
2# Turn off concurrent inserts to avoid random errors
3# NOTE: We reset the variable back to saved value at the end of test
4SET @OLD_CONCURRENT_INSERT = @@GLOBAL.CONCURRENT_INSERT;
5SET @@GLOBAL.CONCURRENT_INSERT = 0;
6DROP TABLE IF EXISTS t1, `"t"1`, t1aa, t2, t2aa, t3;
7drop database if exists mysqldump_test_db;
8drop database if exists db1;
9drop database if exists db2;
10drop view if exists v1, v2, v3;
11CREATE TABLE t1(a INT, KEY (a)) KEY_BLOCK_SIZE=1024;
12INSERT INTO t1 VALUES (1), (2);
13<?xml version="1.0"?>
14<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
15<database name="test">
16 <table_structure name="t1">
17 <field Field="a" Type="int(11)" Null="YES" Key="MUL" Extra="" Comment="" />
18 <key Table="t1" Non_unique="1" Key_name="a" Seq_in_index="1" Column_name="a" Collation="A" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />
19 </table_structure>
20 <table_data name="t1">
21 <row>
22 <field name="a">1</field>
23 </row>
24 <row>
25 <field name="a">2</field>
26 </row>
27 </table_data>
28</database>
29</mysqldump>
30DROP TABLE t1;
31#
32# Bug#2005 Long decimal comparison bug.
33#
34CREATE TABLE t1 (a decimal(64, 20));
35INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"),
36("0987654321098765432109876543210987654321");
37/*!40101 SET @saved_cs_client = @@character_set_client */;
38/*!40101 SET character_set_client = utf8 */;
39CREATE TABLE `t1` (
40 `a` decimal(64,20) DEFAULT NULL
41) ENGINE=MyISAM DEFAULT CHARSET=latin1;
42/*!40101 SET character_set_client = @saved_cs_client */;
43INSERT INTO `t1` VALUES (1234567890123456789012345678901234567890.00000000000000000000),(987654321098765432109876543210987654321.00000000000000000000);
44DROP TABLE t1;
45#
46# Bug#2055 mysqldump should replace "-inf" numeric field values with "NULL"
47#
48CREATE TABLE t1 (a double);
49INSERT INTO t1 VALUES ('-9e999999');
50Warnings:
51Warning 1264 Out of range value for column 'a' at row 1
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `t1` (
55 `a` double DEFAULT NULL
56) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57/*!40101 SET character_set_client = @saved_cs_client */;
58INSERT INTO `t1` VALUES (-1.7976931348623157e308);
59DROP TABLE t1;
60#
61# Bug#3361 mysqldump quotes DECIMAL values inconsistently
62#
63CREATE TABLE t1 (a DECIMAL(10,5), b FLOAT);
64INSERT INTO t1 VALUES (1.2345, 2.3456);
65INSERT INTO t1 VALUES ('1.2345', 2.3456);
66INSERT INTO t1 VALUES ("1.2345", 2.3456);
67SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI_QUOTES';
68INSERT INTO t1 VALUES (1.2345, 2.3456);
69INSERT INTO t1 VALUES ('1.2345', 2.3456);
70INSERT INTO t1 VALUES ("1.2345", 2.3456);
71ERROR 42S22: Unknown column '1.2345' in 'field list'
72SET SQL_MODE=@OLD_SQL_MODE;
73/*!40101 SET @saved_cs_client = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `t1` (
76 `a` decimal(10,5) DEFAULT NULL,
77 `b` float DEFAULT NULL
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79/*!40101 SET character_set_client = @saved_cs_client */;
80INSERT INTO `t1` VALUES (1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456);
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `t1` (
84 `a` decimal(10,5) DEFAULT NULL,
85 `b` float DEFAULT NULL
86);
87/*!40101 SET character_set_client = @saved_cs_client */;
88INSERT INTO `t1` VALUES (1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456);
89
90/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
91/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
92/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
93/*!40101 SET NAMES utf8 */;
94/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
95/*!40103 SET TIME_ZONE='+00:00' */;
96/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
97/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
98/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
99/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
100DROP TABLE IF EXISTS `t1`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `t1` (
104 `a` decimal(10,5) DEFAULT NULL,
105 `b` float DEFAULT NULL
106);
107/*!40101 SET character_set_client = @saved_cs_client */;
108
109LOCK TABLES `t1` WRITE;
110/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
111INSERT INTO `t1` VALUES (1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456);
112/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
113UNLOCK TABLES;
114/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
115
116/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
117/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
118/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
119/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
120/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
121/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
122/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
123
124/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
125/*!40103 SET TIME_ZONE='+00:00' */;
126/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
127/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
128/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
129/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `t1` (
133 `a` decimal(10,5) DEFAULT NULL,
134 `b` float DEFAULT NULL
135);
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138INSERT INTO `t1` VALUES (1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456),(1.23450,2.3456);
139/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
140
141/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
142/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
143/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
144/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
145
146DROP TABLE t1;
147CREATE TABLE t1(a int, b text, c varchar(3));
148INSERT INTO t1 VALUES (1, "test", "tes"), (2, "TEST", "TES");
149<?xml version="1.0"?>
150<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
151<database name="test">
152 <table_structure name="t1">
153 <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
154 <field Field="b" Type="text" Null="YES" Key="" Extra="" Comment="" />
155 <field Field="c" Type="varchar(3)" Null="YES" Key="" Extra="" Comment="" />
156 </table_structure>
157 <table_data name="t1">
158 <row>
159 <field name="a">1</field>
160 <field name="b">test</field>
161 <field name="c">tes</field>
162 </row>
163 <row>
164 <field name="a">2</field>
165 <field name="b">TEST</field>
166 <field name="c">TES</field>
167 </row>
168 </table_data>
169</database>
170</mysqldump>
171DROP TABLE t1;
172#
173# Bug#1707 mysqldump -X does't quote field and table names
174#
175CREATE TABLE t1 (`a"b"` char(2));
176INSERT INTO t1 VALUES ("1\""), ("\"2");
177<?xml version="1.0"?>
178<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
179<database name="test">
180 <table_structure name="t1">
181 <field Field="a&quot;b&quot;" Type="char(2)" Null="YES" Key="" Extra="" Comment="" />
182 </table_structure>
183 <table_data name="t1">
184 <row>
185 <field name="a&quot;b&quot;">1&quot;</field>
186 </row>
187 <row>
188 <field name="a&quot;b&quot;">&quot;2</field>
189 </row>
190 </table_data>
191</database>
192</mysqldump>
193DROP TABLE t1;
194#
195# Bug#1994 mysqldump does not correctly dump UCS2 data
196# Bug#4261 mysqldump 10.7 (mysql 4.1.2) --skip-extended-insert drops NULL from inserts
197#
198CREATE TABLE t1 (a VARCHAR(255)) DEFAULT CHARSET koi8r;
199INSERT INTO t1 VALUES (_koi8r x'C1C2C3C4C5'), (NULL);
200
201/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
202/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
203/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
204/*!40101 SET NAMES utf8 */;
205/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
206/*!40103 SET TIME_ZONE='+00:00' */;
207/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
208/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
209/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
210/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
211DROP TABLE IF EXISTS `t1`;
212/*!40101 SET @saved_cs_client = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `t1` (
215 `a` varchar(255) DEFAULT NULL
216) ENGINE=MyISAM DEFAULT CHARSET=koi8r;
217/*!40101 SET character_set_client = @saved_cs_client */;
218
219LOCK TABLES `t1` WRITE;
220/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
221INSERT INTO `t1` VALUES ('абцде');
222INSERT INTO `t1` VALUES (NULL);
223/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
224UNLOCK TABLES;
225/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
226
227/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
228/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
229/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
230/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
231/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
232/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
233/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
234
235DROP TABLE t1;
236#
237# Bug#2634 mysqldump in --compatible=mysql4
238#
239CREATE TABLE t1 (a int) ENGINE=MYISAM;
240INSERT INTO t1 VALUES (1), (2);
241/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
242/*!40103 SET TIME_ZONE='+00:00' */;
243/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
244/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
245/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
246/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
247DROP TABLE IF EXISTS `t1`;
248CREATE TABLE `t1` (
249 `a` int(11) DEFAULT NULL
250) TYPE=MyISAM;
251
252LOCK TABLES `t1` WRITE;
253/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
254INSERT INTO `t1` VALUES (1),(2);
255/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
256UNLOCK TABLES;
257/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
258
259/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
260/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
261/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
262/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
263
264/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
265/*!40103 SET TIME_ZONE='+00:00' */;
266/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
267/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
268/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
269/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
270DROP TABLE IF EXISTS `t1`;
271CREATE TABLE `t1` (
272 `a` int(11) DEFAULT NULL
273) TYPE=MyISAM;
274
275LOCK TABLES `t1` WRITE;
276/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
277INSERT INTO `t1` VALUES (1),(2);
278/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
279UNLOCK TABLES;
280/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
281
282/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
283/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
284/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
285/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
286
287DROP TABLE t1;
288#
289# Bug#2592 mysqldump doesn't quote "tricky" names correctly
290#
291create table ```a` (i int);
292/*!40101 SET @saved_cs_client = @@character_set_client */;
293/*!40101 SET character_set_client = utf8 */;
294CREATE TABLE ```a` (
295 `i` int(11) DEFAULT NULL
296) ENGINE=MyISAM DEFAULT CHARSET=latin1;
297/*!40101 SET character_set_client = @saved_cs_client */;
298drop table ```a`;
299#
300# Bug#2591 mysqldump quotes names inconsistently
301#
302create table t1(a int);
303
304/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
305/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
306/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
307/*!40101 SET NAMES utf8 */;
308/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
309/*!40103 SET TIME_ZONE='+00:00' */;
310/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
311/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
312/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
313/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
314DROP TABLE IF EXISTS `t1`;
315/*!40101 SET @saved_cs_client = @@character_set_client */;
316/*!40101 SET character_set_client = utf8 */;
317CREATE TABLE `t1` (
318 `a` int(11) DEFAULT NULL
319) ENGINE=MyISAM DEFAULT CHARSET=latin1;
320/*!40101 SET character_set_client = @saved_cs_client */;
321
322LOCK TABLES `t1` WRITE;
323/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
324/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
325UNLOCK TABLES;
326/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
327
328/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
329/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
330/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
331/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
332/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
333/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
334/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
335
336/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
337/*!40103 SET TIME_ZONE='+00:00' */;
338/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
339/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
340/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
341/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
342DROP TABLE IF EXISTS "t1";
343/*!40101 SET @saved_cs_client = @@character_set_client */;
344/*!40101 SET character_set_client = utf8 */;
345CREATE TABLE "t1" (
346 "a" int(11) DEFAULT NULL
347);
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350LOCK TABLES "t1" WRITE;
351/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
352/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
353UNLOCK TABLES;
354/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
355
356/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
357/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
358/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
359/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
360
361set global sql_mode='ANSI_QUOTES';
362
363/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
364/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
365/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
366/*!40101 SET NAMES utf8 */;
367/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
368/*!40103 SET TIME_ZONE='+00:00' */;
369/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
370/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
371/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
372/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
373DROP TABLE IF EXISTS `t1`;
374/*!40101 SET @saved_cs_client = @@character_set_client */;
375/*!40101 SET character_set_client = utf8 */;
376CREATE TABLE `t1` (
377 `a` int(11) DEFAULT NULL
378) ENGINE=MyISAM DEFAULT CHARSET=latin1;
379/*!40101 SET character_set_client = @saved_cs_client */;
380
381LOCK TABLES `t1` WRITE;
382/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
383/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
384UNLOCK TABLES;
385/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
386
387/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
388/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
389/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
390/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
391/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
392/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
393/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
394
395/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
396/*!40103 SET TIME_ZONE='+00:00' */;
397/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
398/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
399/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
400/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
401DROP TABLE IF EXISTS "t1";
402/*!40101 SET @saved_cs_client = @@character_set_client */;
403/*!40101 SET character_set_client = utf8 */;
404CREATE TABLE "t1" (
405 "a" int(11) DEFAULT NULL
406);
407/*!40101 SET character_set_client = @saved_cs_client */;
408
409LOCK TABLES "t1" WRITE;
410/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
411/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
412UNLOCK TABLES;
413/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
414
415/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
416/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
417/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
418/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
419
420set global sql_mode='';
421drop table t1;
422#
423# Bug#2705 mysqldump --tab extra output
424#
425create table t1(a int);
426insert into t1 values (1),(2),(3);
427
428/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
429/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
430/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
431/*!40101 SET NAMES utf8 */;
432/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
433/*!40103 SET TIME_ZONE='+00:00' */;
434/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
435/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
436DROP TABLE IF EXISTS `t1`;
437/*!40101 SET @saved_cs_client = @@character_set_client */;
438/*!40101 SET character_set_client = utf8 */;
439CREATE TABLE `t1` (
440 `a` int(11) DEFAULT NULL
441) ENGINE=MyISAM DEFAULT CHARSET=latin1;
442/*!40101 SET character_set_client = @saved_cs_client */;
443
444/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
445
446/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
447/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
448/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
449/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
450/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
451
4521
4532
4543
455drop table t1;
456#
457# Bug#6101 create database problem
458#
459
460/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
461/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
462/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
463/*!40101 SET NAMES utf8 */;
464/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
465/*!40103 SET TIME_ZONE='+00:00' */;
466/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
467/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
468/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
469/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
470
471CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
472
473USE `test`;
474/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
475
476/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
477/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
478/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
479/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
480/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
481/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
482/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
483
484create database mysqldump_test_db character set latin2 collate latin2_bin;
485
486/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
487/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
488/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
489/*!40101 SET NAMES utf8 */;
490/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
491/*!40103 SET TIME_ZONE='+00:00' */;
492/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
493/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
494/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
495/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
496
497CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_test_db` /*!40100 DEFAULT CHARACTER SET latin2 COLLATE latin2_bin */;
498
499USE `mysqldump_test_db`;
500/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
501
502/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
503/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
504/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
505/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
506/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
507/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
508/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
509
510drop database mysqldump_test_db;
511#
512# Bug#7020 mysqldump --compatible=mysql40 should set --skip-set-charset --default-char...
513# Check that we don't dump in UTF8 in compatible mode by default,
514# but use the default compiled values, or the values given in
515# --default-character-set=xxx. However, we should dump in UTF8
516# if it is explicitely set.
517CREATE TABLE t1 (a CHAR(10));
518INSERT INTO t1 VALUES (_latin1 'ÄÖÜß');
519
520/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
521/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
522/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
523/*!40101 SET NAMES utf8 */;
524/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
525/*!40103 SET TIME_ZONE='+00:00' */;
526/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
527/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
528/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
529/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
530DROP TABLE IF EXISTS `t1`;
531/*!40101 SET @saved_cs_client = @@character_set_client */;
532/*!40101 SET character_set_client = utf8 */;
533CREATE TABLE `t1` (
534 `a` char(10) DEFAULT NULL
535) ENGINE=MyISAM DEFAULT CHARSET=latin1;
536/*!40101 SET character_set_client = @saved_cs_client */;
537
538LOCK TABLES `t1` WRITE;
539/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
540INSERT INTO `t1` VALUES ('ÄÖÜß');
541/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
542UNLOCK TABLES;
543/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
544
545/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
546/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
547/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
548/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
549/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
550/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
551/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
552
553#
554# Bug#8063 make test mysqldump [ fail ]
555# We cannot test this command because its output depends
556# on --default-character-set incompiled into "mysqldump" program.
557# If the future we can move this command into a separate test with
558# checking that "mysqldump" is compiled with "latin1"
559#
560/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
561/*!40103 SET TIME_ZONE='+00:00' */;
562/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
563/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
564/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
565/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
566DROP TABLE IF EXISTS `t1`;
567CREATE TABLE `t1` (
568 `a` char(10) DEFAULT NULL
569) TYPE=MyISAM;
570
571LOCK TABLES `t1` WRITE;
572/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
573INSERT INTO `t1` VALUES ('Ž™šá');
574/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
575UNLOCK TABLES;
576/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
577
578/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
579/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
580/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
581/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
582
583/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
584/*!40103 SET TIME_ZONE='+00:00' */;
585/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
586/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
587/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
588/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
589DROP TABLE IF EXISTS `t1`;
590CREATE TABLE `t1` (
591 `a` char(10) DEFAULT NULL
592) TYPE=MyISAM;
593
594LOCK TABLES `t1` WRITE;
595/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
596INSERT INTO `t1` VALUES ('Ž™šá');
597/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
598UNLOCK TABLES;
599/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
600
601/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
602/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
603/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
604/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
605
606/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
607/*!40103 SET TIME_ZONE='+00:00' */;
608/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
609/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
610/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
611/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
612DROP TABLE IF EXISTS `t1`;
613CREATE TABLE `t1` (
614 `a` char(10) DEFAULT NULL
615) TYPE=MyISAM;
616
617LOCK TABLES `t1` WRITE;
618/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
619INSERT INTO `t1` VALUES ('ÄÖÜß');
620/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
621UNLOCK TABLES;
622/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
623
624/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
625/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
626/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
627/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
628
629DROP TABLE t1;
630#
631# WL#2319 Exclude Tables from dump
632#
633CREATE TABLE t1 (a int);
634CREATE TABLE t2 (a int);
635INSERT INTO t1 VALUES (1),(2),(3);
636INSERT INTO t2 VALUES (4),(5),(6);
637
638/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
639/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
640/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
641/*!40101 SET NAMES utf8 */;
642/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
643/*!40103 SET TIME_ZONE='+00:00' */;
644/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
645/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
646/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
647/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
648DROP TABLE IF EXISTS `t2`;
649/*!40101 SET @saved_cs_client = @@character_set_client */;
650/*!40101 SET character_set_client = utf8 */;
651CREATE TABLE `t2` (
652 `a` int(11) DEFAULT NULL
653) ENGINE=MyISAM DEFAULT CHARSET=latin1;
654/*!40101 SET character_set_client = @saved_cs_client */;
655
656LOCK TABLES `t2` WRITE;
657/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
658INSERT INTO `t2` VALUES (4),(5),(6);
659/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
660UNLOCK TABLES;
661/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
662
663/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
664/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
665/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
666/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
667/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
668/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
669/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
670
671DROP TABLE t1;
672DROP TABLE t2;
673#
674# Bug#8830 mysqldump --skip-extended-insert causes --hex-blob to dump wrong values
675#
676CREATE TABLE t1 (`b` blob);
677INSERT INTO `t1` VALUES (0x602010000280100005E71A);
678
679/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
680/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
681/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
682/*!40101 SET NAMES utf8 */;
683/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
684/*!40103 SET TIME_ZONE='+00:00' */;
685/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
686/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
687/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
688/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
689DROP TABLE IF EXISTS `t1`;
690/*!40101 SET @saved_cs_client = @@character_set_client */;
691/*!40101 SET character_set_client = utf8 */;
692CREATE TABLE `t1` (
693 `b` blob
694) ENGINE=MyISAM DEFAULT CHARSET=latin1;
695/*!40101 SET character_set_client = @saved_cs_client */;
696
697LOCK TABLES `t1` WRITE;
698/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
699INSERT INTO `t1` VALUES (0x602010000280100005E71A);
700/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
701UNLOCK TABLES;
702/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
703
704/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
705/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
706/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
707/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
708/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
709/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
710/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
711
712DROP TABLE t1;
713#
714# Test for --insert-ignore
715#
716CREATE TABLE t1 (a INT);
717INSERT INTO t1 VALUES (1),(2),(3);
718INSERT INTO t1 VALUES (4),(5),(6);
719
720/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
721/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
722/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
723/*!40101 SET NAMES utf8 */;
724/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
725/*!40103 SET TIME_ZONE='+00:00' */;
726/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
727/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
728/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
729/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
730DROP TABLE IF EXISTS `t1`;
731/*!40101 SET @saved_cs_client = @@character_set_client */;
732/*!40101 SET character_set_client = utf8 */;
733CREATE TABLE `t1` (
734 `a` int(11) DEFAULT NULL
735) ENGINE=MyISAM DEFAULT CHARSET=latin1;
736/*!40101 SET character_set_client = @saved_cs_client */;
737
738LOCK TABLES `t1` WRITE;
739/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
740INSERT IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
741/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
742UNLOCK TABLES;
743/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
744
745/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
746/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
747/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
748/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
749/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
750/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
751/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
752
753
754/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
755/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
756/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
757/*!40101 SET NAMES utf8 */;
758/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
759/*!40103 SET TIME_ZONE='+00:00' */;
760/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
761/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
762/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
763/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
764DROP TABLE IF EXISTS `t1`;
765/*!40101 SET @saved_cs_client = @@character_set_client */;
766/*!40101 SET character_set_client = utf8 */;
767CREATE TABLE `t1` (
768 `a` int(11) DEFAULT NULL
769) ENGINE=MyISAM DEFAULT CHARSET=latin1;
770/*!40101 SET character_set_client = @saved_cs_client */;
771
772/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
773INSERT DELAYED IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
774/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
775/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
776
777/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
778/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
779/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
780/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
781/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
782/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
783/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
784
785DROP TABLE t1;
786#
787# Bug#10286 mysqldump -c crashes on table that has many fields with long
788# names
789#
790create table t1 (
791F_c4ca4238a0b923820dcc509a6f75849b int,
792F_c81e728d9d4c2f636f067f89cc14862c int,
793F_eccbc87e4b5ce2fe28308fd9f2a7baf3 int,
794F_a87ff679a2f3e71d9181a67b7542122c int,
795F_e4da3b7fbbce2345d7772b0674a318d5 int,
796F_1679091c5a880faf6fb5e6087eb1b2dc int,
797F_8f14e45fceea167a5a36dedd4bea2543 int,
798F_c9f0f895fb98ab9159f51fd0297e236d int,
799F_45c48cce2e2d7fbdea1afc51c7c6ad26 int,
800F_d3d9446802a44259755d38e6d163e820 int,
801F_6512bd43d9caa6e02c990b0a82652dca int,
802F_c20ad4d76fe97759aa27a0c99bff6710 int,
803F_c51ce410c124a10e0db5e4b97fc2af39 int,
804F_aab3238922bcc25a6f606eb525ffdc56 int,
805F_9bf31c7ff062936a96d3c8bd1f8f2ff3 int,
806F_c74d97b01eae257e44aa9d5bade97baf int,
807F_70efdf2ec9b086079795c442636b55fb int,
808F_6f4922f45568161a8cdf4ad2299f6d23 int,
809F_1f0e3dad99908345f7439f8ffabdffc4 int,
810F_98f13708210194c475687be6106a3b84 int,
811F_3c59dc048e8850243be8079a5c74d079 int,
812F_b6d767d2f8ed5d21a44b0e5886680cb9 int,
813F_37693cfc748049e45d87b8c7d8b9aacd int,
814F_1ff1de774005f8da13f42943881c655f int,
815F_8e296a067a37563370ded05f5a3bf3ec int,
816F_4e732ced3463d06de0ca9a15b6153677 int,
817F_02e74f10e0327ad868d138f2b4fdd6f0 int,
818F_33e75ff09dd601bbe69f351039152189 int,
819F_6ea9ab1baa0efb9e19094440c317e21b int,
820F_34173cb38f07f89ddbebc2ac9128303f int,
821F_c16a5320fa475530d9583c34fd356ef5 int,
822F_6364d3f0f495b6ab9dcf8d3b5c6e0b01 int,
823F_182be0c5cdcd5072bb1864cdee4d3d6e int,
824F_e369853df766fa44e1ed0ff613f563bd int,
825F_1c383cd30b7c298ab50293adfecb7b18 int,
826F_19ca14e7ea6328a42e0eb13d585e4c22 int,
827F_a5bfc9e07964f8dddeb95fc584cd965d int,
828F_a5771bce93e200c36f7cd9dfd0e5deaa int,
829F_d67d8ab4f4c10bf22aa353e27879133c int,
830F_d645920e395fedad7bbbed0eca3fe2e0 int,
831F_3416a75f4cea9109507cacd8e2f2aefc int,
832F_a1d0c6e83f027327d8461063f4ac58a6 int,
833F_17e62166fc8586dfa4d1bc0e1742c08b int,
834F_f7177163c833dff4b38fc8d2872f1ec6 int,
835F_6c8349cc7260ae62e3b1396831a8398f int,
836F_d9d4f495e875a2e075a1a4a6e1b9770f int,
837F_67c6a1e7ce56d3d6fa748ab6d9af3fd7 int,
838F_642e92efb79421734881b53e1e1b18b6 int,
839F_f457c545a9ded88f18ecee47145a72c0 int,
840F_c0c7c76d30bd3dcaefc96f40275bdc0a int,
841F_2838023a778dfaecdc212708f721b788 int,
842F_9a1158154dfa42caddbd0694a4e9bdc8 int,
843F_d82c8d1619ad8176d665453cfb2e55f0 int,
844F_a684eceee76fc522773286a895bc8436 int,
845F_b53b3a3d6ab90ce0268229151c9bde11 int,
846F_9f61408e3afb633e50cdf1b20de6f466 int,
847F_72b32a1f754ba1c09b3695e0cb6cde7f int,
848F_66f041e16a60928b05a7e228a89c3799 int,
849F_093f65e080a295f8076b1c5722a46aa2 int,
850F_072b030ba126b2f4b2374f342be9ed44 int,
851F_7f39f8317fbdb1988ef4c628eba02591 int,
852F_44f683a84163b3523afe57c2e008bc8c int,
853F_03afdbd66e7929b125f8597834fa83a4 int,
854F_ea5d2f1c4608232e07d3aa3d998e5135 int,
855F_fc490ca45c00b1249bbe3554a4fdf6fb int,
856F_3295c76acbf4caaed33c36b1b5fc2cb1 int,
857F_735b90b4568125ed6c3f678819b6e058 int,
858F_a3f390d88e4c41f2747bfa2f1b5f87db int,
859F_14bfa6bb14875e45bba028a21ed38046 int,
860F_7cbbc409ec990f19c78c75bd1e06f215 int,
861F_e2c420d928d4bf8ce0ff2ec19b371514 int,
862F_32bb90e8976aab5298d5da10fe66f21d int,
863F_d2ddea18f00665ce8623e36bd4e3c7c5 int,
864F_ad61ab143223efbc24c7d2583be69251 int,
865F_d09bf41544a3365a46c9077ebb5e35c3 int,
866F_fbd7939d674997cdb4692d34de8633c4 int,
867F_28dd2c7955ce926456240b2ff0100bde int,
868F_35f4a8d465e6e1edc05f3d8ab658c551 int,
869F_d1fe173d08e959397adf34b1d77e88d7 int,
870F_f033ab37c30201f73f142449d037028d int,
871F_43ec517d68b6edd3015b3edc9a11367b int,
872F_9778d5d219c5080b9a6a17bef029331c int,
873F_fe9fc289c3ff0af142b6d3bead98a923 int,
874F_68d30a9594728bc39aa24be94b319d21 int,
875F_3ef815416f775098fe977004015c6193 int,
876F_93db85ed909c13838ff95ccfa94cebd9 int,
877F_c7e1249ffc03eb9ded908c236bd1996d int,
878F_2a38a4a9316c49e5a833517c45d31070 int,
879F_7647966b7343c29048673252e490f736 int,
880F_8613985ec49eb8f757ae6439e879bb2a int,
881F_54229abfcfa5649e7003b83dd4755294 int,
882F_92cc227532d17e56e07902b254dfad10 int,
883F_98dce83da57b0395e163467c9dae521b int,
884F_f4b9ec30ad9f68f89b29639786cb62ef int,
885F_812b4ba287f5ee0bc9d43bbf5bbe87fb int,
886F_26657d5ff9020d2abefe558796b99584 int,
887F_e2ef524fbf3d9fe611d5a8e90fefdc9c int,
888F_ed3d2c21991e3bef5e069713af9fa6ca int,
889F_ac627ab1ccbdb62ec96e702f07f6425b int,
890F_f899139df5e1059396431415e770c6dd int,
891F_38b3eff8baf56627478ec76a704e9b52 int,
892F_ec8956637a99787bd197eacd77acce5e int,
893F_6974ce5ac660610b44d9b9fed0ff9548 int,
894F_c9e1074f5b3f9fc8ea15d152add07294 int,
895F_65b9eea6e1cc6bb9f0cd2a47751a186f int,
896F_f0935e4cd5920aa6c7c996a5ee53a70f int,
897F_a97da629b098b75c294dffdc3e463904 int,
898F_a3c65c2974270fd093ee8a9bf8ae7d0b int,
899F_2723d092b63885e0d7c260cc007e8b9d int,
900F_5f93f983524def3dca464469d2cf9f3e int,
901F_698d51a19d8a121ce581499d7b701668 int,
902F_7f6ffaa6bb0b408017b62254211691b5 int,
903F_73278a4a86960eeb576a8fd4c9ec6997 int,
904F_5fd0b37cd7dbbb00f97ba6ce92bf5add int,
905F_2b44928ae11fb9384c4cf38708677c48 int,
906F_c45147dee729311ef5b5c3003946c48f int,
907F_eb160de1de89d9058fcb0b968dbbbd68 int,
908F_5ef059938ba799aaa845e1c2e8a762bd int,
909F_07e1cd7dca89a1678042477183b7ac3f int,
910F_da4fb5c6e93e74d3df8527599fa62642 int,
911F_4c56ff4ce4aaf9573aa5dff913df997a int,
912F_a0a080f42e6f13b3a2df133f073095dd int,
913F_202cb962ac59075b964b07152d234b70 int,
914F_c8ffe9a587b126f152ed3d89a146b445 int,
915F_3def184ad8f4755ff269862ea77393dd int,
916F_069059b7ef840f0c74a814ec9237b6ec int,
917F_ec5decca5ed3d6b8079e2e7e7bacc9f2 int,
918F_76dc611d6ebaafc66cc0879c71b5db5c int,
919F_d1f491a404d6854880943e5c3cd9ca25 int,
920F_9b8619251a19057cff70779273e95aa6 int,
921F_1afa34a7f984eeabdbb0a7d494132ee5 int,
922F_65ded5353c5ee48d0b7d48c591b8f430 int,
923F_9fc3d7152ba9336a670e36d0ed79bc43 int,
924F_02522a2b2726fb0a03bb19f2d8d9524d int,
925F_7f1de29e6da19d22b51c68001e7e0e54 int,
926F_42a0e188f5033bc65bf8d78622277c4e int,
927F_3988c7f88ebcb58c6ce932b957b6f332 int,
928F_013d407166ec4fa56eb1e1f8cbe183b9 int,
929F_e00da03b685a0dd18fb6a08af0923de0 int,
930F_1385974ed5904a438616ff7bdb3f7439 int,
931F_0f28b5d49b3020afeecd95b4009adf4c int,
932F_a8baa56554f96369ab93e4f3bb068c22 int,
933F_903ce9225fca3e988c2af215d4e544d3 int,
934F_0a09c8844ba8f0936c20bd791130d6b6 int,
935F_2b24d495052a8ce66358eb576b8912c8 int,
936F_a5e00132373a7031000fd987a3c9f87b int,
937F_8d5e957f297893487bd98fa830fa6413 int,
938F_47d1e990583c9c67424d369f3414728e int,
939F_f2217062e9a397a1dca429e7d70bc6ca int,
940F_7ef605fc8dba5425d6965fbd4c8fbe1f int,
941F_a8f15eda80c50adb0e71943adc8015cf int,
942F_37a749d808e46495a8da1e5352d03cae int,
943F_b3e3e393c77e35a4a3f3cbd1e429b5dc int,
944F_1d7f7abc18fcb43975065399b0d1e48e int,
945F_2a79ea27c279e471f4d180b08d62b00a int,
946F_1c9ac0159c94d8d0cbedc973445af2da int,
947F_6c4b761a28b734fe93831e3fb400ce87 int,
948F_06409663226af2f3114485aa4e0a23b4 int,
949F_140f6969d5213fd0ece03148e62e461e int,
950F_b73ce398c39f506af761d2277d853a92 int,
951F_bd4c9ab730f5513206b999ec0d90d1fb int,
952F_82aa4b0af34c2313a562076992e50aa3 int,
953F_0777d5c17d4066b82ab86dff8a46af6f int,
954F_fa7cdfad1a5aaf8370ebeda47a1ff1c3 int,
955F_9766527f2b5d3e95d4a733fcfb77bd7e int,
956F_7e7757b1e12abcb736ab9a754ffb617a int,
957F_5878a7ab84fb43402106c575658472fa int,
958F_006f52e9102a8d3be2fe5614f42ba989 int,
959F_3636638817772e42b59d74cff571fbb3 int,
960F_149e9677a5989fd342ae44213df68868 int,
961F_a4a042cf4fd6bfb47701cbc8a1653ada int,
962F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e int,
963F_f7e6c85504ce6e82442c770f7c8606f0 int,
964F_bf8229696f7a3bb4700cfddef19fa23f int,
965F_82161242827b703e6acf9c726942a1e4 int,
966F_38af86134b65d0f10fe33d30dd76442e int,
967F_96da2f590cd7246bbde0051047b0d6f7 int,
968F_8f85517967795eeef66c225f7883bdcb int,
969F_8f53295a73878494e9bc8dd6c3c7104f int,
970F_045117b0e0a11a242b9765e79cbf113f int,
971F_fc221309746013ac554571fbd180e1c8 int,
972F_4c5bde74a8f110656874902f07378009 int,
973F_cedebb6e872f539bef8c3f919874e9d7 int,
974F_6cdd60ea0045eb7a6ec44c54d29ed402 int,
975F_eecca5b6365d9607ee5a9d336962c534 int,
976F_9872ed9fc22fc182d371c3e9ed316094 int,
977F_31fefc0e570cb3860f2a6d4b38c6490d int,
978F_9dcb88e0137649590b755372b040afad int,
979F_a2557a7b2e94197ff767970b67041697 int,
980F_cfecdb276f634854f3ef915e2e980c31 int,
981F_0aa1883c6411f7873cb83dacb17b0afc int,
982F_58a2fc6ed39fd083f55d4182bf88826d int,
983F_bd686fd640be98efaae0091fa301e613 int,
984F_a597e50502f5ff68e3e25b9114205d4a int,
985F_0336dcbab05b9d5ad24f4333c7658a0e int,
986F_084b6fbb10729ed4da8c3d3f5a3ae7c9 int,
987F_85d8ce590ad8981ca2c8286f79f59954 int,
988F_0e65972dce68dad4d52d063967f0a705 int,
989F_84d9ee44e457ddef7f2c4f25dc8fa865 int,
990F_3644a684f98ea8fe223c713b77189a77 int,
991F_757b505cfd34c64c85ca5b5690ee5293 int,
992F_854d6fae5ee42911677c739ee1734486 int,
993F_e2c0be24560d78c5e599c2a9c9d0bbd2 int,
994F_274ad4786c3abca69fa097b85867d9a4 int,
995F_eae27d77ca20db309e056e3d2dcd7d69 int,
996F_7eabe3a1649ffa2b3ff8c02ebfd5659f int,
997F_69adc1e107f7f7d035d7baf04342e1ca int,
998F_091d584fced301b442654dd8c23b3fc9 int,
999F_b1d10e7bafa4421218a51b1e1f1b0ba2 int,
1000F_6f3ef77ac0e3619e98159e9b6febf557 int,
1001F_eb163727917cbba1eea208541a643e74 int,
1002F_1534b76d325a8f591b52d302e7181331 int,
1003F_979d472a84804b9f647bc185a877a8b5 int,
1004F_ca46c1b9512a7a8315fa3c5a946e8265 int,
1005F_3b8a614226a953a8cd9526fca6fe9ba5 int,
1006F_45fbc6d3e05ebd93369ce542e8f2322d int,
1007F_63dc7ed1010d3c3b8269faf0ba7491d4 int,
1008F_e96ed478dab8595a7dbda4cbcbee168f int,
1009F_c0e190d8267e36708f955d7ab048990d int,
1010F_ec8ce6abb3e952a85b8551ba726a1227 int,
1011F_060ad92489947d410d897474079c1477 int,
1012F_bcbe3365e6ac95ea2c0343a2395834dd int,
1013F_115f89503138416a242f40fb7d7f338e int,
1014F_13fe9d84310e77f13a6d184dbf1232f3 int,
1015F_d1c38a09acc34845c6be3a127a5aacaf int,
1016F_9cfdf10e8fc047a44b08ed031e1f0ed1 int,
1017F_705f2172834666788607efbfca35afb3 int,
1018F_74db120f0a8e5646ef5a30154e9f6deb int,
1019F_57aeee35c98205091e18d1140e9f38cf int,
1020F_6da9003b743b65f4c0ccd295cc484e57 int,
1021F_9b04d152845ec0a378394003c96da594 int,
1022F_be83ab3ecd0db773eb2dc1b0a17836a1 int,
1023F_e165421110ba03099a1c0393373c5b43 int,
1024F_289dff07669d7a23de0ef88d2f7129e7 int,
1025F_577ef1154f3240ad5b9b413aa7346a1e int,
1026F_01161aaa0b6d1345dd8fe4e481144d84 int,
1027F_539fd53b59e3bb12d203f45a912eeaf2 int,
1028F_ac1dd209cbcc5e5d1c6e28598e8cbbe8 int,
1029F_555d6702c950ecb729a966504af0a635 int,
1030F_335f5352088d7d9bf74191e006d8e24c int,
1031F_f340f1b1f65b6df5b5e3f94d95b11daf int,
1032F_e4a6222cdb5b34375400904f03d8e6a5 int,
1033F_cb70ab375662576bd1ac5aaf16b3fca4 int,
1034F_9188905e74c28e489b44e954ec0b9bca int,
1035F_0266e33d3f546cb5436a10798e657d97 int,
1036F_38db3aed920cf82ab059bfccbd02be6a int,
1037F_3cec07e9ba5f5bb252d13f5f431e4bbb int,
1038F_621bf66ddb7c962aa0d22ac97d69b793 int,
1039F_077e29b11be80ab57e1a2ecabb7da330 int,
1040F_6c9882bbac1c7093bd25041881277658 int,
1041F_19f3cd308f1455b3fa09a282e0d496f4 int,
1042F_03c6b06952c750899bb03d998e631860 int,
1043F_c24cd76e1ce41366a4bbe8a49b02a028 int,
1044F_c52f1bd66cc19d05628bd8bf27af3ad6 int,
1045F_fe131d7f5a6b38b23cc967316c13dae2 int,
1046F_f718499c1c8cef6730f9fd03c8125cab int,
1047F_d96409bf894217686ba124d7356686c9 int,
1048F_502e4a16930e414107ee22b6198c578f int,
1049F_cfa0860e83a4c3a763a7e62d825349f7 int,
1050F_a4f23670e1833f3fdb077ca70bbd5d66 int,
1051F_b1a59b315fc9a3002ce38bbe070ec3f5 int,
1052F_36660e59856b4de58a219bcf4e27eba3 int,
1053F_8c19f571e251e61cb8dd3612f26d5ecf int,
1054F_d6baf65e0b240ce177cf70da146c8dc8 int,
1055F_e56954b4f6347e897f954495eab16a88 int,
1056F_f7664060cc52bc6f3d620bcedc94a4b6 int,
1057F_eda80a3d5b344bc40f3bc04f65b7a357 int,
1058F_8f121ce07d74717e0b1f21d122e04521 int,
1059F_06138bc5af6023646ede0e1f7c1eac75 int,
1060F_39059724f73a9969845dfe4146c5660e int,
1061F_7f100b7b36092fb9b06dfb4fac360931 int,
1062F_7a614fd06c325499f1680b9896beedeb int,
1063F_4734ba6f3de83d861c3176a6273cac6d int,
1064F_d947bf06a885db0d477d707121934ff8 int,
1065F_63923f49e5241343aa7acb6a06a751e7 int,
1066F_db8e1af0cb3aca1ae2d0018624204529 int,
1067F_20f07591c6fcb220ffe637cda29bb3f6 int,
1068F_07cdfd23373b17c6b337251c22b7ea57 int,
1069F_d395771085aab05244a4fb8fd91bf4ee int,
1070F_92c8c96e4c37100777c7190b76d28233 int,
1071F_e3796ae838835da0b6f6ea37bcf8bcb7 int,
1072F_6a9aeddfc689c1d0e3b9ccc3ab651bc5 int,
1073F_0f49c89d1e7298bb9930789c8ed59d48 int,
1074F_46ba9f2a6976570b0353203ec4474217 int,
1075F_0e01938fc48a2cfb5f2217fbfb00722d int,
1076F_16a5cdae362b8d27a1d8f8c7b78b4330 int,
1077F_918317b57931b6b7a7d29490fe5ec9f9 int,
1078F_48aedb8880cab8c45637abc7493ecddd int,
1079F_839ab46820b524afda05122893c2fe8e int,
1080F_f90f2aca5c640289d0a29417bcb63a37 int,
1081F_9c838d2e45b2ad1094d42f4ef36764f6 int,
1082F_1700002963a49da13542e0726b7bb758 int,
1083F_53c3bce66e43be4f209556518c2fcb54 int,
1084F_6883966fd8f918a4aa29be29d2c386fb int,
1085F_49182f81e6a13cf5eaa496d51fea6406 int,
1086F_d296c101daa88a51f6ca8cfc1ac79b50 int,
1087F_9fd81843ad7f202f26c1a174c7357585 int,
1088F_26e359e83860db1d11b6acca57d8ea88 int,
1089F_ef0d3930a7b6c95bd2b32ed45989c61f int,
1090F_94f6d7e04a4d452035300f18b984988c int,
1091F_34ed066df378efacc9b924ec161e7639 int,
1092F_577bcc914f9e55d5e4e4f82f9f00e7d4 int,
1093F_11b9842e0a271ff252c1903e7132cd68 int,
1094F_37bc2f75bf1bcfe8450a1a41c200364c int,
1095F_496e05e1aea0a9c4655800e8a7b9ea28 int,
1096F_b2eb7349035754953b57a32e2841bda5 int,
1097F_8e98d81f8217304975ccb23337bb5761 int,
1098F_a8c88a0055f636e4a163a5e3d16adab7 int,
1099F_eddea82ad2755b24c4e168c5fc2ebd40 int,
1100F_06eb61b839a0cefee4967c67ccb099dc int,
1101F_9dfcd5e558dfa04aaf37f137a1d9d3e5 int,
1102F_950a4152c2b4aa3ad78bdd6b366cc179 int,
1103F_158f3069a435b314a80bdcb024f8e422 int,
1104F_758874998f5bd0c393da094e1967a72b int,
1105F_ad13a2a07ca4b7642959dc0c4c740ab6 int,
1106F_3fe94a002317b5f9259f82690aeea4cd int,
1107F_5b8add2a5d98b1a652ea7fd72d942dac int,
1108F_432aca3a1e345e339f35a30c8f65edce int,
1109F_8d3bba7425e7c98c50f52ca1b52d3735 int,
1110F_320722549d1751cf3f247855f937b982 int,
1111F_caf1a3dfb505ffed0d024130f58c5cfa int,
1112F_5737c6ec2e0716f3d8a7a5c4e0de0d9a int,
1113F_bc6dc48b743dc5d013b1abaebd2faed2 int,
1114F_f2fc990265c712c49d51a18a32b39f0c int,
1115F_89f0fd5c927d466d6ec9a21b9ac34ffa int,
1116F_a666587afda6e89aec274a3657558a27 int,
1117F_b83aac23b9528732c23cc7352950e880 int,
1118F_cd00692c3bfe59267d5ecfac5310286c int,
1119F_6faa8040da20ef399b63a72d0e4ab575 int,
1120F_fe73f687e5bc5280214e0486b273a5f9 int);
1121insert into t1 (F_8d3bba7425e7c98c50f52ca1b52d3735) values (1);
1122
1123/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1124/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1125/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1126/*!40101 SET NAMES utf8 */;
1127/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1128/*!40103 SET TIME_ZONE='+00:00' */;
1129/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1130/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1131/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1132/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1133DROP TABLE IF EXISTS `t1`;
1134/*!40101 SET @saved_cs_client = @@character_set_client */;
1135/*!40101 SET character_set_client = utf8 */;
1136CREATE TABLE `t1` (
1137 `F_c4ca4238a0b923820dcc509a6f75849b` int(11) DEFAULT NULL,
1138 `F_c81e728d9d4c2f636f067f89cc14862c` int(11) DEFAULT NULL,
1139 `F_eccbc87e4b5ce2fe28308fd9f2a7baf3` int(11) DEFAULT NULL,
1140 `F_a87ff679a2f3e71d9181a67b7542122c` int(11) DEFAULT NULL,
1141 `F_e4da3b7fbbce2345d7772b0674a318d5` int(11) DEFAULT NULL,
1142 `F_1679091c5a880faf6fb5e6087eb1b2dc` int(11) DEFAULT NULL,
1143 `F_8f14e45fceea167a5a36dedd4bea2543` int(11) DEFAULT NULL,
1144 `F_c9f0f895fb98ab9159f51fd0297e236d` int(11) DEFAULT NULL,
1145 `F_45c48cce2e2d7fbdea1afc51c7c6ad26` int(11) DEFAULT NULL,
1146 `F_d3d9446802a44259755d38e6d163e820` int(11) DEFAULT NULL,
1147 `F_6512bd43d9caa6e02c990b0a82652dca` int(11) DEFAULT NULL,
1148 `F_c20ad4d76fe97759aa27a0c99bff6710` int(11) DEFAULT NULL,
1149 `F_c51ce410c124a10e0db5e4b97fc2af39` int(11) DEFAULT NULL,
1150 `F_aab3238922bcc25a6f606eb525ffdc56` int(11) DEFAULT NULL,
1151 `F_9bf31c7ff062936a96d3c8bd1f8f2ff3` int(11) DEFAULT NULL,
1152 `F_c74d97b01eae257e44aa9d5bade97baf` int(11) DEFAULT NULL,
1153 `F_70efdf2ec9b086079795c442636b55fb` int(11) DEFAULT NULL,
1154 `F_6f4922f45568161a8cdf4ad2299f6d23` int(11) DEFAULT NULL,
1155 `F_1f0e3dad99908345f7439f8ffabdffc4` int(11) DEFAULT NULL,
1156 `F_98f13708210194c475687be6106a3b84` int(11) DEFAULT NULL,
1157 `F_3c59dc048e8850243be8079a5c74d079` int(11) DEFAULT NULL,
1158 `F_b6d767d2f8ed5d21a44b0e5886680cb9` int(11) DEFAULT NULL,
1159 `F_37693cfc748049e45d87b8c7d8b9aacd` int(11) DEFAULT NULL,
1160 `F_1ff1de774005f8da13f42943881c655f` int(11) DEFAULT NULL,
1161 `F_8e296a067a37563370ded05f5a3bf3ec` int(11) DEFAULT NULL,
1162 `F_4e732ced3463d06de0ca9a15b6153677` int(11) DEFAULT NULL,
1163 `F_02e74f10e0327ad868d138f2b4fdd6f0` int(11) DEFAULT NULL,
1164 `F_33e75ff09dd601bbe69f351039152189` int(11) DEFAULT NULL,
1165 `F_6ea9ab1baa0efb9e19094440c317e21b` int(11) DEFAULT NULL,
1166 `F_34173cb38f07f89ddbebc2ac9128303f` int(11) DEFAULT NULL,
1167 `F_c16a5320fa475530d9583c34fd356ef5` int(11) DEFAULT NULL,
1168 `F_6364d3f0f495b6ab9dcf8d3b5c6e0b01` int(11) DEFAULT NULL,
1169 `F_182be0c5cdcd5072bb1864cdee4d3d6e` int(11) DEFAULT NULL,
1170 `F_e369853df766fa44e1ed0ff613f563bd` int(11) DEFAULT NULL,
1171 `F_1c383cd30b7c298ab50293adfecb7b18` int(11) DEFAULT NULL,
1172 `F_19ca14e7ea6328a42e0eb13d585e4c22` int(11) DEFAULT NULL,
1173 `F_a5bfc9e07964f8dddeb95fc584cd965d` int(11) DEFAULT NULL,
1174 `F_a5771bce93e200c36f7cd9dfd0e5deaa` int(11) DEFAULT NULL,
1175 `F_d67d8ab4f4c10bf22aa353e27879133c` int(11) DEFAULT NULL,
1176 `F_d645920e395fedad7bbbed0eca3fe2e0` int(11) DEFAULT NULL,
1177 `F_3416a75f4cea9109507cacd8e2f2aefc` int(11) DEFAULT NULL,
1178 `F_a1d0c6e83f027327d8461063f4ac58a6` int(11) DEFAULT NULL,
1179 `F_17e62166fc8586dfa4d1bc0e1742c08b` int(11) DEFAULT NULL,
1180 `F_f7177163c833dff4b38fc8d2872f1ec6` int(11) DEFAULT NULL,
1181 `F_6c8349cc7260ae62e3b1396831a8398f` int(11) DEFAULT NULL,
1182 `F_d9d4f495e875a2e075a1a4a6e1b9770f` int(11) DEFAULT NULL,
1183 `F_67c6a1e7ce56d3d6fa748ab6d9af3fd7` int(11) DEFAULT NULL,
1184 `F_642e92efb79421734881b53e1e1b18b6` int(11) DEFAULT NULL,
1185 `F_f457c545a9ded88f18ecee47145a72c0` int(11) DEFAULT NULL,
1186 `F_c0c7c76d30bd3dcaefc96f40275bdc0a` int(11) DEFAULT NULL,
1187 `F_2838023a778dfaecdc212708f721b788` int(11) DEFAULT NULL,
1188 `F_9a1158154dfa42caddbd0694a4e9bdc8` int(11) DEFAULT NULL,
1189 `F_d82c8d1619ad8176d665453cfb2e55f0` int(11) DEFAULT NULL,
1190 `F_a684eceee76fc522773286a895bc8436` int(11) DEFAULT NULL,
1191 `F_b53b3a3d6ab90ce0268229151c9bde11` int(11) DEFAULT NULL,
1192 `F_9f61408e3afb633e50cdf1b20de6f466` int(11) DEFAULT NULL,
1193 `F_72b32a1f754ba1c09b3695e0cb6cde7f` int(11) DEFAULT NULL,
1194 `F_66f041e16a60928b05a7e228a89c3799` int(11) DEFAULT NULL,
1195 `F_093f65e080a295f8076b1c5722a46aa2` int(11) DEFAULT NULL,
1196 `F_072b030ba126b2f4b2374f342be9ed44` int(11) DEFAULT NULL,
1197 `F_7f39f8317fbdb1988ef4c628eba02591` int(11) DEFAULT NULL,
1198 `F_44f683a84163b3523afe57c2e008bc8c` int(11) DEFAULT NULL,
1199 `F_03afdbd66e7929b125f8597834fa83a4` int(11) DEFAULT NULL,
1200 `F_ea5d2f1c4608232e07d3aa3d998e5135` int(11) DEFAULT NULL,
1201 `F_fc490ca45c00b1249bbe3554a4fdf6fb` int(11) DEFAULT NULL,
1202 `F_3295c76acbf4caaed33c36b1b5fc2cb1` int(11) DEFAULT NULL,
1203 `F_735b90b4568125ed6c3f678819b6e058` int(11) DEFAULT NULL,
1204 `F_a3f390d88e4c41f2747bfa2f1b5f87db` int(11) DEFAULT NULL,
1205 `F_14bfa6bb14875e45bba028a21ed38046` int(11) DEFAULT NULL,
1206 `F_7cbbc409ec990f19c78c75bd1e06f215` int(11) DEFAULT NULL,
1207 `F_e2c420d928d4bf8ce0ff2ec19b371514` int(11) DEFAULT NULL,
1208 `F_32bb90e8976aab5298d5da10fe66f21d` int(11) DEFAULT NULL,
1209 `F_d2ddea18f00665ce8623e36bd4e3c7c5` int(11) DEFAULT NULL,
1210 `F_ad61ab143223efbc24c7d2583be69251` int(11) DEFAULT NULL,
1211 `F_d09bf41544a3365a46c9077ebb5e35c3` int(11) DEFAULT NULL,
1212 `F_fbd7939d674997cdb4692d34de8633c4` int(11) DEFAULT NULL,
1213 `F_28dd2c7955ce926456240b2ff0100bde` int(11) DEFAULT NULL,
1214 `F_35f4a8d465e6e1edc05f3d8ab658c551` int(11) DEFAULT NULL,
1215 `F_d1fe173d08e959397adf34b1d77e88d7` int(11) DEFAULT NULL,
1216 `F_f033ab37c30201f73f142449d037028d` int(11) DEFAULT NULL,
1217 `F_43ec517d68b6edd3015b3edc9a11367b` int(11) DEFAULT NULL,
1218 `F_9778d5d219c5080b9a6a17bef029331c` int(11) DEFAULT NULL,
1219 `F_fe9fc289c3ff0af142b6d3bead98a923` int(11) DEFAULT NULL,
1220 `F_68d30a9594728bc39aa24be94b319d21` int(11) DEFAULT NULL,
1221 `F_3ef815416f775098fe977004015c6193` int(11) DEFAULT NULL,
1222 `F_93db85ed909c13838ff95ccfa94cebd9` int(11) DEFAULT NULL,
1223 `F_c7e1249ffc03eb9ded908c236bd1996d` int(11) DEFAULT NULL,
1224 `F_2a38a4a9316c49e5a833517c45d31070` int(11) DEFAULT NULL,
1225 `F_7647966b7343c29048673252e490f736` int(11) DEFAULT NULL,
1226 `F_8613985ec49eb8f757ae6439e879bb2a` int(11) DEFAULT NULL,
1227 `F_54229abfcfa5649e7003b83dd4755294` int(11) DEFAULT NULL,
1228 `F_92cc227532d17e56e07902b254dfad10` int(11) DEFAULT NULL,
1229 `F_98dce83da57b0395e163467c9dae521b` int(11) DEFAULT NULL,
1230 `F_f4b9ec30ad9f68f89b29639786cb62ef` int(11) DEFAULT NULL,
1231 `F_812b4ba287f5ee0bc9d43bbf5bbe87fb` int(11) DEFAULT NULL,
1232 `F_26657d5ff9020d2abefe558796b99584` int(11) DEFAULT NULL,
1233 `F_e2ef524fbf3d9fe611d5a8e90fefdc9c` int(11) DEFAULT NULL,
1234 `F_ed3d2c21991e3bef5e069713af9fa6ca` int(11) DEFAULT NULL,
1235 `F_ac627ab1ccbdb62ec96e702f07f6425b` int(11) DEFAULT NULL,
1236 `F_f899139df5e1059396431415e770c6dd` int(11) DEFAULT NULL,
1237 `F_38b3eff8baf56627478ec76a704e9b52` int(11) DEFAULT NULL,
1238 `F_ec8956637a99787bd197eacd77acce5e` int(11) DEFAULT NULL,
1239 `F_6974ce5ac660610b44d9b9fed0ff9548` int(11) DEFAULT NULL,
1240 `F_c9e1074f5b3f9fc8ea15d152add07294` int(11) DEFAULT NULL,
1241 `F_65b9eea6e1cc6bb9f0cd2a47751a186f` int(11) DEFAULT NULL,
1242 `F_f0935e4cd5920aa6c7c996a5ee53a70f` int(11) DEFAULT NULL,
1243 `F_a97da629b098b75c294dffdc3e463904` int(11) DEFAULT NULL,
1244 `F_a3c65c2974270fd093ee8a9bf8ae7d0b` int(11) DEFAULT NULL,
1245 `F_2723d092b63885e0d7c260cc007e8b9d` int(11) DEFAULT NULL,
1246 `F_5f93f983524def3dca464469d2cf9f3e` int(11) DEFAULT NULL,
1247 `F_698d51a19d8a121ce581499d7b701668` int(11) DEFAULT NULL,
1248 `F_7f6ffaa6bb0b408017b62254211691b5` int(11) DEFAULT NULL,
1249 `F_73278a4a86960eeb576a8fd4c9ec6997` int(11) DEFAULT NULL,
1250 `F_5fd0b37cd7dbbb00f97ba6ce92bf5add` int(11) DEFAULT NULL,
1251 `F_2b44928ae11fb9384c4cf38708677c48` int(11) DEFAULT NULL,
1252 `F_c45147dee729311ef5b5c3003946c48f` int(11) DEFAULT NULL,
1253 `F_eb160de1de89d9058fcb0b968dbbbd68` int(11) DEFAULT NULL,
1254 `F_5ef059938ba799aaa845e1c2e8a762bd` int(11) DEFAULT NULL,
1255 `F_07e1cd7dca89a1678042477183b7ac3f` int(11) DEFAULT NULL,
1256 `F_da4fb5c6e93e74d3df8527599fa62642` int(11) DEFAULT NULL,
1257 `F_4c56ff4ce4aaf9573aa5dff913df997a` int(11) DEFAULT NULL,
1258 `F_a0a080f42e6f13b3a2df133f073095dd` int(11) DEFAULT NULL,
1259 `F_202cb962ac59075b964b07152d234b70` int(11) DEFAULT NULL,
1260 `F_c8ffe9a587b126f152ed3d89a146b445` int(11) DEFAULT NULL,
1261 `F_3def184ad8f4755ff269862ea77393dd` int(11) DEFAULT NULL,
1262 `F_069059b7ef840f0c74a814ec9237b6ec` int(11) DEFAULT NULL,
1263 `F_ec5decca5ed3d6b8079e2e7e7bacc9f2` int(11) DEFAULT NULL,
1264 `F_76dc611d6ebaafc66cc0879c71b5db5c` int(11) DEFAULT NULL,
1265 `F_d1f491a404d6854880943e5c3cd9ca25` int(11) DEFAULT NULL,
1266 `F_9b8619251a19057cff70779273e95aa6` int(11) DEFAULT NULL,
1267 `F_1afa34a7f984eeabdbb0a7d494132ee5` int(11) DEFAULT NULL,
1268 `F_65ded5353c5ee48d0b7d48c591b8f430` int(11) DEFAULT NULL,
1269 `F_9fc3d7152ba9336a670e36d0ed79bc43` int(11) DEFAULT NULL,
1270 `F_02522a2b2726fb0a03bb19f2d8d9524d` int(11) DEFAULT NULL,
1271 `F_7f1de29e6da19d22b51c68001e7e0e54` int(11) DEFAULT NULL,
1272 `F_42a0e188f5033bc65bf8d78622277c4e` int(11) DEFAULT NULL,
1273 `F_3988c7f88ebcb58c6ce932b957b6f332` int(11) DEFAULT NULL,
1274 `F_013d407166ec4fa56eb1e1f8cbe183b9` int(11) DEFAULT NULL,
1275 `F_e00da03b685a0dd18fb6a08af0923de0` int(11) DEFAULT NULL,
1276 `F_1385974ed5904a438616ff7bdb3f7439` int(11) DEFAULT NULL,
1277 `F_0f28b5d49b3020afeecd95b4009adf4c` int(11) DEFAULT NULL,
1278 `F_a8baa56554f96369ab93e4f3bb068c22` int(11) DEFAULT NULL,
1279 `F_903ce9225fca3e988c2af215d4e544d3` int(11) DEFAULT NULL,
1280 `F_0a09c8844ba8f0936c20bd791130d6b6` int(11) DEFAULT NULL,
1281 `F_2b24d495052a8ce66358eb576b8912c8` int(11) DEFAULT NULL,
1282 `F_a5e00132373a7031000fd987a3c9f87b` int(11) DEFAULT NULL,
1283 `F_8d5e957f297893487bd98fa830fa6413` int(11) DEFAULT NULL,
1284 `F_47d1e990583c9c67424d369f3414728e` int(11) DEFAULT NULL,
1285 `F_f2217062e9a397a1dca429e7d70bc6ca` int(11) DEFAULT NULL,
1286 `F_7ef605fc8dba5425d6965fbd4c8fbe1f` int(11) DEFAULT NULL,
1287 `F_a8f15eda80c50adb0e71943adc8015cf` int(11) DEFAULT NULL,
1288 `F_37a749d808e46495a8da1e5352d03cae` int(11) DEFAULT NULL,
1289 `F_b3e3e393c77e35a4a3f3cbd1e429b5dc` int(11) DEFAULT NULL,
1290 `F_1d7f7abc18fcb43975065399b0d1e48e` int(11) DEFAULT NULL,
1291 `F_2a79ea27c279e471f4d180b08d62b00a` int(11) DEFAULT NULL,
1292 `F_1c9ac0159c94d8d0cbedc973445af2da` int(11) DEFAULT NULL,
1293 `F_6c4b761a28b734fe93831e3fb400ce87` int(11) DEFAULT NULL,
1294 `F_06409663226af2f3114485aa4e0a23b4` int(11) DEFAULT NULL,
1295 `F_140f6969d5213fd0ece03148e62e461e` int(11) DEFAULT NULL,
1296 `F_b73ce398c39f506af761d2277d853a92` int(11) DEFAULT NULL,
1297 `F_bd4c9ab730f5513206b999ec0d90d1fb` int(11) DEFAULT NULL,
1298 `F_82aa4b0af34c2313a562076992e50aa3` int(11) DEFAULT NULL,
1299 `F_0777d5c17d4066b82ab86dff8a46af6f` int(11) DEFAULT NULL,
1300 `F_fa7cdfad1a5aaf8370ebeda47a1ff1c3` int(11) DEFAULT NULL,
1301 `F_9766527f2b5d3e95d4a733fcfb77bd7e` int(11) DEFAULT NULL,
1302 `F_7e7757b1e12abcb736ab9a754ffb617a` int(11) DEFAULT NULL,
1303 `F_5878a7ab84fb43402106c575658472fa` int(11) DEFAULT NULL,
1304 `F_006f52e9102a8d3be2fe5614f42ba989` int(11) DEFAULT NULL,
1305 `F_3636638817772e42b59d74cff571fbb3` int(11) DEFAULT NULL,
1306 `F_149e9677a5989fd342ae44213df68868` int(11) DEFAULT NULL,
1307 `F_a4a042cf4fd6bfb47701cbc8a1653ada` int(11) DEFAULT NULL,
1308 `F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e` int(11) DEFAULT NULL,
1309 `F_f7e6c85504ce6e82442c770f7c8606f0` int(11) DEFAULT NULL,
1310 `F_bf8229696f7a3bb4700cfddef19fa23f` int(11) DEFAULT NULL,
1311 `F_82161242827b703e6acf9c726942a1e4` int(11) DEFAULT NULL,
1312 `F_38af86134b65d0f10fe33d30dd76442e` int(11) DEFAULT NULL,
1313 `F_96da2f590cd7246bbde0051047b0d6f7` int(11) DEFAULT NULL,
1314 `F_8f85517967795eeef66c225f7883bdcb` int(11) DEFAULT NULL,
1315 `F_8f53295a73878494e9bc8dd6c3c7104f` int(11) DEFAULT NULL,
1316 `F_045117b0e0a11a242b9765e79cbf113f` int(11) DEFAULT NULL,
1317 `F_fc221309746013ac554571fbd180e1c8` int(11) DEFAULT NULL,
1318 `F_4c5bde74a8f110656874902f07378009` int(11) DEFAULT NULL,
1319 `F_cedebb6e872f539bef8c3f919874e9d7` int(11) DEFAULT NULL,
1320 `F_6cdd60ea0045eb7a6ec44c54d29ed402` int(11) DEFAULT NULL,
1321 `F_eecca5b6365d9607ee5a9d336962c534` int(11) DEFAULT NULL,
1322 `F_9872ed9fc22fc182d371c3e9ed316094` int(11) DEFAULT NULL,
1323 `F_31fefc0e570cb3860f2a6d4b38c6490d` int(11) DEFAULT NULL,
1324 `F_9dcb88e0137649590b755372b040afad` int(11) DEFAULT NULL,
1325 `F_a2557a7b2e94197ff767970b67041697` int(11) DEFAULT NULL,
1326 `F_cfecdb276f634854f3ef915e2e980c31` int(11) DEFAULT NULL,
1327 `F_0aa1883c6411f7873cb83dacb17b0afc` int(11) DEFAULT NULL,
1328 `F_58a2fc6ed39fd083f55d4182bf88826d` int(11) DEFAULT NULL,
1329 `F_bd686fd640be98efaae0091fa301e613` int(11) DEFAULT NULL,
1330 `F_a597e50502f5ff68e3e25b9114205d4a` int(11) DEFAULT NULL,
1331 `F_0336dcbab05b9d5ad24f4333c7658a0e` int(11) DEFAULT NULL,
1332 `F_084b6fbb10729ed4da8c3d3f5a3ae7c9` int(11) DEFAULT NULL,
1333 `F_85d8ce590ad8981ca2c8286f79f59954` int(11) DEFAULT NULL,
1334 `F_0e65972dce68dad4d52d063967f0a705` int(11) DEFAULT NULL,
1335 `F_84d9ee44e457ddef7f2c4f25dc8fa865` int(11) DEFAULT NULL,
1336 `F_3644a684f98ea8fe223c713b77189a77` int(11) DEFAULT NULL,
1337 `F_757b505cfd34c64c85ca5b5690ee5293` int(11) DEFAULT NULL,
1338 `F_854d6fae5ee42911677c739ee1734486` int(11) DEFAULT NULL,
1339 `F_e2c0be24560d78c5e599c2a9c9d0bbd2` int(11) DEFAULT NULL,
1340 `F_274ad4786c3abca69fa097b85867d9a4` int(11) DEFAULT NULL,
1341 `F_eae27d77ca20db309e056e3d2dcd7d69` int(11) DEFAULT NULL,
1342 `F_7eabe3a1649ffa2b3ff8c02ebfd5659f` int(11) DEFAULT NULL,
1343 `F_69adc1e107f7f7d035d7baf04342e1ca` int(11) DEFAULT NULL,
1344 `F_091d584fced301b442654dd8c23b3fc9` int(11) DEFAULT NULL,
1345 `F_b1d10e7bafa4421218a51b1e1f1b0ba2` int(11) DEFAULT NULL,
1346 `F_6f3ef77ac0e3619e98159e9b6febf557` int(11) DEFAULT NULL,
1347 `F_eb163727917cbba1eea208541a643e74` int(11) DEFAULT NULL,
1348 `F_1534b76d325a8f591b52d302e7181331` int(11) DEFAULT NULL,
1349 `F_979d472a84804b9f647bc185a877a8b5` int(11) DEFAULT NULL,
1350 `F_ca46c1b9512a7a8315fa3c5a946e8265` int(11) DEFAULT NULL,
1351 `F_3b8a614226a953a8cd9526fca6fe9ba5` int(11) DEFAULT NULL,
1352 `F_45fbc6d3e05ebd93369ce542e8f2322d` int(11) DEFAULT NULL,
1353 `F_63dc7ed1010d3c3b8269faf0ba7491d4` int(11) DEFAULT NULL,
1354 `F_e96ed478dab8595a7dbda4cbcbee168f` int(11) DEFAULT NULL,
1355 `F_c0e190d8267e36708f955d7ab048990d` int(11) DEFAULT NULL,
1356 `F_ec8ce6abb3e952a85b8551ba726a1227` int(11) DEFAULT NULL,
1357 `F_060ad92489947d410d897474079c1477` int(11) DEFAULT NULL,
1358 `F_bcbe3365e6ac95ea2c0343a2395834dd` int(11) DEFAULT NULL,
1359 `F_115f89503138416a242f40fb7d7f338e` int(11) DEFAULT NULL,
1360 `F_13fe9d84310e77f13a6d184dbf1232f3` int(11) DEFAULT NULL,
1361 `F_d1c38a09acc34845c6be3a127a5aacaf` int(11) DEFAULT NULL,
1362 `F_9cfdf10e8fc047a44b08ed031e1f0ed1` int(11) DEFAULT NULL,
1363 `F_705f2172834666788607efbfca35afb3` int(11) DEFAULT NULL,
1364 `F_74db120f0a8e5646ef5a30154e9f6deb` int(11) DEFAULT NULL,
1365 `F_57aeee35c98205091e18d1140e9f38cf` int(11) DEFAULT NULL,
1366 `F_6da9003b743b65f4c0ccd295cc484e57` int(11) DEFAULT NULL,
1367 `F_9b04d152845ec0a378394003c96da594` int(11) DEFAULT NULL,
1368 `F_be83ab3ecd0db773eb2dc1b0a17836a1` int(11) DEFAULT NULL,
1369 `F_e165421110ba03099a1c0393373c5b43` int(11) DEFAULT NULL,
1370 `F_289dff07669d7a23de0ef88d2f7129e7` int(11) DEFAULT NULL,
1371 `F_577ef1154f3240ad5b9b413aa7346a1e` int(11) DEFAULT NULL,
1372 `F_01161aaa0b6d1345dd8fe4e481144d84` int(11) DEFAULT NULL,
1373 `F_539fd53b59e3bb12d203f45a912eeaf2` int(11) DEFAULT NULL,
1374 `F_ac1dd209cbcc5e5d1c6e28598e8cbbe8` int(11) DEFAULT NULL,
1375 `F_555d6702c950ecb729a966504af0a635` int(11) DEFAULT NULL,
1376 `F_335f5352088d7d9bf74191e006d8e24c` int(11) DEFAULT NULL,
1377 `F_f340f1b1f65b6df5b5e3f94d95b11daf` int(11) DEFAULT NULL,
1378 `F_e4a6222cdb5b34375400904f03d8e6a5` int(11) DEFAULT NULL,
1379 `F_cb70ab375662576bd1ac5aaf16b3fca4` int(11) DEFAULT NULL,
1380 `F_9188905e74c28e489b44e954ec0b9bca` int(11) DEFAULT NULL,
1381 `F_0266e33d3f546cb5436a10798e657d97` int(11) DEFAULT NULL,
1382 `F_38db3aed920cf82ab059bfccbd02be6a` int(11) DEFAULT NULL,
1383 `F_3cec07e9ba5f5bb252d13f5f431e4bbb` int(11) DEFAULT NULL,
1384 `F_621bf66ddb7c962aa0d22ac97d69b793` int(11) DEFAULT NULL,
1385 `F_077e29b11be80ab57e1a2ecabb7da330` int(11) DEFAULT NULL,
1386 `F_6c9882bbac1c7093bd25041881277658` int(11) DEFAULT NULL,
1387 `F_19f3cd308f1455b3fa09a282e0d496f4` int(11) DEFAULT NULL,
1388 `F_03c6b06952c750899bb03d998e631860` int(11) DEFAULT NULL,
1389 `F_c24cd76e1ce41366a4bbe8a49b02a028` int(11) DEFAULT NULL,
1390 `F_c52f1bd66cc19d05628bd8bf27af3ad6` int(11) DEFAULT NULL,
1391 `F_fe131d7f5a6b38b23cc967316c13dae2` int(11) DEFAULT NULL,
1392 `F_f718499c1c8cef6730f9fd03c8125cab` int(11) DEFAULT NULL,
1393 `F_d96409bf894217686ba124d7356686c9` int(11) DEFAULT NULL,
1394 `F_502e4a16930e414107ee22b6198c578f` int(11) DEFAULT NULL,
1395 `F_cfa0860e83a4c3a763a7e62d825349f7` int(11) DEFAULT NULL,
1396 `F_a4f23670e1833f3fdb077ca70bbd5d66` int(11) DEFAULT NULL,
1397 `F_b1a59b315fc9a3002ce38bbe070ec3f5` int(11) DEFAULT NULL,
1398 `F_36660e59856b4de58a219bcf4e27eba3` int(11) DEFAULT NULL,
1399 `F_8c19f571e251e61cb8dd3612f26d5ecf` int(11) DEFAULT NULL,
1400 `F_d6baf65e0b240ce177cf70da146c8dc8` int(11) DEFAULT NULL,
1401 `F_e56954b4f6347e897f954495eab16a88` int(11) DEFAULT NULL,
1402 `F_f7664060cc52bc6f3d620bcedc94a4b6` int(11) DEFAULT NULL,
1403 `F_eda80a3d5b344bc40f3bc04f65b7a357` int(11) DEFAULT NULL,
1404 `F_8f121ce07d74717e0b1f21d122e04521` int(11) DEFAULT NULL,
1405 `F_06138bc5af6023646ede0e1f7c1eac75` int(11) DEFAULT NULL,
1406 `F_39059724f73a9969845dfe4146c5660e` int(11) DEFAULT NULL,
1407 `F_7f100b7b36092fb9b06dfb4fac360931` int(11) DEFAULT NULL,
1408 `F_7a614fd06c325499f1680b9896beedeb` int(11) DEFAULT NULL,
1409 `F_4734ba6f3de83d861c3176a6273cac6d` int(11) DEFAULT NULL,
1410 `F_d947bf06a885db0d477d707121934ff8` int(11) DEFAULT NULL,
1411 `F_63923f49e5241343aa7acb6a06a751e7` int(11) DEFAULT NULL,
1412 `F_db8e1af0cb3aca1ae2d0018624204529` int(11) DEFAULT NULL,
1413 `F_20f07591c6fcb220ffe637cda29bb3f6` int(11) DEFAULT NULL,
1414 `F_07cdfd23373b17c6b337251c22b7ea57` int(11) DEFAULT NULL,
1415 `F_d395771085aab05244a4fb8fd91bf4ee` int(11) DEFAULT NULL,
1416 `F_92c8c96e4c37100777c7190b76d28233` int(11) DEFAULT NULL,
1417 `F_e3796ae838835da0b6f6ea37bcf8bcb7` int(11) DEFAULT NULL,
1418 `F_6a9aeddfc689c1d0e3b9ccc3ab651bc5` int(11) DEFAULT NULL,
1419 `F_0f49c89d1e7298bb9930789c8ed59d48` int(11) DEFAULT NULL,
1420 `F_46ba9f2a6976570b0353203ec4474217` int(11) DEFAULT NULL,
1421 `F_0e01938fc48a2cfb5f2217fbfb00722d` int(11) DEFAULT NULL,
1422 `F_16a5cdae362b8d27a1d8f8c7b78b4330` int(11) DEFAULT NULL,
1423 `F_918317b57931b6b7a7d29490fe5ec9f9` int(11) DEFAULT NULL,
1424 `F_48aedb8880cab8c45637abc7493ecddd` int(11) DEFAULT NULL,
1425 `F_839ab46820b524afda05122893c2fe8e` int(11) DEFAULT NULL,
1426 `F_f90f2aca5c640289d0a29417bcb63a37` int(11) DEFAULT NULL,
1427 `F_9c838d2e45b2ad1094d42f4ef36764f6` int(11) DEFAULT NULL,
1428 `F_1700002963a49da13542e0726b7bb758` int(11) DEFAULT NULL,
1429 `F_53c3bce66e43be4f209556518c2fcb54` int(11) DEFAULT NULL,
1430 `F_6883966fd8f918a4aa29be29d2c386fb` int(11) DEFAULT NULL,
1431 `F_49182f81e6a13cf5eaa496d51fea6406` int(11) DEFAULT NULL,
1432 `F_d296c101daa88a51f6ca8cfc1ac79b50` int(11) DEFAULT NULL,
1433 `F_9fd81843ad7f202f26c1a174c7357585` int(11) DEFAULT NULL,
1434 `F_26e359e83860db1d11b6acca57d8ea88` int(11) DEFAULT NULL,
1435 `F_ef0d3930a7b6c95bd2b32ed45989c61f` int(11) DEFAULT NULL,
1436 `F_94f6d7e04a4d452035300f18b984988c` int(11) DEFAULT NULL,
1437 `F_34ed066df378efacc9b924ec161e7639` int(11) DEFAULT NULL,
1438 `F_577bcc914f9e55d5e4e4f82f9f00e7d4` int(11) DEFAULT NULL,
1439 `F_11b9842e0a271ff252c1903e7132cd68` int(11) DEFAULT NULL,
1440 `F_37bc2f75bf1bcfe8450a1a41c200364c` int(11) DEFAULT NULL,
1441 `F_496e05e1aea0a9c4655800e8a7b9ea28` int(11) DEFAULT NULL,
1442 `F_b2eb7349035754953b57a32e2841bda5` int(11) DEFAULT NULL,
1443 `F_8e98d81f8217304975ccb23337bb5761` int(11) DEFAULT NULL,
1444 `F_a8c88a0055f636e4a163a5e3d16adab7` int(11) DEFAULT NULL,
1445 `F_eddea82ad2755b24c4e168c5fc2ebd40` int(11) DEFAULT NULL,
1446 `F_06eb61b839a0cefee4967c67ccb099dc` int(11) DEFAULT NULL,
1447 `F_9dfcd5e558dfa04aaf37f137a1d9d3e5` int(11) DEFAULT NULL,
1448 `F_950a4152c2b4aa3ad78bdd6b366cc179` int(11) DEFAULT NULL,
1449 `F_158f3069a435b314a80bdcb024f8e422` int(11) DEFAULT NULL,
1450 `F_758874998f5bd0c393da094e1967a72b` int(11) DEFAULT NULL,
1451 `F_ad13a2a07ca4b7642959dc0c4c740ab6` int(11) DEFAULT NULL,
1452 `F_3fe94a002317b5f9259f82690aeea4cd` int(11) DEFAULT NULL,
1453 `F_5b8add2a5d98b1a652ea7fd72d942dac` int(11) DEFAULT NULL,
1454 `F_432aca3a1e345e339f35a30c8f65edce` int(11) DEFAULT NULL,
1455 `F_8d3bba7425e7c98c50f52ca1b52d3735` int(11) DEFAULT NULL,
1456 `F_320722549d1751cf3f247855f937b982` int(11) DEFAULT NULL,
1457 `F_caf1a3dfb505ffed0d024130f58c5cfa` int(11) DEFAULT NULL,
1458 `F_5737c6ec2e0716f3d8a7a5c4e0de0d9a` int(11) DEFAULT NULL,
1459 `F_bc6dc48b743dc5d013b1abaebd2faed2` int(11) DEFAULT NULL,
1460 `F_f2fc990265c712c49d51a18a32b39f0c` int(11) DEFAULT NULL,
1461 `F_89f0fd5c927d466d6ec9a21b9ac34ffa` int(11) DEFAULT NULL,
1462 `F_a666587afda6e89aec274a3657558a27` int(11) DEFAULT NULL,
1463 `F_b83aac23b9528732c23cc7352950e880` int(11) DEFAULT NULL,
1464 `F_cd00692c3bfe59267d5ecfac5310286c` int(11) DEFAULT NULL,
1465 `F_6faa8040da20ef399b63a72d0e4ab575` int(11) DEFAULT NULL,
1466 `F_fe73f687e5bc5280214e0486b273a5f9` int(11) DEFAULT NULL
1467) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1468/*!40101 SET character_set_client = @saved_cs_client */;
1469
1470LOCK TABLES `t1` WRITE;
1471/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1472INSERT INTO `t1` (`F_c4ca4238a0b923820dcc509a6f75849b`, `F_c81e728d9d4c2f636f067f89cc14862c`, `F_eccbc87e4b5ce2fe28308fd9f2a7baf3`, `F_a87ff679a2f3e71d9181a67b7542122c`, `F_e4da3b7fbbce2345d7772b0674a318d5`, `F_1679091c5a880faf6fb5e6087eb1b2dc`, `F_8f14e45fceea167a5a36dedd4bea2543`, `F_c9f0f895fb98ab9159f51fd0297e236d`, `F_45c48cce2e2d7fbdea1afc51c7c6ad26`, `F_d3d9446802a44259755d38e6d163e820`, `F_6512bd43d9caa6e02c990b0a82652dca`, `F_c20ad4d76fe97759aa27a0c99bff6710`, `F_c51ce410c124a10e0db5e4b97fc2af39`, `F_aab3238922bcc25a6f606eb525ffdc56`, `F_9bf31c7ff062936a96d3c8bd1f8f2ff3`, `F_c74d97b01eae257e44aa9d5bade97baf`, `F_70efdf2ec9b086079795c442636b55fb`, `F_6f4922f45568161a8cdf4ad2299f6d23`, `F_1f0e3dad99908345f7439f8ffabdffc4`, `F_98f13708210194c475687be6106a3b84`, `F_3c59dc048e8850243be8079a5c74d079`, `F_b6d767d2f8ed5d21a44b0e5886680cb9`, `F_37693cfc748049e45d87b8c7d8b9aacd`, `F_1ff1de774005f8da13f42943881c655f`, `F_8e296a067a37563370ded05f5a3bf3ec`, `F_4e732ced3463d06de0ca9a15b6153677`, `F_02e74f10e0327ad868d138f2b4fdd6f0`, `F_33e75ff09dd601bbe69f351039152189`, `F_6ea9ab1baa0efb9e19094440c317e21b`, `F_34173cb38f07f89ddbebc2ac9128303f`, `F_c16a5320fa475530d9583c34fd356ef5`, `F_6364d3f0f495b6ab9dcf8d3b5c6e0b01`, `F_182be0c5cdcd5072bb1864cdee4d3d6e`, `F_e369853df766fa44e1ed0ff613f563bd`, `F_1c383cd30b7c298ab50293adfecb7b18`, `F_19ca14e7ea6328a42e0eb13d585e4c22`, `F_a5bfc9e07964f8dddeb95fc584cd965d`, `F_a5771bce93e200c36f7cd9dfd0e5deaa`, `F_d67d8ab4f4c10bf22aa353e27879133c`, `F_d645920e395fedad7bbbed0eca3fe2e0`, `F_3416a75f4cea9109507cacd8e2f2aefc`, `F_a1d0c6e83f027327d8461063f4ac58a6`, `F_17e62166fc8586dfa4d1bc0e1742c08b`, `F_f7177163c833dff4b38fc8d2872f1ec6`, `F_6c8349cc7260ae62e3b1396831a8398f`, `F_d9d4f495e875a2e075a1a4a6e1b9770f`, `F_67c6a1e7ce56d3d6fa748ab6d9af3fd7`, `F_642e92efb79421734881b53e1e1b18b6`, `F_f457c545a9ded88f18ecee47145a72c0`, `F_c0c7c76d30bd3dcaefc96f40275bdc0a`, `F_2838023a778dfaecdc212708f721b788`, `F_9a1158154dfa42caddbd0694a4e9bdc8`, `F_d82c8d1619ad8176d665453cfb2e55f0`, `F_a684eceee76fc522773286a895bc8436`, `F_b53b3a3d6ab90ce0268229151c9bde11`, `F_9f61408e3afb633e50cdf1b20de6f466`, `F_72b32a1f754ba1c09b3695e0cb6cde7f`, `F_66f041e16a60928b05a7e228a89c3799`, `F_093f65e080a295f8076b1c5722a46aa2`, `F_072b030ba126b2f4b2374f342be9ed44`, `F_7f39f8317fbdb1988ef4c628eba02591`, `F_44f683a84163b3523afe57c2e008bc8c`, `F_03afdbd66e7929b125f8597834fa83a4`, `F_ea5d2f1c4608232e07d3aa3d998e5135`, `F_fc490ca45c00b1249bbe3554a4fdf6fb`, `F_3295c76acbf4caaed33c36b1b5fc2cb1`, `F_735b90b4568125ed6c3f678819b6e058`, `F_a3f390d88e4c41f2747bfa2f1b5f87db`, `F_14bfa6bb14875e45bba028a21ed38046`, `F_7cbbc409ec990f19c78c75bd1e06f215`, `F_e2c420d928d4bf8ce0ff2ec19b371514`, `F_32bb90e8976aab5298d5da10fe66f21d`, `F_d2ddea18f00665ce8623e36bd4e3c7c5`, `F_ad61ab143223efbc24c7d2583be69251`, `F_d09bf41544a3365a46c9077ebb5e35c3`, `F_fbd7939d674997cdb4692d34de8633c4`, `F_28dd2c7955ce926456240b2ff0100bde`, `F_35f4a8d465e6e1edc05f3d8ab658c551`, `F_d1fe173d08e959397adf34b1d77e88d7`, `F_f033ab37c30201f73f142449d037028d`, `F_43ec517d68b6edd3015b3edc9a11367b`, `F_9778d5d219c5080b9a6a17bef029331c`, `F_fe9fc289c3ff0af142b6d3bead98a923`, `F_68d30a9594728bc39aa24be94b319d21`, `F_3ef815416f775098fe977004015c6193`, `F_93db85ed909c13838ff95ccfa94cebd9`, `F_c7e1249ffc03eb9ded908c236bd1996d`, `F_2a38a4a9316c49e5a833517c45d31070`, `F_7647966b7343c29048673252e490f736`, `F_8613985ec49eb8f757ae6439e879bb2a`, `F_54229abfcfa5649e7003b83dd4755294`, `F_92cc227532d17e56e07902b254dfad10`, `F_98dce83da57b0395e163467c9dae521b`, `F_f4b9ec30ad9f68f89b29639786cb62ef`, `F_812b4ba287f5ee0bc9d43bbf5bbe87fb`, `F_26657d5ff9020d2abefe558796b99584`, `F_e2ef524fbf3d9fe611d5a8e90fefdc9c`, `F_ed3d2c21991e3bef5e069713af9fa6ca`, `F_ac627ab1ccbdb62ec96e702f07f6425b`, `F_f899139df5e1059396431415e770c6dd`, `F_38b3eff8baf56627478ec76a704e9b52`, `F_ec8956637a99787bd197eacd77acce5e`, `F_6974ce5ac660610b44d9b9fed0ff9548`, `F_c9e1074f5b3f9fc8ea15d152add07294`, `F_65b9eea6e1cc6bb9f0cd2a47751a186f`, `F_f0935e4cd5920aa6c7c996a5ee53a70f`, `F_a97da629b098b75c294dffdc3e463904`, `F_a3c65c2974270fd093ee8a9bf8ae7d0b`, `F_2723d092b63885e0d7c260cc007e8b9d`, `F_5f93f983524def3dca464469d2cf9f3e`, `F_698d51a19d8a121ce581499d7b701668`, `F_7f6ffaa6bb0b408017b62254211691b5`, `F_73278a4a86960eeb576a8fd4c9ec6997`, `F_5fd0b37cd7dbbb00f97ba6ce92bf5add`, `F_2b44928ae11fb9384c4cf38708677c48`, `F_c45147dee729311ef5b5c3003946c48f`, `F_eb160de1de89d9058fcb0b968dbbbd68`, `F_5ef059938ba799aaa845e1c2e8a762bd`, `F_07e1cd7dca89a1678042477183b7ac3f`, `F_da4fb5c6e93e74d3df8527599fa62642`, `F_4c56ff4ce4aaf9573aa5dff913df997a`, `F_a0a080f42e6f13b3a2df133f073095dd`, `F_202cb962ac59075b964b07152d234b70`, `F_c8ffe9a587b126f152ed3d89a146b445`, `F_3def184ad8f4755ff269862ea77393dd`, `F_069059b7ef840f0c74a814ec9237b6ec`, `F_ec5decca5ed3d6b8079e2e7e7bacc9f2`, `F_76dc611d6ebaafc66cc0879c71b5db5c`, `F_d1f491a404d6854880943e5c3cd9ca25`, `F_9b8619251a19057cff70779273e95aa6`, `F_1afa34a7f984eeabdbb0a7d494132ee5`, `F_65ded5353c5ee48d0b7d48c591b8f430`, `F_9fc3d7152ba9336a670e36d0ed79bc43`, `F_02522a2b2726fb0a03bb19f2d8d9524d`, `F_7f1de29e6da19d22b51c68001e7e0e54`, `F_42a0e188f5033bc65bf8d78622277c4e`, `F_3988c7f88ebcb58c6ce932b957b6f332`, `F_013d407166ec4fa56eb1e1f8cbe183b9`, `F_e00da03b685a0dd18fb6a08af0923de0`, `F_1385974ed5904a438616ff7bdb3f7439`, `F_0f28b5d49b3020afeecd95b4009adf4c`, `F_a8baa56554f96369ab93e4f3bb068c22`, `F_903ce9225fca3e988c2af215d4e544d3`, `F_0a09c8844ba8f0936c20bd791130d6b6`, `F_2b24d495052a8ce66358eb576b8912c8`, `F_a5e00132373a7031000fd987a3c9f87b`, `F_8d5e957f297893487bd98fa830fa6413`, `F_47d1e990583c9c67424d369f3414728e`, `F_f2217062e9a397a1dca429e7d70bc6ca`, `F_7ef605fc8dba5425d6965fbd4c8fbe1f`, `F_a8f15eda80c50adb0e71943adc8015cf`, `F_37a749d808e46495a8da1e5352d03cae`, `F_b3e3e393c77e35a4a3f3cbd1e429b5dc`, `F_1d7f7abc18fcb43975065399b0d1e48e`, `F_2a79ea27c279e471f4d180b08d62b00a`, `F_1c9ac0159c94d8d0cbedc973445af2da`, `F_6c4b761a28b734fe93831e3fb400ce87`, `F_06409663226af2f3114485aa4e0a23b4`, `F_140f6969d5213fd0ece03148e62e461e`, `F_b73ce398c39f506af761d2277d853a92`, `F_bd4c9ab730f5513206b999ec0d90d1fb`, `F_82aa4b0af34c2313a562076992e50aa3`, `F_0777d5c17d4066b82ab86dff8a46af6f`, `F_fa7cdfad1a5aaf8370ebeda47a1ff1c3`, `F_9766527f2b5d3e95d4a733fcfb77bd7e`, `F_7e7757b1e12abcb736ab9a754ffb617a`, `F_5878a7ab84fb43402106c575658472fa`, `F_006f52e9102a8d3be2fe5614f42ba989`, `F_3636638817772e42b59d74cff571fbb3`, `F_149e9677a5989fd342ae44213df68868`, `F_a4a042cf4fd6bfb47701cbc8a1653ada`, `F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e`, `F_f7e6c85504ce6e82442c770f7c8606f0`, `F_bf8229696f7a3bb4700cfddef19fa23f`, `F_82161242827b703e6acf9c726942a1e4`, `F_38af86134b65d0f10fe33d30dd76442e`, `F_96da2f590cd7246bbde0051047b0d6f7`, `F_8f85517967795eeef66c225f7883bdcb`, `F_8f53295a73878494e9bc8dd6c3c7104f`, `F_045117b0e0a11a242b9765e79cbf113f`, `F_fc221309746013ac554571fbd180e1c8`, `F_4c5bde74a8f110656874902f07378009`, `F_cedebb6e872f539bef8c3f919874e9d7`, `F_6cdd60ea0045eb7a6ec44c54d29ed402`, `F_eecca5b6365d9607ee5a9d336962c534`, `F_9872ed9fc22fc182d371c3e9ed316094`, `F_31fefc0e570cb3860f2a6d4b38c6490d`, `F_9dcb88e0137649590b755372b040afad`, `F_a2557a7b2e94197ff767970b67041697`, `F_cfecdb276f634854f3ef915e2e980c31`, `F_0aa1883c6411f7873cb83dacb17b0afc`, `F_58a2fc6ed39fd083f55d4182bf88826d`, `F_bd686fd640be98efaae0091fa301e613`, `F_a597e50502f5ff68e3e25b9114205d4a`, `F_0336dcbab05b9d5ad24f4333c7658a0e`, `F_084b6fbb10729ed4da8c3d3f5a3ae7c9`, `F_85d8ce590ad8981ca2c8286f79f59954`, `F_0e65972dce68dad4d52d063967f0a705`, `F_84d9ee44e457ddef7f2c4f25dc8fa865`, `F_3644a684f98ea8fe223c713b77189a77`, `F_757b505cfd34c64c85ca5b5690ee5293`, `F_854d6fae5ee42911677c739ee1734486`, `F_e2c0be24560d78c5e599c2a9c9d0bbd2`, `F_274ad4786c3abca69fa097b85867d9a4`, `F_eae27d77ca20db309e056e3d2dcd7d69`, `F_7eabe3a1649ffa2b3ff8c02ebfd5659f`, `F_69adc1e107f7f7d035d7baf04342e1ca`, `F_091d584fced301b442654dd8c23b3fc9`, `F_b1d10e7bafa4421218a51b1e1f1b0ba2`, `F_6f3ef77ac0e3619e98159e9b6febf557`, `F_eb163727917cbba1eea208541a643e74`, `F_1534b76d325a8f591b52d302e7181331`, `F_979d472a84804b9f647bc185a877a8b5`, `F_ca46c1b9512a7a8315fa3c5a946e8265`, `F_3b8a614226a953a8cd9526fca6fe9ba5`, `F_45fbc6d3e05ebd93369ce542e8f2322d`, `F_63dc7ed1010d3c3b8269faf0ba7491d4`, `F_e96ed478dab8595a7dbda4cbcbee168f`, `F_c0e190d8267e36708f955d7ab048990d`, `F_ec8ce6abb3e952a85b8551ba726a1227`, `F_060ad92489947d410d897474079c1477`, `F_bcbe3365e6ac95ea2c0343a2395834dd`, `F_115f89503138416a242f40fb7d7f338e`, `F_13fe9d84310e77f13a6d184dbf1232f3`, `F_d1c38a09acc34845c6be3a127a5aacaf`, `F_9cfdf10e8fc047a44b08ed031e1f0ed1`, `F_705f2172834666788607efbfca35afb3`, `F_74db120f0a8e5646ef5a30154e9f6deb`, `F_57aeee35c98205091e18d1140e9f38cf`, `F_6da9003b743b65f4c0ccd295cc484e57`, `F_9b04d152845ec0a378394003c96da594`, `F_be83ab3ecd0db773eb2dc1b0a17836a1`, `F_e165421110ba03099a1c0393373c5b43`, `F_289dff07669d7a23de0ef88d2f7129e7`, `F_577ef1154f3240ad5b9b413aa7346a1e`, `F_01161aaa0b6d1345dd8fe4e481144d84`, `F_539fd53b59e3bb12d203f45a912eeaf2`, `F_ac1dd209cbcc5e5d1c6e28598e8cbbe8`, `F_555d6702c950ecb729a966504af0a635`, `F_335f5352088d7d9bf74191e006d8e24c`, `F_f340f1b1f65b6df5b5e3f94d95b11daf`, `F_e4a6222cdb5b34375400904f03d8e6a5`, `F_cb70ab375662576bd1ac5aaf16b3fca4`, `F_9188905e74c28e489b44e954ec0b9bca`, `F_0266e33d3f546cb5436a10798e657d97`, `F_38db3aed920cf82ab059bfccbd02be6a`, `F_3cec07e9ba5f5bb252d13f5f431e4bbb`, `F_621bf66ddb7c962aa0d22ac97d69b793`, `F_077e29b11be80ab57e1a2ecabb7da330`, `F_6c9882bbac1c7093bd25041881277658`, `F_19f3cd308f1455b3fa09a282e0d496f4`, `F_03c6b06952c750899bb03d998e631860`, `F_c24cd76e1ce41366a4bbe8a49b02a028`, `F_c52f1bd66cc19d05628bd8bf27af3ad6`, `F_fe131d7f5a6b38b23cc967316c13dae2`, `F_f718499c1c8cef6730f9fd03c8125cab`, `F_d96409bf894217686ba124d7356686c9`, `F_502e4a16930e414107ee22b6198c578f`, `F_cfa0860e83a4c3a763a7e62d825349f7`, `F_a4f23670e1833f3fdb077ca70bbd5d66`, `F_b1a59b315fc9a3002ce38bbe070ec3f5`, `F_36660e59856b4de58a219bcf4e27eba3`, `F_8c19f571e251e61cb8dd3612f26d5ecf`, `F_d6baf65e0b240ce177cf70da146c8dc8`, `F_e56954b4f6347e897f954495eab16a88`, `F_f7664060cc52bc6f3d620bcedc94a4b6`, `F_eda80a3d5b344bc40f3bc04f65b7a357`, `F_8f121ce07d74717e0b1f21d122e04521`, `F_06138bc5af6023646ede0e1f7c1eac75`, `F_39059724f73a9969845dfe4146c5660e`, `F_7f100b7b36092fb9b06dfb4fac360931`, `F_7a614fd06c325499f1680b9896beedeb`, `F_4734ba6f3de83d861c3176a6273cac6d`, `F_d947bf06a885db0d477d707121934ff8`, `F_63923f49e5241343aa7acb6a06a751e7`, `F_db8e1af0cb3aca1ae2d0018624204529`, `F_20f07591c6fcb220ffe637cda29bb3f6`, `F_07cdfd23373b17c6b337251c22b7ea57`, `F_d395771085aab05244a4fb8fd91bf4ee`, `F_92c8c96e4c37100777c7190b76d28233`, `F_e3796ae838835da0b6f6ea37bcf8bcb7`, `F_6a9aeddfc689c1d0e3b9ccc3ab651bc5`, `F_0f49c89d1e7298bb9930789c8ed59d48`, `F_46ba9f2a6976570b0353203ec4474217`, `F_0e01938fc48a2cfb5f2217fbfb00722d`, `F_16a5cdae362b8d27a1d8f8c7b78b4330`, `F_918317b57931b6b7a7d29490fe5ec9f9`, `F_48aedb8880cab8c45637abc7493ecddd`, `F_839ab46820b524afda05122893c2fe8e`, `F_f90f2aca5c640289d0a29417bcb63a37`, `F_9c838d2e45b2ad1094d42f4ef36764f6`, `F_1700002963a49da13542e0726b7bb758`, `F_53c3bce66e43be4f209556518c2fcb54`, `F_6883966fd8f918a4aa29be29d2c386fb`, `F_49182f81e6a13cf5eaa496d51fea6406`, `F_d296c101daa88a51f6ca8cfc1ac79b50`, `F_9fd81843ad7f202f26c1a174c7357585`, `F_26e359e83860db1d11b6acca57d8ea88`, `F_ef0d3930a7b6c95bd2b32ed45989c61f`, `F_94f6d7e04a4d452035300f18b984988c`, `F_34ed066df378efacc9b924ec161e7639`, `F_577bcc914f9e55d5e4e4f82f9f00e7d4`, `F_11b9842e0a271ff252c1903e7132cd68`, `F_37bc2f75bf1bcfe8450a1a41c200364c`, `F_496e05e1aea0a9c4655800e8a7b9ea28`, `F_b2eb7349035754953b57a32e2841bda5`, `F_8e98d81f8217304975ccb23337bb5761`, `F_a8c88a0055f636e4a163a5e3d16adab7`, `F_eddea82ad2755b24c4e168c5fc2ebd40`, `F_06eb61b839a0cefee4967c67ccb099dc`, `F_9dfcd5e558dfa04aaf37f137a1d9d3e5`, `F_950a4152c2b4aa3ad78bdd6b366cc179`, `F_158f3069a435b314a80bdcb024f8e422`, `F_758874998f5bd0c393da094e1967a72b`, `F_ad13a2a07ca4b7642959dc0c4c740ab6`, `F_3fe94a002317b5f9259f82690aeea4cd`, `F_5b8add2a5d98b1a652ea7fd72d942dac`, `F_432aca3a1e345e339f35a30c8f65edce`, `F_8d3bba7425e7c98c50f52ca1b52d3735`, `F_320722549d1751cf3f247855f937b982`, `F_caf1a3dfb505ffed0d024130f58c5cfa`, `F_5737c6ec2e0716f3d8a7a5c4e0de0d9a`, `F_bc6dc48b743dc5d013b1abaebd2faed2`, `F_f2fc990265c712c49d51a18a32b39f0c`, `F_89f0fd5c927d466d6ec9a21b9ac34ffa`, `F_a666587afda6e89aec274a3657558a27`, `F_b83aac23b9528732c23cc7352950e880`, `F_cd00692c3bfe59267d5ecfac5310286c`, `F_6faa8040da20ef399b63a72d0e4ab575`, `F_fe73f687e5bc5280214e0486b273a5f9`) VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1473/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1474UNLOCK TABLES;
1475/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1476
1477/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1478/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1479/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1480/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1481/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1482/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1483/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1484
1485drop table t1;
1486#
1487# Test for --add-drop-database
1488#
1489CREATE TABLE t1 (a int);
1490INSERT INTO t1 VALUES (1),(2),(3);
1491
1492/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1493/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1494/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1495/*!40101 SET NAMES utf8 */;
1496/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1497/*!40103 SET TIME_ZONE='+00:00' */;
1498/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1499/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1500/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1501/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1502
1503/*!40000 DROP DATABASE IF EXISTS `test`*/;
1504
1505CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
1506
1507USE `test`;
1508DROP TABLE IF EXISTS `t1`;
1509/*!40101 SET @saved_cs_client = @@character_set_client */;
1510/*!40101 SET character_set_client = utf8 */;
1511CREATE TABLE `t1` (
1512 `a` int(11) DEFAULT NULL
1513) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1514/*!40101 SET character_set_client = @saved_cs_client */;
1515
1516LOCK TABLES `t1` WRITE;
1517/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1518INSERT INTO `t1` VALUES (1),(2),(3);
1519/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1520UNLOCK TABLES;
1521/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1522
1523/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1524/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1525/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1526/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1527/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1528/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1529/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1530
1531DROP TABLE t1;
1532#
1533# Bug#9558 mysqldump --no-data db t1 t2 format still dumps data
1534#
1535CREATE DATABASE mysqldump_test_db;
1536USE mysqldump_test_db;
1537CREATE TABLE t1 ( a INT );
1538CREATE TABLE t2 ( a INT );
1539INSERT INTO t1 VALUES (1), (2);
1540INSERT INTO t2 VALUES (1), (2);
1541
1542/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1543/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1544/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1545/*!40101 SET NAMES utf8 */;
1546/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1547/*!40103 SET TIME_ZONE='+00:00' */;
1548/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1549/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1550/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1551/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1552DROP TABLE IF EXISTS `t1`;
1553/*!40101 SET @saved_cs_client = @@character_set_client */;
1554/*!40101 SET character_set_client = utf8 */;
1555CREATE TABLE `t1` (
1556 `a` int(11) DEFAULT NULL
1557) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1558/*!40101 SET character_set_client = @saved_cs_client */;
1559DROP TABLE IF EXISTS `t2`;
1560/*!40101 SET @saved_cs_client = @@character_set_client */;
1561/*!40101 SET character_set_client = utf8 */;
1562CREATE TABLE `t2` (
1563 `a` int(11) DEFAULT NULL
1564) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1565/*!40101 SET character_set_client = @saved_cs_client */;
1566/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1567
1568/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1569/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1570/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1571/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1572/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1573/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1574/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1575
1576
1577/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1578/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1579/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1580/*!40101 SET NAMES utf8 */;
1581/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1582/*!40103 SET TIME_ZONE='+00:00' */;
1583/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1584/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1585/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1586/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1587DROP TABLE IF EXISTS `t1`;
1588/*!40101 SET @saved_cs_client = @@character_set_client */;
1589/*!40101 SET character_set_client = utf8 */;
1590CREATE TABLE `t1` (
1591 `a` int(11) DEFAULT NULL
1592) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1593/*!40101 SET character_set_client = @saved_cs_client */;
1594DROP TABLE IF EXISTS `t2`;
1595/*!40101 SET @saved_cs_client = @@character_set_client */;
1596/*!40101 SET character_set_client = utf8 */;
1597CREATE TABLE `t2` (
1598 `a` int(11) DEFAULT NULL
1599) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1600/*!40101 SET character_set_client = @saved_cs_client */;
1601/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1602
1603/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1604/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1605/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1606/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1607/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1608/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1609/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1610
1611<?xml version="1.0"?>
1612<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1613<database name="mysqldump_test_db">
1614 <table_structure name="t1">
1615 <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
1616 </table_structure>
1617 <table_structure name="t2">
1618 <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
1619 </table_structure>
1620</database>
1621</mysqldump>
1622<?xml version="1.0"?>
1623<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1624<database name="mysqldump_test_db">
1625 <table_structure name="t1">
1626 <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
1627 </table_structure>
1628 <table_structure name="t2">
1629 <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
1630 </table_structure>
1631</database>
1632</mysqldump>
1633DROP TABLE t1, t2;
1634DROP DATABASE mysqldump_test_db;
1635#
1636# Testing with tables and databases that don't exists
1637# or contains illegal characters
1638# (Bug#9358 mysqldump crashes if tablename starts with \)
1639#
1640create database mysqldump_test_db;
1641use mysqldump_test_db;
1642create table t1(a varchar(30) primary key, b int not null);
1643create table t2(a varchar(30) primary key, b int not null);
1644create table t3(a varchar(30) primary key, b int not null);
1645test_sequence
1646------ Testing with illegal table names ------
1647mysqldump: Couldn't find table: "\d-2-1.sql"
1648mysqldump: Couldn't find table: "\t1"
1649mysqldump: Couldn't find table: "\t1"
1650mysqldump: Couldn't find table: "\\t1"
1651mysqldump: Couldn't find table: "t\1"
1652mysqldump: Couldn't find table: "t\1"
1653mysqldump: Couldn't find table: "t/1"
1654mysqldump: Couldn't find table: "T_1"
1655mysqldump: Couldn't find table: "T%1"
1656mysqldump: Couldn't find table: "T'1"
1657mysqldump: Couldn't find table: "T_1"
1658mysqldump: Couldn't find table: "T_"
1659test_sequence
1660------ Testing with illegal database names ------
1661mysqldump: Got error: 1049: Unknown database 'mysqldump_test_d' when selecting the database
1662mysqldump: Got error: 1049: Unknown database 'mysqld\ump_test_db' when selecting the database
1663drop table t1, t2, t3;
1664drop database mysqldump_test_db;
1665use test;
1666#
1667# Bug#9657 mysqldump xml ( -x ) does not format NULL fields correctly
1668#
1669create table t1 (a int(10));
1670create table t2 (pk int primary key auto_increment,
1671a int(10), b varchar(30), c datetime, d blob, e text);
1672insert into t1 values (NULL), (10), (20);
1673insert into t2 (a, b) values (NULL, NULL),(10, NULL),(NULL, "twenty"),(30, "thirty");
1674<?xml version="1.0"?>
1675<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1676<database name="test">
1677 <table_data name="t1">
1678 <row>
1679 <field name="a" xsi:nil="true" />
1680 </row>
1681 <row>
1682 <field name="a">10</field>
1683 </row>
1684 <row>
1685 <field name="a">20</field>
1686 </row>
1687 </table_data>
1688 <table_data name="t2">
1689 <row>
1690 <field name="pk">1</field>
1691 <field name="a" xsi:nil="true" />
1692 <field name="b" xsi:nil="true" />
1693 <field name="c" xsi:nil="true" />
1694 <field name="d" xsi:nil="true" />
1695 <field name="e" xsi:nil="true" />
1696 </row>
1697 <row>
1698 <field name="pk">2</field>
1699 <field name="a">10</field>
1700 <field name="b" xsi:nil="true" />
1701 <field name="c" xsi:nil="true" />
1702 <field name="d" xsi:nil="true" />
1703 <field name="e" xsi:nil="true" />
1704 </row>
1705 <row>
1706 <field name="pk">3</field>
1707 <field name="a" xsi:nil="true" />
1708 <field name="b">twenty</field>
1709 <field name="c" xsi:nil="true" />
1710 <field name="d" xsi:nil="true" />
1711 <field name="e" xsi:nil="true" />
1712 </row>
1713 <row>
1714 <field name="pk">4</field>
1715 <field name="a">30</field>
1716 <field name="b">thirty</field>
1717 <field name="c" xsi:nil="true" />
1718 <field name="d" xsi:nil="true" />
1719 <field name="e" xsi:nil="true" />
1720 </row>
1721 </table_data>
1722</database>
1723</mysqldump>
1724drop table t1, t2;
1725#
1726# Bug#12123 mysqldump --tab results in text file which can't be imported
1727#
1728create table t1 (a text character set utf8, b text character set latin1);
1729insert t1 values (0x4F736E616272C3BC636B, 0x4BF66C6E);
1730select * from t1;
1731a b
1732Osnabrück Köln
1733test.t1: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
1734select * from t1;
1735a b
1736Osnabrück Köln
1737drop table t1;
1738#
1739# Bug#15328 Segmentation fault occured if my.cnf is invalid for escape sequence
1740#
1741--fields-optionally-enclosed-by="
1742#
1743# Bug#19025 mysqldump doesn't correctly dump "auto_increment = [int]"
1744#
1745create table `t1` (
1746t1_name varchar(255) default null,
1747t1_id int(10) unsigned not null auto_increment,
1748key (t1_name),
1749primary key (t1_id)
1750) auto_increment = 1000 default charset=latin1;
1751insert into t1 (t1_name) values('bla');
1752insert into t1 (t1_name) values('bla');
1753insert into t1 (t1_name) values('bla');
1754select * from t1;
1755t1_name t1_id
1756bla 1000
1757bla 1001
1758bla 1002
1759show create table `t1`;
1760Table Create Table
1761t1 CREATE TABLE `t1` (
1762 `t1_name` varchar(255) DEFAULT NULL,
1763 `t1_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1764 PRIMARY KEY (`t1_id`),
1765 KEY `t1_name` (`t1_name`)
1766) ENGINE=MyISAM AUTO_INCREMENT=1003 DEFAULT CHARSET=latin1
1767DROP TABLE `t1`;
1768select * from t1;
1769t1_name t1_id
1770bla 1000
1771bla 1001
1772bla 1002
1773show create table `t1`;
1774Table Create Table
1775t1 CREATE TABLE `t1` (
1776 `t1_name` varchar(255) DEFAULT NULL,
1777 `t1_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1778 PRIMARY KEY (`t1_id`),
1779 KEY `t1_name` (`t1_name`)
1780) ENGINE=MyISAM AUTO_INCREMENT=1003 DEFAULT CHARSET=latin1
1781drop table `t1`;
1782#
1783# Bug#18536 wrong table order
1784#
1785create table t1(a int);
1786create table t2(a int);
1787create table t3(a int);
1788
1789/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1790/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1791/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1792/*!40101 SET NAMES utf8 */;
1793/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1794/*!40103 SET TIME_ZONE='+00:00' */;
1795/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1796/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1797/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1798/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1799DROP TABLE IF EXISTS `t3`;
1800/*!40101 SET @saved_cs_client = @@character_set_client */;
1801/*!40101 SET character_set_client = utf8 */;
1802CREATE TABLE `t3` (
1803 `a` int(11) DEFAULT NULL
1804) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1805/*!40101 SET character_set_client = @saved_cs_client */;
1806DROP TABLE IF EXISTS `t1`;
1807/*!40101 SET @saved_cs_client = @@character_set_client */;
1808/*!40101 SET character_set_client = utf8 */;
1809CREATE TABLE `t1` (
1810 `a` int(11) DEFAULT NULL
1811) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1812/*!40101 SET character_set_client = @saved_cs_client */;
1813DROP TABLE IF EXISTS `t2`;
1814/*!40101 SET @saved_cs_client = @@character_set_client */;
1815/*!40101 SET character_set_client = utf8 */;
1816CREATE TABLE `t2` (
1817 `a` int(11) DEFAULT NULL
1818) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1819/*!40101 SET character_set_client = @saved_cs_client */;
1820/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1821
1822/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1823/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1824/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1825/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1826/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1827/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1828/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1829
1830drop table t1, t2, t3;
1831#
1832# Bug#21288 mysqldump segmentation fault when using --where
1833#
1834create table t1 (a int);
1835mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `t1` WHERE xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 (1064)
1836mysqldump: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 when retrieving data from server
1837
1838/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1839/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1840/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1841/*!40101 SET NAMES utf8 */;
1842/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1843/*!40103 SET TIME_ZONE='+00:00' */;
1844/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1845/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1846/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1847/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1848DROP TABLE IF EXISTS `t1`;
1849/*!40101 SET @saved_cs_client = @@character_set_client */;
1850/*!40101 SET character_set_client = utf8 */;
1851CREATE TABLE `t1` (
1852 `a` int(11) DEFAULT NULL
1853) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1854/*!40101 SET character_set_client = @saved_cs_client */;
1855
1856/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1857
1858/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1859/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1860/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1861/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1862/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1863/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1864/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1865
1866drop table t1;
1867#
1868# Bug#13926 --order-by-primary fails if PKEY contains quote character
1869#
1870DROP TABLE IF EXISTS `t1`;
1871CREATE TABLE `t1` (
1872`a b` INT,
1873`c"d` INT,
1874`e``f` INT,
1875PRIMARY KEY (`a b`, `c"d`, `e``f`)
1876) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1877insert into t1 values (0815, 4711, 2006);
1878/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1879/*!40103 SET TIME_ZONE='+00:00' */;
1880/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1881/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1882/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
1883/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1884DROP TABLE IF EXISTS "t1";
1885/*!40101 SET @saved_cs_client = @@character_set_client */;
1886/*!40101 SET character_set_client = utf8 */;
1887CREATE TABLE "t1" (
1888 "a b" int(11) NOT NULL DEFAULT '0',
1889 "c""d" int(11) NOT NULL DEFAULT '0',
1890 "e`f" int(11) NOT NULL DEFAULT '0',
1891 PRIMARY KEY ("a b","c""d","e`f")
1892);
1893/*!40101 SET character_set_client = @saved_cs_client */;
1894
1895LOCK TABLES "t1" WRITE;
1896/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
1897INSERT INTO "t1" VALUES (815,4711,2006);
1898/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
1899UNLOCK TABLES;
1900/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1901
1902/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1903/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1904/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1905/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1906
1907
1908/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1909/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1910/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1911/*!40101 SET NAMES utf8 */;
1912/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1913/*!40103 SET TIME_ZONE='+00:00' */;
1914/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1915/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1916/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1917/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1918DROP TABLE IF EXISTS `t1`;
1919/*!40101 SET @saved_cs_client = @@character_set_client */;
1920/*!40101 SET character_set_client = utf8 */;
1921CREATE TABLE `t1` (
1922 `a b` int(11) NOT NULL DEFAULT '0',
1923 `c"d` int(11) NOT NULL DEFAULT '0',
1924 `e``f` int(11) NOT NULL DEFAULT '0',
1925 PRIMARY KEY (`a b`,`c"d`,`e``f`)
1926) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1927/*!40101 SET character_set_client = @saved_cs_client */;
1928
1929LOCK TABLES `t1` WRITE;
1930/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1931INSERT INTO `t1` VALUES (815,4711,2006);
1932/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1933UNLOCK TABLES;
1934/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1935
1936/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1937/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1938/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1939/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1940/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1941/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1942/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1943
1944DROP TABLE `t1`;
1945End of 4.1 tests
1946#
1947# Bug#10213 mysqldump crashes when dumping VIEWs(on MacOS X)
1948#
1949create database db1;
1950use db1;
1951CREATE TABLE t2 (
1952a varchar(30) default NULL,
1953KEY a (a(5))
1954);
1955INSERT INTO t2 VALUES ('alfred');
1956INSERT INTO t2 VALUES ('angie');
1957INSERT INTO t2 VALUES ('bingo');
1958INSERT INTO t2 VALUES ('waffle');
1959INSERT INTO t2 VALUES ('lemon');
1960create view v2 as select * from t2 where a like 'a%' with check option;
1961
1962/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1963/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1964/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1965/*!40101 SET NAMES utf8 */;
1966/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1967/*!40103 SET TIME_ZONE='+00:00' */;
1968/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1969/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1970/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1971/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1972DROP TABLE IF EXISTS `t2`;
1973/*!40101 SET @saved_cs_client = @@character_set_client */;
1974/*!40101 SET character_set_client = utf8 */;
1975CREATE TABLE `t2` (
1976 `a` varchar(30) DEFAULT NULL,
1977 KEY `a` (`a`(5))
1978) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1979/*!40101 SET character_set_client = @saved_cs_client */;
1980
1981LOCK TABLES `t2` WRITE;
1982/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
1983INSERT INTO `t2` VALUES ('alfred'),('angie'),('bingo'),('waffle'),('lemon');
1984/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
1985UNLOCK TABLES;
1986DROP TABLE IF EXISTS `v2`;
1987/*!50001 DROP VIEW IF EXISTS `v2`*/;
1988SET @saved_cs_client = @@character_set_client;
1989SET character_set_client = utf8;
1990/*!50001 CREATE TABLE `v2` (
1991 `a` varchar(30)
1992) ENGINE=MyISAM */;
1993SET character_set_client = @saved_cs_client;
1994/*!50001 DROP TABLE IF EXISTS `v2`*/;
1995/*!50001 DROP VIEW IF EXISTS `v2`*/;
1996/*!50001 SET @saved_cs_client = @@character_set_client */;
1997/*!50001 SET @saved_cs_results = @@character_set_results */;
1998/*!50001 SET @saved_col_connection = @@collation_connection */;
1999/*!50001 SET character_set_client = latin1 */;
2000/*!50001 SET character_set_results = latin1 */;
2001/*!50001 SET collation_connection = latin1_swedish_ci */;
2002/*!50001 CREATE ALGORITHM=UNDEFINED */
2003/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2004/*!50001 VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where (`t2`.`a` like 'a%') */
2005/*!50002 WITH CASCADED CHECK OPTION */;
2006/*!50001 SET character_set_client = @saved_cs_client */;
2007/*!50001 SET character_set_results = @saved_cs_results */;
2008/*!50001 SET collation_connection = @saved_col_connection */;
2009/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2010
2011/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2012/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2013/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2014/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2015/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2016/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2017/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2018
2019drop table t2;
2020drop view v2;
2021drop database db1;
2022use test;
2023#
2024# Bug#10713 mysqldump includes database in create view and referenced tables
2025#
2026create database db2;
2027use db2;
2028create table t1 (a int);
2029create table t2 (a int, b varchar(10), primary key(a));
2030insert into t2 values (1, "on"), (2, "off"), (10, "pol"), (12, "meg");
2031insert into t1 values (289), (298), (234), (456), (789);
2032create view v1 as select * from t2;
2033create view v2 as select * from t1;
2034drop table t1, t2;
2035drop view v1, v2;
2036drop database db2;
2037use test;
2038create database db1;
2039use db1;
2040show tables;
2041Tables_in_db1
2042t1
2043t2
2044v1
2045v2
2046select * from t2 order by a;
2047a b
20481 on
20492 off
205010 pol
205112 meg
2052drop table t1, t2;
2053drop database db1;
2054use test;
2055create table t1(a int);
2056create view v1 as select * from t1;
2057
2058/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2059/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2060/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2061/*!40101 SET NAMES utf8 */;
2062/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2063/*!40103 SET TIME_ZONE='+00:00' */;
2064/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2065/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2066/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2067/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2068DROP TABLE IF EXISTS `t1`;
2069/*!40101 SET @saved_cs_client = @@character_set_client */;
2070/*!40101 SET character_set_client = utf8 */;
2071CREATE TABLE `t1` (
2072 `a` int(11) DEFAULT NULL
2073) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2074/*!40101 SET character_set_client = @saved_cs_client */;
2075
2076LOCK TABLES `t1` WRITE;
2077/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2078/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2079UNLOCK TABLES;
2080DROP TABLE IF EXISTS `v1`;
2081/*!50001 DROP VIEW IF EXISTS `v1`*/;
2082SET @saved_cs_client = @@character_set_client;
2083SET character_set_client = utf8;
2084/*!50001 CREATE TABLE `v1` (
2085 `a` int(11)
2086) ENGINE=MyISAM */;
2087SET character_set_client = @saved_cs_client;
2088/*!50001 DROP TABLE IF EXISTS `v1`*/;
2089/*!50001 DROP VIEW IF EXISTS `v1`*/;
2090/*!50001 SET @saved_cs_client = @@character_set_client */;
2091/*!50001 SET @saved_cs_results = @@character_set_results */;
2092/*!50001 SET @saved_col_connection = @@collation_connection */;
2093/*!50001 SET character_set_client = latin1 */;
2094/*!50001 SET character_set_results = latin1 */;
2095/*!50001 SET collation_connection = latin1_swedish_ci */;
2096/*!50001 CREATE ALGORITHM=UNDEFINED */
2097/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2098/*!50001 VIEW `v1` AS select `t1`.`a` AS `a` from `t1` */;
2099/*!50001 SET character_set_client = @saved_cs_client */;
2100/*!50001 SET character_set_results = @saved_cs_results */;
2101/*!50001 SET collation_connection = @saved_col_connection */;
2102/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2103
2104/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2105/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2106/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2110/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2111
2112drop view v1;
2113drop table t1;
2114#
2115# Bug#10213 mysqldump crashes when dumping VIEWs(on MacOS X)
2116#
2117create database mysqldump_test_db;
2118use mysqldump_test_db;
2119CREATE TABLE t2 (
2120a varchar(30) default NULL,
2121KEY a (a(5))
2122);
2123INSERT INTO t2 VALUES ('alfred');
2124INSERT INTO t2 VALUES ('angie');
2125INSERT INTO t2 VALUES ('bingo');
2126INSERT INTO t2 VALUES ('waffle');
2127INSERT INTO t2 VALUES ('lemon');
2128create view v2 as select * from t2 where a like 'a%' with check option;
2129
2130/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2131/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2132/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2133/*!40101 SET NAMES utf8 */;
2134/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2135/*!40103 SET TIME_ZONE='+00:00' */;
2136/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2137/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2138/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2139/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2140DROP TABLE IF EXISTS `t2`;
2141/*!40101 SET @saved_cs_client = @@character_set_client */;
2142/*!40101 SET character_set_client = utf8 */;
2143CREATE TABLE `t2` (
2144 `a` varchar(30) DEFAULT NULL,
2145 KEY `a` (`a`(5))
2146) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2147/*!40101 SET character_set_client = @saved_cs_client */;
2148
2149LOCK TABLES `t2` WRITE;
2150/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
2151INSERT INTO `t2` VALUES ('alfred'),('angie'),('bingo'),('waffle'),('lemon');
2152/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
2153UNLOCK TABLES;
2154DROP TABLE IF EXISTS `v2`;
2155/*!50001 DROP VIEW IF EXISTS `v2`*/;
2156SET @saved_cs_client = @@character_set_client;
2157SET character_set_client = utf8;
2158/*!50001 CREATE TABLE `v2` (
2159 `a` varchar(30)
2160) ENGINE=MyISAM */;
2161SET character_set_client = @saved_cs_client;
2162/*!50001 DROP TABLE IF EXISTS `v2`*/;
2163/*!50001 DROP VIEW IF EXISTS `v2`*/;
2164/*!50001 SET @saved_cs_client = @@character_set_client */;
2165/*!50001 SET @saved_cs_results = @@character_set_results */;
2166/*!50001 SET @saved_col_connection = @@collation_connection */;
2167/*!50001 SET character_set_client = latin1 */;
2168/*!50001 SET character_set_results = latin1 */;
2169/*!50001 SET collation_connection = latin1_swedish_ci */;
2170/*!50001 CREATE ALGORITHM=UNDEFINED */
2171/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2172/*!50001 VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where (`t2`.`a` like 'a%') */
2173/*!50002 WITH CASCADED CHECK OPTION */;
2174/*!50001 SET character_set_client = @saved_cs_client */;
2175/*!50001 SET character_set_results = @saved_cs_results */;
2176/*!50001 SET collation_connection = @saved_col_connection */;
2177/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2178
2179/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2180/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2181/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2182/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2183/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2184/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2185/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2186
2187drop table t2;
2188drop view v2;
2189drop database mysqldump_test_db;
2190use test;
2191#
2192# Bug#9756 mysql client failing on dumps containing certain \ sequences
2193#
2194CREATE TABLE t1 (a char(10));
2195INSERT INTO t1 VALUES ('\'');
2196
2197/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2198/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2199/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2200/*!40101 SET NAMES utf8 */;
2201/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2202/*!40103 SET TIME_ZONE='+00:00' */;
2203/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2204/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2205/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2206/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2207DROP TABLE IF EXISTS `t1`;
2208/*!40101 SET @saved_cs_client = @@character_set_client */;
2209/*!40101 SET character_set_client = utf8 */;
2210CREATE TABLE `t1` (
2211 `a` char(10) DEFAULT NULL
2212) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2213/*!40101 SET character_set_client = @saved_cs_client */;
2214
2215LOCK TABLES `t1` WRITE;
2216/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2217INSERT INTO `t1` VALUES ('\'');
2218/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2219UNLOCK TABLES;
2220/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2221
2222/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2223/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2224/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2225/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2226/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2227/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2228/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2229
2230DROP TABLE t1;
2231#
2232# Bug#10927 mysqldump: Can't reload dump with view that consist of other view
2233#
2234create table t1(a int, b int, c varchar(30));
2235insert into t1 values(1, 2, "one"), (2, 4, "two"), (3, 6, "three");
2236create view v3 as
2237select * from t1;
2238create view v1 as
2239select * from v3 where b in (1, 2, 3, 4, 5, 6, 7);
2240create view v2 as
2241select v3.a from v3, v1 where v1.a=v3.a and v3.b=3 limit 1;
2242
2243/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2244/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2245/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2246/*!40101 SET NAMES utf8 */;
2247/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2248/*!40103 SET TIME_ZONE='+00:00' */;
2249/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2250/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2251/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2252/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2253DROP TABLE IF EXISTS `t1`;
2254/*!40101 SET @saved_cs_client = @@character_set_client */;
2255/*!40101 SET character_set_client = utf8 */;
2256CREATE TABLE `t1` (
2257 `a` int(11) DEFAULT NULL,
2258 `b` int(11) DEFAULT NULL,
2259 `c` varchar(30) DEFAULT NULL
2260) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2261/*!40101 SET character_set_client = @saved_cs_client */;
2262
2263LOCK TABLES `t1` WRITE;
2264/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2265INSERT INTO `t1` VALUES (1,2,'one'),(2,4,'two'),(3,6,'three');
2266/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2267UNLOCK TABLES;
2268DROP TABLE IF EXISTS `v1`;
2269/*!50001 DROP VIEW IF EXISTS `v1`*/;
2270SET @saved_cs_client = @@character_set_client;
2271SET character_set_client = utf8;
2272/*!50001 CREATE TABLE `v1` (
2273 `a` int(11),
2274 `b` int(11),
2275 `c` varchar(30)
2276) ENGINE=MyISAM */;
2277SET character_set_client = @saved_cs_client;
2278DROP TABLE IF EXISTS `v2`;
2279/*!50001 DROP VIEW IF EXISTS `v2`*/;
2280SET @saved_cs_client = @@character_set_client;
2281SET character_set_client = utf8;
2282/*!50001 CREATE TABLE `v2` (
2283 `a` int(11)
2284) ENGINE=MyISAM */;
2285SET character_set_client = @saved_cs_client;
2286DROP TABLE IF EXISTS `v3`;
2287/*!50001 DROP VIEW IF EXISTS `v3`*/;
2288SET @saved_cs_client = @@character_set_client;
2289SET character_set_client = utf8;
2290/*!50001 CREATE TABLE `v3` (
2291 `a` int(11),
2292 `b` int(11),
2293 `c` varchar(30)
2294) ENGINE=MyISAM */;
2295SET character_set_client = @saved_cs_client;
2296/*!50001 DROP TABLE IF EXISTS `v1`*/;
2297/*!50001 DROP VIEW IF EXISTS `v1`*/;
2298/*!50001 SET @saved_cs_client = @@character_set_client */;
2299/*!50001 SET @saved_cs_results = @@character_set_results */;
2300/*!50001 SET @saved_col_connection = @@collation_connection */;
2301/*!50001 SET character_set_client = latin1 */;
2302/*!50001 SET character_set_results = latin1 */;
2303/*!50001 SET collation_connection = latin1_swedish_ci */;
2304/*!50001 CREATE ALGORITHM=UNDEFINED */
2305/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2306/*!50001 VIEW `v1` AS select `v3`.`a` AS `a`,`v3`.`b` AS `b`,`v3`.`c` AS `c` from `v3` where (`v3`.`b` in (1,2,3,4,5,6,7)) */;
2307/*!50001 SET character_set_client = @saved_cs_client */;
2308/*!50001 SET character_set_results = @saved_cs_results */;
2309/*!50001 SET collation_connection = @saved_col_connection */;
2310/*!50001 DROP TABLE IF EXISTS `v2`*/;
2311/*!50001 DROP VIEW IF EXISTS `v2`*/;
2312/*!50001 SET @saved_cs_client = @@character_set_client */;
2313/*!50001 SET @saved_cs_results = @@character_set_results */;
2314/*!50001 SET @saved_col_connection = @@collation_connection */;
2315/*!50001 SET character_set_client = latin1 */;
2316/*!50001 SET character_set_results = latin1 */;
2317/*!50001 SET collation_connection = latin1_swedish_ci */;
2318/*!50001 CREATE ALGORITHM=UNDEFINED */
2319/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2320/*!50001 VIEW `v2` AS select `v3`.`a` AS `a` from (`v3` join `v1`) where ((`v1`.`a` = `v3`.`a`) and (`v3`.`b` = 3)) limit 1 */;
2321/*!50001 SET character_set_client = @saved_cs_client */;
2322/*!50001 SET character_set_results = @saved_cs_results */;
2323/*!50001 SET collation_connection = @saved_col_connection */;
2324/*!50001 DROP TABLE IF EXISTS `v3`*/;
2325/*!50001 DROP VIEW IF EXISTS `v3`*/;
2326/*!50001 SET @saved_cs_client = @@character_set_client */;
2327/*!50001 SET @saved_cs_results = @@character_set_results */;
2328/*!50001 SET @saved_col_connection = @@collation_connection */;
2329/*!50001 SET character_set_client = latin1 */;
2330/*!50001 SET character_set_results = latin1 */;
2331/*!50001 SET collation_connection = latin1_swedish_ci */;
2332/*!50001 CREATE ALGORITHM=UNDEFINED */
2333/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches

to all changes: