LOCK TABLES

The following command is not supported in SingleStore DB.

LOCK TABLES table_name [ READ | WRITE ] [, table_name [READ | WRITE]] ...

By default, it will emit this warning:

Feature 'LOCK TABLES' is not supported by SingleStore DB. Execution will continue, but the feature will be ignored.

The command has no effect. If you set the global engine variable warn_level to errors, then this command will return an error instead. The default behavior of returning a warning is for increased compatibility with some MySQL-compatible tools.