An error occurred fetching the project authors.
  1. 02 Nov, 2003 2 commits
    • unknown's avatar
      fixed BUG#1645 · 31e42be6
      unknown authored
        all calls of fix_fields() are inspected
      (copy of cset which I lost in accidatly tree delete)
      
      
      mysql-test/r/subselect.result:
        test of BUG#1645
      mysql-test/t/subselect.test:
        test of BUG#1645
      sql/item_subselect.cc:
        removed passing left_expr through parameters, because it present in class fields
        fixed fix_fields() call
      sql/item_subselect.h:
        removed passing left_expr through parameters, because it present in class fields
      sql/set_var.cc:
        comments added
      sql/sql_select.cc:
        fixed BUG#1645 (thd can be used in fix_fields of subqueries)
      31e42be6
    • unknown's avatar
      fixed locking problem with innodb & subqueries (BUG#1708) · 9b03f17e
      unknown authored
      tests with innodb moved to separate file
      
      
      mysql-test/r/subselect.result:
        tests with innodb moved to separate file
      mysql-test/t/subselect.test:
        tests with innodb moved to separate file
        test for BUG#1708
      sql/sql_select.cc:
        it is better to check simople variable (full) first
        fixed locking problem with innodb & subqueries (BUG#1708)
      9b03f17e
  2. 26 Oct, 2003 1 commit
    • unknown's avatar
      fixed ALL/ANY optimisation with union (BUG#1668) · 4d68a0db
      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
      4d68a0db
  3. 23 Oct, 2003 1 commit
  4. 19 Oct, 2003 1 commit
    • unknown's avatar
      correct table name assigned to temporary table field: · 468e6f85
      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
      468e6f85
  5. 17 Oct, 2003 1 commit
    • unknown's avatar
      fixed deleting derived table tree after using (BUG#1536) · dd9c388a
      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
      dd9c388a
  6. 16 Oct, 2003 1 commit
    • unknown's avatar
      fixed support of used_tables() and const_item() in subqueries · 36fc55fb
      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
      36fc55fb
  7. 10 Oct, 2003 1 commit
    • unknown's avatar
      samall optimisation (any independent query will not save data for rexecution) · 972fc0f9
      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
      972fc0f9
  8. 08 Oct, 2003 2 commits
    • unknown's avatar
      Some simple optimisation · 302744f1
      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
      302744f1
    • unknown's avatar
      fixed error handling in SET and DO operators (BUG#1484) · 4fcc5a7f
      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
      4fcc5a7f
  9. 06 Oct, 2003 2 commits
    • unknown's avatar
      fixed error names · b94300ab
      unknown authored
      mysql-test/r/row.result:
        fixed error message as it was suggested by Peter Gulutzan
      mysql-test/r/subselect.result:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/czech/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/danish/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/dutch/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/english/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/estonian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/french/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/german/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/greek/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/hungarian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/italian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/japanese/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/korean/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/norwegian-ny/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/norwegian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/polish/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/portuguese/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/romanian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/russian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/serbian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/slovak/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/spanish/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/swedish/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      sql/share/ukrainian/errmsg.txt:
        fixed error message as it was suggested by Peter Gulutzan
      b94300ab
    • unknown's avatar
      fix error messages · 1385d26e
      unknown authored
      fix derived inside subqueries
      
      
      mysql-test/r/subselect.result:
        error tex changes whi i forgot to commit
      mysql-test/t/derived.test:
        code changing
      sql/sql_yacc.yy:
        allow derived inside subselects
      1385d26e
  10. 30 Sep, 2003 1 commit
  11. 20 Sep, 2003 1 commit
  12. 14 Sep, 2003 2 commits
  13. 13 Sep, 2003 1 commit
    • unknown's avatar
      Fixes for OPTION_FOUND_ROWS in UNION's · e08cbd11
      unknown authored
      mysql-test/r/subselect.result:
        A warning added to subselect test due to the recent changes.
        
        UNION in sub-select returns the empty set, which is why this warning is
        a mistery to me.
      mysql-test/r/union.result:
        two changes.
        
        First one is due to the proper handling of LIMIT offset, limit in 
        UNION without all.
        
        Second is a change in behaviour due to the fact that ORDER by in a 
        UNION without braces is not now applicable to the last SELECT node.
        
        It can not be applied until one bug is fixed (after my vacation).
        
        Should be documented.
      e08cbd11
  14. 09 Sep, 2003 2 commits
    • unknown's avatar
      after merge fix · 886f29fc
      unknown authored
      886f29fc
    • unknown's avatar
      Fix for a bug #1226. · 6bc438e3
      unknown authored
      Happens when braces are used on a single select, which leads
      to the uninitialized global parameters structure.
      
      6bc438e3
  15. 08 Sep, 2003 1 commit
    • unknown's avatar
      removing additional IN subquery condition · c33c0248
      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
      c33c0248
  16. 07 Sep, 2003 1 commit
    • unknown's avatar
      fixed row union processing · 27c164bd
      unknown authored
      mysql-test/r/subselect.result:
        row union test
      mysql-test/t/subselect.test:
        row union test
      27c164bd
  17. 28 Aug, 2003 1 commit
    • unknown's avatar
      reset() split in 2 function clear() & add() · 0eeb472c
      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
      0eeb472c
  18. 26 Aug, 2003 1 commit
  19. 23 Aug, 2003 1 commit
    • unknown's avatar
      fixed bug of lack of fix_fields call (after merge bugfix (SCRUM)) · 07b50407
      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
      07b50407
  20. 20 Aug, 2003 1 commit
    • unknown's avatar
      merge · 0bd2c7e2
      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
      0bd2c7e2
  21. 18 Aug, 2003 1 commit
    • unknown's avatar
      After merge fixes · 89ad93a8
      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
      89ad93a8
  22. 12 Aug, 2003 2 commits
    • unknown's avatar
      after merge fix · 3f20ea74
      unknown authored
      3f20ea74
    • unknown's avatar
      optimisation of independent ALL/ANY with aggregate function (WL#1115) (SCRUM) · 4a36d2ad
      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
      4a36d2ad
  23. 11 Aug, 2003 1 commit
    • unknown's avatar
      fixed collation of Item_cache family (BUG#951) · 086d2b75
      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
      086d2b75
  24. 09 Aug, 2003 1 commit
    • unknown's avatar
      fixed union unlocking problem (BUG#906) · 6640365c
      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
      6640365c
  25. 07 Aug, 2003 1 commit
    • unknown's avatar
      fixed bug in used_tables() report of left expression of IN subquery · c777dc6d
      unknown authored
      fixed number of rows of external field reported to optimizer
      added check of choosen key (checked left expression tag)
      (SCRUM fix for simple IN optimisation)
      
      
      mysql-test/r/subselect.result:
        new EXPLAIN results ufter fixing used_tables() of Item_cache
      sql/item_cmpfunc.cc:
        fixed used_tables asignment
      sql/item_subselect.cc:
        added left expression referenca tag
      sql/item_subselect.h:
        fixed layout
      sql/mysql_priv.h:
        left expression reference tag
      sql/mysqld.cc:
        left expression reference tag
      sql/sql_select.cc:
        checked left expression reference tag
        fixed number of rows in outer reference (it should be constant)
      c777dc6d
  26. 30 Jul, 2003 1 commit
    • unknown's avatar
      Derivation attribute was not processed correctly · c785f098
      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);
      
      
      c785f098
  27. 29 Jul, 2003 2 commits
    • unknown's avatar
      prevented finding references in item_list for non-SELECT st_select_lex · 3590612c
      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
      3590612c
    • unknown's avatar
      count HAVING clause elements with select list elements, because agregate... · 5cd3915f
      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
      5cd3915f
  28. 24 Jul, 2003 2 commits
    • unknown's avatar
      added warning about external fields resolving to EXPLAIN command · 2ffaad0a
      unknown authored
      (SCRUM) (WL#1053)
      
      
      include/mysqld_error.h:
        new warning
      mysql-test/r/subselect.result:
        new warning
      sql/item.cc:
        warning for external fields resolving
      sql/share/czech/errmsg.txt:
        new warning
      sql/share/danish/errmsg.txt:
        new warning
      sql/share/dutch/errmsg.txt:
        new warning
      sql/share/english/errmsg.txt:
        new warning
      sql/share/estonian/errmsg.txt:
        new warning
      sql/share/french/errmsg.txt:
        new warning
      sql/share/german/errmsg.txt:
        new warning
      sql/share/greek/errmsg.txt:
        new warning
      sql/share/hungarian/errmsg.txt:
        new warning
      sql/share/italian/errmsg.txt:
        new warning
      sql/share/japanese/errmsg.txt:
        new warning
      sql/share/korean/errmsg.txt:
        new warning
      sql/share/norwegian-ny/errmsg.txt:
        new warning
      sql/share/norwegian/errmsg.txt:
        new warning
      sql/share/polish/errmsg.txt:
        new warning
      sql/share/portuguese/errmsg.txt:
        new warning
      sql/share/romanian/errmsg.txt:
        new warning
      sql/share/russian/errmsg.txt:
        new warning
      sql/share/serbian/errmsg.txt:
        new warning
      sql/share/slovak/errmsg.txt:
        new warning
      sql/share/spanish/errmsg.txt:
        new warning
      sql/share/swedish/errmsg.txt:
        new warning
      sql/share/ukrainian/errmsg.txt:
        new warning
      2ffaad0a
    • unknown's avatar
      independent ALL/ANY subselect on top of WHERE clause (subselect without GROUP... · afb97542
      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
      afb97542
  29. 17 Jul, 2003 1 commit
    • unknown's avatar
      new optimisation for ref_null (SCRUM) (WL#818) · 7d055886
      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
      7d055886
  30. 07 Jul, 2003 2 commits
    • unknown's avatar
      new IN subquery engine added for simple IN with non-primary index but without NULL returning · 06b048f0
      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
      06b048f0
    • unknown's avatar
      Optimisation if simple IN subselect with primary index · 0383e793
      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
      0383e793
  31. 30 Jun, 2003 1 commit
    • unknown's avatar
      Remove FORCE_INIT_OF_VARS when compiling for valgrind/purify to spot wrong LINT_INIT() options · 94d05b12
      unknown authored
      Fixed bug in ALTER TABLE ... MODIFY integer-column
      Added ref_or_null optimization (needed for subqueries)
      
      
      BUILD/compile-pentium-valgrind-max:
        Remove FORCE_INIT_OF_VARS to spot wrong LINT_INIT() options
      mysql-test/r/distinct.result:
        Update of test results (new optimizer)
      mysql-test/r/null_key.result:
        Update after ref_or_null optimization
      mysql-test/r/subselect.result:
        Update after ref_or_null optimization
      mysql-test/t/null_key.test:
        New tests for ref_or_null optimization
      sql/sql_select.cc:
        Added ref_or_null optimization
        Optimized find_best_combinations() and read-functions
      sql/sql_select.h:
        Added ref_or_null optimization
      sql/sql_yacc.yy:
        Fixed bug in ALTER TABLE ... MODIFY integer-column
      sql/table.cc:
        Safety fix for ALTER TABLE .. MODIFY
      sql/unireg.cc:
        Safety fix for ALTER TABLE .. MODIFY
      94d05b12