• unknown's avatar
    Fix for Bug#32538: View definition picks up character set, · c1d0dd94
    unknown authored
    but not collation.
    
    The problem here was that text literals in a view were always
    dumped with character set introducer. That lead to loosing
    collation information.
    
    The fix is to dump character set introducer only if it was
    in the original query. That is now possible because there 
    is no problem any more of loss of character set of string
    literals in views -- after WL#4052 the view is dumped 
    in the original character set.
    
    
    mysql-test/r/case.result:
      Update result file.
    mysql-test/r/compress.result:
      Update result file.
    mysql-test/r/ctype_collate.result:
      Update result file.
    mysql-test/r/date_formats.result:
      Update result file.
    mysql-test/r/ddl_i18n_koi8r.result:
      Update result file.
    mysql-test/r/ddl_i18n_utf8.result:
      Update result file.
    mysql-test/r/fulltext.result:
      Update result file.
    mysql-test/r/func_crypt.result:
      Update result file.
    mysql-test/r/func_encrypt.result:
      Update result file.
    mysql-test/r/func_if.result:
      Update result file.
    mysql-test/r/func_in.result:
      Update result file.
    mysql-test/r/func_like.result:
      Update result file.
    mysql-test/r/func_regexp.result:
      Update result file.
    mysql-test/r/func_set.result:
      Update result file.
    mysql-test/r/func_str.result:
      Update result file.
    mysql-test/r/func_time.result:
      Update result file.
    mysql-test/r/gis.result:
      Update result file.
    mysql-test/r/group_min_max.result:
      Update result file.
    mysql-test/r/mysqldump.result:
      Update result file.
    mysql-test/r/negation_elimination.result:
      Update result file.
    mysql-test/r/null.result:
      Update result file.
    mysql-test/r/select.result:
      Update result file.
    mysql-test/r/show_check.result:
      Update result file.
    mysql-test/r/sp-code.result:
      Update result file.
    mysql-test/r/ssl.result:
      Update result file.
    mysql-test/r/ssl_compress.result:
      Update result file.
    mysql-test/r/subselect.result:
      Update result file.
    mysql-test/r/temp_table.result:
      Update result file.
    mysql-test/r/type_blob.result:
      Update result file.
    mysql-test/r/view.result:
      Update result file.
    mysql-test/suite/binlog/r/binlog_stm_blackhole.result:
      Update result file.
    mysql-test/suite/rpl/r/rpl_get_lock.result:
      Update result file.
    mysql-test/suite/rpl/r/rpl_master_pos_wait.result:
      Update result file.
    mysql-test/t/view.test:
      Add a test case for Bug#32538.
    sql/item.cc:
      Do not dump character set introducer if it was not specified
      explicitly in the original query.
    sql/item.h:
      Add 'cs_specified' property to Item_string.
    sql/sql_yacc.yy:
      Set Item_string::cs_specified property to TRUE
      when character set introducer is explicitly specified.
    c1d0dd94
view.result 111 KB