Mikhail, ----- Original Message ----- From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 2:34 PM Subject: Re: Timestamp field in the InnoDB table
> Heikki, > > thank you for your response. > > > Is this a big problem? > > Well, actually it is not very big problem for me now, because I already know > about that feature. ;) > But I would prefer to have timestamp that means the end of the transaction. that is difficult, because then we would need a completion procedure at the end of a transaction which would go to set the timestamps to the transaction commit timepoint. > Anyway it would be very useful to have some notices in the documentation. > Thank you. > > Best regards, > Mikhail. Regards, Heikki > ----- Original Message ----- > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, October 21, 2002 1:20 PM > Subject: Re: Timestamp field in the InnoDB table > > > > Mikhail, > > > > ----- Original Message ----- > > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, October 21, 2002 1:11 PM > > Subject: Timestamp field in the InnoDB table > > > > > > > Hi, > > > > > > I have found one unclear place for me regarding to the timestamp field > in > > > the InnoDB table. > > > Please, explain me am I correct or not. > > > > > > Let's say we have a table Test with 'timestamp' field: > > > > > > CREATE TABLE `Test` ( > > > `id` int(3) NOT NULL auto_increment, > > > `UpdateDate` timestamp(14) NOT NULL, > > > PRIMARY KEY (`id`) > > > ) TYPE=InnoDB; > > > > > > and I try to update one row in this table: > > > > > > update Test set UpdateDate = NULL where id = 1; > > > > > > Let's say I started 'update' statement at 15:00:00. But the row with id > = > > 1 > > > is blocked by another transaction, > > > so 'update' statement needs to wait till the end of the transaction. > > > After 10 sec the block on the record with id = 1 is released. So my > > 'update' > > > finished. > > > > > > select UpdateDate from Test where id = 1 > > > > > > gives me 20021021150000, but I would expect 20021021150010. > > > > > > So what do you think about it? > > > > > > looks like the MySQL interpreter assigns the clock time value to the > > timestamp field before calling the InnoDB backend. Is this a big problem? > > > > > > > Thanks in advance. > > > > > > Best regards, > > > Mikhail. > > > > Regards, > > > > Heikki > > > > > 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
