Oracle
1Z0-882 · Question #84
Consider the statements: Mysql> drop function foo; ERROR 1305 (420000): FUNCTION test, foo does not exist Mysql > show warnings; Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT; What is the…
The correct answer is B. A warning message is generated that adds error 1758 (invalid condition number) to the. See the full explanation below for the reasoning.
Question
Consider the statements:
Mysql> drop function foo; ERROR 1305 (420000): FUNCTION test, foo does not exist Mysql > show warnings; Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT; What is the result of the final statement?
Options
- AAn empty result is returned.@msg is set to message of the warning.
- BA warning message is generated that adds error 1758 (invalid condition number) to the
- CA line will be an output to the error log that contains the warning message details from the failed
- DAn error is generated as only one condition can exist in the diagnostics area.
How the community answered
(35 responses)- A6% (2)
- B83% (29)
- C9% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.