1. 29 Nov, 2006 4 commits
  2. 28 Nov, 2006 4 commits
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 852d3780
      unknown authored
      into  rakia.gmz:/home/kgeorge/mysql/autopush/B24156-5.0-opt
      
      
      852d3780
    • unknown's avatar
      Bug#24156: Loose index scan not used with CREATE TABLE ...SELECT and similar · 762f4ac1
      unknown authored
                 statements
      Currently the optimizer evaluates loose index scan only for top-level SELECT
      statements
      Extend loose index scan applicability by :
       - Test the applicability of loose scan for each sub-select, instead of the
         whole query. This change enables loose index scan for sub-queries.
       - allow non-select statements with SELECT parts (like, e.g. 
         CREATE TABLE .. SELECT ...) to use loose index scan.
      
      
      mysql-test/r/group_min_max.result:
        Bug#24156: Loose index scan not used with CREATE TABLE ...SELECT and similar
                   statements
         - test case
      mysql-test/t/group_min_max.test:
        Bug#24156: Loose index scan not used with CREATE TABLE ...SELECT and similar
                   statements
         - test case
      sql/opt_range.cc:
        Bug#24156: Loose index scan not used with CREATE TABLE ...SELECT and similar
                   statements
         - loose index scan will be tried over the current subselect 
           (lex->current_select) instead of the whole query (lex->select_lex).
         - allow non-select statements with SELECT parts (like, e.g. 
           CREATE TABLE .. SELECT ...) to use loose index scan.
      762f4ac1
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · bce65bf4
      unknown authored
      into  rakia.gmz:/home/kgeorge/mysql/autopush/B11927-5.0-opt
      
      
      mysql-test/r/func_gconcat.result:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item.h:
        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/sql_string.h:
        Auto merged
      bce65bf4
    • unknown's avatar
      BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0) · 9221a548
      unknown authored
       When implicitly converting string fields to numbers the 
       string-to-number conversion error was not sent to the client.
       Added code to send the conversion error as warning.
       
       We also need to prevent generation of warnings from the places
       where val_xxx() methods are called for the sole purpose of updating
       the Item::null_value flag.
       To achieve that a special function is added (and called) : 
       update_null_value(). This function will set the no_errors flag and
       will call val_xxx(). The warning generation in Field_string::val_xxx()
       will use the flag when generating the conversion warnings. 
      
      
      mysql-test/r/compare.result:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - non-convertible strings in arithmetic operations
      mysql-test/r/func_gconcat.result:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - non-convertible strings in arithmetic operations
      mysql-test/r/func_group.result:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - non-convertible strings in arithmetic operations
      mysql-test/r/type_varchar.result:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - test case
      mysql-test/t/type_varchar.test:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - test case
      sql/field.cc:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - send conversion warning to the client
      sql/item.cc:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - send conversion warning to the client
      sql/item.h:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - added a special function to explicitly update the null_value
      sql/item_func.h:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - added a special function to explicitly update the null_value
      sql/item_subselect.h:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - added a special function to explicitly update the null_value
      sql/item_sum.cc:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - added a special function to explicitly update the null_value
      sql/item_sum.h:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - added a special function to explicitly update the null_value
      sql/sql_string.h:
        BUG#11927: Warnings shown for CAST( chr as signed) but not (chr + 0)
         - send conversion warning to the client
      9221a548
  3. 27 Nov, 2006 1 commit
    • unknown's avatar
      Bug#17254: Error for DEFINER security on VIEW provides too much info · af1b3da5
      unknown authored
      If a view was created with the DEFINER security and later the definer user
      was dropped then a SELECT from the view throws the error message saying that
      there is no definer user is registered. This is ok for a root but too much
      for a mere user.
      
      Now the st_table_list::prepare_view_securety_context() function reveals
      the absence of the definer only to a superuser and throws the 'access denied'
      error to others.
      
      
      mysql-test/t/view_grant.test:
        Added a test case for bug#17254: Error for DEFINER security on VIEW provides too much info
      mysql-test/r/view_grant.result:
        Added a test case for bug#17254: Error for DEFINER security on VIEW provides too much info
      sql/table.cc:
        Bug#17254: Error for DEFINER security on VIEW provides too much info
        Now the st_table_list::prepare_view_securety_context() function reveals
        the absence of the definer only to a superuser and throws the 'access denied'
        error to others.
      af1b3da5
  4. 21 Nov, 2006 2 commits
  5. 19 Nov, 2006 2 commits
  6. 17 Nov, 2006 4 commits
    • unknown's avatar
      ABI fix · a3d04155
      unknown authored
      
      include/mysql_h.ic:
        this one should actually be removed from the ABI
      a3d04155
    • unknown's avatar
      merging · 3ebdcee5
      unknown authored
      3ebdcee5
    • unknown's avatar
      merging · bde03bce
      unknown authored
      bde03bce
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0-opt · 96ad04de
      unknown authored
      into  mysql.com:/home/hf/work/mysql-5.0-0mrg
      
      
      BitKeeper/deleted/.del-mysql_client.test:
        Auto merged
      include/mysql.h:
        Auto merged
      libmysqld/lib_sql.cc:
        Auto merged
      mysql-test/r/order_by.result:
        Auto merged
      mysql-test/r/query_cache.result:
        Auto merged
      mysql-test/r/subselect.result:
        Auto merged
      mysql-test/r/type_newdecimal.result:
        Auto merged
      mysql-test/t/flush.test:
        Auto merged
      mysql-test/t/flush_block_commit.test:
        Auto merged
      mysql-test/t/innodb-deadlock.test:
        Auto merged
      mysql-test/t/innodb-lock.test:
        Auto merged
      mysql-test/t/lock_multi.test:
        Auto merged
      mysql-test/t/mysql.test:
        Auto merged
      mysql-test/t/query_cache.test:
        Auto merged
      mysql-test/t/rename.test:
        Auto merged
      mysql-test/t/show_check.test:
        Auto merged
      mysql-test/t/status.test:
        Auto merged
      mysql-test/t/subselect.test:
        Auto merged
      mysql-test/t/type_newdecimal.test:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/item_subselect.cc:
        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/item_timefunc.h:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/protocol.cc:
        Auto merged
      sql/protocol.h:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_lex.cc:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      sql/sql_parse.cc:
        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/table.cc:
        Auto merged
      sql-common/client.c:
        Auto merged
      sql-common/my_time.c:
        Auto merged
      Makefile.am:
        merging
      client/mysqltest.c:
        merging
      include/my_time.h:
        merging
      libmysql/libmysql.c:
        merging
      mysql-test/t/order_by.test:
        merging
      96ad04de
  7. 16 Nov, 2006 4 commits
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mysql-4.1-mrg · e971334e
      unknown authored
      into  mysql.com:/home/hf/work/mysql-5.0-mrg
      
      
      client/mysqltest.c:
        Auto merged
      mysql-test/t/flush.test:
        Auto merged
      mysql-test/t/flush_block_commit.test:
        Auto merged
      mysql-test/t/innodb-deadlock.test:
        Auto merged
      mysql-test/t/innodb-lock.test:
        Auto merged
      mysql-test/t/lock_multi.test:
        Auto merged
      mysql-test/t/rename.test:
        Auto merged
      mysql-test/t/show_check.test:
        Auto merged
      mysql-test/t/status.test:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/protocol.h:
        Auto merged
      sql-common/client.c:
        Auto merged
      Makefile.am:
        merging
      BitKeeper/deleted/.del-mysql_client.test:
        merging
      include/mysql.h:
        SCCS merged
      libmysql/libmysql.c:
        merging
      libmysqld/lib_sql.cc:
        merging
      mysql-test/r/order_by.result:
        SCCS merged
      mysql-test/r/subselect.result:
        SCCS merged
      mysql-test/t/order_by.test:
        merging
      mysql-test/t/subselect.test:
        SCCS merged
      sql/item_subselect.cc:
        merging
      sql/item_subselect.h:
        merging
      sql/protocol.cc:
        merging
      sql/sql_class.h:
        merging
      e971334e
    • unknown's avatar
      merging · e78fd1d1
      unknown authored
      e78fd1d1
    • unknown's avatar
      merging · 83a7bbf7
      unknown authored
      83a7bbf7
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-4.1 · 17c238a1
      unknown authored
      into  mysql.com:/home/hf/work/mysql-4.1-mrg
      
      
      include/mysql.h:
        Auto merged
      mysql-test/r/subselect.result:
        Auto merged
      mysql-test/t/rename.test:
        Auto merged
      mysql-test/t/subselect.test:
        Auto merged
      sql-common/client.c:
        Auto merged
      sql/sql_class.h:
        Auto merged
      Makefile.am:
        merging
      client/mysqltest.c:
        merging
      mysql-test/t/mysql_client.test:
        merging
      17c238a1
  8. 15 Nov, 2006 7 commits
  9. 14 Nov, 2006 10 commits
  10. 13 Nov, 2006 2 commits