1. 24 Aug, 2005 1 commit
    • unknown's avatar
      Post-fix for BUG#6276. · 45fa37fe
      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.
      45fa37fe
  2. 23 Aug, 2005 10 commits
    • unknown's avatar
      Test for BUG#6495. · e9a3d1b0
      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.
      e9a3d1b0
    • unknown's avatar
      Test for BUG#4889 - inconsistent resilts of more than 2-way natural join · 359ed9a0
      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.
      359ed9a0
    • unknown's avatar
      Fix for BUG#6276. · 3bfeefff
      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.
      3bfeefff
    • unknown's avatar
      Test case for BUG#10972 - Natural join of view and underlying table gives wrong result. · 98d63231
      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.
      98d63231
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · e7f4f49d
      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
      e7f4f49d
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · 1f91a6dc
      unknown authored
      into  mysql.com:/home/timka/mysql/src/5.0-dbg
      
      1f91a6dc
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/5.0-virgin · de209ff6
      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
      de209ff6
    • unknown's avatar
      WL#2486 - natural and using join according to SQL:2003 · 1647932c
      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.
      1647932c
    • unknown's avatar
      configure.in: · 2d7996ce
      unknown authored
        fixed build bug with ndb grep block
      
      
      configure.in:
        fixed build bug with ndb grep block
      2d7996ce
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 0c20af41
      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.
      0c20af41
  3. 22 Aug, 2005 15 commits
  4. 21 Aug, 2005 5 commits
    • unknown's avatar
      Cleanup during review of new pushed code · 0776999d
      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()
      0776999d
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-4.1-push · 97ac930b
      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
      97ac930b
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · dfc8b3c2
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      dfc8b3c2
    • unknown's avatar
      Merge mishka.local:/tmp/skr99/mysql-5.0 · 916e1938
      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
      916e1938
    • unknown's avatar
      Merge mronstrom@bk-internal.mysql.com:/home/bk/mysql-5.0 · 5885a7d9
      unknown authored
      into  c-4a09e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/mysql-5.0
      
      5885a7d9
  5. 20 Aug, 2005 6 commits
    • unknown's avatar
      Merge c-4a09e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/mysql-4.1 · 8e176ed5
      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
      8e176ed5
    • unknown's avatar
      Bug #12460 Table Full · a2035397
      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.
      
      a2035397
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · ba57fc49
      unknown authored
      into sergbook.mysql.com:/usr/home/serg/Abk/mysql-5.0
      
      
      sql/sql_yacc.yy:
        Auto merged
      ba57fc49
    • unknown's avatar
      Fixes during review of new pushed code · 8cc25933
      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
      8cc25933
    • unknown's avatar
      Merge mysql.com:/home/stewart/Documents/MySQL/5.0/main · b4587f8f
      unknown authored
      into  mysql.com:/home/stewart/Documents/MySQL/5.0/bug10950
      
      b4587f8f
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 06714f2b
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      06714f2b
  6. 19 Aug, 2005 3 commits