========== -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 ==========