Description: 1) On Windows 2000 : With a 4.0.0alpha-max server, a SELECT ... LOCK IN SHARE MODE issued in a 11.15 (from the 3.23.46a-max distrib) or 11.16 (from the 4.0.0alpha distrib) mysql client generates ERROR 1064: You have an error in your SQL syntax near 'lock in share mode'. Whereas it works well with a 3.23.46a-max server and both clients. 2) On Linux : With a 4.0.0alpha-max server (installed from the RPMs), a SELECT ... LOCK IN SHARE MODE issued in a 11.16 (from the 4.0.0alpha distrib) mysql client generates ERROR 1064: You have an error in your SQL syntax near 'lock in share mode'.

How-To-Repeat: With a 4.0.0alpha-max server, in a 11.16 mysql client, on Windows 2000 or Linux : create table t (a int) type=innodb; insert into t values(10); begin; select * from t lock in share mode;

Fix: ?

Synopsis: <mysql 4.0.0alpha-max server on Windows 2000 and Linux rejects LOCK IN SHARE MODE> Submitter-Id: <?> Originator: <Guilhem BICHOT> Organization: <> MySQL support: [none] Severity: [serious] Priority: [] Category: [mysqld] Class: [sw-bug] Release: mysql-4.0.0alpha

Executable: [mysqld-max-nt for Windows, mysqld-max for Linux ] Environment: <Windows 2000 Workstation and Linux Mandrake 8.1> System: <> Architecture: Pentium III