diff options
| author | igor@olga.mysql.com <> | 2007-12-07 23:36:58 -0800 |
|---|---|---|
| committer | igor@olga.mysql.com <> | 2007-12-07 23:36:58 -0800 |
| commit | c04d3727dcae1a7de83d2caf0b72869d703470cf (patch) | |
| tree | 1ba07ebaff7001c989b3db280d4e56a82ab94f08 /mysql-test/r/func_misc.result | |
| parent | 987ec3f306e43faf55981b3e71e7a3fe5ebccea0 (diff) | |
| download | mariadb-git-c04d3727dcae1a7de83d2caf0b72869d703470cf.tar.gz | |
Fixed bug #27545.
Both arguments of the function NAME_CONST must be constant expressions.
This constraint is checked in the Item_name_const::fix_fields method.
Yet if the argument of the function was not a constant expression no
error message was reported. As a result the client hanged waiting for a
response.
Now the function Item_name_const::fix_fields reports an error message
when any of the additional context conditions imposed on the function
NAME_CONST is not satisfied.
Diffstat (limited to 'mysql-test/r/func_misc.result')
| -rw-r--r-- | mysql-test/r/func_misc.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index c941790c35b..d04c22c0c9d 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -207,4 +207,9 @@ test SELECT NAME_CONST('test', 'test'); test test +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (5), (2); +SELECT NAME_CONST(x,2) FROM (SELECT a x FROM t1) t; +ERROR HY000: The 'NAME_CONST' syntax is reserved for purposes internal to the MySQL server +DROP TABLE t1; End of 5.0 tests |