1. 25 Apr, 2006 1 commit
  2. 24 Apr, 2006 2 commits
    • dlenev@mysql.com's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0-runtime · 0fd2c5b5
      dlenev@mysql.com authored
      into  mysql.com:/home/dlenev/mysql-5.0-bg11081
      0fd2c5b5
    • dlenev@mysql.com's avatar
      Fix for bug#11081 "Using a CONVERT_TZ function in a stored function or · 2033f7ba
      dlenev@mysql.com authored
      trigger fails".
      
      In cases when CONVERT_TZ() function was used in trigger or stored function
      (or in stored procedure which was called from trigger or stored function)
      error about non existing '.' table was reported.
      
      Statements that use CONVERT_TZ() function should have time zone related
      tables in their table list. tz_init_table_list() function which is used
      to produce part of table list containing those tables didn't set
      TABLE_LIST::db_length/table_name_length members properly. As result time
      zone tables needed for CONVERT_TZ() function were incorrectly handled by
      prelocking algorithm and "Table '.' doesn't exist' error was emitted.
      This fix changes tz_init_table_list() in such way that it properly inits
      TABLE_LIST::table_name_length/db_length members and thus produces table list
      which can be handled by prelocking algorithm correctly.
      2033f7ba
  3. 23 Apr, 2006 2 commits
  4. 22 Apr, 2006 2 commits
    • dlenev@mysql.com's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0-runtime · 5e7076ce
      dlenev@mysql.com authored
      into  mysql.com:/home/dlenev/mysql-5.0-bg15153-2
      5e7076ce
    • dlenev@mysql.com's avatar
      Fix for bug#15153 "CONVERT_TZ() is not allowed in all places in VIEWs". · c77d5a0e
      dlenev@mysql.com authored
      Error was emitted when one tried to select information from view which used
      merge algorithm and which also had CONVERT_TZ() function in its select list.
      
      This bug was caused by wrong assumption that global table list for view
      which is handled using merge algorithm begins from tables belonging to
      the main select of this view. Nowadays the above assumption is not true only
      when one uses convert_tz() function in view's select list, but in future
      other cases may be added (for example we may support merging of views
      with subqueries in select list one day). Relying on this false assumption
      led to the usage of wrong table list for field lookups and therefor errors. 
      
      With this fix we explicitly use pointer to the beginning of main select's
      table list.
      c77d5a0e
  5. 21 Apr, 2006 16 commits
  6. 20 Apr, 2006 16 commits
  7. 19 Apr, 2006 1 commit