Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    12.0p Join-generation only takes output fields into account, not also criteria fields

    Hi Isomorphic,

    using current 12.0p I noticed a problem where on the serverside DSRequests fail with broken SQL statements.
    This happens if you put criteria on an includeFrom field, and also have an setOutputs() on the DSRequest that does not include this field.
    In that case there is a tablename.null = .... in the SQL.

    While I generally like very much that you don't generate unnecessary joins, this is a bug IMHO.
    Joins to the respective table should also be generated if a field is in criteria only.

    Best regards
    Blama
Working...
X