1. 27 Oct, 2007 1 commit
  2. 26 Oct, 2007 3 commits
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · 7e26bcec
      unknown authored
      into  mysql.com:/scratch/tnurnberg/31662/51-31662
      
      
      sql/sql_base.cc:
        Auto merged
      7e26bcec
    • unknown's avatar
      Merge mysql.com:/scratch/tnurnberg/31662/50-31662 · 93f1f1f8
      unknown authored
      into  mysql.com:/scratch/tnurnberg/31662/51-31662
      
      
      mysql-test/r/information_schema_db.result:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      93f1f1f8
    • unknown's avatar
      Bug#31662: 'null' is shown as type of fields for view with bad definer, breaks mysqldump · a4698b61
      unknown authored
      SHOW FIELDS FROM a view with no valid definer was possible (since fix
      for Bug#26817), but gave NULL as a field-type. This led to mysqldump-ing
      of such views being successful, but loading such a dump with the client
      failing. Patch allows SHOW FIELDS to give data-type of field in underlying
      table.
      
      
      mysql-test/r/information_schema_db.result:
        Fix test results: SHOW FIELDS FROM a view with no valid DEFINER
        gives us the field-type of the underlying table now rather than NULL.
      sql/sql_base.cc:
        In the case of SHOW FIELDS FROM <view>, do not require a valid
        DEFINER for determining underlying data-type like we usually do.
        This is needed for mysqldump.
      a4698b61
  3. 24 Oct, 2007 4 commits
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B30715-merged-5.0-opt · a63f873e
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B30715-merged-5.1-opt
      
      
      mysql-test/r/func_group.result:
        Auto merged
      mysql-test/r/type_decimal.result:
        Auto merged
      mysql-test/t/func_group.test:
        Auto merged
      mysql-test/t/type_decimal.test:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/opt_sum.cc:
        merge bug 30715 to 5.1-opt
      a63f873e
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B30715-5.0-opt · 911dd5b5
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B30715-merged-5.0-opt
      
      911dd5b5
    • unknown's avatar
      Bug #30715: Assertion failed: item_field->field->real_maybe_null(), · d74214fd
      unknown authored
        file .\opt_sum.cc, line
      The optimizer pre-calculates the MIN/MAX values for queries like
       SELECT MIN(kp_k) WHERE kp_1 = const AND ... AND kp_k-1 = const
      when there is a key over kp_1...kp_k
      In doing so it was not checking correctly nullability and 
      there was a superfluous assert(). 
      Fixed by making sure that the field can be null before checking and
      taking out the wrong assert().
      .
      Introduced a correct check for nullability 
      The MIN(field) can return NULL when all the row values in the group
      are NULL-able or if there were no rows.
      Fixed the assertion to reflect the case when there are no rows.
      
      
      mysql-test/r/func_group.result:
        Bug #30715: test case
      mysql-test/t/func_group.test:
        Bug #30715: test case
      sql/opt_sum.cc:
        Bug #30715: correct nullability check for MIN/MAX pre-calculation over index.
      d74214fd
    • unknown's avatar
      result fix · 611a8972
      unknown authored
      611a8972
  4. 23 Oct, 2007 32 commits