Bug #34073 | stored function fails to return a value with a temporary table with auto increme | ||
---|---|---|---|
Submitted: | 26 Jan 2008 2:40 | Modified: | 26 Jan 2008 20:45 |
Reporter: | sfa afddf | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S2 (Serious) |
Version: | 5.0.45 | OS: | MacOS |
Assigned to: | CPU Architecture: | Any | |
Tags: | auto_increment, stored function, temporary table |
[26 Jan 2008 2:40]
sfa afddf
[26 Jan 2008 6:44]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior: mysql> DELIMITER $$ mysql> CREATE FUNCTION `meow`(seed VARCHAR(100)) RETURNS int -> BEGIN -> -> DROP TEMPORARY TABLE IF EXISTS pfiltered; -> CREATE TEMPORARY TABLE pfiltered(id INT AUTO_INCREMENT primary key); -> -> return 2; -> -> END -> $$ Query OK, 0 rows affected (0.10 sec) mysql> mysql> select meow('a')$$ +-----------+ | meow('a') | +-----------+ | 2 | +-----------+ 1 row in set, 1 warning (0.06 sec) mysql> show warnings$$ +-------+------+---------------------------+ | Level | Code | Message | +-------+------+---------------------------+ | Note | 1051 | Unknown table 'pfiltered' | +-------+------+---------------------------+ 1 row in set (0.00 sec) mysql>
[26 Jan 2008 20:45]
sfa afddf
thanks.. i realized that when the primary key attribute is not set, the error is not displayed by the Mac OS X's Query Browser...