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 Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.18-nt OS:Windows (Windows XP Pro)
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.