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

compare integer with varchar

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.7.00
    • 1.7.02
    • CRC Cell
    • None
    • i2b2 crc cell

    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.




       

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          giryu Giyung Ryu created issue -
          mem61 Mike Mendis made changes -
          Field Original Value New Value
          Fix Version/s 1.7.02 [ 10091 ]
          jmd86 Janice Donahoe made changes -
          Workflow classic default workflow [ 10246 ] i2b2 Issues [ 10310 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          SVN Revision Number 4789
          jmd86 Janice Donahoe made changes -
          SVN Revision Number 4789
          jmd86 Janice Donahoe made changes -
          SVN Revision Number CRC-4789
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10310 ] i2b2 Issues Workflow [ 10479 ]
          jmd86 Janice Donahoe made changes -
          Component/s CRC Cell [ 10049 ]
          Component/s CRC Cell [ 10000 ]
          Fix Version/s 1.7.02 [ 10155 ]
          Fix Version/s 1.7.02 [ 10091 ]
          Key LEOPARD-148 CORE-93
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.7.00 [ 10153 ]
          Affects Version/s 1.7.00 [ 10081 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            mem61 Mike Mendis
            giryu Giyung Ryu
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: