Query builder can generate reserved words

(2 posts) (2 voices)

Tags:

No tags yet.

  1. elb98rm, Member

    Just to report an issue:

    Take two tables:

    • organisation_names
    • organisation_type

    If I use the SQL builder to join these for some form of query, then the SQL generated uses aliases. Unfortunately these aliases are NOT respecting protected/special phrases.
    The above example gives:

    • o.{field}
    • or.{field}

    OR is a protected phrase and thus I've had to manually change this.
    This should of course not arise.

    Cheers
    Rick

  2. myDBR Team, Key Master

    Thanks for reporting this issue. We'll fix it.

    --
    myDBR Team


Reply

You must log in to post.