[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 | ||
| Participant/s: |
| Description |
|
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. |