An error occurred fetching the project authors.
  1. 05 Aug, 2005 1 commit
    • unknown's avatar
      mysql_priv.h: · 4811f7bd
      unknown authored
        Fixed bug #12154: a query returned: Column <name> cannot be null.
        The problem was due to a bug in the function setup_table_map:
        the flag maybe_null was set up incorrectly for inner tables of
        nested outer joins.
      join_nested.result, join_nested.test:
        Added a test case for bug #12154.
      
      
      mysql-test/t/join_nested.test:
        Added a test case for bug #12154.
      mysql-test/r/join_nested.result:
        Added a test case for bug #12154.
      sql/mysql_priv.h:
        Fixed bug #12154: a query returned: Column <name> cannot be null.
        The problem was due to a bug in the function setup_table_map:
        the flag maybe_null was set up incorrectly for inner tables of
        nested outer joins.
      4811f7bd
  2. 15 Jun, 2005 1 commit
    • unknown's avatar
      join_nested.result, join_nested.test: · ad57284c
      unknown authored
        Added a teast case for bug #11284.
      sql_select.cc:
        Fixed bug #11284.
        Optimization with empty inner table currently cannot be
        used in the case of nested outer join.
      
      
      sql/sql_select.cc:
        Fixed bug #11284.
        Optimization with empty inner table currently cannot be
        used in the case of nested outer join.
      mysql-test/t/join_nested.test:
        Added a teast case for bug #11284.
      ad57284c
  3. 13 Aug, 2004 1 commit
    • unknown's avatar
      join_nested.test, join_nested.result: · f0ac45bc
      unknown authored
        Added a case for bug #4976 when one of the inner tables is empty.
      select.result, join.result:
        Reversed the previous change of the erronious fix for bug #4976.
      sql_select.cc:
        The previous fix for bug 4976 was reversed as it
        erroniously converted an outer join into an innner join
        when on_expression does not refer to outer tables.
        This is not valid if inner tables return an empty set.
        Setting dependency on outer tables was added for the above cases.
        To fix the crash in the test case of bug #4976  
        a guard was added that blocks running the crashing code for
        nested outer joins.
      
      
      sql/sql_select.cc:
        The previous fix for bug 4976 was reversed as it
        erroniously converted an outer join into an innner join
        when on_expression does not refer to outer tables.
        This is not valid if inner tables return an empty set.
        Setting dependency on outer tables was added.
        The crash of the test case for bug #4976 was fixed
        adding a guard that blocks running the code for
        nested outer joins.
      mysql-test/r/join.result:
        Reversed the previous change of the erronious fix for bug #4976.
      mysql-test/r/select.result:
        Reversed the previous change of the erronious fix for bug #4976.
      mysql-test/r/join_nested.result:
        Added a case for bug #4976 when one of the inner tables is empty.
      mysql-test/t/join_nested.test:
        Added a case for bug #4976 when one of the inner tables is empty.
      f0ac45bc
  4. 11 Aug, 2004 1 commit
    • unknown's avatar
      join.result, select.result: · a2a94818
      unknown authored
        Fixed bug #4976.
      join_nested.result, join_nested.test:
        Added a test case for bug #4976.
      sql_select.cc:
        Applied conversion from an outer join to an inner join 
        when the on expression does not depend on the outer table.
        It fixed bug #4976.
      
      
      sql/sql_select.cc:
        Applied conversion from an outer join to an inner join 
        when the on expression does not depend on the outer table.
        It fixed bug #4976.
      mysql-test/t/join_nested.test:
        Added a case test for bug #4976.
      mysql-test/r/join_nested.result:
        Added a case test for bug #4976.
      mysql-test/r/select.result:
        Fixed bug #4976.
      mysql-test/r/join.result:
        Fixed bug #4976.
      a2a94818
  5. 06 Aug, 2004 1 commit
    • unknown's avatar
      join_nested.result, join_nested.test: · 3478d656
      unknown authored
        Added a test case for bug #4922.
      sql_select.cc:
        Blocked an optimization performed by join_read_const_table when
        applied to an inner table of a nested outer join.
        It was done to fix bug #4922.
      sql_yacc.yy:
        Fixed a typo bug in the rule for join_table.
      
      
      sql/sql_yacc.yy:
        Fixed a typo bug in the rule for join_table.
      sql/sql_select.cc:
        Blocked an optimization performed by join_read_const_table when
        applied to an inner table of a nested outer join.
        It was done to fix bug #4922.
      mysql-test/t/join_nested.test:
        Added a test case for bug #4922.
      mysql-test/r/join_nested.result:
        Added a test case for bug #4922.
      3478d656
  6. 02 Jul, 2004 1 commit
    • unknown's avatar
      right join print fixed · 688baf83
      unknown authored
      mysql-test/r/join_nested.result:
        right join test
      mysql-test/t/join_nested.test:
        right join test
      688baf83
  7. 01 Jul, 2004 1 commit
    • unknown's avatar
      fixed join_nested test independence of environment · 148eecbd
      unknown authored
      spaces at line end in fresh definitions removed
      fixed printing of nested joins (BUG#4352)
      
      
      mysql-test/r/join_nested.result:
        fixed join_nested test independence of environment
        print of nested join test added
      mysql-test/t/join_nested.test:
        fixed join_nested test independence of environment
        print of nested join test added
      sql/sql_lex.h:
        space at line end in fresh definition removed
      sql/sql_select.cc:
        fixed printing of nested joins
      sql/table.h:
        spaces at line end in fresh definitions removed
        method for table printing
      148eecbd
  8. 11 Jun, 2004 1 commit
    • unknown's avatar
      join_nested.test, join_nested.result: · cd23d6e3
      unknown authored
        new file
      Many files:
        Nested joins added.
      
      
      sql/item_cmpfunc.h:
        Nested joins added.
      sql/item_func.h:
        Nested joins added.
      sql/sql_base.cc:
        Nested joins added.
      sql/sql_lex.cc:
        Nested joins added.
      sql/sql_lex.h:
        Nested joins added.
      sql/sql_parse.cc:
        Nested joins added.
      sql/sql_select.cc:
        Nested joins added.
      sql/sql_select.h:
        Nested joins added.
      sql/sql_yacc.yy:
        Nested joins added.
      sql/table.h:
        Nested joins added.
      mysql-test/r/join_outer.result:
        Nested joins added.
      mysql-test/r/select.result:
        Nested joins added.
      cd23d6e3