Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
I create a stored function with a name of an existing built-in function.
CREATE OR REPLACE FUNCTION UPPER() RETURNS TEXT RETURN 'upper'; |
SHOW WARNINGS;
|
+-------+------+--------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+--------------------------------------------------------------+
|
| Note | 1585 | This function 'UPPER' has the same name as a native function |
|
+-------+------+--------------------------------------------------------------+
|
It correctly returns a warning.
Now I query I_S.ROUTINES and I_S.PARAMETERS:
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='test' AND ROUTINE_NAME='upper'; |
SHOW WARNINGS;
|
+-------+------+--------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+--------------------------------------------------------------+
|
| Note | 1585 | This function 'upper' has the same name as a native function |
|
+-------+------+--------------------------------------------------------------+
|
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA='test' AND SPECIFIC_NAME='upper'; |
SHOW WARNINGS;
|
+-------+------+--------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+--------------------------------------------------------------+
|
| Note | 1585 | This function 'UPPER' has the same name as a native function |
|
+-------+------+--------------------------------------------------------------+
|
It also returns warnings. This is too verbose.
Let's suppress warnings during I_S queries.
Attachments
Issue Links
- relates to
-
MDEV-31736 Create native function for format_bytes
-
- Closed
-