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

Teiid Designer uses 0 as a default length value

    Details

    • Type: Quality Risk
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.12
    • Fix Version/s: 10.0
    • Component/s: Query Engine
    • Labels:
      None

      Description

      If you create a view in teiid designer, but define it with an expression:

      select case when rand() < .5 then 'heads' else 'tails' end as x

      A string column length will be set to 0. On the server this may cause issues such as with the odata layer that will check facets against the length of 0.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  shawkins Steven Hawkins
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: