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: | |
| 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
[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.