bzr commit into mysql-6.0 tree (marc.alff:2652) Bug#35578

[Marc Alff]

#At file:///home/malff/BZR-TREE/mysql-6.0-35578/

------------------------------------------------------------
revno: 2652
revision-id: marc.alff@stripped
parent: sergefp@stripped
committer: Marc Alff <marc.alff@stripped>
branch nick: mysql-6.0-35578
timestamp: Thu 2008-06-12 09:21:49 -0600
message:
  Bug#35578 (Parser allows useless/illegal CREATE TABLE syntax)
  
  Fix the (still non supported) CHECK syntax to:
  - enforce that parenthesis are present in the "CHECK ( <expr> )" syntax,
  per the SQL specification
  - enforce that "CONSTRAINT <name>" alone, without any constraint, is illegal,
  per the SQL specification
  
  Fixing this also resolves 3 shift/reduce conflicts in the grammar.
modified:
  mysql-test/r/constraints.result sp1f-constraints.result-20021124134717-7zxvgqnu6v5ledfcj7ogb7td4p2t7vom
  mysql-test/t/constraints.test  sp1f-constraints.test-20021124134717-oq4swkpdmf7yoq5xf5gem2vum6qvdqz6
  sql/sql_yacc.yy                sp1f-sql_yacc.yy-19700101030959-wvn4qyy2drpmge7kaq3dysprbhlrv27j
per-file comments:
  mysql-test/r/constraints.result
    Bug#35578 (Parser allows useless/illegal CREATE TABLE syntax)
  mysql-test/t/constraints.test
    Bug#35578 (Parser allows useless/illegal CREATE TABLE syntax)
  sql/sql_yacc.yy
    Bug#35578 (Parser allows useless/illegal CREATE TABLE syntax)

Attachment: [text/text/x-diff] patch-2652.diff