On Wed, 11 Sep 2002, snpe wrote:
> On Wednesday 11 September 2002 02:38 pm, Rod Taylor wrote: > > > > > Why rollback.This is error (typing error).Nothing happen. > > > > > I think that we need clear set : what is start transaction ? > > > > > I think that transaction start with change data in database > > > > > (what don't change data this start not transaction. > > > > > > > > Another interesting case for a select is, what about > > > > select func(x) from table; > > > > Does func() have any side effects that might change data? > > > > At what point do we decide that the statement needs a > > > > transaction? > > > > > > Function in select list mustn't change any data. > > > What if function change data in from clause ? > > > > Why can't the function change data? I've done this one a number of > > times through views to log the user pulling out information from the > > system, and what it was at the time (time sensitive data). > Scenario : > Func change data in table in form clause > I fetch 3 (after row 1 and 2) and then change row 1 > What result expect ? Just because the behavior is sometimes undefined by the spec doesn't mean the construct should be disallowed. Grouped character string columns also could have implementation-dependent behavior (which never needs to be specified), but we don't disallow that either. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
