• unknown's avatar
    Fixed bug #5500: EXPLAIN returned a wrong select_type for queries using views. · 22c3e7b4
    unknown authored
    Select_type in the EXPLAIN output for the query SELECT * FROM t1 was
    'SIMPLE', while for the query SELECT * FROM v1, where the view v1
    was defined as SELECT * FROM t1, the EXPLAIN output contained 'PRIMARY'
    for the select_type column.
     
    
    
    mysql-test/r/group_by.result:
      Adjusted results after the fix for bug #5500.
    mysql-test/r/information_schema.result:
      Adjusted results after the fix for bug #5500.
    mysql-test/r/olap.result:
      Adjusted results after the fix for bug #5500.
    mysql-test/r/range.result:
      Adjusted results after the fix for bug #5500.
    mysql-test/r/view.result:
      Added a test case for bug #5500.
      Adjusted other results.
    mysql-test/r/view_grant.result:
      Adjusted results after the fix for bug #5500.
    mysql-test/t/view.test:
      Added a test case for bug #5500.
    22c3e7b4
sql_select.cc 455 KB