April 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5326) SAP IQ timestamp conversion to varchar wrong resulting format

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5326?page=com.atlassian.jira.plugin... ] Jan Stastny updated TEIID-5326: ------------------------------- Description: Following Teiid query: {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM BQT1.SmallA {code} is pushed as: {code:sql} SELECT g_0."timestampvalue" AS c_0, lcase(stuff(stuff(convert(varchar, g_0."timestampvalue", 102), 5, 1, '-'), 8, 1, '-')+convert(varchar, g_0."timestampvalue", 8)) AS c_1 FROM "bqt-server"."dvqe"."SmallA" AS g_0 {code} and returns the string representation of timestamp as: 2000-01-0100:00:00 2000-01-0100:00:01 ... Notice the missing space between date and time part. SAP IQ is capable of converting the value implicitly, e.g. when I issue query {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM SmallA {code} directly against SAP IQ instance, I get following string format: 2000-01-01 00:00:00.000 2000-01-01 00:00:01.000 .... The same results are returned if I use an explicit convert like: {code:sql} SELECT TimeStampValue, LOWER(CONVERT(varchar,TimeStampValue,121)) FROM SmallA {code} For more formatting options see [SyBooks Online|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.info...] was: Following Teiid query: {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM BQT1.SmallA {code} is pushed as: {code:sql} SELECT g_0."timestampvalue" AS c_0, lcase(stuff(stuff(convert(varchar, g_0."timestampvalue", 102), 5, 1, '-'), 8, 1, '-')+convert(varchar, g_0."timestampvalue", 8)) AS c_1 FROM "bqt-server"."dvqe"."SmallA" AS g_0 {code} and returns the string representation of timestamp as: 2000-01-0100:00:00 2000-01-0100:00:01 ... Notice the missing space between date and time part. SAP IQ is capable of converting the value implicitly, e.g. when I issue query {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM SmallA {code} directly against SAP IQ instance, I get following string format: 2000-01-01 00:00:00.000 2000-01-01 00:00:01.000 .... The same results are returned if I use an explicit convert like: {code:sql} SELECT TimeStampValue, LOWER(CONVERT(varchar,TimeStampValue,121)) FROM SmallA {code} For more formatting options see [SyBooks Online|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.info...] > SAP IQ timestamp conversion to varchar wrong resulting format > ------------------------------------------------------------- > > Key: TEIID-5326 > URL: https://issues.jboss.org/browse/TEIID-5326 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.13.6_4 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > Following Teiid query: > {code:sql} > SELECT TimeStampValue, LOWER(TimeStampValue) FROM BQT1.SmallA > {code} > is pushed as: > {code:sql} > SELECT g_0."timestampvalue" AS c_0, lcase(stuff(stuff(convert(varchar, g_0."timestampvalue", 102), 5, 1, '-'), 8, 1, '-')+convert(varchar, g_0."timestampvalue", 8)) AS c_1 FROM "bqt-server"."dvqe"."SmallA" AS g_0 > {code} > and returns the string representation of timestamp as: > 2000-01-0100:00:00 > 2000-01-0100:00:01 > ... > Notice the missing space between date and time part. > SAP IQ is capable of converting the value implicitly, e.g. when I issue query > {code:sql} > SELECT TimeStampValue, LOWER(TimeStampValue) FROM SmallA > {code} > directly against SAP IQ instance, I get following string format: > 2000-01-01 00:00:00.000 > 2000-01-01 00:00:01.000 > .... > The same results are returned if I use an explicit convert like: > {code:sql} > SELECT TimeStampValue, LOWER(CONVERT(varchar,TimeStampValue,121)) FROM SmallA > {code} > For more formatting options see [SyBooks Online|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.info...] -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5326) SAP IQ timestamp conversion to varchar wrong resulting format

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5326: ---------------------------------- Summary: SAP IQ timestamp conversion to varchar wrong resulting format Key: TEIID-5326 URL: https://issues.jboss.org/browse/TEIID-5326 Project: Teiid Issue Type: Bug Affects Versions: 8.12.13.6_4 Reporter: Jan Stastny Assignee: Steven Hawkins Following Teiid query: {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM BQT1.SmallA {code} is pushed as: {code:sql} SELECT g_0."timestampvalue" AS c_0, lcase(stuff(stuff(convert(varchar, g_0."timestampvalue", 102), 5, 1, '-'), 8, 1, '-')+convert(varchar, g_0."timestampvalue", 8)) AS c_1 FROM "bqt-server"."dvqe"."SmallA" AS g_0 {code} and returns the string representation of timestamp as: 2000-01-0100:00:00 2000-01-0100:00:01 ... Notice the missing space between date and time part. SAP IQ is capable of converting the value implicitly, e.g. when I issue query {code:sql} SELECT TimeStampValue, LOWER(TimeStampValue) FROM SmallA {code} directly against SAP IQ instance, I get following string format: 2000-01-01 00:00:00.000 2000-01-01 00:00:01.000 .... The same results are returned if I use an explicit convert like: {code:sql} SELECT TimeStampValue, LOWER(CONVERT(varchar,TimeStampValue,121)) FROM SmallA {code} For more formatting options see [SyBooks Online|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.info...] -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5325) MongoDB: Detect array types correctly

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5325?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5325. --------------------------------- Fix Version/s: 10.3 Assignee: Ramesh Reddy (was: Steven Hawkins) Resolution: Done Looked at the value at zero index of the array, used that to detect the type of the array. It is assumed that all the values in a given array are homogeneous. > MongoDB: Detect array types correctly > ------------------------------------- > > Key: TEIID-5325 > URL: https://issues.jboss.org/browse/TEIID-5325 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.3 > > > Currently, primitive array types are detected as "object[]", the values can be introspected similar to the value of single element and type can be detected in same way. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5324) MongoDB: SecurityType "None" is not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5324?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5324: --------------------------------------- > Should this be pulled into other branches? We are still maintaining 10.1 and 10.2 if you want it in those. > MongoDB: SecurityType "None" is not working > ------------------------------------------- > > Key: TEIID-5324 > URL: https://issues.jboss.org/browse/TEIID-5324 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.3 > > > MongoDB resource adapter with "None" security type is not recognized, and ends with error. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5324) MongoDB: SecurityType "None" is not working

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5324?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5324. --------------------------------- Resolution: Done Corrected the issue to honor the "None" security type. Should this be pulled into other branches? > MongoDB: SecurityType "None" is not working > ------------------------------------------- > > Key: TEIID-5324 > URL: https://issues.jboss.org/browse/TEIID-5324 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.3 > > > MongoDB resource adapter with "None" security type is not recognized, and ends with error. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5325) MongoDB: Detect array types correctly

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-5325: ----------------------------------- Summary: MongoDB: Detect array types correctly Key: TEIID-5325 URL: https://issues.jboss.org/browse/TEIID-5325 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Steven Hawkins Currently, primitive array types are detected as "object[]", the values can be introspected similar to the value of single element and type can be detected in same way. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5324) MongoDB: SecurityType "None" is not working

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-5324: ----------------------------------- Summary: MongoDB: SecurityType "None" is not working Key: TEIID-5324 URL: https://issues.jboss.org/browse/TEIID-5324 Project: Teiid Issue Type: Bug Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 10.3 MongoDB resource adapter with "None" security type is not recognized, and ends with error. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Work on TEIID-5210 started by Steven Hawkins. --------------------------------------------- > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-5210 at 4/20/18 1:48 PM: ---------------------------------------------------------------- In trying to understand the "new" gitbook and create a new organization (as I'm not the owner of the old), it appears that 10.2.x is now offline. Also the legacy links seem to be spotty. So docs may be more of an issue than before. was (Author: shawkins): In trying to understand the "new" gitbook and create a new organization (as I'm not the owner of the old), it appears that everything is now offline. Also none of the legacy links work for me. So docs may be down until this is addressed. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5210: ---------------------------------- Priority: Critical (was: Major) In trying to understand the "new" gitbook and create a new organization (as I'm not the owner of the old), it appears that everything is now offline. Also none of the legacy links work for me. So docs may be down until this is addressed. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.3 > > > GitBooks are no longer syncing to our github. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2018