[CORE-103] Error returned from the CRC when running a query with result type of Encounter set Created: 14/May/14 Updated: 01/Jul/14 Resolved: 09/Jun/14 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | CRC Cell |
| Affects Version/s: | 1.7.00, 1.7.01 |
| Fix Version/s: | 1.7.02 |
| Type: | Bug | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | PostgreSQL | ||
| i2b2 Feature/s: |
Queries
|
| Testing Notes: | 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) |
| Participant/s: |
| 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. |
| Comments |
| Comment by Mike Mendis [ 03/Jun/14 ] |
|
I am unable to reproduce this. I ran a query and selected encounter set, and resulted in the correct number.
|
| Comment by Janice Donahoe [ 06/Jun/14 ] |
| Need to test against PostgreSQL. |