accumulating query

2004-02-17 Thread Bruce Altner
Hello. I just installed 4.0.18-nt and I am getting very weird results. I asked this before but the example was too complicated to follow. Sorry about that. Here it is in a much simpler form: For example after restarting mysqld I run this query: select location from vevents where event_id=15 UN

UNION caches query?

2004-02-17 Thread Bruce Altner
45 |45 | 2004-02-11 16:30:00 | 2004-02-11 17:30:00 | A simultaneous event |45 |45 | 2004-02-11 16:30:00 | 2004-02-11 17:30:00 | On top of old smokey SNIP... Is there a cache setting that I should be turning off here...I should get 16 rows for each query. (SQL_NO_CACHE has no effect). Thanks, in advance, Bruce Altner