[teiid-issues] [JBoss JIRA] (TEIID-3547) Oracle and postgres translators - date/time format letters are not translated correctly if pattern ends with non-pattern/non-letter character
RH Bugzilla Integration (JIRA)
issues at jboss.org
Tue Jul 7 09:23:06 EDT 2015
[ https://issues.jboss.org/browse/TEIID-3547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087405#comment-13087405 ]
RH Bugzilla Integration commented on TEIID-3547:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1233212|https://bugzilla.redhat.com/show_bug.cgi?id=1233212] from MODIFIED to ON_QA
> Oracle and postgres translators - date/time format letters are not translated correctly if pattern ends with non-pattern/non-letter character
> ---------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3547
> URL: https://issues.jboss.org/browse/TEIID-3547
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Oracle translator seems to support translation of patterns from SimpleDateFormat to oracle's patterns [1], but not for all of them [2]. If Teiid is not able to translate format then it retrieves date/time/timestamp field and format it [2]. However, if pattern ends with non-pattern/non-letter character, pattern is translated only partially and passed to Oracle DB [3] - I have tried number, *, /, \, etc. Similar behavior with postgresql translator
> [1]
> *Query:* select formattimestamp(timestampvalue, 'y') from bqt1.smalla where intkey=1;
> *Source-specific command:* SELECT TO_CHAR(g_0."TIMESTAMPVALUE", 'YYYY') FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1
> [2]
> *Query:* select formattimestamp(timestampvalue, 'D') from bqt1.smalla where intkey=1;
> *Source-specific command:* SELECT g_0."TIMESTAMPVALUE" FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1
> [3]
> *Query:* select formattimestamp(timestampvalue, 'G-y-M-w-W-D-d-F-E-a-H-k-K-h-m-s') from bqt1.smalla where intkey=1;
> *Source-specific command:* SELECT g_0."TIMESTAMPVALUE" FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1
> *Query:* select formattimestamp(timestampvalue, 'G-y-M-w-W-D-d-F-E-a-H-k-K-h-m-s-') from bqt1.smalla where intkey=1;
> *Source-specific command:* SELECT TO_CHAR(g_0."TIMESTAMPVALUE", 'AD-YYYY-------Dy-AM-------') FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
More information about the teiid-issues
mailing list