• Konstantin Osipov's avatar
    Backport of: · e2400f18
    Konstantin Osipov authored
    ----------------------------------------------------------
    revno: 2630.2.6
    committer: Konstantin Osipov <konstantin@mysql.com>
    branch nick: mysql-6.0-27430
    timestamp: Mon 2008-05-26 16:12:28 +0400
    message:
      Cover four special cases of WL#4166 with tests:
      - when the query cache is disabled at the time of prepared statement
      reprepare
      - when long data parameters are used
      - when character_set_connection != character_set_client, and a parameter
      conversion takes place
      - when parameter data is out of acceptable range, e.g. year 10000 is
      supplied as part of MYSQL_TYPE_DATETIME value. The server is supposed
      to warn in such case.
    
    mysql-test/include/query_cache_sql_prepare.inc:
      Addditional test for Bug#27430
    mysql-test/r/query_cache_ps_no_prot.result:
      Update result file.
    mysql-test/r/query_cache_ps_ps_prot.result:
      Update result file.
    tests/mysql_client_test.c:
      Add more tests (Bug#27430 and WL#4166).
      Fix test_datetime_range() test to correctly assert for the number
      of warnings. Additionally, print these warnings out.
    e2400f18
query_cache_sql_prepare.inc 14.1 KB