[CORE-93] compare integer with varchar Created: 14/Apr/14  Updated: 01/Jul/14  Resolved: 27/May/14

Status: Closed
Project: i2b2 Core Software
Component/s: CRC Cell
Affects Version/s: 1.7.00
Fix Version/s: 1.7.02

Type: Bug Priority: Minor
Reporter: Giyung Ryu Assignee: Mike Mendis
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment: i2b2 crc cell

Rank: 0|i000l3:

There are comparisons between int and varchar in edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/dao/setfinder/QueryMasterSpringDao.java
This brings error messages in i2b2 with postgresql.
In table i2b2demodata.qt_query_master, column QUERY_MASTER_ID in int but it is compared with master_id which is string.

Generated at Fri Aug 19 14:02:33 UTC 2022 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.