March 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5289) Download link for snapshots is not providing the latest

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5289?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5289. ----------------------------------- Resolution: Done Simply missed that these were pointing at the jboss snapshot repository. > Download link for snapshots is not providing the latest > ------------------------------------------------------- > > Key: TEIID-5289 > URL: https://issues.jboss.org/browse/TEIID-5289 > Project: Teiid > Issue Type: Quality Risk > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Even though the url specifies the latest https://repository.jboss.org/nexus/service/local/artifact/maven/redirect?... > I'm being provided with what appears to be the earliest of the 10.2 snapshots. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5290?page=com.atlassian.jira.plugin... ] dalex dalex commented on TEIID-5290: ------------------------------------ > Have you found other pl/sql languages that behave differently? {code:sql} BEGIN DECLARE @c integer = 20000; Declare @tem table (ts datetime); WHILE (@c > 0) BEGIN INSERT INTO @tem VALUES((select getdate())); Set @c= @c-1; END select min(ts), max(ts) from @tem; END ;; {code} on MSSQL the now() function is treated as a non-deterministic value showing the following results: {code:noformat} 2018-03-19 17:18:42.547 2018-03-19 17:18:43.413 {code} > NOW() function returns the same value for each call in BEGIN...END block > ------------------------------------------------------------------------ > > Key: TEIID-5290 > URL: https://issues.jboss.org/browse/TEIID-5290 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > > 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5290?page=com.atlassian.jira.plugin... ] dalex dalex edited comment on TEIID-5290 at 3/19/18 12:35 PM: -------------------------------------------------------------- > Have you found other pl/sql languages that behave differently? {code:sql} BEGIN DECLARE @c integer = 20000; Declare @tem table (ts datetime); WHILE (@c > 0) BEGIN INSERT INTO @tem VALUES((select getdate())); Set @c= @c-1; END select min(ts), max(ts) from @tem; END ;; {code} on MSSQL the getdate() function is treated as a non-deterministic value showing the following results: {code:noformat} 2018-03-19 17:18:42.547 2018-03-19 17:18:43.413 {code} was (Author: dalex005): > Have you found other pl/sql languages that behave differently? {code:sql} BEGIN DECLARE @c integer = 20000; Declare @tem table (ts datetime); WHILE (@c > 0) BEGIN INSERT INTO @tem VALUES((select getdate())); Set @c= @c-1; END select min(ts), max(ts) from @tem; END ;; {code} on MSSQL the now() function is treated as a non-deterministic value showing the following results: {code:noformat} 2018-03-19 17:18:42.547 2018-03-19 17:18:43.413 {code} > NOW() function returns the same value for each call in BEGIN...END block > ------------------------------------------------------------------------ > > Key: TEIID-5290 > URL: https://issues.jboss.org/browse/TEIID-5290 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > > 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5290?page=com.atlassian.jira.plugin... ] dalex dalex commented on TEIID-5290: ------------------------------------ > That behavior isn't altered when it appears in a procedure block. Have you found other pl/sql languages that behave differently? I indeed checked it on PostgreSQL and it has the same behavior as in teiid, that is as a deterministic value. Actually I suspected that behavior will be like a deterministic value and I've already encountered with it in scope of the TEIID-4423 issue. But there we agreed about such behavior: "So now: update test.textagg_test_2 set id =(select uuid()) where id = 'xxxx'; will evaluate to a single id value. update test.textagg_test_2 set id =uuid() where id = 'xxxx'; will set an id per row, which in this case without a key will result in an error." What do you think can we do the same here? For example, if we use explicitly the "select now()" then it should be treated as a deterministic value but if we use just now() function, say, like here: {code:sql} BEGIN declare timestamp ts1 = now(); DECLARE integer c = 20000; WHILE (c > 0) BEGIN c= c-1; END declare timestamp ts2 = now(); select ts1, ts2; END ;; {code} it will be treated as a non-deterministic value. > NOW() function returns the same value for each call in BEGIN...END block > ------------------------------------------------------------------------ > > Key: TEIID-5290 > URL: https://issues.jboss.org/browse/TEIID-5290 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > > 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5290?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5290: --------------------------------------- Selecting a non-deterministic function in a scalar subquery is treated as a deterministic value, which means that it is pre-evaluated. See the note on https://teiid.gitbooks.io/documents/content/reference/Nondeterministic_Fu... That behavior isn't altered when it appears in a procedure block. Have you found other pl/sql languages that behave differently? > NOW() function returns the same value for each call in BEGIN...END block > ------------------------------------------------------------------------ > > Key: TEIID-5290 > URL: https://issues.jboss.org/browse/TEIID-5290 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > > 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by dalex dalex (JIRA)

[ 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. > NOW() function returns the same value for each call in BEGIN...END block > ------------------------------------------------------------------------ > > Key: TEIID-5290 > URL: https://issues.jboss.org/browse/TEIID-5290 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > > 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5290) NOW() function returns the same value for each call in BEGIN...END block

by dalex dalex (JIRA)

dalex dalex created TEIID-5290: ---------------------------------- Summary: NOW() function returns the same value for each call in BEGIN...END block Key: TEIID-5290 URL: https://issues.jboss.org/browse/TEIID-5290 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 10.1 Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) Reporter: dalex dalex Assignee: Steven Hawkins Priority: Blocker 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)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5289) Download link for snapshots is not providing the latest

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5289?page=com.atlassian.jira.plugin... ] Work on TEIID-5289 started by Steven Hawkins. --------------------------------------------- > Download link for snapshots is not providing the latest > ------------------------------------------------------- > > Key: TEIID-5289 > URL: https://issues.jboss.org/browse/TEIID-5289 > Project: Teiid > Issue Type: Quality Risk > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Even though the url specifies the latest https://repository.jboss.org/nexus/service/local/artifact/maven/redirect?... > I'm being provided with what appears to be the earliest of the 10.2 snapshots. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5286) Rename/alias the Sybase IQ translator to SAP IQ

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5286?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5286: ---------------------------------- Fix Version/s: 10.2 > Rename/alias the Sybase IQ translator to SAP IQ > ----------------------------------------------- > > Key: TEIID-5286 > URL: https://issues.jboss.org/browse/TEIID-5286 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation, Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.2 > > > References to Sybase IQ should be replaced or include SAP IQ - including the translator name. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5288) OData4 skiptoken is not pulling from the cached results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5288?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5288. ----------------------------------- Fix Version/s: 10.1.3 10.0.5 10.2 Resolution: Done Changed to use a name generator that is local to the sql builder. > OData4 skiptoken is not pulling from the cached results > ------------------------------------------------------- > > Key: TEIID-5288 > URL: https://issues.jboss.org/browse/TEIID-5288 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 10.1.3, 10.0.5, 10.2 > > > The user query is every time on the next link even though the skip-token-cache-time has not expired. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2018