An error occurred fetching the project authors.
  1. 19 Aug, 2005 1 commit
    • unknown's avatar
      updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication). · f4186eae
      unknown authored
      We binlog the DROP TABLE for each table that was actually dropped. Per Sergei's 
      suggestion a fixed buffer for the DROP TABLE query is pre-allocated from THD pool, and 
      logging now is done in batches - new batch is started if the buffer becomes full.
      Reduced memory usage by reusing the table list instead of accumulating a list of 
      dropped table names. Also fixed the problem if the table was not actually dropped, eg
      due to permissions. Extended the test case to make sure batched query 
      logging does work.  
      
      
      mysql-test/r/rpl_drop_db.result:
        test for query buffer overrun
      mysql-test/t/rpl_drop_db.test:
        test for query buffer overrun
      sql/mysql_priv.h:
        updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication)
      BitKeeper/etc/ignore:
        Added support-files/MacOSX/postflight support-files/MacOSX/preflight to the ignore list
      sql/sql_db.cc:
        updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication)
      sql/sql_table.cc:
        updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication)
      sql/table.h:
        updated patch for BUG#4680 (incomplete DROP DATABASE breaking replication)
      f4186eae
  2. 22 Apr, 2005 1 commit
  3. 19 Apr, 2005 1 commit
    • unknown's avatar
      Bug#7806 - insert on duplicate key and auto-update of timestamp · 670eae79
      unknown authored
      Modified the check for the timestamp field so that the flags for
      the automatic for inserts and updates are cleared independently.
      
      
      mysql-test/r/type_timestamp.result:
        Bug#7806 - insert on duplicate key and auto-update of timestamp
        The test result.
      mysql-test/t/type_timestamp.test:
        Bug#7806 - insert on duplicate key and auto-update of timestamp
        The test case.
      sql/mysql_priv.h:
        Bug#7806 - insert on duplicate key and auto-update of timestamp
        Made check_insert_fields() static. It is used only in sql_insert.cc.
      sql/sql_insert.cc:
        Bug#7806 - insert on duplicate key and auto-update of timestamp
        Modified the check of the insert fields so that an explicit
        assignment of the timestamp field does only disable the automatic
        for inserts and retains the automatic for updates.
        Added a check if the update fields contain the timestamp field.
        In this case, the automatic on update is disabled, but not the
        automatic on insert. This is called from mysql_prepare_insert().
      sql/table.h:
        Bug#7806 - insert on duplicate key and auto-update of timestamp
        Extended a comment to warn about usage of enum timestamp_auto_set_type.
      670eae79
  4. 30 Mar, 2005 1 commit
    • unknown's avatar
      Fix for BUG#9213: GROUP BY returns wrong query results: · 6a11e33d
      unknown authored
      Make test_if_skip_sort_order() rebuild tab->ref if it decides to use an index
      different from the index join optimizer has choosen.  
      
      
      mysql-test/r/group_by.result:
        Testcase for BUG#9213
      mysql-test/t/group_by.test:
        Testcase for BUG#9213
      sql/table.h:
        Added comments about TABLE::used_keys
      6a11e33d
  5. 11 Dec, 2004 1 commit
    • unknown's avatar
      Fix for BUG#5837 - attempt 3. · 4ca0670d
      unknown authored
        Call mark_as_null_row in join_read_const and join_read_system.
      
      
      mysql-test/r/multi_update.result:
        Testcase for BUG#5837
      mysql-test/t/multi_update.test:
        Testcase for BUG#5837
      sql/table.h:
        Added comments
      4ca0670d
  6. 22 Oct, 2004 1 commit
    • unknown's avatar
      A fix and test case for Bug#6050 "EXECUTE stmt reports ambiguous field · f306f414
      unknown authored
      names with ident. tables fr. diff. schemata": revise all uses of
      Item_field and make them prepared-statements friendly when necessary.
      
      
      mysql-test/r/ps.result:
        Test results fixed: the test case for Bug#6050
      mysql-test/r/ps_1general.result:
        Test results fixed: in prepared statements we expand '*' to a list
        of fully qualified fields (db.table.column).
      mysql-test/t/ps.test:
        A test for Bug#6050 "EXECUTE stmt reports ambiguous fieldnames with 
        ident. tables fr. diff. schemata"
      sql/item.cc:
        Revise all Item_field constructors: we need to make sure that no Item_field
        object points to unaccessible memory in prepared statements.
      sql/item.h:
        Revise all Item_field constructors: we need to make sure that no Item_field
        object points to unaccessible memory in prepared statements.
      sql/sql_base.cc:
        Item_field use changed to be prepared statements friendly.
      sql/sql_class.h:
        New check of Item_arena state.
      sql/sql_union.cc:
        Fixing the problem with name resolving in UNION and prepared statements:
        In case of SELECT a, b, c FROM t1 UNION SELECT a, b, c FROM t2 the list of
        selected items is represented as a List<Item_field>, where each 
        Item_field points to a field of temporary table.
        But the temporary table is created anew on each execution of the prepared 
        statement. So on each subsequent execution we should reset Item_field
        items to point to fields from freshly-created temporary table.
      sql/table.h:
        Comment TABLE member.
      f306f414
  7. 01 Oct, 2004 1 commit
    • unknown's avatar
      Support for TIMESTAMP columns holding NULL values. Unlike all other · c2a25521
      unknown authored
      column types TIMESTAMP is NOT NULL by default, so in order to have 
      TIMESTAMP column holding NULL valaues you have to specify NULL as
      one of its attributes (this needed for backward compatibility).
      
      Main changes:
      Replaced TABLE::timestamp_default_now/on_update_now members with
      TABLE::timestamp_auto_set_type flag which is used everywhere
      for determining if we should auto-set value of TIMESTAMP field 
      during this operation or not. We are also use Field_timestamp::set_time()
      instead of handler::update_timestamp() in handlers.
      
      
      mysql-test/r/type_timestamp.result:
        Added test for TIMESTAMP columns which are able to store NULL values.
      mysql-test/t/type_timestamp.test:
        Added test for TIMESTAMP columns which are able to store NULL values.
      sql/field.cc:
        Added support for TIMESTAMP fields holding NULL values.
        We don't need Field_timestamp::set_timestamp_offsets() anymore.
        Instead we need Field_timestamp::get_auto_set_type() function
        which will convert TIMESTAMP auto-set type stored in Field in 
        unireg_check to value from timestamp_auto_set_type_enum.
        (We can't replace this function with additional Field_timestamp member
        and some code in constructor because then we will have troubles
        with Field::new_field() method).
        We should also set field to not null in Field_timestamp::set_time() now.
      sql/field.h:
        Added support for TIMESTAMP fields holding NULL values.
        We don't need Field_timestamp::set_timestamp_offsets() anymore.
        Instead we need Field_timestamp::get_auto_set_type() function,
        which will convert TIMESTAMP auto-set type stored in Field in 
        unireg_check to value from timestamp_auto_set_type_enum.
        We also have to support NULL values in Field_timestamp::get_timestamp()
        function.
      sql/field_conv.cc:
        Added comment clarifying behavior in case of TIMESTAMP fields which are
        able to store NULL values.
      sql/ha_berkeley.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_heap.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_innodb.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_isam.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_isammrg.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_myisam.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_myisammrg.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/ha_ndbcluster.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now for determining 
        if we should auto-set value of TIMESTAMP field during this operation.
        We are also use Field_timestamp::set_time() instead of 
        handler::update_timestamp().
      sql/handler.cc:
        handler::update_timestamp() is no longer needed since now we use
        Field_timestamp::set_time() instead.
        (we can't use handler::update_timestamp() anyway since field position
        only is not enough for TIMESTAMP fields which are able to store NULLs)
      sql/handler.h:
        handler::update_timestamp() is no longer needed since now we use
        Field_timestamp::set_time() instead.
      sql/item_timefunc.cc:
        Since now TIMESTAMP fields can hold NULL values we should take this into
        account.
      sql/sql_base.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now. 
        (Here we use Field_timestamp::get_auto_set_type() to setup its value
         before further statement execution).
      sql/sql_insert.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now.
      sql/sql_load.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now.
      sql/sql_parse.cc:
        Added support for TIMESTAMP fields holding NULL values.
        We should distinguish NULL default values and non-specified default
        values for such fields (because latter could mean DEFAULT NOW()
        ON UPDATE NOW() in some cases).
      sql/sql_show.cc:
        Added support for TIMESTAMP fields holding NULL values.
        Unlike all other fields these are NOT NULL by default
        so we have to specify NULL attribute explicitly for them.
      sql/sql_table.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now.
      sql/sql_update.cc:
        Now we use TABLE::timestamp_field_type instead of 
        TABLE::timestamp_default_now/on_update_now.
      sql/sql_yacc.yy:
        Added support for TIMESTAMP fields holding NULL values.
        Unlike all other fields these are NOT NULL by default
        (so we have to set NOT_NULL_FLAG properly for them).
      sql/table.h:
        Added timestamp_auto_set_type enum which values are used for indicating
        during which operations we should automatically set TIMESTAPM field
        value to current timestamp.
        TABLE: Replaced timestamp_default_now/on_update_now members with
        timestamp_auto_set_type flag (Now when TIMESTAMP field are able to 
        store NULL values, single position of field in record is not enough 
        for updating this field anyway).
      c2a25521
  8. 26 Sep, 2004 1 commit
    • unknown's avatar
      Fix for bug #4131 "TIMESTAMP columns missing minutes and seconds when · 0b1a83ea
      unknown authored
      using GROUP BY"
      Now we are setting Field_timestamp::field_length to 19 in open_table()
      if we are in new mode (and we are restoring it back when we are coming
      back to normal mode). This also should solve potential problems with
      some of LOAD DATA INFILE and SELECT * INTO in this mode.
      
      
      mysql-test/r/type_timestamp.result:
        Added test for bug #4131 'TIMESTAMP columns missing minutes and seconds
        when using GROUP BY' and other --new mode related behavior.
      mysql-test/t/type_timestamp.test:
        Added test for bug #4131 'TIMESTAMP columns missing minutes and seconds
        when using GROUP BY' and other --new mode related behavior.
      sql/field.cc:
        Added Field_timestamp::orig_field_length member for saving original
        field_length value, because this member can be modified if new_mode is
        in effect.
        Lot of Field_timestamp code simplified and Field_timestamp::make_field()
        is no longer needed because we are setting field_length to 19 if we are
        in --new mode now.
      sql/field.h:
        Added Field_timestamp::orig_field_length member for saving original
        field_length value, because this member can be modified if new_mode
        is in effect. 
        Field_timestamp::make_field() is no longer needed because we are setting
        field_length to 19 if we are in --new mode now.
      sql/sql_base.cc:
        If --new mode is in effect all TIMESTAMP fields should pretend that they
        have length of 19. We are achieving this by setting 
        Field_timestamp::field_length to 19 (or original value) in open_table().
        We are using TABLE::timestamp_mode variable for avoiding of unnecessary
        looping over all fields of the table and setting field_length if table
        was used with same new_mode value before.
        
        Note: We do not introduce general framework for setting up Field objects
        for usage with current THD here because this fix is only needed in 4.0
        and Monty said that we will also remove looping over all fields when
        updating table_name member at some point. This more general framework
        will also complicate nice optimization with avoiding of unneeded looping.
      sql/sql_parse.cc:
        Now when we are creating TIMESTAMP(19) fields by default in --new mode,
        otherwise we will have unaligned behavior between ALTER and CREATE.
      sql/table.h:
        Added TABLE::timestamp_mode field for saving information whenever we set 
        field_length members of table's TIMESTAMP fields to 19 (to honor 
        new_mode) or they have original values.
      0b1a83ea
  9. 24 Jun, 2004 1 commit
  10. 09 Apr, 2004 1 commit
    • unknown's avatar
      after review PS fixes · 77330300
      unknown authored
      sql/item_cmpfunc.cc:
        merged in one if
      sql/mysql_priv.h:
        removed unused paremeter of check_one_table_access
        declaration of new function for SP share code
      sql/set_var.cc:
        function descriotion added
        unneeded parantses removed
      sql/sql_acl.cc:
        new parameter to limit number of checked tables for check_grant
      sql/sql_acl.h:
        new parameter to limit number of checked tables for check_grant
      sql/sql_delete.cc:
        preparation moved in separate function
      sql/sql_insert.cc:
        preparation moved in separate function
      sql/sql_lex.cc:
        comment style fixed
        unneeded assignment removed
      sql/sql_parse.cc:
        new parameter to limit number of checked tables for check_grant
        table list manipulation removed (because of above)
        new precheck function
      sql/sql_prepare.cc:
        function rewrited to shere code with sql_prepare.cc
        flow control fixed
      sql/sql_show.cc:
        new parameter to limit number of checked tables for check_grant
      sql/sql_update.cc:
        preparation moved in separate function
      sql/table.h:
        flag renamed
      77330300
  11. 07 Apr, 2004 2 commits
    • unknown's avatar
      new error for unsupported command in PS · 9802b134
      unknown authored
      fixed IN subselect with basic constant left expression
      SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS (BUG#3398, BUG#3406)
      fixed multiupdate privelege check (BUG#3408)
      fixed multiupdate tables check (BUG#3411)
      unchecked commands now is rejected by PS protocol to avoid serever crash
      fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)
      
      
      include/mysqld_error.h:
        new error for unsupported command in PS
      mysql-test/r/multi_update.result:
        test sutes (BUG#3408, BUG#3411)
      mysql-test/t/multi_update.test:
        test sutes (BUG#3408, BUG#3411)
      sql/item_cmpfunc.cc:
        fixed IN subselect with basic constant left expression
      sql/mysql_priv.h:
        some function frop sql_parse.h become public
      sql/set_var.cc:
        check for SET command via PS
      sql/set_var.h:
        check for SET command via PS
      sql/share/czech/errmsg.txt:
        new error for unsupported command in PS
      sql/share/danish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/dutch/errmsg.txt:
        new error for unsupported command in PS
      sql/share/english/errmsg.txt:
        new error for unsupported command in PS
      sql/share/estonian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/french/errmsg.txt:
        new error for unsupported command in PS
      sql/share/german/errmsg.txt:
        new error for unsupported command in PS
      sql/share/greek/errmsg.txt:
        new error for unsupported command in PS
      sql/share/hungarian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/italian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/japanese/errmsg.txt:
        new error for unsupported command in PS
      sql/share/korean/errmsg.txt:
        new error for unsupported command in PS
      sql/share/norwegian-ny/errmsg.txt:
        new error for unsupported command in PS
      sql/share/norwegian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/polish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/portuguese/errmsg.txt:
        new error for unsupported command in PS
      sql/share/romanian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/russian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/serbian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/slovak/errmsg.txt:
        new error for unsupported command in PS
      sql/share/spanish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/swedish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/ukrainian/errmsg.txt:
        new error for unsupported command in PS
      sql/sql_lex.cc:
        first table unlincking procedures for CREATE command
      sql/sql_lex.h:
        first table unlincking procedures for CREATE command
      sql/sql_parse.cc:
        used function to exclude first table from list
        SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS (BUG#3398, BUG#3406)
        fixed multiupdate privelege check (BUG#3408)
        fixed multiupdate tables check (BUG#3411)
      sql/sql_prepare.cc:
        fixed a lot of commands to be compatible with PS
        unchecked commands now is rejected to avoid serever crash
      sql/sql_select.cc:
        allow empty result for PS preparing
      sql/sql_union.cc:
        fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)
      sql/sql_update.cc:
        fixed update to use correct tables lists (BUG#3408)
      sql/table.h:
        flag to support multi update tables check (BUG#3408)
      tests/client_test.c:
        removed unsupported tables
        fixed show table test
        added new tests
      9802b134
    • unknown's avatar
      after review changes · 56507195
      unknown authored
      sql/log_event.cc:
        non_cachable_table flag changed to cacheable_table
      sql/repl_failsafe.cc:
        non_cachable_table flag changed to cacheable_table
      sql/slave.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_acl.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_base.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_cache.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_help.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_insert.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_parse.cc:
        non_cachable_table flag changed to cacheable_table
      sql/sql_prepare.cc:
        renamed DEBUG tag
      sql/table.h:
        non_cachable_table flag changed to cacheable_table
      56507195
  12. 04 Apr, 2004 1 commit
    • unknown's avatar
      removed old way to prevent using stack tables for caching Items in PS · 5339d094
      unknown authored
      fixed error code in union test
      
      
      mysql-test/t/union.test:
        right code worr 4.1 error
      sql/log_event.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/repl_failsafe.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/slave.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/sql_acl.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/sql_base.cc:
        assign non-cachable for Item status for all stack tables for safety
        non-cachable status processing
      sql/sql_cache.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/sql_class.cc:
        removed ald way to prevent using stack tables for caching Items in PS
      sql/sql_class.h:
        removed old way to prevent using stack tables for caching Items in PS
      sql/sql_help.cc:
        assign non-cachable for Item status for all stack tables for safety
      sql/sql_insert.cc:
        assign non-cachable for Item status for all stack tables for safety
        removed old way to prevent using stack tables for caching Items in PS
      sql/table.h:
        non-cachable for Item status for tables
      5339d094
  13. 03 Apr, 2004 1 commit
    • unknown's avatar
      fixed brocken of client_test · 7ce8fd9e
      unknown authored
      fixed aggregate functions in PS (BUG#3360)
      
      
      mysql-test/r/union.result:
        4.1 more correct error
      sql/item_cmpfunc.h:
        and_conds do not make fix fields
      sql/item_sum.cc:
        storing/restoring argument of aggregate function for prepared statements
        restoring order list of group_concat for safety
      sql/item_sum.h:
        storing/restoring argument of aggregate function for prepared statements
        layout fix
      sql/mysql_priv.h:
        just declaration
      sql/sql_base.cc:
        fix_fields() have to be called with temporary memory pool active
      sql/sql_parse.cc:
        removed hack with item pointer storing
      sql/sql_prepare.cc:
        debug output added
        removed hack with item pointer storing
      sql/sql_select.cc:
        fix_fields now should be called separately
      sql/sql_union.cc:
        removed wrong merged check from 4.0 (4.1 have its own protection)
      sql/table.h:
        removed hack with item pointer storing
      tests/client_test.c:
        new test fo PS
      7ce8fd9e
  14. 02 Apr, 2004 2 commits
    • unknown's avatar
      6429b1be
    • unknown's avatar
      WL#1266 "Separate auto-set logic from TIMESTAMP type." · 4ada2ea9
      unknown authored
      Final version of patch.
      
      Adds support for specifying of DEFAULT NOW() and/or ON UPDATE NOW()
      clauses for TIMESTAMP field definition.
      Current implementation allows only one such field per table and
      uses several unireg types for storing info about this properties of
      field. It should be replaced with better implementation when new
      .frm format is introduced.
      
      
      include/mysqld_error.h:
        Added error codes for case when we have more than one column with NOW()
        in DEFAULT or ON UPDATE clauses and for case when we are using ON UPDATE
        clause with wrong type.
      mysql-test/r/create.result:
        Added tests for using of DEFAULT NOW() and ON UPDATE NOW() with
        non-TIMESTAMP fields.
      mysql-test/r/show_check.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW CREATE TABLE.
      mysql-test/r/system_mysql_db.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW CREATE TABLE.
      mysql-test/r/type_ranges.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW COLUMNS.
      mysql-test/r/type_timestamp.result:
        Added tests for various DEFAULT and ON UPDATE clauses for TIMESTAMP
        fields definitions.
      mysql-test/t/create.test:
        Added tests for using of DEFAULT NOW() and ON UPDATE NOW() with
        non-TIMESTAMP fields.
      mysql-test/t/type_timestamp.test:
        Added tests for various DEFAULT and ON UPDATE clauses for TIMESTAMP
        fields definitions.
      sql/field.cc:
        Added support for various combinations of DEFAULT and ON UPDATE clauses
        for TIMESTAMP field. 
        
        Setting TABLE::timestamp* members for TIMESTAMP fields with auto-set 
        option taking into account their unireg type (which corresponds to 
        various DEFAULT/ON UPDATE values combinations). Replaced 
        TABLE::time_stamp with TABLE::timestamp_default_now/on_update_now
        couple moved their setup to separate method set_timestamp_offsets(),
        which now is called from  open_table instead of Field_timestamp cons.
      sql/field.h:
        Added more unireg types for handling of DEFAULT NOW() and ON UPDATE
        NOW() for TIMESTAMP fields.
        Fixed value corresponding to DEFAULT item for TIMESTAMP field.
      sql/ha_berkeley.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_heap.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_innodb.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_isam.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_isammrg.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_myisam.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_myisammrg.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/item_func.h:
        We need to distinguish NOW() from other function for using in 
        DEFAULT and in ON UPDATE clauses.
      sql/item_timefunc.h:
        We need to distinguish NOW() from other function for using in 
        DEFAULT and in ON UPDATE clauses.
      sql/mysql_priv.h:
        Added parameter for ON UPDATE value to add_field_to_list() function.
      sql/share/czech/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/danish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/dutch/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/english/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/estonian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/french/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/german/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/greek/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/hungarian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/italian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/japanese/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/korean/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/norwegian-ny/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/norwegian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/polish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/portuguese/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/romanian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/russian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/serbian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/slovak/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/spanish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/swedish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/ukrainian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/sql_base.cc:
        Added setup of TABLE::timestamp_default_now/on_update_now pair
        for each statement to open_table().
      sql/sql_insert.cc:
        Using TABLE::timestamp_default_now/on_update_now pair instead of
        old TABLE::time_stamp. Added check for case then REPLACE could not
        be converted to UPDATE because of different DEFAULT/ON UPDATE values
        for TIMESTAMP field.
      sql/sql_lex.h:
        Added member for value used in ON UPDATE clause to st_lex.
      sql/sql_load.cc:
        Using TABLE::timestamp_default_now/on_update_now pair instead of
        old TABLE::time_stamp. We don't need to restore these members
        since they are set up for each statement in open_table().
      sql/sql_parse.cc:
        Added handling of DEFAULT NOW() and ON UPDATE NOW() clauses for
        TIMESTAMP fields to add_field_to_list() function.
      sql/sql_show.cc:
        Added support for DEFAULT CURRENT_TIMESTAMP (aka NOW() ) and 
        ON UPDATE CURRENT_TIMESTAMP to SHOW CREATE TABLE and SHOW COLUMNS.
      sql/sql_table.cc:
        mysql_create_table() function - added check for number of TIMESTAMP 
          fields with auto-set values and replacing of old style TIMESTAMPs
          with their newer analogs.
        mysql_alter_table(): Using TABLE::timestamp_default_now/on_update_now 
          pair instead of old TABLE::time_stamp. We don't need to restore these
          members since they are set up for each statement in open_table().
      sql/sql_update.cc:
        Left only setting of TABLE::timestamp_default_now/on_update_now
        to 0 since they should be already set up in open_table().
      sql/sql_yacc.yy:
        Added support for DEFAULT NOW() and ON UPDATE NOW() in field
        definitions.
      sql/table.h:
        Replaced TABLE::time_stamp withTABLE::timestamp_default_now/timestamp_on_update_now
        pair which allows to distinguish TIMESTAMP's with various DEFAULT/ON UPDATE
        clauses and optimize checks if TIMESTAMP field should be set to NOW()
        in handlers.
      sql/unireg.cc:
        Now we are marking only TIMESTAMP fields with NOW() as default or
        as on update value as special field for unireg.
      4ada2ea9
  15. 28 Mar, 2004 1 commit
    • unknown's avatar
      "Fix" for BUG #2050 "10 to 1 performance drop with server 4.1.1". · 12dd5008
      unknown authored
      Actually it is not a bug but right behavior observed as pefomance 
      degradation after we have forced Item_field::fix_fields() to 
      re-execute each time when we are executing prep stmt.
      
      This patch implements small optimization which heals this bad 
      behavior. We are caching field position in TABLE::field array in
      Item's member and are using this position for speeding up field
      lookups in fix_fields() in case of its re-execution.
      
      
      sql/item.cc:
        Added cached_field_index member to Item_ident for caching field
        position in TABLE::field array for quicker field lookup in case 
        fix_fields() is executed twice.
      sql/item.h:
        Added cached_field_index member to Item_ident for caching field
        position in TABLE::field array for quicker field lookup in case 
        fix_fields() is executed twice.
      sql/mysql_priv.h:
        Now find_field_in_table has one more in-out parameter which is used
        for caching field index in TABLE::field array stored for quicker
        field look up.
      sql/sql_acl.cc:
        Now find_field_in_table has one more in-out parameter which is used
        for caching field index in TABLE::field array stored for quicker
        field look up.
      sql/sql_base.cc:
        Optimization: Now when we are looking up Field by its name we are 
        caching its position in TABLE::field array in Item_ident::cached_field_index,
        so when we will call fix_fields() second time for this item (e.g.
        when we are re-executing prep statement) we can reuse this index
        to speed up this lookup.
      sql/table.cc:
        Now we storing in TABLE::name_hash pointers to elements of 
        TABLE::field array, because this allows easily retrieve index
        of field in this array when it is looked up by its name.
      sql/table.h:
        Added comment claryfying what we store in TABLE::name_hash.
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      12dd5008
  16. 16 Feb, 2004 1 commit
    • unknown's avatar
      ulternative bugfix for BUG#2508 and fix for BUG#2809 - every table has its own TABLE structure · 435fdbc2
      unknown authored
      mysql-test/r/union.result:
        fix for union test becuase now not all fields in UNION allow NULLS
        fix of test
        test suite for BUG#2809
      mysql-test/t/union.test:
        test suite for BUG#2809
      sql/mysql_priv.h:
        removed unused parameter of setup_tables()
      sql/sql_base.cc:
        removed unused parameter of setup_tables()
        cleanup of unused code
      sql/sql_class.h:
        removed unused field
      sql/sql_help.cc:
        removed unused parameter of setup_tables()
      sql/sql_insert.cc:
        removed unused parameter of setup_tables()
      sql/sql_lex.cc:
        excluded duplicate tables finding for UNION
      sql/sql_load.cc:
        removed unused parameter of setup_tables()
      sql/sql_olap.cc:
        removed unused parameter of setup_tables()
      sql/sql_prepare.cc:
        removed unused parameter of setup_tables()
      sql/sql_select.cc:
        removed unused parameter of setup_tables()
        revert old BUG#2508 patch
      sql/sql_union.cc:
        revert old BUG#2508 patch
        removed unused code
      sql/sql_update.cc:
        removed unused parameter of setup_tables()
      sql/table.h:
        shared used only for multi-update for now
      435fdbc2
  17. 12 Dec, 2003 1 commit
    • unknown's avatar
      Fix autoincrement for signed columns (Bug #1366) · 6c50fea9
      unknown authored
      Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      Disable creation of symlinks if my_disable_symlink is set
      Fixed searching of TEXT with end space. (Bug #1651)
      Fixed caching bug in multi-table-update where same table was used twice. (Bug #1711)
      Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      Fixed timestamp.test
      
      
      include/my_base.h:
        Add HA_END_SPACE_KEY to mark keys that has VARCHAR/TEXT fields.
      myisam/mi_check.c:
        Delete not used variable
      myisam/mi_key.c:
        Fix autoincrement for signed columns (Bug #1366). Patch by Holyfoot
      myisam/mi_open.c:
        Bug fix for future (doesn't affect current code)
      myisam/mi_search.c:
        Ignore end space for VARCHAR/TEXT columns
      mysql-test/r/auto_increment.result:
        Test auto_increment with signed numbers
      mysql-test/r/binary.result:
        Update results (old result was wrong)
      mysql-test/r/func_str.result:
        Added test of QUOTE()
      mysql-test/r/func_time.result:
        Add test of unix_timestamp()
      mysql-test/r/have_met_timezone.require:
        Fixed test
      mysql-test/r/innodb.result:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/r/multi_update.result:
        Test of multi-update bug
      mysql-test/r/symlink.result:
        Test of ALTER TABLE and symlinks
      mysql-test/r/timezone.result:
        Test of from_unixtime()
      mysql-test/r/truncate.result:
        Test of truncate and auto_increment
      mysql-test/r/type_blob.result:
        Test of key search on TEXT/VARCHAR column with end space
      mysql-test/t/auto_increment.test:
        Test auto_increment with signed numbers
      mysql-test/t/func_str.test:
        Added test of QUOTE()
      mysql-test/t/func_time.test:
        Add test of unix_timestamp()
      mysql-test/t/innodb.test:
        Add test for InnoDB behaviour with TRUNCATE
      mysql-test/t/multi_update.test:
        Test of multi-update bug
      mysql-test/t/symlink.test:
        Test of ALTER TABLE and symlinks
      mysql-test/t/timezone.test:
        Test of from_unixtime()
      mysql-test/t/truncate.test:
        Test of truncate and auto_increment
      mysql-test/t/type_blob.test:
        Test of key search on TEXT/VARCHAR column with end space
      mysys/my_symlink2.c:
        Disable creation of symlinks if my_disable_symlink is set
      sql/field.h:
        Indentation cleanup
      sql/ha_innodb.cc:
        HA_PART_KEY -> HA_PART_KEY_SEG
      sql/item_strfunc.cc:
        Fixed problem with char > 128 in QUOTE() function. (Bug #1868)
      sql/mysql_priv.h:
        Make check_dup() external
      sql/opt_range.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/records.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/sql_acl.cc:
        Reset ip and ip_mask if hostname is NULL
      sql/sql_parse.cc:
        Make check_dup() global
      sql/sql_select.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/sql_update.cc:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/table.cc:
        Fixed searching of TEXT with end space. (Bug #1651)
      sql/table.h:
        Fixed caching bug in multi-table-update where same table was used twice.
        (Bug #1711)
      sql/time.cc:
        Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998)
      6c50fea9
  18. 18 Nov, 2003 1 commit
    • unknown's avatar
      CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS · 1b739e39
      unknown authored
      New multi-key-cache handling. This was needed becasue the old one didn't work reliable with MERGE tables.
      ALTER TABLE table_name ... CHARACTER SET  ... now changes all char/varchar/text columns to the given character set
      (One must use ALTER TABLE ... DEFAULT CHARACTER SET ... to change the default character set)
      Fixed that have_compress is detected properly (fixes problems with func_compress.test on platforms without zlib)
      New syntax for CACHE INDEX ('keys' is optional if no index name is given and one mentions the key cache name only ones)
      Removed compiler warnings
      Added mysql_set_server_option() to allow clients like PHP to easaily set/reset the multi-statement flag.
      
      
      BUILD/compile-pentium-valgrind-max:
        Add test of isam
      client/mysql.cc:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
      include/my_base.h:
        Remove HA_EXTRA_SET_KEY_CACHE
      include/my_no_pthread.h:
        Add defines to ignore rw-locks when running without threads
      include/my_sys.h:
        Added function for multi-key-caches
      include/myisam.h:
        Added function to handle multi-key-caches
      include/mysql.h:
        Added mysql_set_server_option
      include/mysql_com.h:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
        Added enum_mysql_set_option
      include/mysqld_error.h:
        Added error message for unknown key cache
      innobase/srv/srv0start.c:
        Removed warning that is confused for MySQL users
      libmysql/libmysql.c:
        Added mysql_set_server_option()
      libmysql/libmysql.def:
        Added mysql_set_server_option()
      myisam/ft_nlq_search.c:
        Removed compiler warning
      myisam/ft_static.c:
        Removed compiler warning and fixed wrong return value
      myisam/mi_check.c:
        Clean up multi-key-cache usage
      myisam/mi_checksum.c:
        Removed not used variable
      myisam/mi_close.c:
        keycache -> key_cache
      myisam/mi_delete_all.c:
        keycache -> key_cache
      myisam/mi_extra.c:
        keycache -> key_cache
        Removed HA_EXTRA_SET_KEY_CACHE
      myisam/mi_keycache.c:
        Changed logic so that it's MyISAM that is responsible for assign tables to different key caches instead of the upper level
      myisam/mi_locking.c:
        Don't change key cache on unlock (must be done before)
      myisam/mi_open.c:
        Fetch key cache to use from multi_key_cache_search()
      myisam/mi_page.c:
        keycache -> key_cache
      myisam/mi_panic.c:
        keycache -> key_cache
      myisam/mi_preload.c:
        keycache -> key_cache
      myisam/mi_test1.c:
        Use KEY_CACHE_BLOCK_SIZE
      myisam/mi_test2.c:
        Always test resize_key_cache()
      myisam/mi_test3.c:
        Use KEY_CACHE_BLOCK_SIZE instead of 512
      myisam/myisamchk.c:
        update for multiple key caches
      myisam/myisamdef.h:
        Remove reg_keycache
        Add unique_name_length for storing length of unique_file_name
      myisam/myisamlog.c:
        Change how end_key_cache() is called
      mysql-test/mysql-test-run.sh:
        Fixed web link
        Added name of failed test to abort row.
      mysql-test/r/alter_table.result:
        Testing of ALTER TABLE ... [DEFAULT] CHARACTER SET
      mysql-test/r/case.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/cast.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/create.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_collate.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_latin1_de.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_many.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_mb.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_recoding.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/ctype_ucs.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/derived.result:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/r/fulltext.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/func_str.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/func_system.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/gis-rtree.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/innodb.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/key_cache.result:
        Update test for new key cache syntax.
        Added more tests
      mysql-test/r/merge.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/preload.result:
        New syntax
      mysql-test/r/show_check.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/sql_mode.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/subselect.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_blob.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_enum.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_nchar.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/type_set.result:
        Update result for DEFAULT CHARSET...
      mysql-test/r/union.result:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/t/alter_table.test:
        Testing of ALTER TABLE ... [DEFAULT] CHARACTER SET
      mysql-test/t/ctype_many.test:
        Update result for DEFAULT CHARSET...
      mysql-test/t/derived.test:
        Use STRAIGHT_JOIN to make join order predictable
      mysql-test/t/isam.test:
        Use disable warnings for test loop
      mysql-test/t/join.test:
        Update test now when we only support 61 tables in join
      mysql-test/t/key_cache.test:
        Update test for new key cache syntax.
        Added more tests
      mysql-test/t/preload.test:
        Update for new syntax
      mysql-test/t/union.test:
        Use STRAIGHT_JOIN to make join order predictable
      mysys/Makefile.am:
        Added mf_keycaches.c
      mysys/hash.c:
        TRUE -> 1
      mysys/mf_keycache.c:
        Removed compiler warnings
        Striped end space
        Fixed indentation and improved function comments
        TRUE -> 1
        Changed parameters to end_key_cache() to make it easer to use
        Fixed bug when using key blocks size > 1024 bytes (First part of index file could be overwritten with wrong data)
        Split function flush_key_blocks into two functions to not get mutex used twice when called from flush_all_key_blocks()
      mysys/my_bitmap.c:
        More debugging
        Safe bitmap_free()
        Fixed indentation
      mysys/my_getopt.c:
        Ensure that we initialize option->value, option->max_value and value from GET_ASK_ADDR
      mysys/my_thr_init.c:
        Remove not used mutex THR_LOCK_keycache
      mysys/typelib.c:
        Fixed function comments
      sql-common/client.c:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
        Fixed the multi_result flag is set also on SELECT;s
      sql/ha_myisam.cc:
        Fixed multiple key_cache handling
        (Now done on MyISAM level)
      sql/ha_myisammrg.cc:
        Fixed multiple key_cache handling
        (Now done on MyISAM level)
      sql/handler.cc:
        New multi key cache handling
      sql/handler.h:
        New multi key cache handling
        Added support for default character set
      sql/item.h:
        Added function cleanup() (Needed for prepared statements / cursors)
      sql/item_cmpfunc.h:
        Added cleanup function
      sql/item_func.cc:
        Indentation cleanup
      sql/mysql_priv.h:
        New multi-key-cache functions
        Removed LOCK_assign
      sql/mysqld.cc:
        New multi-key-cache handling
        Fixed that variable have_compress is set correctly
      sql/protocol.cc:
        SELECT didn't work reliable in multi-statements
      sql/set_var.cc:
        Support for new key cache variables
      sql/set_var.h:
        Support for new key cache variables
      sql/share/czech/errmsg.txt:
        New error messages
      sql/share/danish/errmsg.txt:
        New error messages
      sql/share/dutch/errmsg.txt:
        New error messages
      sql/share/english/errmsg.txt:
        New error messages
      sql/share/estonian/errmsg.txt:
        New error messages
      sql/share/french/errmsg.txt:
        New error messages
      sql/share/german/errmsg.txt:
        New error messages
      sql/share/greek/errmsg.txt:
        New error messages
      sql/share/hungarian/errmsg.txt:
        New error messages
      sql/share/italian/errmsg.txt:
        New error messages
      sql/share/japanese/errmsg.txt:
        New error messages
      sql/share/korean/errmsg.txt:
        New error messages
      sql/share/norwegian-ny/errmsg.txt:
        New error messages
      sql/share/norwegian/errmsg.txt:
        New error messages
      sql/share/polish/errmsg.txt:
        New error messages
      sql/share/portuguese/errmsg.txt:
        New error messages
      sql/share/romanian/errmsg.txt:
        New error messages
      sql/share/russian/errmsg.txt:
        New error messages
      sql/share/serbian/errmsg.txt:
        New error messages
      sql/share/slovak/errmsg.txt:
        New error messages
      sql/share/spanish/errmsg.txt:
        New error messages
      sql/share/swedish/errmsg.txt:
        New error messages
      sql/share/ukrainian/errmsg.txt:
        New error messages
      sql/sql_base.cc:
        Removed all key_cache handling (this is now done on MyISAM level)
        Change table_charset -> default_table_charset
      sql/sql_db.cc:
        table_charset -> default_table_charset
      sql/sql_delete.cc:
        table_charset -> default_table_charset
      sql/sql_lex.cc:
        CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTS
      sql/sql_lex.h:
        New option to store a name and length
      sql/sql_parse.cc:
        Support for mysql_set_server_option()
        Reset "default" keycache status variables in 'FLUSH STATUS' (Need to be improved later)
      sql/sql_show.cc:
        Add DEFAULT before CHARSET (for table character sets)
        Fetch key cache variables from 'sql_key_cache'
      sql/sql_table.cc:
        table_charset -> default_table_charset
        New multi-key-cache handling
      sql/sql_test.cc:
        Write information from all key caches
      sql/sql_yacc.yy:
        Changed syntax for CACHE INDEX ...
        Force user to use DEFAULT before database/table level character sets
      sql/structs.h:
        Added SHOW_KEY_CACHE_LONG (to get values from sql_key_cache)
      sql/table.cc:
        table_charset -> default_table_charset
      sql/table.h:
        New key cache handling (this is now done in mysys/mf_keycaches.c)
      sql/unireg.h:
        A
      1b739e39
  19. 02 Aug, 2003 1 commit
    • unknown's avatar
      Many files: · 6ef96ae3
      unknown authored
        Added key cache assignment
      mi_locking.c:
        Added key cache assignment: correction
      my_sys.h:
        Added key cache variable structure
      
      
      include/my_sys.h:
        Added key cache variable structure
      include/my_base.h:
        Added key cache assignment
      include/myisam.h:
        Added key cache assignment
      include/my_global.h:
        Added key cache assignment
      isam/_page.c:
        Added key cache assignment
      isam/close.c:
        Added key cache assignment
      isam/isamchk.c:
        Added key cache assignment
      isam/isamlog.c:
        Added key cache assignment
      isam/panic.c:
        Added key cache assignment
      isam/_locking.c:
        Added key cache assignment
      isam/test2.c:
        Added key cache assignment
      isam/test3.c:
        Added key cache assignment
      myisam/myisamdef.h:
        Added key cache assignment
      myisam/mi_check.c:
        Added key cache assignment
      myisam/mi_close.c:
        Added key cache assignment
      myisam/mi_extra.c:
        Added key cache assignment
      myisam/mi_page.c:
        Added key cache assignment
      myisam/mi_panic.c:
        Added key cache assignment
      myisam/mi_preload.c:
        Added key cache assignment
      myisam/mi_test1.c:
        Added key cache assignment
      myisam/mi_test2.c:
        Added key cache assignment
      myisam/mi_test3.c:
        Added key cache assignment
      myisam/myisamchk.c:
        Added key cache assignment
      myisam/myisamlog.c:
        Added key cache assignment
      myisam/mi_delete_all.c:
        Added key cache assignment
      myisam/mi_locking.c:
        Added key cache assignment: correction
      myisam/mi_keycache.c:
        Added key cache assignment
      sql/handler.h:
        Added key cache assignment
      sql/mysql_priv.h:
        Added key cache assignment
      sql/set_var.h:
        Added key cache assignment
      sql/table.h:
        Added key cache assignment
      sql/ha_myisam.cc:
        Added key cache assignment
      sql/ha_myisammrg.cc:
        Added key cache assignment
      sql/handler.cc:
        Added key cache assignment
      sql/mysqld.cc:
        Added key cache assignment
      sql/set_var.cc:
        Added key cache assignment
      sql/sql_base.cc:
        Added key cache assignment
      sql/sql_table.cc:
        Added key cache assignment
      sql/sql_test.cc:
        Added key cache assignment
      sql/sql_yacc.yy:
        Added key cache assignment
      mysys/mf_keycache.c:
        Added key cache assignment
      mysql-test/t/key_cache.test:
        Added key cache assignment
      mysql-test/r/key_cache.result:
        Added key cache assignment
      6ef96ae3
  20. 28 Jul, 2003 1 commit
    • unknown's avatar
      changed for AUTO_VALUE_ON_ZERO · b0e1cd18
      unknown authored
      mysql-test/r/auto_increment.result:
        added test for AUTO_VALUE_ON_ZERO
      mysql-test/t/auto_increment.test:
        added test for AUTO_VALUE_ON_ZERO
      b0e1cd18
  21. 22 Jul, 2003 1 commit
  22. 08 Jul, 2003 1 commit
    • unknown's avatar
      Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS · 9388c6fd
      unknown authored
      Removed double my_thread_end() which caused fatal error on windows if mysqld died on startup
      
      
      myisam/mi_extra.c:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      mysql-test/r/alter_table.result:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      mysql-test/t/alter_table.test:
        Test DISABLE/ENABLE KEY
      sql/ha_myisam.cc:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      sql/mysqld.cc:
        Removed double my_thread_end() which caused fatal error on windows if mysqld died on startup
      sql/sql_table.cc:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      sql/table.cc:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      sql/table.h:
        Fixed bug in ALTER TABLE ... DISABLE/ENABLE KEYS
      9388c6fd
  23. 12 Jun, 2003 2 commits
    • unknown's avatar
      Derived tables bug fix ....... · f61bd0e7
      unknown authored
      sql/ha_myisam.cc:
        DISABLE KEYS warnings
      sql/sql_table.cc:
        DISABLE KEYS warnings
      f61bd0e7
    • unknown's avatar
      Many files: · dfbe0f86
      unknown authored
        New feature: preload indexes into key cache.
      mi_preload.c:
        new file
      Many files:
        Added preload statement.
      
      
      sql/ha_myisam.h:
        Added preload statement.
      sql/handler.cc:
        Added preload statement.
      sql/lex.h:
        Added preload statement.
      sql/mysql_priv.h:
        Added preload statement.
      sql/sql_lex.h:
        Added preload statement.
      sql/sql_base.cc:
        Added preload statement.
      sql/sql_table.cc:
        New feature: preload indexes into key cache.
      sql/sql_parse.cc:
        New feature: preload indexes into key cache.
      sql/mysqld.cc:
        New feature: preload indexes into key cache.
      sql/set_var.cc:
        New feature: preload indexes into key cache.
      sql/sql_yacc.yy:
        New feature: preload indexes into key cache.
      sql/ha_myisam.cc:
        New feature: preload indexes into key cache.
      sql/table.h:
        New feature: preload indexes into key cache.
      mysys/mf_keycache.c:
        New feature: preload indexes into key cache.
      myisam/myisamdef.h:
        New feature: preload indexes into key cache.
      myisam/mi_extra.c:
        New feature: preload indexes into key cache.
      myisam/Makefile.am:
        New feature: preload indexes into key cache.
      include/my_base.h:
        New feature: preload indexes into key cache.
      include/my_sys.h:
        New feature: preload indexes into key cache.
      include/myisam.h:
        New feature: preload indexes into key cache.
      dfbe0f86
  24. 14 May, 2003 1 commit
    • unknown's avatar
      subselect transformation moved in after-fix_field place · 93155e67
      unknown authored
      removed "of is null" if it is possible
        (this cset should be SCRUM related, but not approved as scrum task yet)
      
      
      mysql-test/r/subselect.result:
        new subselect test result (new place of error detecting & and more subselect reducing)
      sql/item.cc:
        layout fix
      sql/item.h:
        unneed ';'
        fixed print pethod
      sql/item_cmpfunc.cc:
        new method to support transformation after fix_fields
      sql/item_cmpfunc.h:
        new method to support transformation after fix_fields
        fixed Item printing
      sql/item_subselect.cc:
        new transformation
      sql/item_subselect.h:
        new transformation
      sql/sql_derived.cc:
        'table' & 'table_list' now is not union
      sql/sql_lex.cc:
        'table' & 'table_list' now is not union to support reinit only shared tables (but all)
      sql/sql_lex.h:
        mark fake st_select_lex
      sql/sql_olap.cc:
        fixed table assignment
        TODO added
      sql/sql_select.cc:
        'table' & 'table_list' now is not union
        transforming subselect
      sql/sql_union.cc:
        prepare make on fix_fields
      sql/sql_yacc.yy:
        fixed layout
      sql/table.h:
        'table & 'table_list' now is different fields
      93155e67
  25. 02 May, 2003 1 commit
  26. 24 Apr, 2003 1 commit
    • unknown's avatar
      Many files: · 4d46f983
      unknown authored
         Added the MAX_LENGTH_FOR_SORT_DATA option
      filesort.cc:
        Added the MAX_LENGTH_FOR_SORT_DATA option
      
      
      sql/filesort.cc:
        Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/mysqld.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/opt_range.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/records.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/set_var.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_base.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_class.h:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_delete.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_select.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_sort.h:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_table.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/sql_update.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/structs.h:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/table.h:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      sql/uniques.cc:
         Added the MAX_LENGTH_FOR_SORT_DATA option
      4d46f983
  27. 19 Feb, 2003 1 commit
    • unknown's avatar
      Applying Sinisa's patch: · f0b20a1a
      unknown authored
      "Cleaning the code of the remaining OLAP code.
      This code is unnecessary in 4.1/5.0"
      
      f0b20a1a
  28. 12 Feb, 2003 1 commit
    • unknown's avatar
      Fixed a lot of wrong memory references as reported by valgrind · d79e52a7
      unknown authored
      Portability fixes
      Added new client function: mysql_get_server_version()
      New server help code (From Victor Vagin)
      Fixed wrong usage of binary()
      Disabled RTREE usage for now.
      
      
      
      BitKeeper/etc/ignore:
        added scripts/fill_help_tables.sql
      client/mysql.cc:
        Some fixes when using 'help'
      cmd-line-utils/libedit/compat.h:
        Portability fix
      cmd-line-utils/libedit/fgetln.c:
        Portability fix
      include/mysql.h:
        Added new client function: mysql_get_server_version()
      libmysql/libmysql.c:
        Added new client function: mysql_get_server_version()
      libmysqld/libmysqld.c:
        Fixed prototype
      mysql-test/install_test_db.sh:
        Added creation of help tables
      mysql-test/r/connect.result:
        Added help tables
      mysql-test/r/myisam.result:
        Test of RTREE index
      mysql-test/r/type_ranges.result:
        updated results
      mysql-test/t/myisam.test:
        Test of RTREE index
      mysql-test/t/type_ranges.test:
        Updated test
      mysys/charset.c:
        Indentation change
      mysys/my_symlink.c:
        Removed compiler warning
      scripts/fill_help_tables.sh:
        Update for new help tables
      sql/field.cc:
        Indentation changes
      sql/filesort.cc:
        Optimized character set usage
      sql/item_cmpfunc.cc:
        Fix wrong usage of binary()
      sql/item_cmpfunc.h:
        Fix wrong usage of binary()
      sql/item_func.cc:
        Fix wrong usage of binary()
      sql/item_func.h:
        Fix wrong usage of binary()
      sql/item_strfunc.cc:
        Fix wrong usage of binary()
      sql/item_sum.cc:
        Fix wrong usage of binary()
      sql/item_sum.h:
        Fix wrong usage of binary()
      sql/key.cc:
        Indentation change
      sql/lex.h:
        HELP -> HELP_SYM
      sql/mysql_priv.h:
        Make get_field() more general
      sql/password.c:
        Indentation change + variable initialisation moved
      sql/sql_acl.cc:
        Make get_field() more general
      sql/sql_base.cc:
        Added comments + assertion for double call to mysql_lock_tables
      sql/sql_cache.cc:
        Indentation changes
      sql/sql_class.h:
        Added need_strxnfrm to SORT_FIELD to be able to optimise character set handling in filesort
      sql/sql_derived.cc:
        Renamed variables
      sql/sql_help.cc:
        New help functions (from Victor Vagin)
      sql/sql_lex.cc:
        Removed variables that doesn't have to be initialized for each query
      sql/sql_lex.h:
        Removed not used variable (olap)
      sql/sql_parse.cc:
        Fixed (not fatal) access of unitialized memory
        Indentation / code cleanup
      sql/sql_prepare.cc:
        Indentaion cleanup
      sql/sql_table.cc:
        Disabled RTREE until 5.0
      sql/sql_udf.cc:
        Make get_field() more general
      sql/sql_yacc.yy:
        Removed access to uninitialized memory
        Always set offset_limit and select_limit when using LIMIT (removed warnings)
        Allow usage of 'help week'
      sql/table.cc:
        Make get_field() more general
        More comments
      sql/table.h:
        Fixded type of TABLE_LIST->derived
      sql/time.cc:
        Stricter date / datetime handling (to be able to handle timestamps with days and microseconds)
      strings/ctype-bin.c:
        Added cha
      d79e52a7
  29. 21 Jan, 2003 1 commit
    • unknown's avatar
      SCRUM · a87396cd
      unknown authored
      Default in UPDATE & SELECT
      
      
      sql/field.h:
        brackets was omitted
      sql/item.cc:
        now only DEFAULT_ITEM
      sql/item.h:
        Item_default class deletion
      sql/sql_yacc.yy:
        changes in syntax for DEFAULT in UPDATE & SELECT
      sql/table.cc:
        default_values member removed
      sql/table.h:
        member changed with inline function
      a87396cd
  30. 09 Jan, 2003 1 commit
    • unknown's avatar
      Don't count NULL values in cardinalty for MyISAM tables. · 805016c5
      unknown authored
      Free row buffer cache after each query for MyISAM tables.
      Added table join option FORCE INDEX
      Fixed core dump bug when connecting with hostname that could not be resolved.
      
      
      include/my_base.h:
        Don't count NULL values in cardinalty
      myisam/mi_check.c:
        Don't count NULL values in cardinalty
      myisam/mi_extra.c:
        Free row buffer cache after each query
      myisam/mi_open.c:
        Avoid realloc if cache size doesn't change
      myisam/mi_search.c:
        Don't count NULL values in cardinalty
      myisam/myisamdef.h:
        Change buffer length from uint to uint32 to make it more portable/predictable
      mysql-test/r/myisam.result:
        Test case for cardinality with NULL keys and FORCE INDEX
      mysql-test/t/myisam.test:
        Test case for cardinality with NULL keys and FORCE INDEX
      sql/lex.h:
        Added table join option FORCE INDEX
      sql/mysql_priv.h:
        Added table join option FORCE INDEX
      sql/opt_range.cc:
        Added table join option FORCE INDEX
      sql/sql_base.cc:
        Added table join option FORCE INDEX
      sql/sql_lex.h:
        Added table join option FORCE INDEX
      sql/sql_parse.cc:
        Added table join option FORCE INDEX
        Don't use strlen() on hostname without first checking if it's not NULL
      sql/sql_select.cc:
        Added table join option FORCE INDEX
      sql/sql_yacc.yy:
        Added table join option FORCE INDEX
      sql/table.h:
        Added table join option FORCE INDEX
      805016c5
  31. 05 Jan, 2003 1 commit
    • unknown's avatar
      SCRUM · 81aaa6f3
      unknown authored
      DEFAULT in UPDATE and SELECT
      
      
      sql/field.h:
        set_default() implementation changed
      sql/item.cc:
        Item_default_value methods implementations added
      sql/item.h:
        Item_default_value class added
      sql/sql_yacc.yy:
        DEFAULT in UPDATE and SELECT added
      sql/table.cc:
        table->default_values initialization added
      sql/table.h:
        st_table::default_values added
      81aaa6f3
  32. 06 Dec, 2002 1 commit
    • unknown's avatar
      After merge fixes · 8bc178a4
      unknown authored
      Added THD to add_to_xxx_list() functions for faster parsing.
      
      
      heap/_check.c:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/multi_update.result:
        Make timestamp test portable
      mysql-test/t/multi_update.test:
        Make timestamp test portable
      sql/field.cc:
        After merge fix
      sql/item_sum.cc:
        After merge fix
      sql/log_event.cc:
        Remove compiler warning
      sql/mysql_priv.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_derived.cc:
        Fixed parameters to create_tmp_table()
      sql/sql_lex.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_lex.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_parse.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_select.cc:
        After merge fixes
        Fixed return values from JOIN::optimize()
        Replaced test_function_query with '!tables_list'
        Optimized arguments to create_tmp_table()
      sql/sql_select.h:
        Removed test_function_query variable
        Updated prototypes
      sql/sql_union.cc:
        Updated argument lists.
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Added THD to all add_xxx_to_list() functions
      sql/table.h:
        After merge fix
      8bc178a4
  33. 29 Nov, 2002 1 commit
    • unknown's avatar
      New multi-table-update code · 7908c8d4
      unknown authored
      New (simpler) internal timestamp handling.
      More debuging to heap tables.
      Small cleanups to multi-table-delete
      false -> 0 and true -> 1  (We should use TRUE and FALSE)
      
      
      heap/_check.c:
        Added checking of rows
      heap/hp_delete.c:
        Extra debugging
      heap/hp_scan.c:
        Extra debugging
      heap/hp_update.c:
        Extra debugging
      heap/hp_write.c:
        Extra debugging
      include/my_base.h:
        Added option to disable row cache when using updates
      isam/extra.c:
        Added option to disable row cache when using updates
      myisam/mi_check.c:
        Comment cleanup
      myisam/mi_extra.c:
        Added option to disable row cache when using updates
      myisam/sort.c:
        Indentaion cleanups
      myisammrg/myrg_extra.c:
        Added option to disable row cache when using updates
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/t/multi_update.test:
        Cleanup up to only use table names t1, t2,...
      mysys/mf_iocache.c:
        Safety fix
      sql/item_cmpfunc.cc:
        change true-> 1 and false -> 0
      sql/mysql_priv.h:
        Cleaned up SQL_LIST handling
      sql/sql_base.cc:
        Fixed grant checking if SELECT tablename.*
      sql/sql_class.h:
        Cleaned up multi-table-update
      sql/sql_delete.cc:
        Fixed OPTION_SAFE_UPDATE checking in multi-table-delete.
        Fixed query-cache invalidation in multi-table-delete
      sql/sql_insert.cc:
        cleaned up timestamp handling
      sql/sql_olap.cc:
        false -> 0
      sql/sql_parse.cc:
        Optimized some list handling.
        Moved multi-table-update to sql_update.cc
      sql/sql_select.cc:
        More comments
        Fixed create_tmp_table for multi-table-update
      sql/sql_select.h:
        New prototypes
      sql/sql_union.cc:
        false -> 0
        Cleaned up timestamp handling
      sql/sql_update.cc:
        New multi-update-table code
      sql/sql_yacc.yy:
        false -> 0, true -> 1
        Optimized some list handling
      sql/table.h:
        Added union for temporary values.
        Made shared int to be able to store counters.
      sql/uniques.cc:
        Indentation cleanup
      7908c8d4
  34. 20 Nov, 2002 1 commit
    • unknown's avatar
      Try to optimize the cache buffer size needed for bulk_insert · 61eb4ca1
      unknown authored
      Fix for shutdown on Mac OS X
      
      
      include/my_tree.h:
        Try to optimize the cache buffer size needed for bulk_insert
      myisam/mi_write.c:
        Try to optimize the cache buffer size needed for bulk_insert
      mysql-test/r/bdb.result:
        Make test repeatable
      mysql-test/t/bdb.test:
        Make test repeatable
      mysys/tree.c:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/mysql_priv.h:
        Small optimization
      sql/mysqld.cc:
        Fix for shutdown on Mac OS X
      sql/sql_insert.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/sql_yacc.yy:
        Call thd->strmake() instead of sql_strmake()
      sql/table.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/table.h:
        Try to optimize the cache buffer size needed for bulk_insert
      61eb4ca1
  35. 26 Sep, 2002 1 commit
    • unknown's avatar
      new EXPLAIN · 404e879b
      unknown authored
      fixed bug in mysql-test/create-test-result
      fixed bug in union-subselect engine
      
      
      mysql-test/create-test-result:
        fixed bug in reject file name assembling
      mysql-test/r/compare.result:
        new EXPLAIN
      mysql-test/r/create.result:
        new EXPLAIN
      mysql-test/r/distinct.result:
        new EXPLAIN
      mysql-test/r/explain.result:
        new EXPLAIN
      mysql-test/r/group_by.result:
        new EXPLAIN
      mysql-test/r/heap.result:
        new EXPLAIN
      mysql-test/r/heap_btree.result:
        new EXPLAIN
      mysql-test/r/heap_hash.result:
        new EXPLAIN
      mysql-test/r/innodb.result:
        new EXPLAIN
      mysql-test/r/join_outer.result:
        new EXPLAIN
      mysql-test/r/key_diff.result:
        new EXPLAIN
      mysql-test/r/key_primary.result:
        new EXPLAIN
      mysql-test/r/merge.result:
        new EXPLAIN
      mysql-test/r/myisam.result:
        new EXPLAIN
      mysql-test/r/null_key.result:
        new EXPLAIN
      mysql-test/r/odbc.result:
        new EXPLAIN
      mysql-test/r/order_by.result:
        new EXPLAIN
      mysql-test/r/range.result:
        new EXPLAIN
      mysql-test/r/select.result:
        new EXPLAIN
      mysql-test/r/subselect.result:
        new EXPLAIN
      mysql-test/r/type_datetime.result:
        new EXPLAIN
      mysql-test/r/union.result:
        new EXPLAIN
      mysql-test/r/user_var.result:
        new EXPLAIN
      mysql-test/r/varbinary.result:
        new EXPLAIN
      mysql-test/t/subselect.test:
        new EXPLAIN
      mysql-test/t/union.test:
        new EXPLAIN
      sql/mysql_priv.h:
        new EXPLAIN
      sql/sql_class.cc:
        new EXPLAIN
      sql/sql_class.h:
        new EXPLAIN
      sql/sql_derived.cc:
        new EXPLAIN
      sql/sql_lex.h:
        new EXPLAIN
      sql/sql_parse.cc:
        new EXPLAIN
      sql/sql_select.cc:
        new EXPLAIN
      sql/sql_union.cc:
        fixed bug in subselect-UNION engine
      sql/table.h:
        new EXPLAIN
      404e879b
  36. 21 Sep, 2002 1 commit
    • unknown's avatar
      Change name -> alias in TABLE_LIST. · ada4f591
      unknown authored
      Added missing mutex-lock around critical section in GRANT handling.
      
      
      Docs/manual.texi:
        ChangeLog
      sql/lock.cc:
        Change name -> alias in TABLE_LIST.
      sql/slave.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_acl.cc:
        Added missing mutex-lock around critical section in GRANT handling.
        Changed name -> alias
      sql/sql_base.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_insert.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_parse.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_show.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_table.cc:
        Change name -> alias in TABLE_LIST.
      sql/sql_udf.cc:
        Change name -> alias in TABLE_LIST.
      sql/table.h:
        Change name -> alias in TABLE_LIST.
      tests/grant.pl:
        Fixed grant test
      ada4f591
  37. 20 Sep, 2002 1 commit
    • unknown's avatar
      Changed table_list->name -> table_list->alias to find places where we where... · 0d2a457f
      unknown authored
      Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      This should fix some issues where --lower-case-table-names doesn't work properly under windows.
      
      
      client/mysql.cc:
        Added missing sslopt-case.h
      sql/lock.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/log_event.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/mysqld.cc:
        Fixed that --ssl and --skip-ssl works
      sql/slave.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_acl.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_base.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_cache.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_handler.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_insert.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_parse.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_show.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_table.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_udf.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_union.cc:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/sql_yacc.yy:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      sql/table.h:
        Changed table_list->name -> table_list->alias to find places where we where using alias instead of table_name.
      0d2a457f