Hi! On Nov 30, Ian Collins wrote:
> Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table > READ, etc) are low level and the use is pretty hairy! > However, the following is a fairly basic problem, and if it cannot be > overcome, one would question the validity of having HANDLER at all. (read > that with a smile please). > > If I do an insert to a table from within my application, and then, from > another mysql session, do > > HANDLER mytable OPEN; > HANDLER mytable READ FIRST; > > then I get, > ERROR 1030: Got error 1 from table handler > > However, if I do a > > select * from mytable; > > then I (as one would hope!) see my new data. Could you, please, create a testcase for that ? Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php