Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1576

Unnecessary table aliasing causing in pushdown query

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • None
    • Data Preview
    • None

      Create a Added a table manually to an existing physical model (generated from JDBC import). put source specific syntax as name in source for a column.
      When previewed I get an error because the g0 predicate was added to the column thus resulting in an invalid query.

      I proved the point by copy/paste the atomic query to the source directly (via Squirrel) it failed with the same error then removed the predicate references (both on column and table) and it succeeded.

      The source is Sybase.
      The Name in source entered for the column was:

      convert(varchar(16384),report)+convert(varchar(16384),impression)+convert(varchar(16384),signature)

      which resulted in the following push down

      SELECT g_0.convert(varchar(16384),report)+convert(varchar(16384),impression)+convert(varchar(16384),signature) FROM "pinspr"."dbo"."cdr_rad_obs" g_0

      which when executed directly against sybase fails..
      if the g_0 is removed entirely the query succeeds in against Sybase using Squirrel.

            Unassigned Unassigned
            tljohnst@gmail.com thomas johnston (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: