Strange behaviour of wildcards

2 posts, 0 answers
  1. Tomasz M.Lipiński
    Tomasz M.Lipiński avatar
    71 posts
    Member since:
    Nov 2009

    Posted 10 Mar 2010 Link to this post

    Hi,
    It is said in the documentation that in OQL WHERE clauses * matches to any string of characters. I've made some experiments with wildcards in OQL and the conclusion is that while processing an OQL query, * is mechanically replaced by %. I've come to this because:
    • % also matches to any string
    • a clause: "xx like '*[*]*'" doesn't match * in my data but perfectly matches % .... it poduces exactly the same result as: "xx like '%[%]%'" ...
    • the same concerns ? that is equivalent to _ (in this case looking for [?] finds _ ...)

    Am I right? And if "yes" - are you going to fix it any way?

    Regards
    Tomasz

  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 16 Mar 2010 Link to this post

    Hi Tomasz M.Lipiński,

    Yes, you are right. We added this to our TODO list and will provide an option to find such strings in one of the following builds.
    Thank you for bringing this to us.

    Best wishes,
    Alexander
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. DevCraft banner
Back to Top