1. 23 Mar, 2007 8 commits
  2. 22 Mar, 2007 32 commits
    • unknown's avatar
      Merge obarnir@bk-internal.mysql.com:/home/bk/mysql-5.0-build · bbcc4bb0
      unknown authored
      into  linux.site:/home/omer/source/bld50_0321
      
      
      bbcc4bb0
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 3e6787d3
      unknown authored
      into  moonbone.local:/mnt/gentoo64/work/26813-bug-5.0-opt-mysql
      
      
      3e6787d3
    • unknown's avatar
      sql_view.cc: · 842eaa44
      unknown authored
        Post-fix for bug#26813.
      
      
      sql/sql_view.cc:
        Post-fix for bug#26813.
      842eaa44
    • unknown's avatar
      Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 3206447b
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      3206447b
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0-opt · b8c101df
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      b8c101df
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mrg/mysql-4.1-opt · 45b55666
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      45b55666
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0 · 96793a96
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      sql/item_cmpfunc.cc:
        Auto merged
      96793a96
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-4.1 · 55f991c2
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-4.1-opt
      
      
      55f991c2
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 9558c66c
      unknown authored
      into  moonbone.local:/mnt/gentoo64/work/26813-bug-5.0-opt-mysql
      
      
      9558c66c
    • unknown's avatar
      Bug#26813: The SUPER privilege is wrongly required to alter a view created by · 9b774e8f
      unknown authored
      another user.
      
      When the DEFINER clause isn't specified in the ALTER statement then it's loaded
      from the view definition. If the definer differs from the current user then
      the error is thrown because only a super-user can set other users as a definers.
      
      Now if the DEFINER clause is omitted in the ALTER VIEW statement then the
      definer from the original view is used without check.
      
      
      mysql-test/t/view_grant.test:
        Added a test case for the bug#27006: The SUPER privilege is wrongly required
        to alter a view created by another user.
      mysql-test/r/view_grant.result:
        Added a test case for the bug#27006: The SUPER privilege is wrongly required
        to alter a view created by another user.
      sql/sql_view.cc:
        Bug#26813: The SUPER privilege is wrongly required to alter a view created by
        another user.
        Now if the DEFINER clause is omitted in the ALTER VIEW statement then the
        definer from the original view is used without check.
      9b774e8f
    • unknown's avatar
      Merge mysql.com:/home/kent/bk/tmp/mysql-4.1-build · 716d23a7
      unknown authored
      into  mysql.com:/home/kent/bk/tmp/mysql-5.0-build
      
      
      BitKeeper/deleted/.del-fill_func_tables.sh:
        Auto merged
      BitKeeper/deleted/.del-fill_help_tables.sh:
        Auto merged
      716d23a7
    • unknown's avatar
      .del-fill_func_tables.sh: · 4b4700f3
      unknown authored
        Delete: scripts/fill_func_tables.sh
      .del-fill_help_tables.sh:
        Delete: scripts/fill_help_tables.sh
      .del-internals.texi:
        Delete: Docs/internals.texi
      
      
      BitKeeper/deleted/.del-internals.texi:
        Delete: Docs/internals.texi
      BitKeeper/deleted/.del-fill_func_tables.sh:
        Delete: scripts/fill_func_tables.sh
      BitKeeper/deleted/.del-fill_help_tables.sh:
        Delete: scripts/fill_help_tables.sh
      4b4700f3
    • unknown's avatar
      Merge mysql.com:/home/kent/bk/tmp/mysql-4.1-build · 693f66bd
      unknown authored
      into  mysql.com:/home/kent/bk/tmp/mysql-5.0-build
      
      
      BitKeeper/deleted/.del-colspec-fix.pl:
        Auto merged
      BitKeeper/deleted/.del-docbook-fixup.pl:
        Auto merged
      BitKeeper/deleted/.del-docbook-prefix.pl:
        Auto merged
      BitKeeper/deleted/.del-docbook-split:
        Auto merged
      BitKeeper/deleted/.del-make-docbook:
        Auto merged
      BitKeeper/deleted/.del-make-makefile:
        Auto merged
      BitKeeper/deleted/.del-test-make-manual-de:
        Auto merged
      BitKeeper/deleted/.del-test-make-manual:
        Auto merged
      BitKeeper/deleted/.del-xwf:
        Auto merged
      693f66bd
    • unknown's avatar
      Merge mysql.com:/home/kent/bk/tmp/mysql-4.0 · d3125d0a
      unknown authored
      into  mysql.com:/home/kent/bk/tmp/mysql-4.1-build
      
      
      BitKeeper/deleted/.del-net_doc.txt:
        Auto merged
      d3125d0a
    • unknown's avatar
      Deleted directories · 84536ba9
      unknown authored
        Docs/Books/
        Docs/MySQL-logos/
      Deleted files
        Docs/Tutorial-MySQL-final.txt
        Docs/bk.txt
        Docs/Support/.cvsignore
        Docs/Support/colspec-fix.pl
        Docs/Support/docbook-fixup.pl
        Docs/Support/docbook-prefix.pl
        Docs/Support/docbook-split
        Docs/Support/make-docbook
        Docs/Support/make-makefile
        Docs/Support/test-make-manual
        Docs/Support/test-make-manual-de
        Docs/Support/trivial-makeinfo-4.0c.patch
        Docs/Support/xwf
      Deleted file now in internals main text
        Docs/my_sys.txt
      Deleted file now in internals svn tree
        Docs/net_doc.txt
      Removed obsolete entries
        Docs/.cvsignore
      Added note that info is obsolete
        Docs/linuxthreads.txt
      
      
      BitKeeper/deleted/.del-colspec-fix.pl:
        Delete: Docs/Support/colspec-fix.pl
      BitKeeper/deleted/.del-docbook-fixup.pl:
        Delete: Docs/Support/docbook-fixup.pl
      BitKeeper/deleted/.del-docbook-prefix.pl:
        Delete: Docs/Support/docbook-prefix.pl
      BitKeeper/deleted/.del-docbook-split:
        Delete: Docs/Support/docbook-split
      BitKeeper/deleted/.del-make-docbook:
        Delete: Docs/Support/make-docbook
      BitKeeper/deleted/.del-make-makefile:
        Delete: Docs/Support/make-makefile
      BitKeeper/deleted/.del-test-make-manual-de:
        Delete: Docs/Support/test-make-manual-de
      BitKeeper/deleted/.del-test-make-manual:
        Delete: Docs/Support/test-make-manual
      BitKeeper/deleted/.del-trivial-makeinfo-4.0c.patch:
        Delete: Docs/Support/trivial-makeinfo-4.0c.patch
      BitKeeper/deleted/.del-xwf:
        Delete: Docs/Support/xwf
      BitKeeper/deleted/.del-algor.eps~1a57aff065918206:
        Delete: Docs/Books/algor.eps
      BitKeeper/deleted/.del-algor.gif:
        Delete: Docs/Books/algor.gif
      BitKeeper/deleted/.del-algor.txt:
        Delete: Docs/Books/algor.txt
      BitKeeper/deleted/.del-dbi.eps~7b1032f98de7736d:
        Delete: Docs/Books/dbi.eps
      BitKeeper/deleted/.del-dbi.gif:
        Delete: Docs/Books/dbi.gif
      BitKeeper/deleted/.del-dbi.txt:
        Delete: Docs/Books/dbi.txt
      BitKeeper/deleted/.del-dubois.eps~f24e09a7fa420436:
        Delete: Docs/Books/dubois.eps
      BitKeeper/deleted/.del-dubois.gif:
        Delete: Docs/Books/dubois.gif
      BitKeeper/deleted/.del-dubois.txt:
        Delete: Docs/Books/dubois.txt
      BitKeeper/deleted/.del-ecomm.eps~17833026ebd7656:
        Delete: Docs/Books/ecomm.eps
      BitKeeper/deleted/.del-ecomm.gif:
        Delete: Docs/Books/ecomm.gif
      BitKeeper/deleted/.del-ecomm.txt:
        Delete: Docs/Books/ecomm.txt
      BitKeeper/deleted/.del-in_21.eps~8150d06653dab178:
        Delete: Docs/Books/in_21.eps
      BitKeeper/deleted/.del-in_21.gif:
        Delete: Docs/Books/in_21.gif
      BitKeeper/deleted/.del-in_21.txt:
        Delete: Docs/Books/in_21.txt
      BitKeeper/deleted/.del-manual.eps~1c2ebcea50b4840c:
        Delete: Docs/Books/manual.eps
      BitKeeper/deleted/.del-manual.gif:
        Delete: Docs/Books/manual.gif
      BitKeeper/deleted/.del-manual.txt:
        Delete: Docs/Books/manual.txt
      BitKeeper/deleted/.del-msql.eps~f3801b9d166ae4fc:
        Delete: Docs/Books/msql.eps
      BitKeeper/deleted/.del-msql.gif:
        Delete: Docs/Books/msql.gif
      BitKeeper/deleted/.del-msql.txt:
        Delete: Docs/Books/msql.txt
      BitKeeper/deleted/.del-prof.eps~1f54d9a56eb2b908:
        Delete: Docs/Books/prof.eps
      BitKeeper/deleted/.del-prof.gif:
        Delete: Docs/Books/prof.gif
      BitKeeper/deleted/.del-prof.txt:
        Delete: Docs/Books/prof.txt
      BitKeeper/deleted/.del-pthreads.eps~2ca8ff2d1181b2c0:
        Delete: Docs/Books/pthreads.eps
      BitKeeper/deleted/.del-pthreads.gif:
        Delete: Docs/Books/pthreads.gif
      BitKeeper/deleted/.del-pthreads.txt:
        Delete: Docs/Books/pthreads.txt
      BitKeeper/deleted/.del-realmen.eps~cc022325d3cb045:
        Delete: Docs/Books/realmen.eps
      BitKeeper/deleted/.del-realmen.gif:
        Delete: Docs/Books/realmen.gif
      BitKeeper/deleted/.del-realmen.txt:
        Delete: Docs/Books/realmen.txt
      BitKeeper/deleted/.del-sql-99.eps~f85c06de7a016c7d:
        Delete: Docs/Books/sql-99.eps
      BitKeeper/deleted/.del-sql-99.gif:
        Delete: Docs/Books/sql-99.gif
      BitKeeper/deleted/.del-sql-99.txt:
        Delete: Docs/Books/sql-99.txt
      BitKeeper/deleted/.del-mysql-01.gif:
        Delete: Docs/MySQL-logos/mysql-01.gif
      BitKeeper/deleted/.del-mysql-02.gif:
        Delete: Docs/MySQL-logos/mysql-02.gif
      BitKeeper/deleted/.del-mysql-03.gif:
        Delete: Docs/MySQL-logos/mysql-03.gif
      BitKeeper/deleted/.del-mysql-04.gif:
        Delete: Docs/MySQL-logos/mysql-04.gif
      BitKeeper/deleted/.del-mysql-05.gif:
        Delete: Docs/MySQL-logos/mysql-05.gif
      BitKeeper/deleted/.del-mysql-06.gif:
        Delete: Docs/MySQL-logos/mysql-06.gif
      BitKeeper/deleted/.del-mysql-07.gif:
        Delete: Docs/MySQL-logos/mysql-07.gif
      BitKeeper/deleted/.del-mysql-08.gif:
        Delete: Docs/MySQL-logos/mysql-08.gif
      BitKeeper/deleted/.del-mysql-09.gif:
        Delete: Docs/MySQL-logos/mysql-09.gif
      BitKeeper/deleted/.del-mysql-10.gif:
        Delete: Docs/MySQL-logos/mysql-10.gif
      BitKeeper/deleted/.del-mysql-11.gif:
        Delete: Docs/MySQL-logos/mysql-11.gif
      BitKeeper/deleted/.del-mysql-12.gif:
        Delete: Docs/MySQL-logos/mysql-12.gif
      BitKeeper/deleted/.del-mysql-13.gif:
        Delete: Docs/MySQL-logos/mysql-13.gif
      BitKeeper/deleted/.del-mysql-14.gif:
        Delete: Docs/MySQL-logos/mysql-14.gif
      BitKeeper/deleted/.del-mysql-15.gif:
        Delete: Docs/MySQL-logos/mysql-15.gif
      BitKeeper/deleted/.del-mysql-16.gif:
        Delete: Docs/MySQL-logos/mysql-16.gif
      BitKeeper/deleted/.del-mysql-17.gif:
        Delete: Docs/MySQL-logos/mysql-17.gif
      BitKeeper/deleted/.del-mysql-compatible.jpg:
        Delete: Docs/MySQL-logos/mysql-compatible.jpg
      BitKeeper/deleted/.del-mysql_anim-01.gif:
        Delete: Docs/MySQL-logos/mysql_anim-01.gif
      BitKeeper/deleted/.del-mysql_anim-02.gif:
        Delete: Docs/MySQL-logos/mysql_anim-02.gif
      BitKeeper/deleted/.del-mysql_anim-03.gif:
        Delete: Docs/MySQL-logos/mysql_anim-03.gif
      BitKeeper/deleted/.del-mysql_anim-04.gif:
        Delete: Docs/MySQL-logos/mysql_anim-04.gif
      BitKeeper/deleted/.del-mysql_anim-05.gif:
        Delete: Docs/MySQL-logos/mysql_anim-05.gif
      BitKeeper/deleted/.del-mysql_anim-06.gif:
        Delete: Docs/MySQL-logos/mysql_anim-06.gif
      BitKeeper/deleted/.del-Tutorial-MySQL-final.txt:
        Delete: Docs/Tutorial-MySQL-final.txt
      BitKeeper/deleted/.del-net_doc.txt:
        Delete: Docs/net_doc.txt
      BitKeeper/deleted/.del-my_sys.txt:
        Delete: Docs/my_sys.txt
      BitKeeper/deleted/.del-bk.txt:
        Delete: Docs/bk.txt
      BitKeeper/deleted/.del-.cvsignore:
        Delete: Docs/Support/.cvsignore
      Docs/.cvsignore:
        Removed obsolete entries
      Docs/linuxthreads.txt:
        Added note info is obsolete
      84536ba9
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · dc41a5ce
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/autopush/B26207-5.0-opt
      
      
      sql/sql_select.h:
        Auto merged
      dc41a5ce
    • unknown's avatar
      Bug #26207: When making the key image to use · 0a48cd93
      unknown authored
       in index search MySQL was not explicitly
       suppressing warnings. And if the context 
       happens to enable warnings (e.g. INSERT ..
       SELECT) the warnings resulting from converting 
       the data the key is compared to are 
       reported to the client.
       Fixed by suppressing warnings when converting
       the data to the same type as the key parts.
      
      
      mysql-test/r/insert_select.result:
        Bug #26207: test case
      mysql-test/t/insert_select.test:
        Bug #26207: test case
      sql/sql_select.h:
        Bug #26207: supress warnings when converting
          data of the same type to key buffer format.
      0a48cd93
    • unknown's avatar
      Makefile.am: · ff7b01d8
      unknown authored
        Don't install benchmark executable
      CMakeLists.txt:
        Handle CMAKE_C_FLAGS_RELWITHDEBINFO and CMAKE_CXX_FLAGS_RELWITHDEBINFO
      
      
      extra/yassl/taocrypt/benchmark/Makefile.am:
        Don't install benchmark executable
      CMakeLists.txt:
        Handle CMAKE_C_FLAGS_RELWITHDEBINFO and CMAKE_CXX_FLAGS_RELWITHDEBINFO
      mysys/CMakeLists.txt:
        Handle CMAKE_C_FLAGS_RELWITHDEBINFO and CMAKE_CXX_FLAGS_RELWITHDEBINFO
      ff7b01d8
    • unknown's avatar
      Bug#24791: Union with AVG-groups generates wrong results · 33da0f37
      unknown authored
      Patch appled after doing a pull from the team tree. Additional tests had to be
      fixed
      
      
      mysql-test/r/union.result:
        Bug 24791
        
        The tests for temporary tables have been fixed. Since the call to 
        display_length(Item) was removed from the constructor for Item_type_holder, items 
        in temporary tables keep the original values of the items, rather than the magic
        numbers supplied by display_length.
      33da0f37
    • unknown's avatar
      Merge mhansson@bk-internal:/home/bk/mysql-5.0-opt · a9df90a7
      unknown authored
      into  linux-st28.site:/home/martin/mysql/src/5.0o-bug24791
      
      
      sql/item.cc:
        Auto merged
      a9df90a7
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0-ndb · bdb9b448
      unknown authored
      into  perch.ndb.mysql.com:/home/jonas/src/mysql-5.0-ndb
      
      
      bdb9b448
    • unknown's avatar
      Merge perch.ndb.mysql.com:/home/jonas/src/50-work · 39e7b560
      unknown authored
      into  perch.ndb.mysql.com:/home/jonas/src/mysql-5.0-ndb
      
      
      ndb/test/ndbapi/testNodeRestart.cpp:
        Auto merged
      39e7b560
    • unknown's avatar
      ndb - · 4dee1e6a
      unknown authored
        fix test prg
      
      
      ndb/test/ndbapi/testNodeRestart.cpp:
        fix test prg
      4dee1e6a
    • unknown's avatar
      Merge mhansson@bk-internal:/home/bk/mysql-5.0-opt · 5b86ad19
      unknown authored
      into  linux-st28.site:/home/martin/mysql/src/5.0o-bug24791
      
      
      sql/field.h:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      5b86ad19
    • unknown's avatar
      Bug #24791: Union with AVG-groups generates wrong results · aa323361
      unknown authored
      The problem in this bug is when we create temporary tables. When
      temporary tables are created for unions, there is some 
      inferrence being carried out regarding the type of the column.
      Whenever this column type is inferred to be REAL (i.e. FLOAT or
      DOUBLE), MySQL will always try to maintain exact precision, and
      if that is not possible (there are hardware limits, since FLOAT
      and DOUBLE are stored as approximate values) will switch to
      using approximate values. The problem here is that at this point
      the information about number of significant digits is not 
      available. Furthermore, the number of significant digits should
      be increased for the AVG function, however, this was not properly 
      handled. There are 4 parts to the problem:
      
      #1: DOUBLE and FLOAT fields don't display their proper display 
      lengths in max_display_length(). This is hard-coded as 53 for 
      DOUBLE and 24 for FLOAT. Now changed to instead return the 
      field_length.
      
      #2: Type holders for temporary tables do not preserve the 
      max_length of the Item's from which they are created, and is 
      instead reverted to the 53 and 24 from above. This causes 
      *all* fields to get non-fixed significant digits.
      
      #3: AVG function does not update max_length (display length)
      when updating number of decimals.
      
      #4: The function that switches to non-fixed number of 
      significant digits should use DBL_DIG + 2 or FLT_DIG + 2 as 
      cut-off values (Since fixed precision does not use the 'e' 
      notation)
      
      Of these points, #1 is the controversial one, but this 
      change is preferred and has been cleared with Monty. The 
      function causes quite a few unit tests to blow up and they had
      to b changed, but each one is annotated and motivated. We 
      frequently see the magical 53 and 24 give way to more relevant
      numbers.
      
      
      mysql-test/r/create.result:
        bug#24791
        
        changed test result
        
        With the changes made for FLOAT and DOUBLE, the original display
        lengths are now preserved.
      mysql-test/r/temp_table.result:
        bug#24791
        
        changed test resullt
        
        Test case added
      mysql-test/r/type_float.result:
        bug#24791
        
        changed test result
        
        delta 1: field was originally declared as DOUBLE with no display
        length, so the hardware maximum is chosen rather than 53.
        
        delta 2: fields exceed the maximum precision and thus switch to
        non-fixed significant digits
        
        delta 3: Same as above, number of decmals and significant digits
        was not specified when t3 was created.
      mysql-test/t/temp_table.test:
        bug#24791
        
        Test case
      sql/field.h:
        bug#24791
        
        The method max_display_length is reimplemented as
        
        uint32 max_display_length() { return field_length; }
        
        in Field_double and Field_float. Since all subclasses of 
        Field_real now have the same implementation of this method, the
        implementation has been moved up the hierarchy to Field_real.
      sql/item.cc:
        bug#24791
        
        We switch to a non-fixed number of significant digits
        (by setting decimals=NOT_FIXED_DECIMAL) if the calculated 
        display length is greater than the display length of a value 
        with the maximum precision. These values differ for double and 
        float, obviously.
      sql/item_sum.cc:
        bug#24791
        
        We must increase the display length accordinly whenever we 
        change number of decimal places.
      aa323361
    • unknown's avatar
      Merge tulin@bk-internal.mysql.com:/home/bk/mysql-5.0-maint · 4e288dc3
      unknown authored
      into  whalegate.ndb.mysql.com:/home/tomas/mysql-5.0-ndb
      
      
      4e288dc3
    • unknown's avatar
      bug #16546 (DATETIME+0 not always coerced the same way) · 2b983572
      unknown authored
        fix for cast( AS DATETIME)+0 in 5.0 and above versions.
        val_real now works using val_decimal for DATETIME Items
        Superfluous val_real() methods deleted
      
      
      sql/item_timefunc.h:
        val_real() for datetime functions implemented
            as { return val_real_from_decimal(); }
            It's not a fastest possible way, but code is simple and less
            error-prone, what i belive is more important here as this part
            works unfrequently.
      2b983572
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mrg/mysql-4.1-opt · 23354862
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      mysql-test/t/type_datetime.test:
        Auto merged
      mysql-test/r/type_datetime.result:
        SCCS merged
      sql/item_timefunc.h:
        SCCS merged
      23354862
    • unknown's avatar
      bug #16546 (DATETIME + 0 not always coerced in the same way) · 50b5064c
      unknown authored
        fix for cast( AS DATETIME) + 0 operation.
        I just implemented Item_datetime_typecast::val() method
        as it is usually done in other classes.
        Should be fixed more radically in 5.0
      
      
      mysql-test/r/type_datetime.result:
        result added
      mysql-test/t/type_datetime.test:
        testcase
      sql/item_timefunc.h:
        added double conversion to Item_datetime_typecast
      50b5064c
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0 · 1fdab610
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      sql/item.h:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      1fdab610
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mrg/mysql-4.1-opt · 52d36629
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      52d36629
    • unknown's avatar
      Merge mysql.com:/home/hf/work/25492/my50-25492 · e98c61bb
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-5.0-opt
      
      
      libmysqld/lib_sql.cc:
        Auto merged
      e98c61bb