[ https://issues.jboss.org/browse/TEIID-5290?page=com.atlassian.jira.plugin... ] dalex dalex updated TEIID-5290: ------------------------------- Description: Run the following queries: {code:sql} BEGIN declare timestamp ts1 = select now(); DECLARE integer c = 20000; WHILE (c > 0) BEGIN c= c-1; END declare timestamp ts2 = select now(); select ts1, ts2; END ;; {code} and {code:sql} BEGIN DECLARE integer c = 20000; create local temporary table #tem(ts timestamp); WHILE (c > 0) BEGIN INSERT INTO #tem VALUES((select NOW())); c= c-1; END select * from #tem; END ;; {code} NOW() function returns the same value for each call in BEGIN...END block and it doesn't matter if it is atomic or not. was: Run the following queries: {code:sql} BEGIN declare timestamp ts1 = select now(); DECLARE integer c = 20000; WHILE (c > 0) BEGIN c= c-1; END declare timestamp ts2 = select now(); select ts1, ts2; END ;; {code} and {code:sql} BEGIN DECLARE integer c = 20000; create local temporary table #tem(ts timestamp); WHILE (c > 0) BEGIN INSERT INTO #tem VALUES((select NOW())); c= c-1; END select * from #tem; END ;; {code} NOW() function returns the same value for each call in BEGIN...END block and it doesn't matter if it is atomic or not. -- This message was sent by Atlassian JIRA (v7.5.0#75005)