1. 27 Dec, 2005 2 commits
    • unknown's avatar
      Merge mysql.com:/space/pekka/ndb/version/my50 · 4ba38085
      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
      4ba38085
    • unknown's avatar
      ndb - wl#2972 (5.0) fix detached trigger opType + new pgm test_event_merge · b4d11507
      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
      b4d11507
  2. 26 Dec, 2005 15 commits
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.1 · ceb41693
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug5390
      
      
      ceb41693
    • unknown's avatar
      3862ee76
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.1 · 78ac54aa
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.1-bug5390
      
      
      sql/sql_parse.cc:
        Auto merged
      78ac54aa
    • unknown's avatar
      Fix for SQLCOM_BINLOG_BASE64_EVENT related code. · 5b35c715
      unknown authored
                                                 
      
      
      sql/sql_yacc.yy:
        Fix for SQLCOM_BINLOG_BASE64_EVENT related code.                                
        - added missing ';'                                                             
        - added binlog_base64_event
      5b35c715
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 059aaa8e
      unknown authored
      into  pylon.mylan:/home/psergey/mysql-5.1-26dec-merge
      
      
      059aaa8e
    • unknown's avatar
      Merge newbox:mysql-5.1-ppruning-r4 · eb333f9b
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-26dec-merge
      
      
      eb333f9b
    • unknown's avatar
      Merge newbox:mysql-5.1-ppruning-r4 · e6cf611f
      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
      e6cf611f
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0-bug5390 · 73f2a1b3
      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
      73f2a1b3
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-4.1-bug5390 · e049f2c8
      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
      e049f2c8
    • unknown's avatar
      ignore: · b9e67f43
      unknown authored
        added item_xmlfunc.cc
      
      
      BitKeeper/etc/ignore:
        added item_xmlfunc.cc
      b9e67f43
    • unknown's avatar
      .del-item_xmlfunc.cc~565ad32584ed96d4: · 6f8d81e9
      unknown authored
        Delete: libmysqld/item_xmlfunc.cc
      
      
      BitKeeper/deleted/.del-item_xmlfunc.cc~565ad32584ed96d4:
        Delete: libmysqld/item_xmlfunc.cc
      6f8d81e9
    • unknown's avatar
      add missing DROP TABLE [IF EXISTS] clauses · 01e1d1a0
      unknown authored
      01e1d1a0
    • unknown's avatar
      WL#2985 "Partition pruning": fixes to post-review fixes: when modifying SEL_TREE::keys, · b3abc977
      unknown authored
      adjust SEL_TREE::keys_map appropriately.
      
      
      b3abc977
    • unknown's avatar
      Fix typo bug in previous cset · 32ff7d99
      unknown authored
      32ff7d99
    • unknown's avatar
      WL#2985 "Partition Pruning": post-review fixes: · a4a1bb0e
      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)
      a4a1bb0e
  3. 25 Dec, 2005 3 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-new · 66f962d8
      unknown authored
      into  mysql.com:/home/my/mysql-5.1
      
      
      client/mysqlslap.c:
        Auto merged
      66f962d8
    • unknown's avatar
      Fixed compile errors (when compiling in debug mode) · c493d102
      unknown authored
      
      BitKeeper/etc/ignore:
        added storage/archive/archive_test
      c493d102
    • unknown's avatar
      New option to run multiple engines through the same test: · 4348dc67
      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.
      4348dc67
  4. 24 Dec, 2005 4 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · a6ef1dc3
      unknown authored
      into  zim.(none):/home/brian/mysql/cluster-5.1
      
      
      mysql-test/r/information_schema.result:
        Auto merged
      a6ef1dc3
    • unknown's avatar
      See message in mysqlslap.c, but basically · ac270838
      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
      ac270838
    • unknown's avatar
      Merge mysql.com:/home/dlenev/src/mysql-5.0-bg14836 · eff9369d
      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.
      eff9369d
    • unknown's avatar
      Just a few cleanup points in azio. Should solve Ubuntu compile problem. · 81ca1581
      unknown authored
      
      storage/archive/azio.c:
        Cleanup.
      storage/archive/azlib.h:
        Moved include lines about.
      81ca1581
  5. 23 Dec, 2005 5 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 64db2ba4
      unknown authored
      into  zim.(none):/home/brian/mysql/archive-5.1
      
      
      64db2ba4
    • unknown's avatar
      Fix for Antony's push. I've also changed from using the zlib off_t pointer... · 8ff68092
      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
      8ff68092
    • unknown's avatar
      storage/bdb/dist/s_all · 6a6e9a1f
      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.)
      6a6e9a1f
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 2c88b639
      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).
      2c88b639
    • unknown's avatar
      Update to add in support for AZIO. · 93b3d4ef
      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''
      93b3d4ef
  6. 22 Dec, 2005 11 commits
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 2f7d0416
      unknown authored
      into  zim.(none):/home/brian/mysql/cluster-5.1
      
      
      libmysqld/Makefile.am:
        Auto merged
      2f7d0416
    • unknown's avatar
      Merge mysql.com:/home/bkroot/mysql-5.1-new · b35aaa27
      unknown authored
      into  mysql.com:/home/bk/b15920-mysql-5.1-new
      
      
      b35aaa27
    • unknown's avatar
      WL#1012 Add to sql/Makefile.am include files forgotten in RBR push. · 90c221be
      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.
      90c221be
    • unknown's avatar
      BUG#5390 - problems with merge tables · 0040aff9
      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().
      0040aff9
    • unknown's avatar
    • unknown's avatar
      Bug#15920 (Temporary tables are not logged in binlog): · 449b679d
      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.
      449b679d
    • unknown's avatar
      WL#2985 "Partition Pruning" · f19fb870
      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 ..."
      f19fb870
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-new · 69221bba
      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
      69221bba
    • unknown's avatar
      This patch does the following: · 67c96c78
      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''
      67c96c78
    • unknown's avatar
      Fix compile problem in ha_example.cc · 973949d0
      unknown authored
      973949d0
    • unknown's avatar
      WL#1012 Missed option file · e2283810
      unknown authored
      
      mysql-test/t/binlog_row_innodb_stat-master.opt:
        missed option file
      e2283810