• dlenev@mysql.com's avatar
    Fix for bug #10055 "Using stored function with information_schema causes empty · 615baa9f
    dlenev@mysql.com authored
    result set".
    
    To enable full access to contents of I_S tables from stored functions
    or statements that use them, we manipulate with thread's open tables
    state and ensure that we won't cause deadlock when we open tables by
    ignoring flushes and name-locks.
    Building of contents of I_S.TABLES no longer requires locking of tables
    since we use use handler::info() method with HA_STATUS_AUTO flag instead
    of handler::update_auto_increment() for obtaining information about
    auto-increment values. But this also means that handlers have to implement
    support for HA_STATUS_AUTO flag (particularly InnoDB needs it).
    615baa9f
sql_class.cc 46.6 KB