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