• unknown's avatar
    Fixed bug #21231: wrong results for a simple query with a · d64f605e
    unknown authored
    a non-correlated single-row subquery over information schema.
    
    The function get_all_tables filling all information schema
    tables reset lex->sql_command to SQLCOM_SHOW_FIELDS. After
    this the function could evaluate partial conditions related to
    some columns. If these conditions contained a subquery over
    information schema it led to a wrong evaluation and a wrong 
    result set.
    This bug was already fixed in 5.1.
    This patch follows the way how it was done in 5.1 where
    the value of lex->sql_command is set to SQLCOM_SHOW_FIELDS
    in get_all_tables only for the calls of the function 
    open_normal_and_derived_tables and is restored after these
    calls.
    
    
    mysql-test/r/information_schema.result:
      Added a test case for bug #21231.
    mysql-test/t/information_schema.test:
      Added a test case for bug #21231.
    d64f605e
information_schema.test 27.2 KB