10:19 a.m.
Steven Hawkins created TEIID-1920:
-------------------------------------
Summary: Dynamic sql using a non-literal requires a keyword
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string keyword.
However the resulting form will not parse is a non-literal dynamic sql string is used.
We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:13 p.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1920.
-----------------------------------
Resolution: Done
Updated the docs and the string form to use EXECUTE IMMEDIATE. Also corrected UVAR to
DVAR.
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:10 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1920:
-------------------------------------------
Bugzilla Update: Perform
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:10 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1920:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=786453
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:12 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a comment on [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453]
Teiid committed the fix to the 7.7 branch, which will be in the SOA 5.3 release.
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:22 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453] from NEW to ON_QA
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4 p.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
JBoss JIRA Server <jira-update(a)redhat.com> made a comment on [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453]
Johnathon Lee <jolee(a)redhat.com> made a comment on jira TEIID-1920
Backported to https://svn.jboss.org/repos/teiid/branches/7.4.x/ (r3935)
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4 p.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Rick Wagner <rwagner(a)redhat.com> made a comment on [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453]
GSS prioritizes this 'high'. Thank you.
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:17 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> made a comment on [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453]
So that QA can be certain we've tested a valid case, please provide a sample query
which exhibits the behavior being corrected.
Thanks!
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:28 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> changed the Status of [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453] from ON_QA to VERIFIED
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:28 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> made a comment on [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453]
Tested OK with the JBDS 4.1.3 update of 4/19.
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:41 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1920:
------------------------------------------------
Rick Wagner <rwagner(a)redhat.com> changed the Status of [bug
786453|https://bugzilla.redhat.com/show_bug.cgi?id=786453] from VERIFIED to CLOSED
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:55 a.m.
[
https://issues.jboss.org/browse/TEIID-1920?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1920.
---------------------------------
Dynamic sql using a non-literal requires a keyword
--------------------------------------------------
Key: TEIID-1920
URL: https://issues.jboss.org/browse/TEIID-1920
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.7
When entering dynamic sql in designer, the resulting string form omits the string
keyword. However the resulting form will not parse is a non-literal dynamic sql string is
used. We should use a string from that has IMMEDIATE.
Also the docs should be updated to show EXECUTE IMMEDIATE examples and to change UVAR to
DVAR.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4200
days inactive
4494
days old
12 comments
2 participants
participants (2)
-
RH Bugzilla Integration (JIRA) -
Steven Hawkins (JIRA)