From: Marc Alff Date: March 17 2010 8:48am Subject: bzr commit into mysql-next-mr-bugfixing branch (marc.alff:3123) Bug#50557 List-Archive: http://lists.mysql.com/commits/103543 X-Bug: 50557 Message-Id: <20100317084831.3656A1F24C3@MarcBook.local> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="Boundary_(ID_cMozjayTG+j4mbzseNKMBA)" --Boundary_(ID_cMozjayTG+j4mbzseNKMBA) MIME-version: 1.0 Content-type: text/plain; CHARSET=US-ASCII Content-transfer-encoding: 7BIT Content-disposition: inline #At file:///Users/malff/BZR_TREE/mysql-next-mr-bugfixing-50557/ based on revid:vvaintroub@stripped 3123 Marc Alff 2010-03-17 Bug#50557 checksum table crashes server when used in performance_schema This bug could not be reproduced. Adding the test case to the test suite for coverage. added: mysql-test/suite/perfschema/r/checksum.result mysql-test/suite/perfschema/t/checksum.test === added file 'mysql-test/suite/perfschema/r/checksum.result' --- a/mysql-test/suite/perfschema/r/checksum.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/r/checksum.result 2010-03-17 08:48:25 +0000 @@ -0,0 +1,15 @@ +checksum table performance_schema.EVENTS_WAITS_CURRENT; +checksum table performance_schema.EVENTS_WAITS_HISTORY; +checksum table performance_schema.EVENTS_WAITS_HISTORY_LONG; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_EVENT_NAME; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_INSTANCE; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_THREAD_BY_EVENT_NAME; +checksum table performance_schema.FILE_INSTANCES; +checksum table performance_schema.FILE_SUMMARY_BY_EVENT_NAME; +checksum table performance_schema.MUTEX_INSTANCES; +checksum table performance_schema.PERFORMANCE_TIMERS; +checksum table performance_schema.PROCESSLIST; +checksum table performance_schema.RWLOCK_INSTANCES; +checksum table performance_schema.SETUP_CONSUMERS; +checksum table performance_schema.SETUP_INSTRUMENTS; +checksum table performance_schema.SETUP_OBJECTS; === added file 'mysql-test/suite/perfschema/t/checksum.test' --- a/mysql-test/suite/perfschema/t/checksum.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/t/checksum.test 2010-03-17 08:48:25 +0000 @@ -0,0 +1,42 @@ +# Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA + +# Tests for PERFORMANCE_SCHEMA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# Test that checksum does not crash or fail with errors. +# The checksum result will be un predictable since the content +# changes all the time, this is expected. + +--disable_result_log +checksum table performance_schema.EVENTS_WAITS_CURRENT; +checksum table performance_schema.EVENTS_WAITS_HISTORY; +checksum table performance_schema.EVENTS_WAITS_HISTORY_LONG; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_EVENT_NAME; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_INSTANCE; +checksum table performance_schema.EVENTS_WAITS_SUMMARY_BY_THREAD_BY_EVENT_NAME; +checksum table performance_schema.FILE_INSTANCES; +checksum table performance_schema.FILE_SUMMARY_BY_EVENT_NAME; +checksum table performance_schema.MUTEX_INSTANCES; +checksum table performance_schema.PERFORMANCE_TIMERS; +checksum table performance_schema.PROCESSLIST; +checksum table performance_schema.RWLOCK_INSTANCES; +checksum table performance_schema.SETUP_CONSUMERS; +checksum table performance_schema.SETUP_INSTRUMENTS; +checksum table performance_schema.SETUP_OBJECTS; +--enable_result_log + --Boundary_(ID_cMozjayTG+j4mbzseNKMBA) MIME-version: 1.0 Content-type: text/bzr-bundle; CHARSET=US-ASCII; name="bzr/marc.alff@stripped" Content-transfer-encoding: 7BIT Content-disposition: inline; filename="bzr/marc.alff@stripped" # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: marc.alff@stripped # target_branch: file:///Users/malff/BZR_TREE/mysql-next-mr-bugfixing-\ # 50557/ # testament_sha1: 373e7f0c93c24c9f984fc5befebca6b6aeb72da5 # timestamp: 2010-03-17 02:48:29 -0600 # base_revision_id: vvaintroub@stripped\ # u8yklmdhcd1f973o # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWc+KiH0AAtZfgEAQWWf//3// 3+C////wYAgK33QlKrsADINANCgpBkTUTJhT1MeiTJtQANBoBkeoBoNABJRqaDJo1GUmxRtJ6nqD JoBo0aGgAACKn6MpD0RoDRoABoAaGgAANADhppkYjCaYCGATTCMExMhpkaGgOGmmRiMJpgIYBNMI wTEyGmRoaASRCYhNGQmE0aTajE1TzRPSjynqPUyeEYp6T0lszVzo+1gy1nPhFIliqkKWDulDXS1W j9ENFxYqDOULkc/W6dTw28FwJMhjbtZNk0dOM9ixX11/FVxsaGlqr3aoXuv9eaaiHBo7HejYtJAF sMEZZWS9HL7HatB8REnlU7P8hYJCMMCI/RpFa+pDldlYgU/LJJmDiUA/VBLJWhRAECUbQz22q2ZS nKI/dqwpQxvEk0wd2fNELdUdVhhNJJ6sBnnLS5NEllXfswskOUrn5ZSgXShF27dNuTudcidsSPYq M/iA9vCCS84gw29Snyy7NWjYZtkLw2b2aUZtmTAwG7q6hsfWTr6jbsAuy6ZElvNGTeQd/dDZqv8o koIJ3pgIU1i3reS3cznsaY4X9mNVs4y6iLwbniINbiCAxaTwpFTChMAt0mguIAVL1SpUXmskMVHg yHGoxFhiw6TkBSIXxqMaziupS7K/8EujQplKsExJhgW7Djuo+KmZmg/OSwydTE0vcgLyiiYe2eKn YWGwknWkBwr9wpEmPFDncQMBimq+JbQgySoi8mqjVEkXESCfxtXGagDSYkVGIGacYH65DcBXAi/r GjSBhzUpwxLlYEiRA12m4vjiPdqHNJtuA131vMH1kBwbnqM5LRtChkfzIprdeBcPLjLokXqcyJwE AuYzIGEDYTcZ2M7FakZZAaiAEDMYm54kNewvzM5iEjwTKot45ar9j8zgWRsNEnF2gMwbNYog45zz nlPccwqhAgDBAd7HDf4xkM6E5UDb6XIQq8CjWRHWwoOHtPJkhNyxnh0Lggy+h59fMfcF/AoASXy9 8/4n9rANshs4zDM3w+x+BGFnDOBIZZtECZM+rlKll5+4wVL/sZQIn/hA2KYJizsVF4AswtZrJMMR DOXJkqDCiTCYfcPW5ARUwDZZkCjWhU+moM41S4mGts6xAvFUjQcRic9RWJGOwmIYuIsJMwu5PYXm IaDILQ16tCzlGH0CZYXywmOOoqhOxiIPUqWEAGNMSQUGGHJ4WUFMmtBrAYGCwCgCzBWJMZgHLLC1 h4izlhAEwKondKi2sOpUJiLRYRLM2ouEF4KJUgW1gMwHMAwxLtPuMK8zDiYGKn4PwSIlonJWDDBE ccF3cTkO7O6HGdjl83SS80g9GdkkvSWC7TtPOET8wPEqAGbNM8PAR7zR7DRGYyJR/qZdxB9LBlNV +zNJKqBmPOnfBB1LSA6y2whaOJZDG7SHqOgeYGw9qYYcTUmEBUGPmh8HYEh9R6FjJfzGCBtJcZyh gZHEZUKABecGAvCDUwZYCSz+9hm6AA4milySBxFpDgCtSeWQx8GTN8xgmROowdbj4kg/UkH1IXAc Sp+xE0F/u2E5Sx1FDiq8V+9d8aZHIeYEzh0Xu6KG6MB4seaMTcQiJLs3vSxWvOE6TND7aoMWGzdY 0Dj8tZ8hWLupjE5mGLTS8kxYilQ8kl8iEkCmBWfbrSBqao0ejsetloAe2r9P6qQK+hYmSvdtUYa1 oAC+PRKIRNPDCekvlsIniyd4iphfBA2aaJ3bLtsFU6d55zu/sRVUjymHEoRXERaZlP6ncVU+bic+ uS5kkmBrdK1cocYnbQZvUaAHIWH0LF/PkNnQdLdY4mHMfBzcmF5GSysSQTYAO95SYakH2m9DzNnB hl8QfXqw7QLKF8V8WocN3SBkPRUKsesyc9aMr/z42rlKdC5mZLvgmCt/BA5FdWWhQ7/LpuLeRM5y RcbUb/8KSSDvNatDhj5goBgdgGBIt9VBkknQOWDkxzyQMy8W19VRB9sFQbdXAORxS9PrHABygmAf YAG9JL8ec9gMQUaq6al1wOi7pLO9S23a/r+VKrM2NXzkUhrlA+fi9gAMMMianNXxINIg0QKLR1+k ilRlQGFN1yLO0834NeogWZg9p17ixcEK9XMg8JRaXewQ+lucbUPp3IL0YxEBXzRX+u4LebqsWOPd MxmfOipv3hOC8gGDrEkuRgq07ocblKQzzMuAG8zg0UuNR+zNBfSKB2Qy6127NuwtEZDFG0aWmcNc gIrxUDm/SJsZQ0IA6SzbLwwEBZZgE2DGCzSsZMwMoPyTsPzOpRjym5AZpby1JLLoRVtZ010NKCmq wkXQQRLgj2nDSFqDG5FSE2F6UkEcPJhnpXGLxeBHJmfssuwkSOvjCpO8gSDFJLbG6+bq3wtytk44 k4JcMRjlHJJ+GoZWjjAVyYYLH0wLGCNAKqMWqbEy/Zc8DynlAznLsbPfaM6Ej3GMRoOOSdj2LSZa N2SedM3wsQcOk3AdfO9W2DhYl4+eIEktNeNxw9gZndKj2a8QfnNb2nvMOkD/i7kinChIZ8VEPoA= --Boundary_(ID_cMozjayTG+j4mbzseNKMBA)--