• Jacob Mathew's avatar
    MDEV-15692: install_spider.sql can fail with some collations · 12e2d039
    Jacob Mathew authored
    The error occurs because of how the character set and collation are chosen for
    stored procedure parameters that have a character data type.  If the character
    set and collation are not explicitly stated in the declaration, the server
    chooses the database character set and collation in effect at routine creation
    time.
    
    To fix the problem, I added explicit character set and collation attributes
    for the stored procedure parameters in the install_spider.sql script.
    
    Author:
      Jacob Mathew.
    
    Reviewer:
      Kentoku Shiba.
    
    Cherry-Picked:
      Commit ff0bf451 on bb-10.3-MDEV-15692
    12e2d039
install_spider.sql 14.1 KB