File: mysqlpump_bugs.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (99 lines) | stat: -rw-r--r-- 3,890 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
#
# Bug#23102944: MYSQLPUMP LEAKS MEMORY IN CASE OF ERRORS.
#
# testing a failed connection: must not crash
WARNING: mysqlpump is deprecated and will be removed in a future version. Use mysqldump instead.
mysqlpump: Got error: 2005: Unknown MySQL server host 'non_existent_ghost' (errno) while connecting to the MySQL server
mysqlpump: [ERROR] (11) 
Dump process encountered error and will not continue.
# testing an invalid option: must not crash
WARNING: mysqlpump is deprecated and will be removed in a future version. Use mysqldump instead.
mysqlpump: [ERROR] unknown variable 'parallelism=3'.
mysqlpump: [ERROR] (7) Error during handling options
Dump process encountered error and will not continue.
mysqlpump: Got error: 2005: Unknown MySQL server host 'non_existent_ghost' (errno) while connecting to the MySQL server
mysqlpump: [ERROR] (11) 
Dump process encountered error and will not continue.
#
# Bug#29389828: CRASH WHEN TILDE EXPANSION USED IN --RESULT-FILE PATH
#
# report error when tilde is used in file name
#
# Bug #29343073: MYSQLPUMP DUMPS GRANT TABLES THAT IT SHOULD NOT
#
include/assert_grep.inc [Should not contain mysql.role_edges]
include/assert_grep.inc [Should not contain mysql.global_grants]
include/assert_grep.inc [Should not contain mysql.default_roles]
include/assert_grep.inc [Should contain mysql.password_history]
Test: dump of mysql database should not contain unexpected tables
Matching lines are:
CREATE TABLE `mysql`.`component` (
CREATE TABLE `mysql`.`engine_cost` (
CREATE TABLE `mysql`.`func` (
CREATE TABLE `mysql`.`help_category` (
CREATE TABLE `mysql`.`help_keyword` (
CREATE TABLE `mysql`.`help_relation` (
CREATE TABLE `mysql`.`help_topic` (
CREATE TABLE `mysql`.`password_history` (
CREATE TABLE `mysql`.`plugin` (
CREATE TABLE `mysql`.`replication_asynchronous_connection_failover` (
CREATE TABLE `mysql`.`replication_asynchronous_connection_failover_managed` (
CREATE TABLE `mysql`.`replication_group_configuration_version` (
CREATE TABLE `mysql`.`replication_group_member_actions` (
CREATE TABLE `mysql`.`server_cost` (
CREATE TABLE `mysql`.`servers` (
CREATE TABLE `mysql`.`slave_worker_info` (
CREATE TABLE `mysql`.`time_zone` (
CREATE TABLE `mysql`.`time_zone_leap_second` (
CREATE TABLE `mysql`.`time_zone_name` (
CREATE TABLE `mysql`.`time_zone_transition` (
CREATE TABLE `mysql`.`time_zone_transition_type` (
Occurrences of 'CREATE TABLE' in the input file: 21
#
# Bug #83144: mysqlpump reads mysql_dump group, not mysqlpump in config-group
#
CREATE DATABASE db1;
CREATE DATABASE db2;
DROP DATABASE db1;
DROP DATABASE db2;
SHOW DATABASES like 'db%';
Database (db%)
db2
DROP DATABASE db2;
#
# Bug #32067013: MYSQLPUMP SEGMENTATION FAULT
#
CREATE DATABASE B32067013;
CREATE TABLE B32067013.t1(v1 INT, v2 INT);
CREATE TABLE B32067013.t2(v1 INT, v2 INT);
CREATE VIEW B32067013.t123 AS SELECT * FROM B32067013.t1;
DROP TABLE B32067013.t1;
# Test criteria: shouldn't crash
DROP DATABASE B32067013;
#
# Bug#32340208: MYSQLPUMP SEGFAULT WHEN DUMPING 2 TABLES
#
SET sql_mode ='';
CREATE DATABASE B32340208;
CREATE TABLE B32340208.test (
`pk` int NOT NULL AUTO_INCREMENT,
`a1` smallint GENERATED ALWAYS AS (((0 <> `c1`) and (_utf8mb4'0000-00-00
00:00:00' <> `d1`))) VIRTUAL NOT SECONDARY,
`b1` char(8) DEFAULT NULL,
`c1` longblob NOT NULL NOT SECONDARY,
`d1` timestamp NOT NULL,
PRIMARY KEY (`pk`),
KEY `functional_index` ((radians(`c1`))) USING BTREE COMMENT 'you''re'
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
Warnings:
Warning	4095	Delimiter '\n' in position 10 in datetime value '0000-00-00
00:00:00' at row 1 is deprecated. Prefer the standard ' '.
# Success criteria: should not crash
DROP DATABASE B32340208;
SET sql_mode = DEFAULT;
#
# Bug #33688141 mysqlpump exits in regards to 'std::logic_error'
#
# Expect log that proves the client clean exit
Pattern "Dump process encountered error and will not continue." found
# End of 8.0 tests