Subject: quirky MySQL:innodb locking...
>
> OnMySQL 5.1.14-beta-community (windows) 5.1.7-beta (linux)
>
> Consider:
> CREATE TABLE
> Entity
> (
> Entity_ID char(4) NOT NULL,
> Entity_Name varchar(50) NULL,
>
> PRIMARY KEY ( Entity_ID )
> ) ENGINE=InnoDB
OnMySQL 5.1.14-beta-community (windows) 5.1.7-beta (linux)
Consider:
CREATE TABLE
Entity
(
Entity_ID char(4) NOT NULL,
Entity_Name varchar(50) NULL,
PRIMARY KEY ( Entity_ID )
) ENGINE=InnoDB ;
now create a dumb function to use this data:
DELIMITER $$
DROP FUNCTION IF EXISTS voxin
