==========
-rw-r--r-- 1 mysqldev users 1115 Jul 7 12:24 main.mysqldump.917.316
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
*** /PATH/mysql-test/r/mysqldump.result
--- /PATH/mysql-test/r/mysqldump.reject
***************
*** 3219,3225
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
- INSERT INTO `t1` VALUES (0x00,'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--- 3219,3224
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 200807060738048215
===---===---===---===---===---===--- OCCURRED:
hpita2-64bit-5.1-enterprise.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1119 Jul 7 12:24 main.mysqldump.923.314
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
*** /PATH/mysql-test/r/mysqldump.result
--- /PATH/mysql-test/r/mysqldump.reject
***************
*** 1904,1910
LOCK TABLES "t1" WRITE;
/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
- INSERT INTO "t1" VALUES (815,4711,2006);
/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--- 1904,1909
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070521440519717
===---===---===---===---===---===--- OCCURRED:
hpita2-64bit-5.1-classic.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1160 Jul 4 15:48 main.mysqldump.950.264
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -3629,10 +3629,6 @@
-
- 1
- FF00FEF0
-
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070221372824015
===---===---===---===---===---===--- OCCURRED:
vm-rhas3-x86-glibc23-5.1-enterprise-gpl.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1204 Jul 4 19:31 main.mysqldump.986.302
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -35,7 +35,6 @@
`a` decimal(64,20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
-INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
DROP TABLE t1;
#
# Bug #2055
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: notyetfound
===---===---===---===---===---===--- OCCURRED:
Do-rpm-vm-rhas3-x86-64-a-5.1-advanced-gpl.rhel3-x86_64.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1502 Jul 7 12:25 main.mysqldump.995.146
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -13,12 +13,6 @@
-
- 1
-
-
- 2
-
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: notyetfound
===---===---===---===---===---===--- OCCURRED:
Do-rpm-rx2620c-5.1-community.log normal
Do-rpm-vm-rhas3-x86-5.1-community.rhel3-i686.log normal
Do-rpm-vm-rhas3-x86-5.1-enterprise.rhel3-i686.log debug
Do-rpm-vm-rhas3-x86-64-a-5.1-community.log debug
vm-rhas3-x86-glibc23-5.1-enterprise.log debug
vm-rhas3-x86-64-a-glibc23-5.1-classic.log debug
vm-rhas3-x86-glibc23-5.1-advanced-gpl.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1334 Jul 4 15:48 main.mysqldump.1137.206
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
*** /PATH/mysql-test/r/mysqldump.result
--- /PATH/mysql-test/r/mysqldump.reject
***************
*** 3950,3956
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
! INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
--- 3950,3956
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
! INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070117184611001
===---===---===---===---===---===--- OCCURRED:
hpux31-64bit-5.1-community.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1332 Jul 7 12:24 main.mysqldump.1137.313
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
*** /PATH/mysql-test/r/mysqldump.result
--- /PATH/mysql-test/r/mysqldump.reject
***************
*** 3432,3438
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
! INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
--- 3432,3438
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
! INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070521440519717
===---===---===---===---===---===--- OCCURRED:
hpita2-64bit-5.1-classic.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1809 Jul 7 12:25 main.mysqldump.1324.136
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -13,12 +13,6 @@
-
- 1
-
-
- 2
-
@@ -35,7 +29,6 @@
`a` decimal(64,20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
-INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
DROP TABLE t1;
#
# Bug #2055
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: notyetfound
===---===---===---===---===---===--- OCCURRED:
Do-rpm-rh-x86-64-5.1-advanced-gpl.rhel4-x86_64.log debug
Do-rpm-rh-x86-64-5.1-advanced.rhel4-x86_64.log debug
Do-rpm-rh-x86-64-5.1-community.rhel4-x86_64.log debug
Do-rpm-rh-x86-64-5.1-enterprise-gpl.rhel4-x86_64.log debug
Do-rpm-rh-x86-64-5.1-enterprise.rhel4-x86_64.log debug
pegasos3-glibc23-5.1-advanced-gpl.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1604 Jul 4 15:48 main.mysqldump.1402.189
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -2227,7 +2227,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('\'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3219,7 +3218,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (0x00,'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3432,7 +3430,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070221372824015
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-enterprise-gpl.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1600 Jul 4 15:48 main.mysqldump.1404.186
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -1525,7 +1525,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1),(2),(3);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -2227,7 +2226,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('\'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3432,7 +3430,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070117184611001
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-community.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1640 Jul 4 15:48 main.mysqldump.1443.191
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -213,8 +213,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('абцде');
-INSERT INTO `t1` VALUES (NULL);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1525,7 +1523,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1),(2),(3);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3950,7 +3947,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070316441229076
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-enterprise.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1756 Jul 7 12:24 main.mysqldump.1557.306
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -35,7 +35,6 @@
`a` decimal(64,20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
-INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
DROP TABLE t1;
#
# Bug #2055
@@ -3432,7 +3431,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
@@ -3856,7 +3855,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-REPLACE INTO `t1` VALUES (1,1),(2,3),(3,4),(4,5);
+REPLACE INTO `t1` VALUES (1,1),(2,3);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070520553512952
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-advanced-gpl.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 1770 Jul 7 12:24 main.mysqldump.1570.307
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -150,16 +150,6 @@
-
- 1
- test
- tes
-
-
- 2
- TEST
- TES
-
@@ -665,7 +655,6 @@
LOCK TABLES `t2` WRITE;
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
-INSERT INTO `t2` VALUES (4),(5),(6);
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3950,7 +3939,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070520553512952
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-advanced-gpl.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1807 Jul 4 15:48 main.mysqldump.1610.187
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -13,12 +13,6 @@
-
- 1
-
-
- 2
-
@@ -35,7 +29,6 @@
`a` decimal(64,20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
-INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
DROP TABLE t1;
#
# Bug #2055
@@ -3950,7 +3943,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070117184611001
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-community.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1886 Jul 4 15:48 main.mysqldump.1688.192
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -2227,7 +2227,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('\'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3219,7 +3218,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (0x00,'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3432,7 +3430,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
@@ -3950,7 +3948,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070316441229076
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-enterprise.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 1935 Jul 4 15:48 main.mysqldump.1740.183
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -213,8 +213,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('абцде');
-INSERT INTO `t1` VALUES (NULL);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -747,7 +745,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
+INSERT IGNORE INTO `t1` VALUES (1),(2),(3);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1525,7 +1523,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1),(2),(3);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3950,7 +3947,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 200807020741557402
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-advanced.log normal
==========
==========
-rw-r--r-- 1 mysqldev users 15341 Jul 7 12:24 main.mysqldump.15097.310
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
*** /PATH/mysql-test/r/mysqldump.result
--- /PATH/mysql-test/r/mysqldump.reject
***************
*** 1479,1485
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
- INSERT INTO `t1` (`F_c4ca4238a0b923820dcc509a6f75849b`, `F_c81e728d9d4c2f636f067f89cc14862c`, ...325_field_names_deleted... `F_cd00692c3bfe59267d5ecfac5310286c`, `F_6faa8040da20ef399b63a72d0e4ab575`, `F_fe73f687e5bc5280214e0486b273a5f9`) VALUES (NULL,NULL,...325_field_values_deleted...,NULL,NULL,NULL);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--- 1479,1484
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070520553512952
===---===---===---===---===---===--- OCCURRED:
hpita2-64bit-5.1-advanced-gpl.log debug
hpita2-64bit-5.1-enterprise-gpl.log debug
==========
==========
-rw-r--r-- 1 mysqldev users 16013 Jul 4 15:48 main.mysqldump.15819.185
=====
main.mysqldump [ fail ]
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /PATH/mysql-test/r/mysqldump.result
+++ /PATH/mysql-test/r/mysqldump.reject
@@ -1479,7 +1479,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` (`F_c4ca4238a0b923820dcc509a6f75849b`, `F_c81e728d9d4c2f636f067f89cc14862c`, ...325_field_names_deleted... `F_cd00692c3bfe59267d5ecfac5310286c`, `F_6faa8040da20ef399b63a72d0e4ab575`, `F_fe73f687e5bc5280214e0486b273a5f9`) VALUES (NULL,NULL,...325_field_values_deleted...,NULL,NULL,NULL);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1904,7 +1903,6 @@
LOCK TABLES "t1" WRITE;
/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
-INSERT INTO "t1" VALUES (815,4711,2006);
/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -2227,7 +2225,6 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES ('\'');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -3432,7 +3429,7 @@
LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
-INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
+INSERT INTO `t1` VALUES (1232131),(4711),(3231);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v1`;
mysqltest: Result content mismatch
Stopping All Servers
===---===---===---===---===---===--- BUGDB: bug#37938
===---===---===---===---===---===--- BUILD-ID: 2008070307175319653
===---===---===---===---===---===--- OCCURRED:
butch-64bit-5.1-classic.log debug
==========