• unknown's avatar
    A lot of fixes for prepared statements (PS): · 853c2c78
    unknown authored
    New mysqltest that can run mysqltest with PS
    Added support for ZEROFILL in PS
    Fixed crash when one called mysql_stmt_store_result() without a preceding mysql_stmt_bind_result()
    Updated test cases to support --ps-protocol
    (Some tests are still run using old protocol)
    Fixed crash in PS when using SELECT * FROM t1 NATURAL JOIN t2...
    Fixed crash in PS when using sub queries
    Create table didn't signal when table was created. This could cause a "DROP TABLE created_table" in another thread to wait "forever"
    Fixed wrong permissions check in PS and multi-table updates (one could get permission denied for legal quries)
    Fix for PS and SELECT ... PROCEDURE
    Reset all warnings when executing a new PS query
    group_concat(...ORDER BY) didn't work with PS
    Fixed problem with test suite when not using innodb
    
    
    BitKeeper/deleted/.del-innodb-lock-master.opt~f76a4a1999728f87:
      Delete: mysql-test/t/innodb-lock-master.opt
    client/Makefile.am:
      mysqltest now uses regex
    client/mysqltest.c:
      Added support for testing of prepared statements (with --ps-protocol)
      Main code was done by Kent, I did mainly some cleanups and minor bug fixes
      New test commands:
      --disable_ps_protocol
      --enable_ps_protocol
      NOTE: new code still has some things that needs to be cleaned up.
      For example run_query_stmt_handle_error() should be made more general so that same code can be used also by 'normal' queries
    configure.in:
      mysqltest now uses regex
    libmysql/libmysql.c:
      Reset warning_count after prepare (safety). In the future we should also provide warnings on prepare
      integer -> string conversion now handles ZEROFILL
      double -> string conversion is now closer to the one in the server
      Fixed crash when one called mysql_stmt_store_result() without preceding mysql_stmt_bind_result()
    libmysqld/examples/Makefile.am:
      mysqltest now uses regex
    mysql-test/include/have_query_cache.inc:
      Fixes for --ps-protocol
    mysql-test/include/ps_conv.inc:
      Fixes for --ps-protocol
    mysql-test/mysql-test-run.sh:
      Added options --ps-protocol
    mysql-test/r/ctype_utf8.result:
      Fixed test case
    mysql-test/r/fulltext_cache.result:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/r/fulltext_left_join.result:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/r/fulltext_multi.result:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/r/innodb-lock.result:
      Fixed test to work even if Innodb is not compiled in.
    mysql-test/t/create.test:
      Fixes for --ps-protocol
    mysql-test/t/ctype_utf8.test:
      Remove warnings
    mysql-test/t/date_formats.test:
      Fixes for --ps-protocol
    mysql-test/t/fulltext_cache.test:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/t/fulltext_left_join.test:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/t/fulltext_multi.test:
      Changed output of MATCH to use round() to get same numbers with --ps-protocol
    mysql-test/t/func_group.test:
      Fixes for --ps-protocol
    mysql-test/t/func_sapdb.test:
      Fixes for --ps-protocol
    mysql-test/t/innodb-lock.test:
      Fixed test to work even if Innodb is not compiled in.
    mysql-test/t/insert.test:
      Fixes for --ps-protocol
    mysql-test/t/insert_select.test:
      Fixes for --ps-protocol
    mysql-test/t/insert_update.test:
      Fixes for --ps-protocol
    mysql-test/t/metadata.test:
      Fixes for --ps-protocol
    mysql-test/t/multi_statement.test:
      Fixes for --ps-protocol
    mysql-test/t/ps_1general.test:
      Fixes for --ps-protocol
    mysql-test/t/rollback.test:
      Fixes for --ps-protocol
    mysql-test/t/rpl_redirect.test:
      Fixes for --ps-protocol
    mysql-test/t/rpl_user_variables.test:
      Fixes for --ps-protocol
    mysql-test/t/select.test:
      Fixes for --ps-protocol
    mysql-test/t/status.test:
      Fixes for --ps-protocol
    mysql-test/t/type_blob.test:
      Fixes for --ps-protocol
    mysql-test/t/type_float.test:
      Fixes for --ps-protocol
    mysql-test/t/union.test:
      Fixes for --ps-protocol
    mysql-test/t/warnings.test:
      Fixes for --ps-protocol
    mysys/my_alloc.c:
      More debugging information
    sql-common/client.c:
      More debugging information
    sql-common/my_time.c:
      TIME didn't support full range with PS
    sql/field.cc:
      TIME didn't support full range with PS
    sql/item_cmpfunc.cc:
      IN(constants,...) didn't work with PS
    sql/item_subselect.cc:
      Some subqueries didn't work with PS
    sql/item_sum.cc:
      group_concat(...ORDER BY) didn't work with PS
      Removed variable warning_available as 'warning' can be used for this.
    sql/item_sum.h:
      Removed not needed variable
    sql/protocol.cc:
      TIME didn't support full range with PS
    sql/set_var.cc:
      Style fix
    sql/sql_base.cc:
      setup_wild() didn't properly restore old arena, which caused core dump in PS when using
      SELECT * FROM t1 NATURAL JOIN t2...
    sql/sql_class.cc:
      Style fix
    sql/sql_error.cc:
      Style fix
    sql/sql_insert.cc:
      Create table didn't signal when table was created. This could cause a "DROP TABLE created_table" in another thread to wait "forever"
    sql/sql_lex.h:
      Fix for PS and procedures
    sql/sql_parse.cc:
      More debugging information
      Make a copy of 'db' in PS as this may change
      Fixed wrong permissions check in PS and multi-table updates
    sql/sql_prepare.cc:
      Fix for PS and SELECT ... PROCEDURE
      Reset all warnings when executing a new query
    sql/sql_union.cc:
      Fixes for PS and SELECT ... PROCEDURE
      Reset 'with_wild' as 'wild' is resolved on prepare
    853c2c78
func_group.test 14.6 KB