1. 27 Dec, 2005 3 commits
    • unknown's avatar
      ndb - post merge fix · db832532
      unknown authored
      
      storage/ndb/test/ndbapi/test_event_merge.cpp:
        Rename: ndb/test/ndbapi/test_event_merge.cpp -> storage/ndb/test/ndbapi/test_event_merge.cpp
      storage/ndb/test/ndbapi/Makefile.am:
        post-merge fix
      db832532
    • unknown's avatar
      Merge mysql.com:/space/pekka/ndb/version/my50 · 69822c49
      unknown authored
      into  mysql.com:/space/pekka/ndb/version/my51
      
      
      storage/ndb/src/kernel/blocks/dbtup/DbtupCommit.cpp:
        merge-ul
      storage/ndb/src/ndbapi/NdbEventOperationImpl.cpp:
        merge-ul
      storage/ndb/test/ndbapi/Makefile.am:
        merge-ul
      69822c49
    • unknown's avatar
      ndb - wl#2972 (5.0) fix detached trigger opType + new pgm test_event_merge · 5e6d7795
      unknown authored
      
      ndb/src/ndbapi/NdbEventOperationImpl.cpp:
        error code 4709 was set outside if()
      ndb/src/kernel/blocks/dbtup/DbtupCommit.cpp:
        fix opType for detached triggers (accidental miss since v21x?)
      ndb/test/ndbapi/Makefile.am:
        test_event_merge v5.0
      ndb/test/ndbapi/test_event_merge.cpp:
        test_event_merge v5.0
      5e6d7795
  2. 26 Dec, 2005 15 commits
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.1 · bedd6350
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug5390
      
      bedd6350
    • unknown's avatar
      8ca9cd6d
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.1 · c1afc407
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug5390
      
      
      sql/sql_parse.cc:
        Auto merged
      c1afc407
    • unknown's avatar
      Fix for SQLCOM_BINLOG_BASE64_EVENT related code. · e2e653dd
      unknown authored
                                                 
      
      
      sql/sql_yacc.yy:
        Fix for SQLCOM_BINLOG_BASE64_EVENT related code.                                
        - added missing ';'                                                             
        - added binlog_base64_event
      e2e653dd
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 28017c32
      unknown authored
      into  pylon.mylan:/home/psergey/mysql-5.1-26dec-merge
      
      28017c32
    • unknown's avatar
      Merge newbox:mysql-5.1-ppruning-r4 · 670012af
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-26dec-merge
      
      670012af
    • unknown's avatar
      Merge newbox:mysql-5.1-ppruning-r4 · 0b8768f2
      unknown authored
      into  pylon.mylan:/home/psergey/mysql-5.1-26dec-merge
      
      
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/ha_partition.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      sql/sql_partition.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/table.h:
        Auto merged
      sql/handler.h:
        Merge
      0b8768f2
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0-bug5390 · 1b8a4a24
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug5390
      
      
      BitKeeper/deleted/.del-ha_blackhole.cc~727c69ef7846623a:
        Auto merged
      mysql-test/t/create.test:
        Auto merged
      mysql-test/r/create.result:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      mysql-test/r/merge.result:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      mysql-test/t/merge.test:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/lock.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/mysql_priv.h:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_base.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_delete.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_insert.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_load.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_parse.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      sql/sql_update.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.1
      1b8a4a24
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-4.1-bug5390 · 52cf747f
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug5390
      
      
      BitKeeper/deleted/.del-ha_blackhole.cc~727c69ef7846623a:
        Auto merged
      mysql-test/r/create.result:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      mysql-test/r/merge.result:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      mysql-test/t/create.test:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      mysql-test/t/merge.test:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      sql/lock.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      sql/mysql_priv.h:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      sql/sql_parse.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      sql/sql_update.cc:
        BUG#5390 - problems with merge tables
        Manual merge: ul - use local changes made for 5.0
      52cf747f
    • unknown's avatar
      ignore: · 1ef4985d
      unknown authored
        added item_xmlfunc.cc
      
      
      BitKeeper/etc/ignore:
        added item_xmlfunc.cc
      1ef4985d
    • unknown's avatar
      .del-item_xmlfunc.cc~565ad32584ed96d4: · a2296255
      unknown authored
        Delete: libmysqld/item_xmlfunc.cc
      
      
      BitKeeper/deleted/.del-item_xmlfunc.cc~565ad32584ed96d4:
        Delete: libmysqld/item_xmlfunc.cc
      a2296255
    • unknown's avatar
      add missing DROP TABLE [IF EXISTS] clauses · a7c1e3f6
      unknown authored
      a7c1e3f6
    • unknown's avatar
      WL#2985 "Partition pruning": fixes to post-review fixes: when modifying SEL_TREE::keys, · fb796ece
      unknown authored
      adjust SEL_TREE::keys_map appropriately.
      
      fb796ece
    • unknown's avatar
      Fix typo bug in previous cset · 8c0712b9
      unknown authored
      8c0712b9
    • unknown's avatar
      WL#2985 "Partition Pruning": post-review fixes: · 8a32a4b7
      unknown authored
      - Added more comments.
      - Added a RANGE_OPT_PARAM::remove_jump_scans flag that disables construction of index_merge
        SEL_TREEs that represent unusable conditions like "key1part1<c1 OR key2part2<c2"
      - make prune_partitions() function handle the case where range analysis produces a list of 
        index_merge trees (it turned out that this is possible, appropriate test case added).
      - Other small fixes.
      
      
      mysql-test/r/partition_pruning.result:
        WL#2985 "Partition Pruning": post-review fixes: more test cases
      mysql-test/t/partition_pruning.test:
        WL#2985 "Partition Pruning": post-review fixes: more test cases
      sql/opt_range.cc:
        WL#2985 "Partition Pruning": post-review fixes:
        - Added more comments.
        - Fix the debug printouts
        - Added a RANGE_OPT_PARAM::remove_jump_scans flag that disables construction of index_merge
          SEL_TREEs that represent unusable conditions like "key1part1<c1 OR key2part2<c2"
        - make prune_partitions() function handle the case where range analysis produces a list of 
          index_merge trees (it turned out that this is possible, appropriate test case added).
      sql/sql_partition.cc:
        WL#2985 "Partition Pruning": post-review fixes: make requested edits in comments.
      sql/table.h:
        WL#2985 "Partition Pruning": post-review fixes: added bool TABLE::no_partitions_used
        (this change was missed when making the original cset)
      8a32a4b7
  3. 25 Dec, 2005 3 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-new · 22dbc2b7
      unknown authored
      into  mysql.com:/home/my/mysql-5.1
      
      
      client/mysqlslap.c:
        Auto merged
      22dbc2b7
    • unknown's avatar
      Fixed compile errors (when compiling in debug mode) · 9fb3ee86
      unknown authored
      
      BitKeeper/etc/ignore:
        added storage/archive/archive_test
      9fb3ee86
    • unknown's avatar
      New option to run multiple engines through the same test: · 18c99584
      unknown authored
      --engine="myisam,archive"
      
      --number-of-rows has been removed for the time being and replaced with
       option to allow you to just repeat multiple time all of the inserts you specifed with data. When number-of-rows-returns it will be instead used for averaging rows while growing concurrency. 
      
      Returned stats now has accurent row and query counts since it includes a multiple for the rows and queries added.
      
      Parser is now a touch smarter and understands end of file issues if you have a delimiter at the end of the file.  
      
      
      client/client_priv.h:
        New options
      client/mysqlslap.c:
        Modifications for doing repeated tests.
      mysql-test/r/mysqlslap.result:
        New result file
      mysql-test/t/mysqlslap.test:
        Changes in tests to make sure concurrency failures would not occur.
      18c99584
  4. 24 Dec, 2005 4 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 6c035508
      unknown authored
      into  zim.(none):/home/brian/mysql/cluster-5.1
      
      
      mysql-test/r/information_schema.result:
        Auto merged
      6c035508
    • unknown's avatar
      See message in mysqlslap.c, but basically · ef0fff43
      unknown authored
      1) Parsing now works
      2) Options are safer, aka it doesn't kill the machine and it cleans up after itself
      3) Option of --only-print added so that you can see what it does.
      4) Tiny cleanup of the auto generate sql. A lot more needs to be done with this, for it to be very valuable. I suspect it doesn't work all that well.
      5) Delimeter is now a single character. No good escaping going on.
      6) You can now change which schema it is runninng against.
      
      Now I think I can go make use of it! 
      
      Though I need to add support for a "only run this many inserts, divide by the number of clients connecting, to really test scaling"
      
      
      
      client/client_priv.h:
        Added new options for mysqlslap
      client/mysqlslap.c:
        Lots of cleanup.
        
        Highlights:
        1) Parsing now works much better, though I suspect escaping issues still exist. All strings are parsed into a typedef called statement. This is a linked structure with each statement held in it. I added options for length so that when the time comes to fix this for binary data the guts of the main executing loop will not need to be changed
        2) Cleaned up options so that it will not destroy data by default and will clean up itself by default. So no leaving around of gobs of data.
        3) Added option of --only-print to see the SQL it would have executed
        4) Parsing handles whitespace trick (which will come back to bite someone I expect)
        5) Delimeter is now a single character
        6) All memory allocated should now be freed.
        7) Set defaults so that only a single run will occur if none are given.
        8) You can now change the schema that it runs against.
      mysql-test/r/information_schema.result:
        Fix for Antony's merge
      mysql-test/r/mysqlslap.result:
        New result set
        More testing
      mysql-test/t/mysqlslap.test:
        More testing
      ef0fff43
    • unknown's avatar
      Merge mysql.com:/home/dlenev/src/mysql-5.0-bg14836 · 8dfd0c3f
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.1-merges
      
      
      mysql-test/r/view.result:
        Auto merged
      mysql-test/t/view.test:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/share/errmsg.txt:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      storage/ndb/src/kernel/blocks/backup/Backup.cpp:
        Auto merged
      storage/ndb/src/kernel/blocks/dbdih/DbdihMain.cpp:
        Auto merged
      storage/ndb/src/kernel/blocks/dblqh/DblqhMain.cpp:
        Auto merged
      storage/ndb/tools/ndb_size.pl:
        Auto merged
      mysql-test/r/information_schema.result:
        Manual merge.
      mysql-test/t/information_schema.test:
        Manual merge.
      sql/sql_trigger.cc:
        Manual merge.
      8dfd0c3f
    • unknown's avatar
      Just a few cleanup points in azio. Should solve Ubuntu compile problem. · c618b8fa
      unknown authored
      
      storage/archive/azio.c:
        Cleanup.
      storage/archive/azlib.h:
        Moved include lines about.
      c618b8fa
  5. 23 Dec, 2005 5 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 2f35e785
      unknown authored
      into  zim.(none):/home/brian/mysql/archive-5.1
      
      2f35e785
    • unknown's avatar
      Fix for Antony's push. I've also changed from using the zlib off_t pointer... · 9ddd1db0
      unknown authored
      Fix for Antony's push. I've also changed from using the zlib off_t pointer type to my_off_t to fix issues around buggy zlib versions and to make sure file sizes are consistent through out mysql.
      
      
      
      mysql-test/r/information_schema.result:
        Fix for Antony adding plugins to information schema.
      sql/ha_archive.cc:
        Fix for now using my_off_t, no need to worry about buggy zlib's anymore.
      sql/ha_archive.h:
        Update to fix issues with buggy zlib.
      storage/archive/azio.c:
        Moved to using my_off_t (which should fix problems with most fille system size issues).
      storage/archive/azlib.h:
        Change to using my_off_t
      9ddd1db0
    • unknown's avatar
      storage/bdb/dist/s_all · fd363aa5
      unknown authored
      When not generating 'tags' file, also don't generate symlinks to it (or make dist will fail/behave wierdly).
      (origin:   1.1985 05/12/22 23:31:15 knielsen@mysql.com +1 -0)
      
      
      storage/bdb/dist/s_all:
        When not generating 'tags' file, also don't generate symlinks to it (or make dist will fail/behave wierdly).
        (Copy of a change done by Kristian Nielsen, to test it.)
      fd363aa5
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 169805ea
      unknown authored
      into  zim.(none):/home/brian/mysql/archive-5.1
      
      
      configure.in:
        Auto merged
      libmysqld/Makefile.am:
        Auto merged
      sql/Makefile.am:
        Auto merged
      sql/ha_archive.cc:
        Auto merged
      storage/Makefile.am:
        Hand merge of the Makefile.am changes (I assume Antony pushed loadable).
      169805ea
    • unknown's avatar
      Update to add in support for AZIO. · f5cbebba
      unknown authored
      AZIO differs in that it uses mysys methods and removes all of the malloc calls. 
      
      
      configure.in:
        Update for new archive directory
      libmysqld/Makefile.am:
        Adding archive storage directory.
      sql/Makefile.am:
        Adding archive library.
      sql/ha_archive.cc:
        Update for ha_archive to use azio.
      sql/ha_archive.h:
        Updates to support azio.
      storage/Makefile.am:
        Added archive directory.
      storage/archive/Makefile.am:
        New BitKeeper file ``storage/archive/Makefile.am''
      storage/archive/archive_test.c:
        New BitKeeper file ``storage/archive/archive_test.c''
      storage/archive/azio.c:
        New BitKeeper file ``storage/archive/azio.c''
      storage/archive/azlib.h:
        New BitKeeper file ``storage/archive/azlib.h''
      f5cbebba
  6. 22 Dec, 2005 10 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 9e9f8336
      unknown authored
      into  zim.(none):/home/brian/mysql/cluster-5.1
      
      
      libmysqld/Makefile.am:
        Auto merged
      9e9f8336
    • unknown's avatar
      Merge mysql.com:/home/bkroot/mysql-5.1-new · ea5f36aa
      unknown authored
      into  mysql.com:/home/bk/b15920-mysql-5.1-new
      
      ea5f36aa
    • unknown's avatar
      WL#1012 Add to sql/Makefile.am include files forgotten in RBR push. · 59b6b002
      unknown authored
      Remove errorneously committed ChangeLog file.
      
      
      BitKeeper/deleted/.del-ChangeLog~408d3fd6ba89dd59:
        Delete: ChangeLog
      sql/Makefile.am:
        Add missing include files forgotten in RBR push.
      59b6b002
    • unknown's avatar
      BUG#5390 - problems with merge tables · 2be428bf
      unknown authored
      Problem #1: INSERT...SELECT, Version for 5.1.
      Extended the unique table check by a check of lock data.
      Merge sub-tables cannot be detected by doing name checks only.
      
      
      mysql-test/r/create.result:
        BUG#5390 - problems with merge tables
        Removed a duplicate test.
      mysql-test/r/merge.result:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT
        Added test results.
      mysql-test/t/create.test:
        BUG#5390 - problems with merge tables
        Removed a duplicate test.
      mysql-test/t/merge.test:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT
        Added tests.
      sql/lock.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added a new function to find a duplicate lock in a list of tables.
      sql/mysql_priv.h:
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
        Added a declaration for the new function.
      sql/sql_base.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
        Added a call to the new mysql_lock_have_duplicate(),
        which needs the thread handle, to unique_table().
      sql/sql_delete.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
      sql/sql_insert.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
      sql/sql_load.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
      sql/sql_parse.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
      sql/sql_update.cc:
        BUG#5390 - problems with merge tables
        Problem #1: INSERT...SELECT, Version for 5.1.
        Added the thread handle to unique_table().
        Replaced a call to find_table_in_local_list() by
        the newly extended unique_table().
      2be428bf
    • unknown's avatar
    • unknown's avatar
      Bug#15920 (Temporary tables are not logged in binlog): · 1d3d6ff5
      unknown authored
        Fixing faulty tests preventing some CREATE TEMPORARY TABLE statements
        from being binlogged under statement-based replication.
      
      
      mysql-test/t/disabled.def:
        Enabling rpl000002 test.
      sql/sql_table.cc:
        Changed faulty tests so that creation of temporary tables are always done
        when statement-based logging is used.
      1d3d6ff5
    • unknown's avatar
      WL#2985 "Partition Pruning" · c4ef5317
      unknown authored
      
      sql/ha_ndbcluster.cc:
        WL#2985 "Partition Pruning": added part_info->used_partitions initialization
      sql/ha_partition.cc:
        WL#2985 "Partition Pruning": added part_info->used_partitions initialization
      sql/handler.h:
        WL#2985 "Partition Pruning": 
        Added function prototypes
        in partition_info:
         - Added 'used_partitions' bitmap
         - Added comments
      sql/item.h:
        WL#2985 "Partition Pruning": 
        - added enum monotonicity_info
        - added virtual Item::get_monotonicity_info()
      sql/item_timefunc.cc:
        WL#2985 "Partition Pruning": 
        - added Item_func_to_days::get_monotonicity_info()
        - added Item_func_year::get_monotonicity_info()
      sql/item_timefunc.h:
        WL#2985 "Partition Pruning": 
        - added Item_func_to_days::get_monotonicity_info()
        - added Item_func_year::get_monotonicity_info()
      sql/opt_range.cc:
        WL#2985 "Partition Pruning":
        - Split out PARAM structure into PARAM and RANGE_OPT_PARAM part.
        - Added partition pruning module code.
      sql/opt_range.h:
        WL#2985 "Partition Pruning": 
        Added prune_partitions() function declaration. This is the entry point for partition pruning 
        module
      sql/sql_class.cc:
        WL#2985 "Partition Pruning": added support for "EXPLAIN PARTITIONS SELECT ..."
      sql/sql_lex.h:
        WL#2985 "Partition Pruning": added support for "EXPLAIN PARTITIONS SELECT ..."
      sql/sql_partition.cc:
        WL#2985 "Partition Pruning": 
         - Added get_list_array_idx_for_endpoint and get_range_... functions to support partition 
           pruning on "partition_field < const"-like intervals.
         - Added partition_info::used_partitions bitmap.
         - Added make_used_partitions_str function
         - Fixed BUG#15819
      sql/sql_select.cc:
        WL#2985 "Partition Pruning": 
        - Added prune_partitions() invocation right before the range analysis
        - Added code to handle return value from prune_partitions()
        - Added support for "EXPLAIN PARTITIONS SELECT ..."
      sql/sql_yacc.yy:
        #2985 "Partition Pruning": added support for "EXPLAIN PARTITIONS SELECT ..."
      c4ef5317
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · a3b0527f
      unknown authored
      into  zim.(none):/home/brian/mysql/cluster-5.1
      
      
      mysql-test/r/information_schema.result:
        Auto merged
      mysql-test/r/information_schema_db.result:
        Auto merged
      sql/ha_partition.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/table.h:
        Auto merged
      a3b0527f
    • unknown's avatar
      This patch does the following: · 64b8d8aa
      unknown authored
      1) Fixes breakage in embedded server build for XMLPath push.
      2) Hides PARTITION engine from view.
      3) Add ENGINES information schema (and it should now be clear from this patch on how to turn any show command into an information schema).
      
      
      libmysqld/Makefile.am:
        Fix for embedded server to build.
      mysql-test/r/information_schema.result:
        Fix for additional information_schema
      mysql-test/r/information_schema_db.result:
        Fix for adding additional engines information schema.
      mysql-test/t/information_schema.test:
        Added test to make sure that engines information schema works.
      sql/ha_partition.cc:
        Made PARTITION hidden in information schema.
      sql/sql_parse.cc:
        Added additional case for engine information schema.
      sql/sql_show.cc:
        Code for ENGINES information schema.
      sql/sql_yacc.yy:
        Extended grammer to support new ENGINES information schema
      sql/table.h:
        Comment on dependency in information schema.
      libmysqld/item_xmlfunc.cc:
        New BitKeeper file ``libmysqld/item_xmlfunc.cc''
      64b8d8aa
    • unknown's avatar
      Fix compile problem in ha_example.cc · 1aa1da0b
      unknown authored
      1aa1da0b