• unknown's avatar
    Fix bug #11416 Server crash if using a view that uses function convert_tz · de4fbc21
    unknown authored
    When parser parses function convert_tz it loads available timezone tables in
    thd->lex->time_zone_tables_used. But view have another lex that main query.
    Thus time_zone_tables_used of main query left uninitialized.
    When Item_func_conver_tz is fixed it takes timezone tables from main query
    and later when it executed it assumes that timezone tables are loaded and
    failed that assertion.
    
    
    
    sql/sql_view.cc:
      Fix bug #11416 Server crash if using a view that uses function convert_tz
    mysql-test/r/view.result:
      Test case for bug#11416 Server crash if using a view that uses function convert_tz
    mysql-test/t/view.test:
      Test case for bug#11416 Server crash if using a view that uses function convert_tz
    de4fbc21
view.test 55.1 KB