2210817 - Multi-thread loading may cause unorderable rowid

• When IQ uses multi threads on LOAD TABLE, rowids of imported data may be discontinuous. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids. Rowid jumps from 13892 to 67108865.
  
  '1' '4276558271' '2015-08-09' 'A.E.49'               1700    201508  '1073'               13891 
  '1' '4101800464' '2015-08-09'                             490    201508  '0192'    '3162'  13892 
  '9' '4943674221646' '2015-08-08' 'WPCR-16887' 2457   201510  'NONE'   'NONE' 67108865 
  '9' '4943674221783' '2015-08-08' 'WPCR-16889' 2200   201510  'NONE'   'NONE' 67108866 
  '9' '4943674217649' '2015-08-08' 'WPCS-13241' 2600   201510  'NONE'   'NONE' 67108867 

•  And there is possibility that rowids of imported data may not match the row order in original data file. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids.
  
  '9' '4988001777847' '2015-08-08' 'COCB-54176' 2800   201507  'NONE'   'NONE' 3969 
  '9' '4988001778356' '2015-08-08' 'COCB-54179' 3000   201507  'NONE'   'NONE' 3970 
  '9' '4988001777977' '2015-08-08' 'COCP-39180' 2200   201507  'NONE'   'NONE' 3971 
  '9' '4988001777984' '2015-08-08' 'COCP-39181' 2200   201507  'NONE'   'NONE' 3972 
  '9' '4988001778011' '2015-08-08' 'COCP-39182' 3241   201507  'NONE'   'NONE' 3973 
  '9' '4988001778028' '2015-08-08' 'COCP-39184' 3241   201507  'NONE'   'NONE' 3974 
  
  The original row order in data file, from row 3969 to row 3974, which are completely different from imported data.
  
  9~4988002316014~20150808~VICL-8129~0002718~199506~NONE~NONE           3969
  9~4988002387809~20150808~VICL-41072~0002400~199908~NONE~NONE         3970
  9~4988002388196~20150808~VICL-41085~0002200~199908~NONE~NONE         3971
  9~4988002353408~20150808~VICL-60049~0001900~199706~NONE~NONE         3972
  9~4988002354603~20150808~VICL-60072~0002900~199709~NONE~NONE         3973
  9~4988002369720~20150808~VICL-60253~0002900~199807~NONE~NONE         3974

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP IQ 16.0

load table, rowid, thread, query plan, order , KBA , BC-SYB-IQ , Sybase IQ , How To