1. 26 Aug, 2005 1 commit
    • unknown's avatar
      fix for bug #11904 (select statement, cursor, grouping wrong results) · 6d74f5b0
      unknown authored
      
      sql/sql_select.cc:
        reset the group functions and copy the values of the first row before exiting because of
        maximal number of rows has been read for this cursor fetch. the additional variable is needed
        to save code duplication.
      tests/mysql_client_test.c:
        test for bug #11904 (cursor grouping wrong result)
      6d74f5b0
  2. 25 Aug, 2005 6 commits
  3. 24 Aug, 2005 20 commits
  4. 23 Aug, 2005 13 commits
    • unknown's avatar
      BUG#12532: Fixes after review · 15f626c2
      unknown authored
      
      sql/log_event.cc:
        Review fixes
      sql/sql_parse.cc:
        Review fixes
      15f626c2
    • unknown's avatar
      Merge mysql.com:/users/lthalmann/ltx/root/mysql-5.0 · 7271ea25
      unknown authored
      into  mysql.com:/users/lthalmann/ltx/dev/mysql-5.0-bug12532
      
      
      sql/log_event.cc:
        Auto merged
      7271ea25
    • 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
      Fix build using --without-server. (Bug #11680) · 4b943136
      unknown authored
      
      configure.in:
        Fix directories built using --without-server, and add mf_keycache.o
        to list of objects only built for thread-safe library, since it requires
        threading.
      dbug/my_main.c:
        Don't try to initialize thread globals if not built with threading.
      mysys/Makefile.am:
        Remove mf_keycache.c from list of files to build (it will be included
        in THREAD_LOBJECTS when appropriate).
      mysys/mf_getdate.c:
        Fix usage of gmtime().
      sql/share/Makefile.am:
        Allow removal of mysqld_error.h to fail, in case it doesn't exist yet.
      tests/Makefile.am:
        Don't link against libmysys explicitly.
      4b943136
    • 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
      Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.0 · ea8fee76
      unknown authored
      into lmy004.:/work/mysql-5.0-clean
      
      
      mysql-test/r/rpl_delete_all.result:
        Auto merged
      mysql-test/t/rpl_delete_all.test:
        Auto merged
      ea8fee76
    • unknown's avatar
      tests fixes · 51d1c2ad
      unknown authored
      
      mysql-test/lib/init_db.sql:
        this should be longblob or info_schema test will fail
      mysql-test/r/rpl_delete_all.result:
        fix result of a test, the error message is different (bug #12591)
      mysql-test/t/rpl_delete_all.test:
        fix test, now the error code is different (bug #12591)
      51d1c2ad