Uploaded image for project: 'SonarTSQL'
  1. SonarTSQL
  2. SONARTSQL-228

Parse error on prefixed column names in fulltext search queries

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Parser
    • Labels:
      None

      Description

      Parser currently only accepts simple column names in the CONTAINS and FREETEXT search predicates (when creating FULLTEXT_PREDICATE). Prefixed column names should be allowed as well. Parameters should also accepts variables.

      Example:

      Contains(myTableAlias.myColumnName, 'param')
      Contains(myTableAlias.myColumnName, @myValue)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              christophe.zurn Christophe Zurn
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: