MySQL Bugs: #2252: getting 'Select command denied error' when trying to delete row

Bug #2252	getting 'Select command denied error' when trying to delete row
Submitted:	1 Jan 2004 19:25	Modified:	2 Feb 2004 6:51
Reporter:	[ name withheld ]	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.16-nt	OS:	Windows (winXP)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When trying to delete a row (one that I have just done a select statement to find) I am getting "Select command denied to user XXX for table XXX".  I have the privileges to perform the select and the delete on the table

How to repeat:
The exact statement I used was:

delete from debtor_transaction where transactionID = 302306;

Below is the structure of the table that I am having difficulty with:

-- Table structure for table `debtor_transaction`
--

CREATE TABLE debtor_transaction (
  TransactionID int(11) NOT NULL default '0',
  DebtorID int(11) default NULL,
  Amount decimal(8,2) default NULL,
  date datetime default NULL,
  term smallint(6) default NULL,
  date_paid datetime default NULL,
  purchase_order int(11) default NULL,
  GST decimal(8,2) default NULL,
  PRIMARY KEY  (TransactionID),
  KEY debtorIDIndex (DebtorID),
  KEY dateIndex (date)
) TYPE=MyISAM;

INSERT INTO debtor_transaction VALUES (302305,53,696.30,'2002-11-29 00:00:01',30,'2002-12-20 00:00:01',0,63.30);
INSERT INTO debtor_transaction VALUES (302306,72,1053.48,'2002-12-02 00:00:01',30,'2002-12-12 00:00:01',0,95.77);
INSERT INTO debtor_transaction VALUES (302307,73,153.75,'2002-12-02 00:00:01',30,'2002-12-10 00:00:01',0,13.98);

and the entries in tables_priv (I am logged on as steve@"203.%")

Host	Db	User	Table_name	Grantor	Timestamp	Table_priv	Column_priv
localhost	menagerie	steve	debtor_transaction	root@127.0.0.1	20031212141410	Select,Insert,Update,Delete,Create,Drop,Grant,References,Index	
203.%	menagerie	steve	debtor_transaction	root@127.0.0.1	20031212141748	Select,Insert,Update,Delete,Create,Drop,Grant,References,Index

I cannot repeat this, so if you would:

See what login mysqld has identified for you: SELECT CURRENT_USER();

And see what grants mysqld has set for you (rather than querying the grant tables directly): SHOW GRANTS FOR user@host;

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".