Imre,
You may have found a stored function bug--the server tries to evaluate
the SELECT statement within the IF block when IF condition is false.
PB
-
Shawn Green wrote:
Hello Imre,
Imre Palik wrote:
Hi,
When I try to run this function, I receive ERROR 1146 (42S02): Table
'gi2.meta'
Hello Imre,
Imre Palik wrote:
Hi,
When I try to run this function, I receive ERROR 1146 (42S02): Table
'gi2.meta' doesn't exist
CREATE FUNCTION get_version()
RETURNS INT UNSIGNED
BEGIN
DECLARE exist_ TINYINT;
SELECT COUNT(*) INTO exist_ FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA =
Hi,
When I try to run this function, I receive ERROR 1146 (42S02): Table
'gi2.meta' doesn't exist
CREATE FUNCTION get_version()
RETURNS INT UNSIGNED
BEGIN
DECLARE exist_ TINYINT;
SELECT COUNT(*) INTO exist_ FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'GI2' AND TABLE_NAME = 'Meta' L