An error occurred fetching the project authors.
  1. 23 Jun, 2007 1 commit
    • unknown's avatar
      Fix for BUG#29318 "Statements prepared with PREPARE and with one · ba7e22db
      unknown authored
      parameter don't use query cache"
      Thanks to the fix of BUG#26842, statements prepared with SQL PREPARE
      and having parameters can now use the query cache.
      
      
      mysql-test/include/query_cache_sql_prepare.inc:
        now, statements prepared with SQL PREPARE use the query cache even
        when they have parameters.
      mysql-test/r/query_cache_ps_no_prot.result:
        updated result: we see caching happened.
      mysql-test/r/query_cache_ps_ps_prot.result:
        updated result: we see caching happened
      sql/sql_prepare.cc:
        query expansion does not insert user variables' references anymore,
        it now inserts parameters' values (BUG#26842's fix did this);
        so we can use the query cache.
      ba7e22db
  2. 24 May, 2007 1 commit
    • unknown's avatar
      This changeset belongs to the fix of Bug#735 Prepared Statements: there is no... · bcb1ff7f
      unknown authored
      This changeset belongs to the fix of Bug#735 Prepared Statements: there is no support for Query Cache
        
      - Create "--ps-protocol" and no "--<whatever>-protocol" variants of the former tests
        t/grant_cache.test and t/query_cache_sql_prepare.test.
      - Some additional subtest and fixes of bugs
      - Minor improvements 
      
      
      mysql-test/include/grant_cache.inc:
        - Rename mysql-test/t/grant_cache.test to include/grant_cache.inc
        - Toplevel scripts running variants of this test are
             t/grant_cache_ps_prot.test (runs only with "--ps-protocol")
             t/grant_cache_no_prot.test (skipped if any protocol is assigned)
        - Modifications to include/grant_cache.inc:
          - Minor improvements like replace --error <number> by --error <name>
          - enable that some subtests are run with "--ps-protocol"
      mysql-test/include/query_cache_sql_prepare.inc:
        - Rename t/query_cache_sql_prepare.test to include/query_cache_sql_prepare.inc
        - Toplevel scripts running variants of this test are
             query_cache_ps_ps_prot.test (skipped if other protocol than --ps-protocol is used.)
             query_cache_ps_no_prot.test (skipped if --<whatever>-protocol is used)   
        - Modifications to include/query_cache_sql_prepare.inc:
        - Minor improvements like add drop table
        - Add tests checking that 
          - another connection gets the same amount of QC hits
          - statements running via ps-protocol do not hit QC results of preceding sql EXECUTEs
      mysql-test/r/grant_cache_no_prot.result:
        Updated result
      mysql-test/r/query_cache_ps_no_prot.result:
        Updated result
      tests/mysql_client_test.c:
        - correct wrong sized "for" loop
        - add some missing tests of query cache hit numbers
      mysql-test/r/grant_cache_ps_prot.result:
        New BitKeeper file ``mysql-test/r/grant_cache_ps_prot.result''
      mysql-test/r/query_cache_ps_ps_prot.result:
        New BitKeeper file ``mysql-test/r/query_cache_ps_ps_prot.result''
      mysql-test/t/grant_cache_no_prot.test:
        Variant of the test grant_cache to be run without any "--<whatever>-protocol"
      mysql-test/t/grant_cache_ps_prot.test:
        Variant of the test grant_cache to be run with "--ps-protocol" only
      mysql-test/t/query_cache_ps_no_prot.test:
        Variant of the test query_cache_sql_prepare to be run without any "--<whatever>-protocol"
      mysql-test/t/query_cache_ps_ps_prot.test:
        Variant of the test query_cache_sql_prepare to be run with "--ps-protocol" only
      bcb1ff7f