[JBoss JIRA] Created: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[JBoss JIRA] Moved: (TEIID-1719)...

[JBoss JIRA] Created: (TEIID-1578)...

Barry LaFond (JIRA)

Wednesday, 11 May 2011 Wed, 11 May '11

10:11 p.m.

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in Teiid Designer. So the 7.4 VDB artifact appears to be ok. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Show replies by date

Barry LaFond (JIRA)

Wednesday, 11 May Wed, 11 May

10:11 p.m.

New subject: [JBoss JIRA] Updated: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Barry LaFond updated TEIID-1584: -------------------------------- Description: Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok. was: Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in Teiid Designer. So the 7.4 VDB artifact appears to be ok.

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

10:22 p.m.

New subject: [JBoss JIRA] Commented: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1584: --------------------------------------- Can you provide any more insight into why you think there is an issue here? It's more likely that the file source is pointed to the wrong spot. Can you verify that the getTextFiles procedure is returning the expected files?

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Paul Nittel (JIRA)

10:34 p.m.

New subject: [JBoss JIRA] Commented: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Paul Nittel commented on TEIID-1584: ------------------------------------ I'm having similar issues and had he same thought, so I added a bogus column to the query and it recognized it wasn't in the text file. (I also tried changing the file so the header was line 1 and data in line 2.) It looks perfectly fine, except for no returning data.

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

10:38 p.m.

New subject: [JBoss JIRA] Commented: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1584: --------------------------------------- I'm still not clear though. Are you getting a file from getTextFiles, but then no data from texttable? Are the clob contents correct?

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Paul Nittel (JIRA)

11:31 p.m.

New subject: [JBoss JIRA] Commented: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Paul Nittel commented on TEIID-1584: ------------------------------------ Uh oh. I ran dos2unix on the data file and things improved dramatically. Looks like the file was edited with some evil tool.

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

Thursday, 12 May Thu, 12 May

12:11 a.m.

New subject: [JBoss JIRA] Commented: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

5:39 a.m.

New subject: [JBoss JIRA] Updated: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1584: ---------------------------------- Fix Version/s: 7.4 Component/s: Query Engine

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Fix For: 7.4 Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

5:41 a.m.

New subject: [JBoss JIRA] Resolved: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1584. ----------------------------------- Labels: 7.4CR2 (was: ) Resolution: Done corrected the case statement that caused the first windows line being confused with the end of input.

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Labels: 7.4CR2 Fix For: 7.4 Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Steven Hawkins (JIRA)

Wednesday, 17 August Wed, 17 Aug

4:37 p.m.

New subject: [JBoss JIRA] Closed: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data

[ https://issues.jboss.org/browse/TEIID-1584?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1584. ---------------------------------

...

Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data ------------------------------------------------------------------------------------------------------ Key: TEIID-1584 URL: https://issues.jboss.org/browse/TEIID-1584 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Steven Hawkins Labels: 7.4CR2 Fix For: 7.4 Ran through the Teiid Designer's Text file example script: http://download.jboss.org/teiid/designer/7.2/examples/text-file-example.zip Previewing the virtual table directly or through VDB does not return any rows. Verified that I could create a VDB using 7.4 Designer, deploy it to a 7.1.1 Final Teiid server and Execute the VDB and query using DTP in 7.1 Teiid Designer. So the 7.4 VDB artifact appears to be ok.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

4698

days inactive

4796

days old

teiid-issues@lists.jboss.org

Manage subscription

9 comments

3 participants

tags (0)

participants (3)

Barry LaFond (JIRA)
Paul Nittel (JIRA)
Steven Hawkins (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

[JBoss JIRA] Created: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data