Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-2886

select filter with int datatype is showing incorrect result in case of table created and loaded on old version and queried in new version

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: core
    • Labels:
      None

      Description

      select filter with int datatype is showing incorrect result in case of table created and loaded on old version and queried in new version
       
      Steps:
      created table and loaded data in base carbon version 1.1
      refresh table in 1.4.1
      select filter query for integer column with valid existing value
       
       
       
      expected result: the filtered row must be shown
      actual result: filtered row is not shown
       
      Note:
      1.  this happens for a particular table in the store
      2. If filter has integer column with any other column then it displays the result

      select cust_id,cust_name from uniqdata_load where cust_name= 'CUST_NAME_00075' or cust_id=9010;
      --------------------------

      cust_id cust_name

      --------------------------

      9010 CUST_NAME_00010
      9075 CUST_NAME_00075

      --------------------------
      2 rows selected (0.652 seconds)
       select cust_id,cust_name from uniqdata_load where cust_id=9010;
      --------------------

      cust_id cust_name

      --------------------
      --------------------
      No rows selected (0.351 seconds)

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                manishgupta_88 Manish Gupta
                Reporter:
                surbhijoshi Surbhi Joshi
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m