• Alexander Barkov's avatar
    MDEV-28769 Assertion `(m_ci->state & 32) || m_with_collate' failed in... · a923d6f4
    Alexander Barkov authored
    MDEV-28769 Assertion `(m_ci->state & 32) || m_with_collate' failed in Lex_exact_charset_opt_extended_collate::Lex_exact_charset_opt_extended_collate on SET NAMES
    
    These system variables:
      @@character_set_client
      @@character_set_connection
      @@character_set_database
      @@character_set_filesystem
      @@character_set_results
      @@character_set_server
    
    can now be set in numeric format only to IDs of default collations, e.g.:
    
    SET @@character_set_xxx=9;  -- OK    (latin2_general_ci  is default)
    SET @@character_set_xxx=2;  -- ERROR (latin2_czech_cs is not default)
    SET @@character_set_xxx=21; -- ERROR (latin2_hungarian_ci is not default)
    
    Before this change the server accepted IDs of non-default collations
    so all three examples above worked without errors,
    but this could lead to unexpected behavior in later statements.
    a923d6f4
character_set_connection_basic.result 17 KB