MySQL Forums
Forum List  »  MySQL Administrator

Administrator and Query Browser fail under XP with stored function
Posted by: David Fuess
Date: October 01, 2005 08:31PM

Not sure where to put this one so I'll put it here.

OS: Windows XP SP2
MySQL 5.0.13 RC
Administrator 1.1.3
Browser 1.1.15

If I define a Stored Function then both the Administrator and Query Browser will fail to read the schema with

"Access violation at address 77C478C0 in moduse 'mscvrt.dll'. Read of address 00000010.

Sometimes the Read of address changes depending on what's in the function.

Here's a test case if you want to try it. Execute the script under the Browser then try to examint the dtest table under the Administrator.

DROP TABLE IF EXISTS cities;
CREATE TABLE cities (
country char(2) NOT NULL default '',
city varchar(100) NOT NULL default '',
city_accented varchar(100) NOT NULL default '',
region char(2) NOT NULL default '',
latitude decimal(12,7) NOT NULL default '0.0000000',
longitude decimal(12,7) NOT NULL default '0.0000000'
) ENGINE=InnoDB;

DELIMITER $$
DROP FUNCTION IF EXISTS `dtest`.`gsDist`$$
CREATE FUNCTION `dtest`.`gsDist`(
lat1 DOUBLE(12,7), lon1 DOUBLE(12,7),
lat2 DOUBLE(12,7), lon2 DOUBLE(12,7)
) RETURNS DOUBLE (20,10)
BEGIN
RETURN ROUND(3963.0 *
acos(
sin(lat1/57.2958) *
sin(lat2/57.2958) +
cos(lat1/57.2958) *
cos(lat2/57.2958) *
cos(lon2/57.2958 - lon1/57.2958)
), 3);
END$$
DELIMITER ;

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.