1. 13 Nov, 2006 6 commits
    • unknown's avatar
      Merge mysql.com:/home/hf/work/embt/my50-embt · 298aff12
      unknown authored
      into  mysql.com:/home/hf/work/embt/my51-embt
      
      
      libmysqld/lib_sql.cc:
        Auto merged
      BitKeeper/deleted/.del-bdb.result:
        Auto merged
      BitKeeper/deleted/.del-bdb.test:
        Auto merged
      mysql-test/r/insert_select.result:
        Auto merged
      mysql-test/r/join.result:
        Auto merged
      mysql-test/t/backup.test:
        Auto merged
      mysql-test/t/delayed.test:
        Auto merged
      mysql-test/t/join.test:
        Auto merged
      mysql-test/t/status.test:
        Auto merged
      mysql-test/t/trigger.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      mysql-test/mysql-test-run.pl:
        merging
      mysql-test/r/flush_block_commit.result:
        SCCS merged
      mysql-test/r/insert.result:
        merging
      mysql-test/t/innodb.test:
        merging
      mysql-test/t/insert.test:
        merging
      sql/share/errmsg.txt:
        merging
      298aff12
    • unknown's avatar
      several fixes to make tests pass in embedded-server mode · ea1f7e4b
      unknown authored
      
      libmysqld/lib_sql.cc:
        check for bootstrap added
      mysql-test/include/federated.inc:
        disabled in embedded
      mysql-test/mysql-test-run.pl:
        we disable ssh in embedded server
      mysql-test/r/bdb.result:
        part moved to bdb_notembedded as it uses binlog
      mysql-test/r/flush_block_commit.result:
        part moved to flush_block_commit_notembedded
      mysql-test/r/insert.result:
        part moved to insert_notembedded as delayed works differently in embedded server
      mysql-test/r/insert_select.result:
        part moved to insert_notembedded as GRANTS usually disabled in embedded server
      mysql-test/r/join.result:
        access rights hidden in result
      mysql-test/t/backup.test:
        now available in embedded server
      mysql-test/t/bdb.test:
        part moved to bdb_notembedded as it uses binlog
      mysql-test/t/delayed.test:
        code trimmed
      mysql-test/t/execution_constants.test:
        skipped in embedded-server mode
      mysql-test/t/flush_block_commit.test:
        moved to flush_block_commit_notembedded
      mysql-test/t/information_schema_db.test:
        skipped in embedded-server
      mysql-test/t/innodb.test:
        directories replaced to be embedded-server compliant
      mysql-test/t/insert.test:
        part moved to insert_notembedded
      mysql-test/t/insert_select.test:
        part moved to insert_notembedded
      mysql-test/t/join.test:
        access rights hidden
      mysql-test/t/status.test:
        skipped in embedded server
      mysql-test/t/trigger.test:
        directories replaced to be embedded-server compliant
      sql/item_strfunc.cc:
        extra contexts not needed whan access checks disabled
      sql/share/errmsg.txt:
        bigger paths reserved to prevent test's fails
      mysql-test/r/bdb_notembedded.result:
        ***MISSING WEAVE***
      mysql-test/r/flush_block_commit_notembedded.result:
        added
      mysql-test/r/insert_notembedded.result:
        added
      mysql-test/t/bdb_notembedded.test:
        ***MISSING WEAVE***
      mysql-test/t/flush_block_commit_notembedded.test:
        added
      mysql-test/t/insert_notembedded.test:
        added
      ea1f7e4b
    • unknown's avatar
      Merge mysql.com:/home/hf/work/embt/my41-embt · 71419317
      unknown authored
      into  mysql.com:/home/hf/work/embt/my50-embt
      
      
      mysql-test/t/delayed.test:
        Auto merged
      71419317
    • unknown's avatar
      delayed.test fixed · f660dfa6
      unknown authored
      
      mysql-test/t/delayed.test:
        shouldn't be tested in embedded server
      f660dfa6
    • unknown's avatar
      Merge mysql.com:/home/hf/work/embt/my41-embt · 002fefab
      unknown authored
      into  mysql.com:/home/hf/work/embt/my50-embt
      
      
      sql/item_func.cc:
        Auto merged
      mysql-test/t/innodb.test:
        merging
      libmysqld/lib_sql.cc:
        SCCS merged
      002fefab
    • unknown's avatar
      embedded-mode tests fixed · 28f6e132
      unknown authored
      
      libmysqld/examples/test-run:
        mysql_embedded should be run here
      libmysqld/lib_sql.cc:
        thd->real_id setup added
        bootstrap check added
      mysql-test/t/innodb.test:
        paths can be different in embedded server - replace_result added
      sql/item_func.cc:
        we should compare real_id-s in embedded server
      28f6e132
  2. 10 Nov, 2006 1 commit
  3. 09 Nov, 2006 5 commits
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.1-opt · 463e9409
      unknown authored
      into  mysql.com:/home/hf/work/8663/my51-8663
      
      
      mysql-test/r/type_newdecimal.result:
        Auto merged
      mysql-test/t/type_newdecimal.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      463e9409
    • unknown's avatar
      Merge macbook.gmz:/Users/kgeorge/mysql/work/mem-test-5.0-opt · 13245571
      unknown authored
      into  macbook.gmz:/Users/kgeorge/mysql/work/mem-test-5.1-opt
      
      
      Makefile.am:
        ported the test-force-mem target to 5.1
      13245571
    • unknown's avatar
      merging · bffe8b8a
      unknown authored
      
      mysql-test/r/subselect3.result:
        'filtered' column added
      mysql-test/r/udf.result:
        'filtered' column added
      bffe8b8a
    • unknown's avatar
      merging · 4b60bdc9
      unknown authored
      
      mysql-test/r/subselect.result:
        result fixed
      4b60bdc9
    • unknown's avatar
      merging · 0119e00f
      unknown authored
      
      mysql-test/t/disabled.def:
        #22457 isn't fixed in 5.1 after merging from 5.0
      0119e00f
  4. 08 Nov, 2006 5 commits
    • unknown's avatar
      merging · 1df20594
      unknown authored
      
      sql/field.cc:
        here we can get negative values
      1df20594
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mysql-5.0.clean · 90d14d50
      unknown authored
      into  mysql.com:/home/hf/work/mysql-5.1.clean
      
      
      include/my_time.h:
        Auto merged
      mysql-test/r/func_group.result:
        Auto merged
      mysql-test/r/gis-rtree.result:
        Auto merged
      mysql-test/r/order_by.result:
        Auto merged
      mysql-test/r/subselect.result:
        Auto merged
      mysql-test/r/type_datetime.result:
        Auto merged
      mysql-test/r/udf.result:
        Auto merged
      mysql-test/t/func_group.test:
        Auto merged
      mysql-test/t/gis-rtree.test:
        Auto merged
      mysql-test/t/type_datetime.test:
        Auto merged
      mysql-test/t/udf.test:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      sql/filesort.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_cmpfunc.cc:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/item_subselect.h:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      sql/item_sum.h:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/my_decimal.cc:
        Auto merged
      sql/my_decimal.h:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/records.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql-common/my_time.c:
        Auto merged
      sql/table.cc:
        Auto merged
      sql/table.h:
        Auto merged
      mysql-test/r/type_newdecimal.result:
        SCCS merged
      mysql-test/t/type_newdecimal.test:
        merging
      sql/item.cc:
        merging
      sql/item_subselect.cc:
        SCCS merged
      sql/item_timefunc.h:
        merging
      sql/sql_lex.cc:
        SCCS merged
      sql/sql_select.h:
        merging
      90d14d50
    • unknown's avatar
      Merge macbook.gmz:/Users/kgeorge/mysql/work/mem-test-4.1-opt · f399d656
      unknown authored
      into  macbook.gmz:/Users/kgeorge/mysql/work/mem-test-5.0-opt
      
      
      Makefile.am:
        merge fixes
      f399d656
    • unknown's avatar
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 3e0139d9
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.0-bug8804-pfix
      
      
      3e0139d9
  5. 07 Nov, 2006 8 commits
    • unknown's avatar
      BUG#24056: Crash in subquery: · 1d2e456f
      unknown authored
      Don't assume that condition that was pushed down into subquery has 
      produced exactly one KEY_FIELD element - it could produce several or
      none at all, handle all of those cases.
      
      
      1d2e456f
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 9c73436b
      unknown authored
      into  rakia.gmz:/home/kgeorge/mysql/autopush/B11032-5.0-opt
      
      
      9c73436b
    • unknown's avatar
      Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 878b4a3a
      unknown authored
      into  mysql.com:/home/hf/work/mysql-5.0.clean
      
      
      878b4a3a
    • unknown's avatar
      bug fixed · 955e0b13
      unknown authored
      
      sql/field.cc:
        datatime length is 19, not 12
      955e0b13
    • unknown's avatar
      Merge macbook.gmz:/Users/kgeorge/mysql/work/B11032-4.1-opt · 5ad3ed8c
      unknown authored
      into  macbook.gmz:/Users/kgeorge/mysql/work/B11032-5.0-opt
      
      
      mysql-test/r/subselect.result:
        merge fixes
      mysql-test/t/subselect.test:
        merge fixes
      sql/item_subselect.cc:
        merge fixes
      sql/item_subselect.h:
        merge fixes
      5ad3ed8c
    • unknown's avatar
      Bug #11032: getObject() returns a String for a sub-query of type datetime · 5af4fd25
      unknown authored
       - When returning metadata for scalar subqueries the actual type of the
         column was calculated based on the value type, which limits the actual
         type of a scalar subselect to the set of (currently) 3 basic types : 
         integer, double precision or string. This is the reason that columns
         of types other then the basic ones (e.g. date/time) are reported as
         being of the corresponding basic type.
         Fixed by storing/returning information for the column type in addition
         to the result type.
      
      
      mysql-test/r/subselect.result:
        Bug #11032: getObject() returns a String for a sub-query of type datetime
         - test case
      mysql-test/t/subselect.test:
        Bug #11032: getObject() returns a String for a sub-query of type datetime
         - test case
      sql/item_subselect.cc:
        Bug #11032: getObject() returns a String for a sub-query of type datetime
         - store and return the field type as well in addition to result type for 
           single row subqueries
      sql/item_subselect.h:
        Bug #11032: getObject() returns a String for a sub-query of type datetime
         - store and return the field type as well in addition to result type for 
           single row subqueries
      5af4fd25
    • unknown's avatar
      item.cc: · c0487fb9
      unknown authored
        merge fixes
      
      
      sql/item.cc:
        merge fixes
      c0487fb9
    • unknown's avatar
      Merge dl145s.mysql.com:/data/bk/team_tree_merge/mysql-4.1-opt · 4d37f9b5
      unknown authored
      into  dl145s.mysql.com:/data/bk/team_tree_merge/MERGE/mysql-5.0-opt
      
      
      sql/item.cc:
        Auto merged
      mysql-test/r/order_by.result:
        SCCS merged
      4d37f9b5
  6. 06 Nov, 2006 6 commits
  7. 05 Nov, 2006 1 commit
    • unknown's avatar
      merging · 7b126a91
      unknown authored
      
      mysql-test/r/gis-rtree.result:
        test result fixed
      7b126a91
  8. 03 Nov, 2006 1 commit
    • unknown's avatar
      Bug #22457: Column alias in ORDER BY works, but not if in an expression · c095f98f
      unknown authored
       The parser is allocating Item_field for references by name in ORDER BY
       expressions. Such expressions however may point not only to Item_field 
       in the select list (or to a table column) but also to an arbitrary Item. 
       This causes Item_field::fix_fields to throw an error about missing 
       column.
       The fix substitutes Item_field for the reference with an Item_ref when 
       not pointing to Item_field.
      
      
      mysql-test/r/order_by.result:
        Bug #22457: Column alias in ORDER BY works, but not if in an expression
         - test case
      mysql-test/t/order_by.test:
        Bug #22457: Column alias in ORDER BY works, but not if in an expression
         - test case
      sql/item.cc:
        Bug #22457: Column alias in ORDER BY works, but not if in an expression
         - transform the Item_field made by the parser into Item_ref if it 
           doesn't point to Item_field and it is in allowed context
      c095f98f
  9. 01 Nov, 2006 6 commits
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/mysql-5.0-opt · 0e69c252
      unknown authored
      into  rurik.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-bug21727
      
      
      mysql-test/r/subselect.result:
        Auto merged
      mysql-test/t/subselect.test:
        Auto merged
      sql/filesort.cc:
        Auto merged
      sql/item_subselect.h:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/records.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      0e69c252
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.1-opt · 022da394
      unknown authored
      into  mysql.com:/home/hf/work/21790/my51-21790
      
      
      mysql-test/t/gis-rtree.test:
        Auto merged
      sql/handler.cc:
        Auto merged
      mysql-test/r/gis-rtree.result:
        merging
      022da394
    • unknown's avatar
      Merge mysql.com:/home/hf/work/21790/my50-21790 · c5453a83
      unknown authored
      into  mysql.com:/home/hf/work/21790/my51-21790
      
      
      mysql-test/r/gis-rtree.result:
        Auto merged
      sql/handler.cc:
        Auto merged
      c5453a83
    • unknown's avatar
      Merge mysql.com:/home/hf/work/19491/my50-19491 · bec1973e
      unknown authored
      into  mysql.com:/home/hf/work/mysql-5.0.19491
      
      
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      bec1973e
    • unknown's avatar
      test result fixed · d922d5b6
      unknown authored
      d922d5b6
    • unknown's avatar
      Fixed bug #21727. · 2a7cf59f
      unknown authored
      This is a performance issue for queries with subqueries evaluation
      of which requires filesort.
      Allocation of memory for the sort buffer at each evaluation of a
      subquery may take a significant amount of time if the buffer is rather big.
      With the fix we allocate the buffer at the first evaluation of the
      subquery and reuse it at each subsequent evaluation.
      
      
      mysql-test/r/subselect.result:
        Added a test case for bug #21727.
      mysql-test/t/subselect.test:
        Added a test case for bug #21727.
      sql/item_subselect.h:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added an implementation for Item_subselect::is_uncacheable()
        returning TRUE if the engine if the subselect is uncacheable.
      sql/mysql_priv.h:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added a new boolean parameter to the filesort_free_buffers procedure.
        If the value of this parameter is TRUE the procedure frees the sort_keys
        buffpek buffers.
      sql/records.cc:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added a new boolean parameter to the filesort_free_buffers procedure.
        If the value of this parameter is TRUE the procedure frees the sort_keys
        buffpek buffers.
      sql/sql_base.cc:
        Fixed bug #21727.
        Made sure that st_table::pos_in_table_list would be always initialized.
      sql/sql_select.cc:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added a new boolean parameter to the filesort_free_buffers procedure.
        If the value of this parameter is TRUE the procedure frees the sort_keys
        buffpek buffers.
      sql/sql_show.cc:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added a new boolean parameter to the filesort_free_buffers procedure.
        If the value of this parameter is TRUE the procedure frees the sort_keys
        buffpek buffers.
      sql/sql_table.cc:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Cleanup.
      sql/table.cc:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added st_table_list::in_subselect() returning for a table the subselect that 
        contains the FROM list this table is taken from (if there is any).
      sql/table.h:
        Fixed bug #21727.
        This is a performance issue for queries with subqueries evaluation
        of which requires filesort.
        Added fields for sort_keys and buffpek buffers to the FILESORT_INFO structure.
      2a7cf59f
  10. 31 Oct, 2006 1 commit