1. 24 Aug, 2005 1 commit
    • unknown's avatar
      Post-fix for BUG#6276. · 2f044d3d
      unknown authored
      
      sql/sql_base.cc:
        Fixed a bug in PS (prepared statements) mode - the "always TRUE" constant
        Item created for outer joins with no common columns was not created in
        the PS memory.
        Now it is created in the right memory.
      2f044d3d
  2. 23 Aug, 2005 10 commits
    • unknown's avatar
      Test for BUG#6495. · 96f884c0
      unknown authored
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test for BUG#6495.
      mysql-test/t/select.test:
        Test for BUG#6495.
      96f884c0
    • unknown's avatar
      Test for BUG#4889 - inconsistent resilts of more than 2-way natural join · 4bf5c7c5
      unknown authored
      due to incorrect transformation to JOIN ... ON.
      
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test for BUG#4889.
      mysql-test/t/select.test:
        Test for BUG#4889.
      4bf5c7c5
    • unknown's avatar
      Fix for BUG#6276. · b4e830c3
      unknown authored
      
      mysql-test/r/select.result:
        Test for BUG#6276.
      mysql-test/t/select.test:
        Test for BUG#6276.
      sql/sql_base.cc:
        Add a true ON condition for outer joins without common columns.
      b4e830c3
    • unknown's avatar
      Test case for BUG#10972 - Natural join of view and underlying table gives wrong result. · 142f6583
      unknown authored
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test case for BUG#10972.
      mysql-test/t/select.test:
        Test case for BUG#10972.
      142f6583
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · 8dbe3266
      unknown authored
      into  mysql.com:/home/timka/mysql/src/5.0-2486
      
      
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/select.test:
        Auto merged
      8dbe3266
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · 30ca3e37
      unknown authored
      into  mysql.com:/home/timka/mysql/src/5.0-dbg
      
      
      30ca3e37
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · 2ef2e063
      unknown authored
      into  mysql.com:/home/timka/mysql/src/5.0-2486
      
      
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/select.test:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      sql/table.h:
        Auto merged
      2ef2e063
    • unknown's avatar
      WL#2486 - natural and using join according to SQL:2003 · fe24add7
      unknown authored
      * Provide backwards compatibility extension to name resolution of
        coalesced columns. The patch allows such columns to be qualified
        with a table (and db) name, as it is in 4.1.
        Based on a patch from Monty.
      
      * Adjusted tests accordingly to test both backwards compatible name
        resolution of qualified columns, and ANSI-style resolution of
        non-qualified columns.
        For this, each affected test has two versions - one with qualified
        columns, and one without. 
      
      
      mysql-test/include/ps_query.inc:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/bdb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/innodb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join_nested.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join_outer.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/null_key.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/order_by.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_2myisam.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_3innodb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_4heap.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_5merge.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_6bdb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_7ndb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/select.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/subselect.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/type_ranges.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/bdb.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/innodb.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join_nested.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join_outer.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/null_key.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/order_by.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/select.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/subselect.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/type_ranges.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      sql/sql_base.cc:
        * Applied Monty's patch for backwards compatible name resolution
          of qualified columns. The idea is:
          - When a column is qualified, search for the column in all
            tables/views underlying each natural join. In this case
            natural joins are *not* considered leaves.
          - If a column is not qualified, then consider natural joins
            as leaves, thus directly search the result columns of
            natural joins.
        * Simplified 'find_field_in_tables()' - unified two similar
          loops into one.
      sql/table.cc:
        - Removed method & members not needed after Monty's patch.
      sql/table.h:
        - Removed method & members not needed after Monty's patch.
      tests/mysql_client_test.c:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      fe24add7
    • unknown's avatar
      configure.in: · 04d7dad1
      unknown authored
        fixed build bug with ndb grep block
      
      
      configure.in:
        fixed build bug with ndb grep block
      04d7dad1
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 6658fb34
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.0-bg11896
      
      
      mysql-test/t/sp-error.test:
        Auto merged
      mysql-test/t/trigger.test:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      mysql-test/r/trigger.result:
        Manual merge.
      sql/share/errmsg.txt:
        Manual merge.
      6658fb34
  3. 22 Aug, 2005 15 commits
  4. 21 Aug, 2005 5 commits
    • unknown's avatar
      Cleanup during review of new pushed code · 72340a48
      unknown authored
      
      include/my_global.h:
        Safer macros to avoid possible overflows
      sql/item_cmpfunc.cc:
        Simple optimization
      sql/sp_head.cc:
        Indentation fixes
        Remove not needed "else" levels
        Added error checking for 'new'
        Simpler reseting of thd->spcont in execute_procedure
      sql/sql_base.cc:
        Faster new
      sql/sql_lex.cc:
        Use 'TRUE' instead of 'true'
      sql/sql_parse.cc:
        Faster new
      sql/sql_view.cc:
        No need to set 'tables' as it's not used
      sql/table.cc:
        Simpler DBUG_ASSERT()
      72340a48
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-4.1-push · ad56f835
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      
      BitKeeper/etc/config:
        Auto merged
      mysql-test/t/ndb_alter_table.test:
        Auto merged
      mysql-test/t/ndb_config.test:
        Auto merged
      ndb/src/common/util/version.c:
        Auto merged
      ndb/src/kernel/Makefile.am:
        Auto merged
      ndb/src/kernel/blocks/qmgr/Qmgr.hpp:
        Auto merged
      ndb/src/kernel/blocks/qmgr/QmgrMain.cpp:
        Auto merged
      ndb/src/mgmsrv/MgmtSrvr.cpp:
        Auto merged
      ndb/src/ndbapi/TransporterFacade.cpp:
        Auto merged
      ndb/tools/Makefile.am:
        Auto merged
      ndb/tools/ndb_config.cpp:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      ad56f835
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · f38b651f
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      
      f38b651f
    • unknown's avatar
      Merge mishka.local:/tmp/skr99/mysql-5.0 · a1820ab1
      unknown authored
      into  mishka.local:/home/my/mysql-5.0
      
      
      sql/item_strfunc.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      a1820ab1
    • unknown's avatar
      Merge mronstrom@bk-internal.mysql.com:/home/bk/mysql-5.0 · a34ca4bf
      unknown authored
      into  c-4a09e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/mysql-5.0
      
      
      a34ca4bf
  5. 20 Aug, 2005 6 commits
    • unknown's avatar
      Merge c-4a09e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/mysql-4.1 · b221b549
      unknown authored
      into  c-4a09e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/mysql-5.0
      
      
      heap/hp_delete.c:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      mysql-test/r/distinct.result:
        Manual merge
      mysql-test/t/distinct.test:
        Manual merge
      b221b549
    • unknown's avatar
      Bug #12460 Table Full · ad8c5c9d
      unknown authored
      On 64 bit platforms the changed statement doesn't work
      so making sure that the larger value is first and using
      subtraction is a quick and backwards-compatible fix of this
      line.
      
      
      ad8c5c9d
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 41dad02d
      unknown authored
      into sergbook.mysql.com:/usr/home/serg/Abk/mysql-5.0
      
      
      sql/sql_yacc.yy:
        Auto merged
      41dad02d
    • unknown's avatar
      Fixes during review of new pushed code · 3eda70b2
      unknown authored
      Fixed new bug when running a SP without a default database
      
      
      mysql-test/r/information_schema.result:
        Added test to cover changes made in default handling
      mysql-test/r/sp-security.result:
        Added test when executing SP without a default database
      mysql-test/t/information_schema.test:
        Added test to cover changes made in default handling
      mysql-test/t/sp-security.test:
        Added test when executing SP without a default database
      sql/item_strfunc.cc:
        Removed wrong push
      sql/mysqld.cc:
        Indentation fix
      sql/sql_base.cc:
        Use share->db instead of share->table_cache_key
        Remove assert that can never fail (because of test in previous row)
      sql/sql_db.cc:
        Allow empty database name when called from SP
        (To allow on run without a default database)
      sql/sql_parse.cc:
        Added comment
      sql/sql_show.cc:
        Indentation fixes
        Simplified code by checking for 'wrong' condition first and doing continue instead of going down one level
        Simplified precision and decimal handling
      3eda70b2
    • unknown's avatar
      Merge mysql.com:/home/stewart/Documents/MySQL/5.0/main · fbaf5b04
      unknown authored
      into  mysql.com:/home/stewart/Documents/MySQL/5.0/bug10950
      
      
      fbaf5b04
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 4c17cdc1
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      4c17cdc1
  6. 19 Aug, 2005 3 commits