Please report as bug in category MySQL Cluster at bugs.mysql.com
Thanks,
T
Joseph E. Sacco, Ph.D. wrote:
>Encountered a problem with 'LOCK TABLE'.
>
>Given an NDB table named 'user':
>
>mysql> describe user;
>+--------------+------------------+------+-----+--------+--------------+
>| Field | Type | Null | Key | Default|Extra |
>+--------------+------------------+------+-----+--------+--------------+
>| user_id | int(10) unsigned | | PRI | NULL |auto_increment|
>| email | varchar(255) | YES | | NULL | |
>| first_name | varchar(64) | YES | | NULL | |
>| last_name | varchar(64) | YES | | NULL | |
>| login | varchar(255) | | MUL | | |
>| mobile_phone | varchar(32) | YES | | NULL | |
>| password | varchar(255) | | | | |
>| phone | varchar(32) | YES | | NULL | |
>| hidden | tinyint(1) | | MUL | 0 | |
>+--------------+------------------+------+-----+---------+-------------+
>
>Consider the following:
>
> mysql> LOCK TABLES user WRITE;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> delete from user where login='jsacco';
> ERROR 1296 (HY000): Got error 208 '208' from ndbcluster
>
>
>
>Now unlock the table and try once more:
>
> mysql> UNLOCK TABLES;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> delete from user where login='jsacco';
> Query OK, 1 row affected (0.02 sec)
>
>Hmmm....
>
>Do we have permission to lock the table???
>
> mysql> use mysql;
> mysql> select User, Host, Lock_tables_priv from user where
> User='root' \G
> *************************** 1. row ***************************
> User: root
> Host: localhost
> Lock_tables_priv: Y
> *************************** 2. row ***************************
> User: root
> Host: musa.jesacco.com
> Lock_tables_priv: Y
> 2 rows in set (0.01 sec)
>
>Yes...
>
>
>
>If the exercise with a myISAM table all is well.
>
>Thoughts???
>
>
>-Joseph
>
>
>
