1. 26 Mar, 2008 1 commit
    • gshchepa/uchum@host.loc's avatar
      Fixed bug #35193. · 2dcec449
      gshchepa/uchum@host.loc authored
      View definition as SELECT ... FROM DUAL WHERE ... has
      valid syntax, but use of such view in SELECT or
      SHOW CREATE VIEW syntax causes unexpected syntax error.
      
      Server omits FROM DUAL clause when storing view body
      string in a .frm file for further evaluation.
      However, syntax of SELECT-witout-FROM query is more
      restrictive than SELECT FROM DUAL syntax, and doesn't
      allow the WHERE clause.
      
      NOTE: this syntax difference is not documented.
      
      
      View registration procedure has been modified to
      preserve original structure of view's body.
      2dcec449
  2. 25 Mar, 2008 1 commit
  3. 24 Mar, 2008 1 commit
  4. 23 Mar, 2008 1 commit
  5. 21 Mar, 2008 2 commits
  6. 19 Mar, 2008 4 commits
  7. 14 Mar, 2008 1 commit
    • gshchepa/uchum@host.loc's avatar
      Fixed bug #34763. · cf90fb55
      gshchepa/uchum@host.loc authored
      Queries like:
      
        SELECT ROW(1, 2) IN (SELECT t1.a, 2)
          FROM t1 GROUP BY t1.a
      
      or 
      
        SELECT ROW(1, 2) IN (SELECT t1.a, 2 FROM t2)
          FROM t1 GROUP BY t1.a
      
      lead to assertion failure in the
      Item_in_subselect::row_value_transformer method in debugging
      build, or to unexpected error message in release build:
      
        ERROR 1247 (42S22): Reference '<list ref>' not supported (forward
                            reference in item list)
      
      Unexpected error message and assertion failure have been
      eliminated.
      cf90fb55
  8. 13 Mar, 2008 1 commit
  9. 12 Mar, 2008 4 commits
  10. 10 Mar, 2008 2 commits
  11. 08 Mar, 2008 1 commit
  12. 07 Mar, 2008 3 commits
  13. 06 Mar, 2008 2 commits
    • sergefp@pslp.mylan's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · f883250f
      sergefp@pslp.mylan authored
      into  mysql.com:/home/psergey/mysql-5.0-bug34945
      f883250f
    • kaa@kaamos.(none)'s avatar
      Fix for bug #34512: CAST( AVG( double ) AS DECIMAL ) · 4ca61aa3
      kaa@kaamos.(none) authored
                          returns wrong results
      
      Casting AVG() to DECIMAL led to incorrect results when the arguments
      had a non-DECIMAL type, because in this case
      Item_sum_avg::val_decimal() performed the division by the number of
      arguments twice.
      
      Fixed by changing Item_sum_avg::val_decimal() to not rely on
      Item_sum_sum::val_decimal(), i.e. calculate sum and divide using
      DECIMAL arithmetics for DECIMAL arguments, and utilize val_real() with
      subsequent conversion to DECIMAL otherwise.
      4ca61aa3
  14. 05 Mar, 2008 1 commit
    • kaa@kaamos.(none)'s avatar
      Fix for bug #34889: mysql_client_test::test_mysql_insert_id test fails · 80d89023
      kaa@kaamos.(none) authored
                          sporadically
      
      Under some circumstances, the mysql_insert_id() value after SELECT ...
      INSERT could return a wrong value. This could happen when the last
      SELECT ... INSERT did not involve an AUTO_INCREMENT column, but the
      value of mysql_insert_id() was changed by some previous statements.
      
      Fixed by checking the value of thd->insert_id_used in
      select_insert::send_eof() and returning 0 for mysql_insert_id() if it
      is not set.
      80d89023
  15. 03 Mar, 2008 5 commits
    • joerg@trift2.'s avatar
      687d2131
    • sergefp@mysql.com's avatar
      BUG#34945: "ref_or_null queries that are null_rejecting and have a null value crash mysql" · b779af55
      sergefp@mysql.com authored
      - Apply Eric Bergen's patch: in join_read_always_key(), move ha_index_init() call
        to before the late NULLs filtering code.
      - Backport function comments from 6.0.
      b779af55
    • kaa@kaamos.(none)'s avatar
      Merge kaamos.(none):/data/src/opt/bug31781/my50 · 232e9d3c
      kaa@kaamos.(none) authored
      into  kaamos.(none):/data/src/opt/mysql-5.0-opt
      232e9d3c
    • kaa@kaamos.(none)'s avatar
      Fix for bug #31781: multi-table UPDATE with temp-pool enabled fails · bd53f960
      kaa@kaamos.(none) authored
                          with errno 17
      
      my_create() did not perform any checks for the case when a file is
      successfully created by a call to open(), but the call to
      my_register_filename() later fails because the number of open files
      has exceeded the my_open_files limit. This can happen on platforms 
      which do not have getrlimit(), and hence we do not know the real limit
      for open files. In such a case an error was returned to a caller
      although the file has actually been created. Since callers assume
      my_create() to return an error only when it failed to create a file,
      they did not perform any cleanups, leaving an 'orphaned' file on the
      file system.
      
      Fixed by adding a check for the above case to my_create() and ensuring
      the newly created file is deleted before returning an error.
      
      Creating a deterministic test case in the test suite is impossible,
      because the exact steps required to reproduce the above situation
      depend on the platform and/or environment (OS per-user limits, queries
      executed by previous tests, startup parameters). The patch was
      manually tested on Windows using examples posted in the bug report.
      bd53f960
    • gluh@mysql.com/mgluh.(none)'s avatar
      test case fix · fc1ae077
      gluh@mysql.com/mgluh.(none) authored
      fc1ae077
  16. 01 Mar, 2008 1 commit
  17. 29 Feb, 2008 8 commits
  18. 28 Feb, 2008 1 commit