Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5313

Oracle translator issue with mixing string types and general issues with non-ascii strings

    XMLWordPrintable

Details

    Description

      Oracle produces an exception when internationalized and regular character strings are mixed via a union or case statement, for example:

      case when val = 'x' then 'x' else N'y' end

      The translator only puts the N literal prefix when a non-ascii character is present though.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5377 Type mismatch when issuing recursive common table expression query

          • Critical - To be worked on immediately following BLOCKER issues.
          • Resolved
          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5587 Oracle 11 drivers don't accept NVARCHAR type

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: