[MDEV-16385] ROW SP variable is allowed in unexpected context - Jira

XML

Word

Printable

This script produces no errors:

CREATE OR REPLACE TABLE t1 (a INT);

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE row ROW(a INT);

  SELECT * FROM t1 ORDER BY row;

END;

$$

DELIMITER ;

It should return an error.

The same problem is repeatable with HAVING:

CREATE OR REPLACE TABLE t1 (a INT);

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE row ROW(a INT);

  SELECT * FROM t1 HAVING row;

END;

$$

DELIMITER ;

The same problem is repeatable in LIKE..ESCAPE:

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE a ROW(a INT);

  SELECT 1 LIKE 2 ESCAPE a;

END;

$$

DELIMITER ;

blocks

MDEV-4912 Data type plugin API version 1

MDEV-16388 Replace member Item::fixed to virtual method is_fixed()

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.