Do schema operations affect regular statements? I've run "alter table add column ..." on the large table and it coinsided with "select fld from same_table limit 0,1". And this select returned as if no records were available though there were plenty.
Is this normal? Should schema changes run independantly if they _really_ don't affect regular statements (if fields not involved in select modified) ? I think schema changes should follow transactional paradigm. But that's tough to do, I understand. At least they have to wait on each other. Yuri. sql,query --------------------------------------------------------------------- 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
