Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6563

Unable to use 'UPPER'/'LOWER' together with 'IN'

Agile BoardAttach filesAttach ScreenshotVotersStop watchingWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.1.2
    • 4.17.0, 5.2.0, 4.16.2, 5.1.3
    • core
    • None

    Description

      Unable to upper case column value and check if it's in the list of values.

      Should be two or more values in IN clause.

      Example: SELECT * FROM table WHERE UPPER(column_name) IN ('value1', 'value2')

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            richardantal Richárd Antal
            vitali.bassov Vitali Bassov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment