[JBoss JIRA] Created: (TEIID-1584) Querying a virtual table backed by a SELECT x, y, z FROM EXECT ... TEXTTABLE() call fails to return data
3: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
3: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
3: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
3: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
3: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
4: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
5:11 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:
---------------------------------------
We should support windows line endings as well. I'll fix that.
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
10:39 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...
]
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
10:41 p.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
9:37 a.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
4899
days inactive
4997
days old
9 comments
3 participants
participants (3)
-
Barry LaFond (JIRA) -
Paul Nittel (JIRA)
-
Steven Hawkins (JIRA)