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

View definition column naming issue

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.4
    • 8.0
    • Query Engine
    • None
    • Workaround Exists
    • Hide

      Use aliasing to match the view definition names to the view column names.

      Show
      Use aliasing to match the view definition names to the view column names.

    Description

      View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down.

      for example:

      SELECT MIN(x.count) FROM agg x

      will fail with agg defined as

      create foreign table smalla (intkey integer);
      create view agg (count integer) as select count(*) from smalla;

      but will function correctly with count(*) as count

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: