Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-103

Error returned from the CRC when running a query with result type of Encounter set

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.00, 1.7.01
    • Fix Version/s: 1.7.02
    • Component/s: CRC Cell
    • Labels:
      None
    • Environment:
      PostgreSQL
    • Rank:
      0|i000iv:
    • i2b2 Feature/s:
      Queries
    • Testing Notes:
      Hide
      Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).

      Environment: Tested with the latest PostgreSQL database (bamboo)
      Show
      Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types). Environment: Tested with the latest PostgreSQL database (bamboo)

      Description

      The following error occurs when running an i2b2 Query against a PostgreSQL database:

      Operator does not exist: integer = character varying


      The above error will occur only when the result type of Encounter set is selected when running the query.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code