1. 10 May, 2004 4 commits
    • unknown's avatar
      Merged ha_ndbcluster.cc · 321ba8ed
      unknown authored
      
      sql/ha_ndbcluster.h:
        Auto merged
      321ba8ed
    • unknown's avatar
      Use correct access method, found using sql-bench and comparing with other handler. · ba5e7d32
      unknown authored
      
      BitKeeper/deleted/.del-regression.sh~c19f771726612629:
        Delete: ndb/bin/regression.sh
      sql/ha_ndbcluster.cc:
        Change index flags, remove HA_WRONG_ASCII_ORDER and HA_ONLY_WHOLE_INDEX.
        HA_WRONG_ASCII_ORDER was used in field::optimize_range and if it was set, the index was hardly ever used.
        Correct check of start_key and start_key->flag != HA_READ_KEY_EXACT, ignore end-Key in suc a case
        Updated implementation o read_range_first
        Made the calculation of number of bytes par batch easier to underatsn and easier to configure. The value bytesperbatch can be made a config variable.
        AReduce the number of bytes sent per batch, don't overload.
        Increase the value returned from scan_time in order to make it clear to optimizer that scanning is the worst alternative. Always use index if available.
      ba5e7d32
    • unknown's avatar
      Updated ndb_basic · 60df153b
      unknown authored
      
      mysql-test/r/ndb_basic.result:
        Updated ndb_basic for better coverage
      mysql-test/t/ndb_basic.test:
        Updated ndb_basic for better coverage
      60df153b
    • unknown's avatar
      WL# 1728 Handler: use scanReadExclusive for scan update and delete · ecff23f3
      unknown authored
      
      
      sql/ha_ndbcluster.cc:
        Modified next_result to process fetched records cached in NdbApi before asking NDB for more. 
        It should also NoCommit any pending operations before contacting NDB again.
        Added utility function define_read_attrs to set the fields that should be read.
      sql/ha_ndbcluster.h:
        Add function define_read_attrs, used to set the fields to read
        Add get_nd_lock_type funciton ,to convert MySQL lock type to NDB lock type
        Always compile filtered scan function even if it's not used yet.
        Add variable ops_pending to keep track of "pending" update/delete operations.
      ecff23f3
  2. 07 May, 2004 4 commits
  3. 06 May, 2004 22 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · c62c4497
      unknown authored
      into mysql.com:/home/my/mysql-4.1
      
      
      libmysql/libmysql.c:
        Auto merged
      c62c4497
    • unknown's avatar
      Portability fixes · f3b3b2b1
      unknown authored
      Change strtoll -> my_strtoll10()
      Fixed bug in my_strntoul() and my_strntol() where we got different values on 32 and 64 bit systems (Bug #3472)
      
      
      configure.in:
        Fixed problem on IRIX64 (One can't have AC_MSG_RESULT on same row as AC_DEFINE
      extra/my_print_defaults.c:
        Fixed wrong definition for 'verbose'
      include/my_global.h:
        Portability fix (IRIX64)
      libmysql/client_settings.h:
        Remove compiler warnings
      libmysql/libmysql.c:
        Remove compiler warnings
      mysql-test/r/func_str.result:
        Updated results
      mysql-test/r/key_cache.result:
        Updated results to not depend on key_blocks_unused
      mysql-test/t/func_str.test:
        More test of long overflow
      mysql-test/t/key_cache.test:
        Updated results to not depend on key_blocks_unused
      sql/item.cc:
        Portability fix (don't use strtoll())
      sql/item.h:
        Portability fix (don't use strtoll())
      sql/item_sum.h:
        Portability fix (don't use strtoll())
      sql/item_timefunc.cc:
        Fixed compiler warning
      strings/ctype-simple.c:
        Fixed bug in my_strntoul() and my_strntol() where we got different values on 32 and 64 bit systems
      strings/ctype-ucs2.c:
        Fixed bug in my_strntoul() and my_strntol() where we got different values on 32 and 64 bit systems
      f3b3b2b1
    • unknown's avatar
      Merge miguel@bk-internal.mysql.com:/home/bk/mysql-4.1 · eac9345a
      unknown authored
      into hegel.local:/home/miguel/bk/mysql-4.1
      
      eac9345a
    • unknown's avatar
      Windows VC++ compiler compatibility · d4589044
      unknown authored
      
      sql/set_var.cc:
        VC++ error compiler compatibility
      d4589044
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · 51339f30
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-all_any-4.1
      
      51339f30
    • unknown's avatar
      postreview fixes · 9074fb2d
      unknown authored
      
      sql/sql_lex.h:
        description of field
      sql/sql_union.cc:
        layout fixed
      9074fb2d
    • unknown's avatar
      fake_select_lex should be prepared during PS preparation to work correctly · 1e17fb37
      unknown authored
      item_list for fake_select will be created only once
      (problem reported by valgrind in test_union2 fixed)
      
      
      sql/sql_lex.h:
        new function to keep code in one place
      sql/sql_union.cc:
        fake_select_lex should be prepared during PS preparation to work correctly
        item_list for fake_select will be created only once
      1e17fb37
    • unknown's avatar
      Merge mysql.com:/space/my/mysql-4.1 · cd7b3ca6
      unknown authored
      into mysql.com:/space/my/mysql-4.1-build
      
      cd7b3ca6
    • unknown's avatar
      - removed duplicate file ..\strings\strxnmov.c from the mysqlclient.dsp · ebf33d02
      unknown authored
         that was accidently added by the last BK auto merge
      
      
      VC++Files/client/mysqlclient.dsp:
         - removed duplicate file ..\strings\strxnmov.c that was added by the
           last auto merge
      ebf33d02
    • unknown's avatar
      mysql_stmt_reset now expects ok/error packet from server. · a18a5aa1
      unknown authored
      
      libmysql/libmysql.c:
        Make advanced_command check client reply
      sql/sql_prepare.cc:
        mysql_stmt_reset now sends ok/error reply to the client.
      tests/client_test.c:
        Memory leak fixed.
      a18a5aa1
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · b82bd045
      unknown authored
      into mysql.com:/home/pem/work/mysql-4.1
      
      b82bd045
    • unknown's avatar
      Fixed (portability) bug in handler.h, and tried to silence cast warnings on some platforms. · b220b976
      unknown authored
      
      sql/handler.h:
        Fixed (portability) bug. No qualified method names in the class definition.
      sql/item_cmpfunc.h:
        Attempt to silence cast warnings on some platforms.
      sql/item_subselect.h:
        Attempt to silence cast warnings on some platforms.
      sql/set_var.cc:
        Silence warning (missing cast).
      sql/spatial.h:
        Attempt to silence cast warnings on some platforms.
      sql/sql_cache.cc:
        Silence warning (wrong cast).
      sql/sql_lex.h:
        Attempt to silence cast warnings on some platforms.
      b220b976
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 0b4df46a
      unknown authored
      into mysql.com:/home/my/mysql-4.1
      
      0b4df46a
    • unknown's avatar
      - Windows compile fixes: added some missing files to the Windows Project · a66eb178
      unknown authored
         files, fixed linking of myisam_ftdump
      
      
      VC++Files/client/mysqlclient.dsp:
         - added strings/ctype.uca.c
      VC++Files/libmysql/libmysql.dsp:
         - added strings/ctype.uca.c
      VC++Files/myisam_ftdump/myisam_ftdump.dsp:
         - added zlib to the link line
      VC++Files/sql/mysqld.dsp:
         - added discover.cpp
      VC++Files/strings/strings.dsp:
         - added strings/ctype.uca.c
      a66eb178
    • unknown's avatar
      Windows VC++ compability fix · e7752b7b
      unknown authored
      
      sql/set_var.cc:
        Fix VC++ compiler error
      e7752b7b
    • unknown's avatar
      WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again). · 0bc9c4ae
      unknown authored
      HEAP: Copies the key count to a backup variable and sets the key count to zero.
      That way, no HEAP function will ever try to touch any index.
      Re-enabling is done by copying back the backup variable.
      To avoid memory leak at table close, disable deletes all index trees.
      Re-enabling must be done with empty indexes and data anyway. Otherwise,
      the indexes would need to be repaired, wich HEAP is not capable of.
      MyISAM: Only the key_map is cleared and set.
      Re-enabling must be done with empty indexes and data. Otherwise, repair needs
      to be done which will enable all keys persistently.
      The former implementation disabled only non-unique keys and maked this persistent.
      The new implementation additionally can disable all keys, but only without
      making this persistent. Re-enabling all keys can be done without repair,
      if data file and indexes are empty.
      
      
      heap/heapdef.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled hp_clear_keys() out of hp_clear().
      heap/hp_clear.c:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled hp_clear_keys() out of hp_clear().
        Added the new functions for disabling and enabling keys and to ask for the key state.
      include/heap.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added a new HP_SHARE element to save the key count while keys are disabled.
        Added declarations for the new functions.
      myisam/mi_open.c:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added the new functions for disabling and enabling keys and to ask for the key state.
      myisam/myisamdef.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the new functions.
      sql/ha_heap.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Pulled set_keys_for_scanning() out of open().
        Added the new functions for disabling and enabling keys and to ask for the key state.
      sql/ha_heap.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the new functions.
      sql/ha_myisam.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Extended disable_indexes() for all keys and no save.
        The argument is now 'mode' as it must handle different cases.
        Extended enable_indexes() for no save.
        The new feature needs the new argument 'mode' with the same semantics as in disable_indexes().
        Added indexes_are_disabled() to ask for the key state.
        Extended the existing call to enable_indexes() by the new argument.
      sql/ha_myisam.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Modified the declarations of dis-/enable_indexes() for the new argument.
        Added the declaration of the new function to ask for the key state.
      sql/handler.h:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Added declarations for the operation modes for the key switching functions.
        Modified the declarations of dis-/enable_indexes() for the new argument.
        Added the declaration of the new function to ask for the key state.
      sql/sql_select.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        In create_myisam_from_heap() take notice of disabled keys
        and disable them in the new table before copying the data.
      sql/sql_table.cc:
        WL#1687 - Optimize UNION DISTINCT ... UNION ALL (again).
        Modified the calls of dis-/enable_indexes() for the new argument.
      0bc9c4ae
    • unknown's avatar
      Merge with 4.0 to get security patch for check_grant_colum · 29b87b34
      unknown authored
      
      innobase/include/os0file.h:
        Auto merged
      innobase/os/os0file.c:
        Auto merged
      innobase/srv/srv0srv.c:
        Auto merged
      mysql-test/r/rpl_server_id2.result:
        Auto merged
      sql/ha_innodb.cc:
        Auto merged
      sql/slave.cc:
        Merge with 4.0
      29b87b34
    • unknown's avatar
      Few cleanups to client_test.c · a7828752
      unknown authored
      
      tests/client_test.c:
        Few cleanups
      a7828752
    • unknown's avatar
      Merge mysql.com:/home/my/mysql-3.23 into mysql.com:/home/my/mysql-4.0 · afb882c4
      unknown authored
      
      sql/sql_acl.cc:
        Auto merged
      afb882c4
    • unknown's avatar
      Remove not used variable · 4023b783
      unknown authored
      4023b783
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 97794e7e
      unknown authored
      into mysql.com:/home/my/mysql-4.1
      
      97794e7e
    • unknown's avatar
      Fixed wrong key usage which caused wrong result for some "WHERE... · 61f9715b
      unknown authored
      Fixed wrong key usage which caused wrong result for some "WHERE primary_key=constant" queries where MySQL could use 'only index' (Bug #3666)
      The bug was introduced in a patch in the 4.1.2 source tree.
      
      
      mysql-test/r/key.result:
        New result
      mysql-test/t/key.test:
        Added test case for bug in key read
      sql/sql_select.cc:
        Fixed wrong key usage which caused wrong result for some "WHERE primary_key=constant" queries where MySQL could use 'only index' (Bug #3666)
      61f9715b
  4. 05 May, 2004 10 commits
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1 · 999a3476
      unknown authored
      into mysql.com:/dbdata/psergey/mysql-4.1-code-cleanup
      
      
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      999a3476
    • unknown's avatar
      fixed test results · 0bd61842
      unknown authored
      0bd61842
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · 4a390920
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-ndb-4.1
      
      4a390920
    • unknown's avatar
      Replication: · 1dd916cd
      unknown authored
      as the I/O thread filters on the server id, we must test replicate_same_server_id in it (on top of in the SQL thread).
      
      
      mysql-test/r/rpl_server_id2.result:
        result update
      sql/slave.cc:
        As the I/O thread filters on the server id, we must test replicate_same_server_id in it (on top of in the SQL thread).
      1dd916cd
    • unknown's avatar
      Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.0 · 2ea8b3f9
      unknown authored
      into mysql.com:/home/mysql_src/mysql-4.0
      
      2ea8b3f9
    • unknown's avatar
      very minor changes: a STOP SLAVE in a replication test to get rid of a non... · 1c7b0723
      unknown authored
      very minor changes: a STOP SLAVE in a replication test to get rid of a non critical message in slave.err,
      and a comment update
      
      
      mysql-test/r/rpl_server_id2.result:
        result update
      mysql-test/t/rpl_server_id2.test:
        We stop the slave before cleaning up otherwise we'll get
        'drop table t1' executed twice, so an error in the slave.err
        (not critical).
      sql/slave.cc:
        update comment about 4.1 now that 4.1 is fixed (in a few minutes, exactly)
      1c7b0723
    • unknown's avatar
      merge · 4bef5548
      unknown authored
      
      mysql-test/r/subselect.result:
        Auto merged
      sql/sql_union.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      4bef5548
    • unknown's avatar
      After merge fixes · 2b67e49d
      unknown authored
      2b67e49d
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 751783c6
      unknown authored
      into mysql.com:/home/my/mysql-4.1
      
      
      sql/item_strfunc.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_union.cc:
        Auto merged
      751783c6
    • unknown's avatar
      after merge fixes · a18b96b1
      unknown authored
      
      client/mysqldump.c:
        Fixed problem with multiple tables (--skip-quote didn't work properly for second table)
      myisam/myisamchk.c:
        after merge fix
      a18b96b1