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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.00, 1.7.01
    • 1.7.02
    • CRC Cell
    • None
    • PostgreSQL
    • Rank:
      0|i000iv:
    • Queries
    • 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

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: