• unknown's avatar
    Implemented the stored procedure data access characteristics: · a750003f
    unknown authored
    NO SQL
    CONTAINS SQL (default)
    READS SQL DATA
    MODIFIES SQL DATA
    
    These are needed as hints for the replication.
    (Before this, we did have the default in the mysql.proc table, but no support in the parser.)
    
    
    mysql-test/r/sp.result:
      Modified test cases for new data access characteristics.
    mysql-test/t/sp.test:
      Modified test cases for new data access characteristics.
    scripts/mysql_create_system_tables.sh:
      We now support all the SP data access characteristics (not just CONTAINS SQL).
    scripts/mysql_fix_privilege_tables.sql:
      We now support all the SP data access characteristics (not just CONTAINS SQL).
    sql/lex.h:
      New tokens for SP data access characteristics.
    sql/sp.cc:
      Store, print and support alter of data access characteristics.
    sql/sp_head.cc:
      Added SP_ prefix to some symbols.
    sql/sql_lex.h:
      Added SP_ prefix to some symbols, and added SP data access enum.
    sql/sql_yacc.yy:
      Parse SP data access characteristics.
      (And allow "alter ... language sql", mostly as a formality, it was accidently
       put in the wrong clause before.)
    a750003f
sp.cc 30.6 KB