MIN(), MAX() not working with LEFT JOIN? Bug?

2003-03-10 Thread Morten Winther
Hello I would asume that these two queries would give the same output? Am I wrong? Seems like the where part don't have any effect on the LEFT JOIN when it comes to MIN() and MAX(). SELECT count( plads_ordre.id ) as antal, MIN( forestilling.arrangement_id ) as min, MAX(

Transaction with InnoDB - how to lock?

2002-06-20 Thread Morten Winther
Hello I have a system where users are able to buy tickets to shows etc. Right now I use the MyISAM as tabletype but I would like to try InnoDB to make safe transactions. For the moment I use a TABLE LOCK to make sure that the same ticket isn't sold twise. One of the table consists on these 3