[
https://issues.apache.org/jira/browse/DERBY-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12985386#action_12985386
]
Bryan Pendleton commented on DERBY-4783:
----------------------------------------
I think that the alternative is that we'd need to do this string processing in
Java code,
rather than in the SQL.
But, in fact, I think this may not be very hard. For instance, I believe that
rs.getString("no_opens")
will already automatically do the equivalent of the "TRIM(CHAR(NO_OPENS))"
processing. So all we're really talking about here is doing something like:
"||"+rs.getString("no_opens") + "||"
Although, it strikes me that we should eliminate the "||" processing as well, as
I suspect these are just markers that will be used later in the code to parse
the values apart, which doesn't seem like the right approach either. It seems
like we should make the ResultSet object available to the bit of code which
needs to fetch the value of the NO_OPENS column, so that code can just do
the getInt() or getString() call itself, directly.
I understand that this would mean a bit of refactoring of the current
PlanExporter
code, so we should study it some more.
> Add all data in XPlain tables into the XML file generated by PlanExporter Tool
> ------------------------------------------------------------------------------
>
> Key: DERBY-4783
> URL: https://issues.apache.org/jira/browse/DERBY-4783
> Project: Derby
> Issue Type: Improvement
> Components: Tools
> Reporter: C.S. Nirmal J. Fernando
> Assignee: C.S. Nirmal J. Fernando
> Priority: Minor
> Attachments: derby-4783-a.diff
>
>
> Rick has suggested this in Derby-4587. I think this way it allows a user to
> create his own style sheets and grab only the data he needed.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
