An error occurred fetching the project authors.
  1. 10 Sep, 2007 1 commit
  2. 03 Sep, 2007 1 commit
    • mhansson/martin@linux-st28.site's avatar
      Bug #30234: Unexpected behavior using DELETE with AS and USING · df5c9e69
      mhansson/martin@linux-st28.site authored
        
      DELETE FROM ... USING ... statements with the following type of 
      ambiguous aliasing gave unexpected results:
      DELETE FROM t1 AS alias USING t1, t2 AS alias WHERE t1.a = alias.a;
      This query would leave table t1 intact but delete rows from t2.
      Fixed by changing DELETE FROM ... USING syntax so that only alias 
      references (as opposed to alias declarations) may be used in FROM.
      df5c9e69
  3. 23 Feb, 2007 1 commit
    • gkodinov/kgeorge@macbook.gmz's avatar
      Bug #26186: · f88aec9e
      gkodinov/kgeorge@macbook.gmz authored
      When handling DELETE ... FROM if there is no
      condition it is internally transformed to 
      TRUNCATE for more efficient execution by the
      storage handler.
      The check for validity of the optional ORDER BY 
      clause is done after the check for the above 
      optimization and will not be performed if the
      optimization can be applied.
      Moved the validity check for ORDER BY before 
      the optimization so it performed regardless of
      the optimization.
      f88aec9e
  4. 11 Jan, 2007 1 commit
    • evgen@moonbone.local's avatar
      Bug#17711: DELETE doesn't use index when ORDER BY, LIMIT and non-restricting · c17bf5cb
      evgen@moonbone.local authored
      WHERE is present.
      
      If a DELETE statement with ORDER BY and LIMIT contains a WHERE clause
      with conditions that for sure cannot be used for index access (like in
      WHERE @var:= field) the execution always follows the filesort path.    
      It happens currently even when for the above case there is an index that
      can be used to speedup sorting by the order by list.
      
      Now if a DELETE statement with ORDER BY and LIMIT contains such WHERE
      clause conditions that cannot be used to build any quick select then
      the mysql_delete() tries to use an index like there is no WHERE clause at all.
      c17bf5cb
  5. 27 Oct, 2006 1 commit
  6. 04 Sep, 2006 1 commit
    • gkodinov/kgeorge@macbook.gmz's avatar
      Bug #21392: multi-table delete with alias table name fails with · 3758b975
      gkodinov/kgeorge@macbook.gmz authored
                  1003: Incorrect table name
      in multi-table DELETE the set of tables to delete from actually 
      references then tables in the other list, e.g:
      DELETE alias_of_t1 FROM t1 alias_of_t1 WHERE ....
      is a valid statement.
      So we must turn off table name syntactical validity check for alias_of_t1 
      because it's not a table name (even if it looks like one).
      In order to do that we add a special flag (TL_OPTION_ALIAS) to 
      disable the name checking for the aliases in multi-table DELETE.
      3758b975
  7. 23 Jul, 2006 1 commit
  8. 03 May, 2006 1 commit
    • igor@rurik.mysql.com's avatar
      Fixed bug #14292: performance degradation for a benchmark query. · ae4eb6b5
      igor@rurik.mysql.com authored
      This performance degradation was due to the fact that some
      cost evaluation code added into 4.1 in the function find_best was
      not merged into the code of the function best_access_path added
      together with other code for greedy optimizer.
      Added a parameter to the function print_plan. The parameter contains
      accumulated cost for a given partial join.
       
      The patch does not include a special test case since this performance
      degradation is hard to reproduse with a simple example.
      
      TODO: make the function find_best use the function best_access_path
      in order to remove duplication of code which might result in incomplete
      merges in the future.
      ae4eb6b5
  9. 30 May, 2005 1 commit
  10. 16 Feb, 2005 1 commit
    • igor@rurik.mysql.com's avatar
      delete.result, delete.test: · d4779d35
      igor@rurik.mysql.com authored
        Added a test case for bug #8392.
      sql_delete.cc:
        Fixed bug #8392.
        The bug caused a crash for a delete statement with ORDER BY
        that explicitly referred to the modified table.
      d4779d35
  11. 22 Nov, 2004 1 commit
  12. 07 Oct, 2004 1 commit
    • monty@mysql.com's avatar
      After merge fixes · 6239edc1
      monty@mysql.com authored
      Some bigger code changes was necessary becasue of the multi-table-update and the new HANDLER code
      6239edc1
  13. 01 Oct, 2004 1 commit
    • ram@gw.mysql.r18.ru's avatar
      delete.result, delete.test: · 4ec50dc4
      ram@gw.mysql.r18.ru authored
        A fix (bug #5733: Table handler error with self-join multi-table DELETE).
      records.cc:
        A fix (bug #5733: Table handler error with self-join multi-table DELETE).
      4ec50dc4
  14. 21 Jun, 2004 1 commit
  15. 16 Feb, 2004 1 commit
    • monty@mysql.com's avatar
      After merge fixes · f43093ec
      monty@mysql.com authored
      Added more DBUG statements
      Ensure that we are comparing end space with BINARY strings
      Use 'any_db' instead of '' to mean any database. (For HANDLER command)
      Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
      f43093ec
  16. 10 Dec, 2003 1 commit
  17. 17 Nov, 2003 1 commit
  18. 04 Jun, 2003 1 commit
    • monty@narttu.mysql.fi's avatar
      Added SQLSTATE to client/server protocol · 23145cfe
      monty@narttu.mysql.fi authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      23145cfe
  19. 04 May, 2003 1 commit
  20. 17 Mar, 2003 1 commit
  21. 10 Mar, 2003 1 commit
  22. 07 Mar, 2003 1 commit
  23. 04 Mar, 2003 1 commit
  24. 05 Jan, 2003 1 commit
  25. 15 Dec, 2002 1 commit
  26. 23 Nov, 2002 1 commit
  27. 21 Nov, 2002 1 commit
  28. 31 Aug, 2002 1 commit
  29. 30 Aug, 2002 1 commit
  30. 28 Sep, 2001 1 commit
    • sasha@mysql.sashanet.com's avatar
      client/mysqlmanagerc.c · bb66c80a
      sasha@mysql.sashanet.com authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      bb66c80a
  31. 28 Dec, 2000 1 commit
  32. 21 Dec, 2000 1 commit