An error occurred fetching the project authors.
  1. 26 Oct, 2003 1 commit
    • unknown's avatar
      fixed ALL/ANY optimisation with union (BUG#1668) · 30764334
      unknown authored
      code cleanup
      
      
      mysql-test/r/subselect.result:
        test for BUG#1668
      mysql-test/t/subselect.test:
        test for BUG#1668
      sql/item_subselect.cc:
        removed unused class field
        fixed min_max subquery used_tables()/const()
        fixed ALL/ANY optimisation for unions
      sql/item_subselect.h:
        removed unused class field
        fixed min_max subquery used_tables()/const()
      sql/sql_union.cc:
        fixed result object assignment
      30764334
  2. 23 Oct, 2003 1 commit
  3. 19 Oct, 2003 1 commit
    • unknown's avatar
      correct table name assigned to temporary table field: · be4e254b
      unknown authored
       - correct table name shown in EXPLAIN Iindex reference)
       - pointer on freed memmory (reallocation of table name in reusing table entry) can't be used in EXPLAIN
      (BUG#1584)
      
      
      mysql-test/r/derived.result:
        test moved to derived table tests
        added test of BUG#1584
      mysql-test/r/subselect.result:
        test moved to derived table tests
      mysql-test/t/derived.test:
        test moved to derived table tests
        added test of BUG#1584
      mysql-test/t/subselect.test:
        test moved to derived table tests
      sql/item.cc:
        layout fix
      sql/sql_select.cc:
        correct table name assigned to temporary table field
      be4e254b
  4. 17 Oct, 2003 1 commit
    • unknown's avatar
      fixed deleting derived table tree after using (BUG#1536) · 6795b264
      unknown authored
      mysql-test/r/subselect.result:
        fixed drop table statement
        test for BUG#1536
      mysql-test/t/subselect.test:
        fixed drop table statement
        test for BUG#1536
      sql/sql_derived.cc:
        all tree of derived table should be deleted
      sql/sql_lex.cc:
        delete subtree method
      sql/sql_lex.h:
        delete subtree method
      6795b264
  5. 16 Oct, 2003 1 commit
    • unknown's avatar
      fixed support of used_tables() and const_item() in subqueries · e4b7aaac
      unknown authored
      (BUG#1444)
      
      
      mysql-test/r/subselect.result:
        BUG#1444 test
      mysql-test/t/subselect.test:
        BUG#1444 test
      sql/item.cc:
        storing used tables in Item_subselect
      sql/item_subselect.cc:
        fixed support of used_tables() and const_item() in subqueries
      sql/item_subselect.h:
        fixed support of used_tables() and const_item() in subqueries
      e4b7aaac
  6. 11 Oct, 2003 1 commit
  7. 10 Oct, 2003 1 commit
    • unknown's avatar
      samall optimisation (any independent query will not save data for rexecution) · 8b09f4b0
      unknown authored
      saving/restoring join_tab array (to save it of chnging by create_sort_index() before reexecuting)
      (BUG#1523)
      
      
      mysql-test/r/subselect.result:
        test of BUG#1523
      mysql-test/t/subselect.test:
        test of BUG#1523
      sql/sql_select.cc:
        samall optimisation (any independent query will not save data for rexecution)
        layout fix
        saving/restoring join_tab array (to save it of chnging by create_sort_index() before reexecuting)
      sql/sql_select.h:
        field for storing saved join_tab_array
      8b09f4b0
  8. 08 Oct, 2003 2 commits
    • unknown's avatar
      Some simple optimisation · 1db2b4e6
      unknown authored
      = ANY and <> ALL converted to (NOT) IN to get advantage of IN optimisation
      
      
      mysql-test/r/subselect.result:
        test of new optimisation
      mysql-test/t/subselect.test:
        test of new optimisation
      sql/mysql_priv.h:
        new function for subquery creation
      sql/sql_parse.cc:
        layout fix
        new function for subquery creation (convert some ALL/ANY to IN)
      sql/sql_yacc.yy:
        same code blocks replaced with function
      1db2b4e6
    • unknown's avatar
      fixed error handling in SET and DO operators (BUG#1484) · 0f81ecf5
      unknown authored
      mysql-test/r/subselect.result:
        test for BUG#1484
      mysql-test/t/subselect.test:
        layout fix
        test for BUG#1484
      sql/set_var.cc:
        value evaluating can fail (because of subqueries for example) => we should check result of operartion and prevent assigning incorrect value
      sql/sql_do.cc:
        DO should ignore all errors
      0f81ecf5
  9. 14 Sep, 2003 1 commit
  10. 13 Sep, 2003 1 commit
    • unknown's avatar
      "normal" warning in test suite disabled · 7eb9d41c
      unknown authored
      bad merge fixed
      
      
      mysql-test/t/isam.test:
        bad merge fixed
      mysql-test/t/lock_tables_lost_commit.test:
        "normal" warning in test suite disabled
      mysql-test/t/subselect.test:
        "normal" warning in test suite disabled
      7eb9d41c
  11. 09 Sep, 2003 1 commit
    • unknown's avatar
      Fix for a bug #1226. · b2a6994b
      unknown authored
      Happens when braces are used on a single select, which leads
      to the uninitialized global parameters structure.
      
      
      b2a6994b
  12. 08 Sep, 2003 1 commit
    • unknown's avatar
      removing additional IN subquery condition · d17cfa9c
      unknown authored
      fixed IN optimisation bug
      
      
      mysql-test/r/subselect.result:
        test of IN optimisation bug
      mysql-test/t/subselect.test:
        test of IN optimisation bug
      sql/item_subselect.cc:
        fixed IN optimisation bug
      sql/mysql_priv.h:
        constant for additional IN subquery condition detecting
      sql/mysqld.cc:
        constant for additional IN subquery condition detecting
      sql/sql_select.cc:
        removing additional IN subquery condition
      d17cfa9c
  13. 07 Sep, 2003 1 commit
    • unknown's avatar
      fixed row union processing · 57c9756b
      unknown authored
      mysql-test/r/subselect.result:
        row union test
      mysql-test/t/subselect.test:
        row union test
      57c9756b
  14. 28 Aug, 2003 1 commit
    • unknown's avatar
      reset() split in 2 function clear() & add() · 85f7a697
      unknown authored
      aggregate function reinitialization (if no rows was found) made with help of clear()
      (fixed BUG#860)
      
      
      mysql-test/r/subselect.result:
        test for BUG#860
      mysql-test/t/subselect.test:
        test for BUG#860
      sql/item_sum.cc:
        reset() replaced with clear()
      sql/item_sum.h:
        reset() replaced with clear()
        (reset now is just composition of clear() and add())
      sql/item_uniq.h:
        reset() replaced with clear()
      sql/sql_select.cc:
        removed NULL value assigment, now it will be done by clear() call
        function for clearing if there was not found any row in group
      sql/sql_select.h:
        function for clearing if there was not found any row in group
      85f7a697
  15. 23 Aug, 2003 1 commit
    • unknown's avatar
      fixed bug of lack of fix_fields call (after merge bugfix (SCRUM)) · 93afa26e
      unknown authored
      fixed bug in Item_sum
      fixed bug in dependence remover
      after merge fix
      
      
      mysql-test/r/subselect.result:
        after merge fix
      mysql-test/r/union.result:
        new test
      mysql-test/t/subselect.test:
        after merge fix
      mysql-test/t/union.test:
        new test
      sql/item.cc:
        fixed returned value
      sql/item.h:
        fixed flag dropper
        (I was not able to find Item whicj need more to be fix_fielded twice)
      sql/item_subselect.h:
        fixed initialisation
      sql/item_sum.cc:
        fixed absence of walk method of Item_sum
      sql/item_sum.h:
        fixed absence of walk method of Item_sum
      sql/mysql_priv.h:
        setup_fields reverter
      sql/sql_base.cc:
        setup_fields reverter
      sql/sql_derived.cc:
        fixed bug of lack of fix_fields call
      sql/sql_union.cc:
        fixed bug of lack of fix_fields call
      93afa26e
  16. 20 Aug, 2003 1 commit
    • unknown's avatar
      merge · 78f54936
      unknown authored
      mysql-test/r/subselect.result:
        correct result after merging with fixed Item_in_optimiser::fix_left()
      mysql-test/t/subselect.test:
        error code changed
      78f54936
  17. 18 Aug, 2003 1 commit
    • unknown's avatar
      After merge fixes · 2901c3b8
      unknown authored
      Use server character set if --default-character-set is not used
      Added convert_string() for more efficient alloc+character-set convert of strings
      
      
      BitKeeper/deleted/.del-convert.result~a3b56e1db6f498e9:
        Delete: mysql-test/r/convert.result
      BitKeeper/deleted/.del-convert.test~f4ceb743194dfe72:
        Delete: mysql-test/t/convert.test
      BitKeeper/deleted/.del-make_win_src_distribution.old~5c9ebdc4a852b43b:
        Delete: scripts/make_win_src_distribution.old
      client/mysql.cc:
        Use server character set if --default-character-set is not used
      client/mysqltest.c:
        Code cleanup (merge identical code)
        More debug messages
      heap/hp_create.c:
        After merge fix
      include/m_ctype.h:
        After merge fix
      include/my_global.h:
        Remove size_str (we already have size_s)
      include/mysql_com.h:
        After merge fix
      libmysql/libmysql.c:
        After merge fix
      libmysqld/Makefile.am:
        After merge fix
      mysql-test/r/auto_increment.result:
        After merge fix
      mysql-test/r/create.result:
        After merge fix
      mysql-test/r/ctype_latin1_de.result:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/drop.result:
        After merge fix
      mysql-test/r/fulltext.result:
        After merge fix
      mysql-test/r/func_gconcat.result:
        After merge fix
      mysql-test/r/func_str.result:
        After merge fix
      mysql-test/r/func_test.result:
        After merge fix
      mysql-test/r/grant.result:
        After merge fix
      mysql-test/r/group_by.result:
        After merge fix
      mysql-test/r/handler.result:
        After merge fix
      mysql-test/r/heap.result:
        After merge fix
      mysql-test/r/heap_btree.result:
        After merge fix
      mysql-test/r/heap_hash.result:
        After merge fix
      mysql-test/r/innodb.result:
        After merge fix
      mysql-test/r/insert.result:
        After merge fix
      mysql-test/r/insert_select.result:
        After merge fix
      mysql-test/r/join_outer.result:
        After merge fix
      mysql-test/r/key.result:
        After merge fix
      mysql-test/r/key_cache.result:
        After merge fix
      mysql-test/r/loaddata.result:
        After merge fix
      mysql-test/r/myisam.result:
        After merge fix
      mysql-test/r/null.result:
        After merge fix
      mysql-test/r/null_key.result:
        After merge fix
      mysql-test/r/order_by.result:
        After merge fix
      mysql-test/r/rpl_do_grant.result:
        After merge fix
      mysql-test/r/rpl_error_ignored_table.result:
        After merge fix
      mysql-test/r/rpl_ignore_grant.result:
        After merge fix
      mysql-test/r/rpl_loaddata.result:
        After merge fix
      mysql-test/r/rpl_log.result:
        After merge fix
      mysql-test/r/rpl_log_pos.result:
        After merge fix
      mysql-test/r/rpl_max_relay_size.result:
        After merge fix
      mysql-test/r/rpl_replicate_do.result:
        After merge fix
      mysql-test/r/rpl_reset_slave.result:
        After merge fix
      mysql-test/r/rpl_rotate_logs.result:
        After merge fix
      mysql-test/r/rpl_user_variables.result:
        After merge fix
      mysql-test/r/select.result:
        After merge fix
      mysql-test/r/select_safe.result:
        After merge fix
      mysql-test/r/subselect.result:
        After merge fix
      mysql-test/r/type_blob.result:
        After merge fix
      mysql-test/r/type_decimal.result:
        After merge fix
      mysql-test/r/type_float.result:
        After merge fix
      mysql-test/r/type_ranges.result:
        After merge fix
      mysql-test/r/type_time.result:
        After merge fix
      mysql-test/r/type_uint.result:
        After merge fix
      mysql-test/r/union.result:
        After merge fix
      mysql-test/r/warnings.result:
        After merge fix
      mysql-test/t/auto_increment.test:
        After merge fix
      mysql-test/t/case.test:
        After merge fix
      mysql-test/t/ctype_collate.test:
        After merge fix
      mysql-test/t/ctype_latin1_de.test:
        After merge fix
      mysql-test/t/drop.test:
        After merge fix
      mysql-test/t/func_in.test:
        After merge fix
      mysql-test/t/func_set.test:
        After merge fix
      mysql-test/t/func_str.test:
        After merge fix
      mysql-test/t/func_test.test:
        After merge fix
      mysql-test/t/grant.test:
        After merge fix
      mysql-test/t/group_by.test:
        After merge fix
      mysql-test/t/handler.test:
        After merge fix
      mysql-test/t/heap.test:
        After merge fix
      mysql-test/t/heap_btree.test:
        After merge fix
      mysql-test/t/heap_hash.test:
        After merge fix
      mysql-test/t/innodb.test:
        After merge fix
      mysql-test/t/insert_select.test:
        After merge fix
      mysql-test/t/key.test:
        After merge fix
      mysql-test/t/key_cache.test:
        After merge fix
      mysql-test/t/lock_tables_lost_commit-master.opt:
        After merge fix
      mysql-test/t/lock_tables_lost_commit.test:
        After merge fix
      mysql-test/t/myisam.test:
        After merge fix
      mysql-test/t/row.test:
        After merge fix
      mysql-test/t/subselect.test:
        After merge fix
      mysql-test/t/type_decimal.test:
        After merge fix
      mysql-test/t/type_ranges.test:
        After merge fix
      mysql-test/t/type_uint.test:
        After merge fix
      mysql-test/t/variables.test:
        After merge fix
      mysql-test/t/warnings.test:
        After merge fix
      scripts/make_win_src_distribution.sh:
        after merge fixes
      sql-common/client.c:
        After merge fix
        Change my_connect() to use poll()
        If character set is not given, use servers character set.
      sql/field.cc:
        After merge fix
        Don't give warnings when storing data in fields in optimizer.
      sql/ha_myisammrg.h:
        After merge fix
      sql/log.cc:
        After merge fix
      sql/log_event.cc:
        After merge fix
      sql/mysqld.cc:
        After merge fix
      sql/opt_range.cc:
        After merge fix
      sql/set_var.cc:
        Code cleanup
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/set_var.h:
        Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps
      sql/slave.cc:
        After merge fix
      sql/sql_acl.cc:
        After merge fix
        Code cleanup
      sql/sql_class.cc:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_class.h:
        Added convert_string() for more efficient alloc+character-set convert of strings
        Add cached flags to avoid calling mysql_charset_same() during parsing.
      sql/sql_handler.cc:
        After merge fix
      sql/sql_lex.h:
        After merge fix
      sql/sql_parse.cc:
        Optimize and fix memory reference errors reported by valgrind
      sql/sql_repl.cc:
        After merge fix
      sql/sql_yacc.yy:
        After merge fix
        Avoid calling mysql_charset_same() when parsing identifiers
      strings/ctype-latin1.c:
        Port latin_de conversion code from 4.0
      2901c3b8
  18. 12 Aug, 2003 2 commits
    • unknown's avatar
      after merge fix · 22422b78
      unknown authored
      22422b78
    • unknown's avatar
      optimisation of independent ALL/ANY with aggregate function (WL#1115) (SCRUM) · 964ffc34
      unknown authored
      mysql-test/r/subselect.result:
        test of new optimisation
      mysql-test/t/subselect.test:
        test of new optimisation
      sql/item_subselect.cc:
        special subselect to finding max/min of returned values
        optimisation of independent ALL/ANY with aggregate function
      sql/item_subselect.h:
        special subselect to finding max/min of returned values
      sql/sql_class.cc:
        class for collaction result for max/min subquery
      sql/sql_class.h:
        class for collaction result for max/min subquery
      964ffc34
  19. 11 Aug, 2003 1 commit
    • unknown's avatar
      fixed collation of Item_cache family (BUG#951) · 68f83391
      unknown authored
      mysql-test/r/subselect.result:
        test of collation
      mysql-test/t/subselect.test:
        test of collation
      sql/item.cc:
        coping collation in the cache
      sql/item.h:
        coping collation in the cache
      68f83391
  20. 09 Aug, 2003 1 commit
    • unknown's avatar
      fixed union unlocking problem (BUG#906) · 9b16dd89
      unknown authored
      mysql-test/r/subselect.result:
        test of union unlocking problem
      mysql-test/t/subselect.test:
        test of union unlocking problem
      sql/sql_union.cc:
        prohibit unlocking all tables by fake select execution
      9b16dd89
  21. 01 Aug, 2003 1 commit
  22. 30 Jul, 2003 1 commit
    • unknown's avatar
      Derivation attribute was not processed correctly · 53e4153d
      unknown authored
      by MAX/MIN in some cases:
      SELECT coercibility(max(s1)) from t1;
      
      Subselect collation and derivation was not processed
      correctly:
      
      create table a select (select s1 from t1);
      select * from t1 where s1 = (select s2 from t1);
      
      
      
      53e4153d
  23. 29 Jul, 2003 2 commits
    • unknown's avatar
      prevented finding references in item_list for non-SELECT st_select_lex · 668cd972
      unknown authored
      (fixed BUG#943)
      
      
      mysql-test/r/subselect.result:
        test for bug 943
      mysql-test/t/subselect.test:
        test for bug 943
      sql/item.cc:
        bool field changed with enum
        prevented finding references in item_list for non-SELECT st_select_lex
      sql/sql_lex.cc:
        bool field changed with enum
      sql/sql_lex.h:
        bool field changed with enum
      sql/sql_parse.cc:
        all subqueries and UNION parts marked as SELECT
      sql/sql_yacc.yy:
        bool field changed with enum
        PRIMARY SELECT command st_select_lex marked as SELECT
      668cd972
    • unknown's avatar
      count HAVING clause elements with select list elements, because agregate... · 0792c1c8
      unknown authored
      count HAVING clause elements with select list elements, because agregate function can be present in it (BUG#922)
      removerd unused loop_id
      
      
      mysql-test/r/subselect.result:
        test of BUG#922
      mysql-test/t/subselect.test:
        test of BUG#922
      sql/item.cc:
        removerd unused loop_id
        we need count HAVING clause elements, because agregate function can be present in it
      sql/item.h:
        removerd unused loop_id
      sql/item_subselect.cc:
        new name of field
      sql/sql_derived.cc:
        new name of field
      sql/sql_lex.cc:
        new name of field
      sql/sql_lex.h:
        new name of field
      sql/sql_select.cc:
        new name of field
      sql/sql_union.cc:
        new name of field
      0792c1c8
  24. 24 Jul, 2003 1 commit
    • unknown's avatar
      independent ALL/ANY subselect on top of WHERE clause (subselect without GROUP... · 9a3979e2
      unknown authored
      independent ALL/ANY subselect on top of WHERE clause (subselect without GROUP BY or aggregate functions) optimisation
      
      (SCRUM) (WL#1086)
      
      
      mysql-test/r/subselect.result:
        new optimisation tests
      mysql-test/t/subselect.test:
        new optimisation tests
      sql/item_cmpfunc.cc:
        new NOT
      sql/item_cmpfunc.h:
        new NOT
      sql/item_subselect.cc:
        independent ALL/ANY in top of WHERE clause optimisation
      sql/item_subselect.h:
        independent ALL/ANY in top of WHERE clause optimisation
      sql/item_sum.cc:
        prevent fixlields call for parameters of min/max if it is already done
      sql/sql_union.cc:
        removed debuging print
      sql/sql_yacc.yy:
        support of ALL optimisation
      9a3979e2
  25. 17 Jul, 2003 1 commit
    • unknown's avatar
      new optimisation for ref_null (SCRUM) (WL#818) · ed8be699
      unknown authored
      mysql-test/r/subselect.result:
        results of new optimisation
      mysql-test/t/subselect.test:
        results of new optimisation
      sql/item_cmpfunc.h:
        function type
      sql/item_func.h:
        function type
      sql/item_subselect.cc:
        new optimisation for ref_or_null
      sql/item_subselect.h:
        new optimisation for ref_or_null
      sql/sql_select.cc:
        new optimisation for ref_or_null
      sql/sql_select.h:
        item_subselect.cc need safe_index_read
      ed8be699
  26. 07 Jul, 2003 2 commits
    • unknown's avatar
      new IN subquery engine added for simple IN with non-primary index but without NULL returning · 210c4aba
      unknown authored
      (SCRUM) (part of WL#818)
      
      
      mysql-test/r/subselect.result:
        test of new engine
      mysql-test/t/subselect.test:
        test of new engine
      sql/item_subselect.cc:
        new engine added
        some common operation moved in separate method
      sql/item_subselect.h:
        new engine added
        some common operation moved in separate method
      sql/sql_select.cc:
        new engine added
        some common operation moved in separate method
      sql/sql_select.h:
        some common operation moved in separate method
      210c4aba
    • unknown's avatar
      Optimisation if simple IN subselect with primary index · 923dba86
      unknown authored
      (SCRUM) (part of WL#818)
      
      
      mysql-test/r/subselect.result:
        test of new optimisation
      mysql-test/t/subselect.test:
        test of new optimisation
      sql/item_subselect.cc:
        new engine for simple IN with primary index
      sql/item_subselect.h:
        new engine for simple IN with primary index
      sql/sql_lex.h:
        fixed typo
      sql/sql_select.cc:
        engine changing
        report_error can't be static, because it used in new engine
      sql/sql_select.h:
        new JT_ type (just for information in EXPLAIN statement)
        report_error can't be static, because it used in new engine
      923dba86
  27. 04 Jul, 2003 1 commit
  28. 28 Jun, 2003 2 commits
    • unknown's avatar
      fixed bug #745 · 1bf6de2c
      unknown authored
      (resolving fields of reduced subselect)
      
      
      mysql-test/r/subselect.result:
        test of bug #745
      mysql-test/t/subselect.test:
        test of bug #745
      sql/sql_union.cc:
        to get chance of outer resolved_fields resolve fields of result table as usual fileds
      1bf6de2c
    • unknown's avatar
      merging · 4d4ddfde
      unknown authored
      test moved to other bug 
      
      
      4d4ddfde
  29. 27 Jun, 2003 1 commit
  30. 26 Jun, 2003 1 commit
    • unknown's avatar
      cond_count moved to SELECT_LEX_NODE · 54cd790b
      unknown authored
      fixed BUG #726
      
      
      mysql-test/r/subselect.result:
        test of bug #726
      mysql-test/t/subselect.test:
        test of bug #726
      sql/item_cmpfunc.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/item_subselect.cc:
        fixed current_select pointer
      sql/sql_base.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_class.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_class.h:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_lex.cc:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_lex.h:
        cond_count moved to SELECT_LEX_NODE
      sql/sql_select.cc:
        cond_count moved to SELECT_LEX_NODE
      54cd790b
  31. 24 Jun, 2003 1 commit
    • unknown's avatar
      Fixed error handling to be able do not interrupt update (907) (SCRUM) · cd01f7cd
      unknown authored
      fixed bug of current select pointer in subselect execution
      fixed layuot
      
      
      mysql-test/r/subselect.result:
        test of update with IGNORE option and error in subselect
      mysql-test/t/subselect.test:
        test of update with IGNORE option and error in subselect
      sql/item_subselect.cc:
        fixed bug of current select pointer
      sql/mysqld.cc:
        error converting to warnings if hd->lex.current_select->no_error id true
        layout fixed
      sql/sql_lex.cc:
        initialization
      sql/sql_lex.h:
        flag which force converting errors to warnings
      sql/sql_select.cc:
        switch on error convering to warnings in select executing if IGNORE option present
      cd01f7cd
  32. 20 Jun, 2003 1 commit
    • unknown's avatar
      fixed BUG #679 · de5e96e4
      unknown authored
      outer resolved fields now do not marked as dependent if they is not really belong to outer SELECT
      one-letter variables name fixed
      
      
      mysql-test/r/subselect.result:
        test of bug 679
      mysql-test/t/subselect.test:
        test of bug 679
      sql/item.cc:
        outer resolved fields now do not marked as dependent if they is not really belong to outer SELECT
        one-letter variables name fixed
      de5e96e4
  33. 04 Jun, 2003 1 commit
    • unknown's avatar
      Added SQLSTATE to client/server protocol · b388eb00
      unknown authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      
      
      BitKeeper/etc/ignore:
        added libmysqld/sql_state.c
      client/mysql.cc:
        Added SQLSTATE to error messages
        Added new function put_error() to be able to clean up some old code.
      client/mysqltest.c:
        Write ERROR SQLSTATE for all errors
      dbug/dbug.c:
        Portability fixes
      include/m_string.h:
        Rename bmove_allign as bmove_align
      include/mysql.h:
        Added SQLSTATE (for embedded version)
      include/mysql_com.h:
        Send correct SQLSTATE for the error to the client
      libmysql/libmysql.c:
        Changed default error state to HY000
        Applied code cleanup patch
      libmysqld/Makefile.am:
        Added sql_state.cc
      libmysqld/libmysqld.c:
        Added sqlstate
      mysql-test/r/analyse.result:
        Updated results
      mysql-test/r/ansi.result:
        Updated results
      mysql-test/r/auto_increment.result:
        Updated results
      mysql-test/r/bdb-deadlock.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/comments.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/ctype_collate.result:
        Updated results
      mysql-test/r/delayed.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/err000001.result:
        Updated results
      mysql-test/r/explain.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/func_gconcat.result:
        Updated results
      mysql-test/r/func_system.result:
        Updated results
      mysql-test/r/grant_cache.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/heap.result:
        Updated results
      mysql-test/r/heap_btree.result:
        Updated results
      mysql-test/r/heap_hash.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/insert_update.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/lock.result:
        Updated results
      mysql-test/r/lock_multi.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/packet.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_log.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/select_safe.result:
        Updated results
      mysql-test/r/show_check.result:
        Updated results
      mysql-test/r/sql_mode.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/truncate.result:
        Updated results
      mysql-test/r/type_blob.result:
        Updated results
      mysql-test/r/type_decimal.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/type_ranges.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/t/ansi.test:
        Test of sql_mode
      mysql-test/t/derived.test:
        Updated results
      mysql-test/t/func_system.test:
        Make this independen of the MySQL server name
      mysql-test/t/lowercase_table.test:
        Cleanup
      mysql-test/t/olap.test:
        A lot of new tests
      mysql-test/t/sql_mode.test:
        More test for sql_mode
      mysql-test/t/subselect.test:
        Added a few new tests (to find a bug in the item_ref code)
      scripts/Makefile.am:
        Added mysql_fix_privilege_tables.sql
      scripts/mysql_fix_privilege_tables.sh:
        Totally new script.  This bascily just pipes mysql_fix_privilege_tables.sql through 'mysql' to 'mysqld'
      sql/Makefile.am:
        Added sql_state.cc
      sql/item.cc:
        Extended Item_field::eq() to be able to better match GROUP BY fields on the command line.
        Needed for ROLLUP
      sql/item.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/item_sum.cc:
        Moved copy_or_same() and some reset() functions from item_sum.h
        Needed to be able to access thd->mem_root.
      sql/item_sum.h:
        Moved some functions to item_sum.cc
        Added make_unique() for ROLLUP
      sql/item_uniq.h:
        Fixed return value
      sql/mysql_priv.h:
        Updated MODE flags
      sql/mysqld.cc:
        Added ANSI as it's own mode
        Moved charset_info variables here
        Cleaned up handler_count handling (for NT)
        Added table_alias_charset, for easier --lower-case-table-name handling
      sql/net_serv.cc:
        New comment
      sql/protocol.cc:
        Send SQLSTATE to client
      sql/set_var.cc:
        Better SQL_MODE handling (Setting complex options also sets sub options)
      sql/set_var.h:
        Better SQL_MODE handling
      sql/sql_base.cc:
        Make alias depend on --lower-case-table-names
        Make find_item_in_list also check database name
      sql/sql_cache.cc:
        Indentation cleanup
      sql/sql_list.h:
        Added safety assert
        Addes support of alloc without current_thd()
      sql/sql_prepare.cc:
        Update after prototype change
      sql/sql_select.cc:
        Added ROLLUP
      sql/sql_select.h:
        structures for rollup
      sql/sql_show.cc:
        Easier SQL_MODE handling
      sql/sql_string.cc:
        Move CHARSET_INFO to mysqld (to be together with all other global variables)
      sql/sql_string.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/sql_table.cc:
        Simpler --lower-case-table-name handling
      sql/sql_union.cc:
        Update after prototype change
      sql/sql_yacc.yy:
        ROLLUP
      sql/unireg.h:
        bmove_allign ->bmove_align
      strings/Makefile.am:
        Fix to be able to compile str_test.c
      strings/ctype.c:
        Removed empty lines
      strings/str_test.c:
        Added test of bmove_align
      strings/strings-x86.s:
        Faster bmove_align, bmove_upp and strmake
      strings/strings.asm:
        move_allg
      b388eb00
  34. 30 May, 2003 1 commit
    • unknown's avatar
      priventing allocation unused Item_buff (alloc_group_fields()) · e263b814
      unknown authored
      mysql-test/r/subselect.result:
        new test for code coverage
      mysql-test/t/subselect.test:
        new test for code coverage
      sql/sql_select.cc:
        priventing allocation unused Item_buff
      sql/sql_select.h:
        priventing allocation unused Item_buff
      e263b814
  35. 28 May, 2003 1 commit
    • unknown's avatar
      added mem_root switching for subselect if it is necessary · a100c0e9
      unknown authored
      (bug #518 fixed)
      
      
      mysql-test/r/subselect.result:
        test of bug #518
      mysql-test/t/subselect.test:
        test of bug #518
      sql/item_subselect.cc:
        test and switch mem_root if it is necessary
        exec() - wrapper around engine->exec() to test and switch mem_root if necessary
      sql/item_subselect.h:
        added storing THD for mem_root testinmg & switching
        exec() - wrapper around engine->exec() to test and switch mem_root if necessary
      a100c0e9