• unknown's avatar
    Fixed BUG#3709: SELECT INTO 1 FROM DUAL not parsed as expected · de2c3523
    unknown authored
    Made the combination of INTO and FROM DUAL work, e.g.
    SELECT 1 INTO @x FROM DUAL.
    As a consequence, DUAL is made a reserved word. It would work to not have
    it reserved, but it was deemed to be confusing as a user defined table by
    the same name then must be qualified with a db (schema).
    
    
    sql/sql_yacc.yy:
      Made the combination of INTO and FROM DUAL work, e.g.
      SELECT 1 INTO @x FROM DUAL.
      As a consequence, DUAL is made a reserved word. It would work to not have
      it reserved, but it was deemed to be confusing as a user defined table by
      the same name then must be qualified with a db (schema).
    de2c3523
sql_yacc.yy 145 KB