Table doesn't exist from stored function

2007-03-07 Thread Imre Palik
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

Problem with new mysql versions. (They hang)

2007-02-08 Thread Imre Palik
Hi, I am running relatively complex queries to analyse a dataset. I have query execution times of around half an hour with version 5.27 I tried both version 5.33 and 5.34, and experienced the following: The first few queries ar run faster than with version 5.27, but after a while a query r