Bug #17130 Command Line Client won't run "show function status" after creating function

• Submitted: 5 Feb 2006 4:14
• Modified: 6 Feb 2006 2:07
• Reporter: Matt Borack
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.18-nt
• OS: Windows (Windows XP Pro)
• CPU Architecture: Any

[5 Feb 2006 4:14] Matt Borack

Description:

After creating a function using "source filename" in the MySQL Command Line Client, I am unable to get "show function status" to run. Instead, the cursor is moved to a new line with a "->" prompt. 

Note: I am able to run "show function status" before "source filename" without any problems.

How to repeat:

Login as root.

use test

show function status;

source c.txt

show function status;

* ERROR *

[5 Feb 2006 4:15] Matt Borack

Create test function

Attachment: c.txt (text/plain), 245 bytes.

[5 Feb 2006 23:29] Hartmut Holzgraefe

Works fine on linux, looks like a windows-only problem?

[6 Feb 2006 1:24] MySQL Verification Team

I was unable to repeat the behavior reported:

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> show function status\G
Empty set (0.02 sec)

mysql> source c:/c.txt
Database changed
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> show function status\G
*************************** 1. row ***************************
           Db: test
         Name: test
         Type: FUNCTION
      Definer: root@localhost
     Modified: 2006-02-05 23:22:28
      Created: 2006-02-05 23:22:28
Security_type: DEFINER
      Comment:
1 row in set (0.00 sec)

mysql>

[6 Feb 2006 2:07] Matt Borack

I apologize in advance. I failed to mention that "show function status" fails in the way I mentioned after executing the attached script file when that script file contains an error. For example, remove "set" from the line "set return_value = 'a';", attempt to execute it using "use c:/c.txt", then try "show function status" again. 

Note: This problem is very similiar to the other problem I reported: 17124