[JBoss JIRA] Created: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
10:23 a.m.
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:33 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
[
https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin...
]
Ken Johnson commented on TEIID-1632:
------------------------------------
I've had multiple requests/inquiries recently to make procedure debugging easier.
Perhaps a logger function that allow the author to place arbitrary logging statements in
procedure code and have it be controlled by log level so it can enabled/disabled through
configuration.
Provide something like an ECHO statement in the procedure language
that can assist a user in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:39 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
[
https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1632:
---------------------------------------
At this point given our usage of implicit cursoring, a procedure language level
enhancement would be most appropriate. Having a procedure or log function would cause the
implicit return cursor to be set from that statement.
So we would have something like:
OUTPUT LOG [level] [context] message
The OUTPUT reserved word would be needed to disambiguate the parsing. level could be
integral, or the Log4j level mnemonics, or the jre Level mnemonics. it would default to
the appropriate debug level. Context would be a string and default to
org.teiid.PROCESSOR
We could make the message expression evaluation contingent upon whether the log will
actually be recorded. But we'd probably also have to add a boolean system function
for more complicated scenarios:
IF (isLoggable(level, context))
BEGIN
//complex concat of message
OUTPUT LOG ....
END
The logs would then be delivered to the underlying log4j logging system.
Any thoughts?
Provide something like an ECHO statement in the procedure language
that can assist a user in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:40 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
[
https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1632.
-----------------------------------
Fix Version/s: 7.4.1
Resolution: Done
After more analysis, system procedures worked better - there's no need to change the
parser and the implicit cursor is not affected when a procedure does not have a
resultset.
So the procedures SYSADMIN.isLoggable and SYSADMIN.logMsg were added and are covered in
the reference. They each have defaults for level and context parameters, so the simplest
statement will be:
CALL logMsg(msg=>'I''m debugging');
The use of isLoggable looks like:
IF ((CALL isLoggable('TRACE', 'org.something')))
BEGIN
...
Provide something like an ECHO statement in the procedure language
that can assist a user in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.4.1
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:12 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
[
https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1632:
----------------------------------
Fix Version/s: 7.5
Provide something like an ECHO statement in the procedure language
that can assist a user in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.5
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:14 a.m.
New subject: [JBoss JIRA] (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic
[
https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1632.
---------------------------------
Provide something like an ECHO statement in the procedure language
that can assist a user in debugging their procedure logic
-----------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1632
URL: https://issues.jboss.org/browse/TEIID-1632
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.5
Provide something like an ECHO statement in the procedure language that can assist a user
in debugging their procedure logic
--
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
4687
days inactive
4945
days old
5 comments
3 participants
participants (3)
-
Ken Johnson (JIRA) -
Steven Hawkins (JIRA)
-
Van Halbert (JIRA)