-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
None
-
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.