• unknown's avatar
    Additional fix for WL#1629: SHOW with WHERE(discussed with PeterG) · 04dabc2b
    unknown authored
     - Do not allow a column list as part of SHOW WITH WHERE task.
     - The WHERE clause must accept field names which are
       valid in SHOW, not INFORMATION_SCHEMA names.
    
    
    mysql-test/r/information_schema.result:
      The test correction
    mysql-test/t/information_schema.test:
      The test correction
    sql/sql_base.cc:
      Process field translation table for 'show' commands
    sql/sql_parse.cc:
      schema_table_seformed is always true for 'show' commands
    sql/sql_show.cc:
      - Do not allow a column list as part of SHOW WITH WHERE task.
      - The WHERE clause must accept field names which are
        valid in SHOW, not INFORMATION_SCHEMA names.
    sql/sql_yacc.yy:
      Do not allow a column list as part of SHOW WITH WHERE task
    sql/table.h:
      A new 'schema_table_reformed' variable in table_list
      If schema_table_reformed is true select items should be 
      translated using field translation table
    04dabc2b
sql_show.cc 119 KB