Bug #7024 FUNCTION does not exist when using CREATE VIEW
Submitted: 5 Dec 2004 21:52 Modified: 24 Jun 2005 17:09
Reporter: Shiang-Rung Wang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1 OS:FreeBSD (FreeBSD 5.x)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[5 Dec 2004 21:52] Shiang-Rung Wang 
Description:
I can't use some function in the VIEW.
Ex: ENCRYPT, SUBSTRING_INDEX

How to repeat:
mysql> CREATE TABLE `t` (`a` VARCHAR(8));
mysql> INSERT INTO `t` VALUES("aaa");
mysql> CREATE VIEW `v` AS SELECT ENCRYPT(`a`) FROM `t`;
mysql> SELECT * FROM `v`;
ERROR 1304 (42000): FUNCTION test.ecrypt does not exist

mysql> CREATE TABLE `t` (`a` VARCHAR(13));
mysql> INSERT INTO `t` VALUES("a:b:c");
mysql> CREATE VIEW `v` AS SELECT SUBSTRING_INDEX(`a`, ":", 1) FROM `t`;
mysql> SELECT * FROM `v`;
ERROR 1304 (42000): FUNCTION test.substr_index does not exist
[5 Dec 2004 22:46] Hartmut Holzgraefe 
Could only verify the first case. Please note that the error message says "ecrypt", not "encrypt". Maybe the missing "n" is the key to it?
[6 Dec 2004 7:03] Shiang-Rung Wang 
I didn't missing the 'n'
if I use "ECRYPT"
when I CREATE VIEW, mysql will give me error.

mysql> CREATE TABLE `t` (`a` VARCHAR(8));
mysql> INSERT INTO `t` VALUES("aaa");
mysql> CREATE VIEW `v` AS SELECT ECRYPT(`a`) FROM `t`;
ERROR 1304 (42000): FUNCTION test.ECRYPT does not exist
[23 Jun 2005 21:24] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/26385
[24 Jun 2005 7:09] Oleksandr Byelkin 
pushed to 5.0.9
[24 Jun 2005 17:09] Mike Hillyer 
Documented in 5.0.9 changelog:

<listitem><para>The <literal>ENCRYPT()</literal> and <literal>SUBSTRING_INDEX()</literal> functions would cause errors when used with a <literal>VIEW</literal>. (Bug #7024)</para></listitem>