Changeset 23683

Show
Ignore:
Timestamp:
11.02.2011 14:23:41 (9 years ago)
Author:
ak19
Message:

John Thompson fixed an important subtle bug that reveals itself when, after a full rebuild, you do an incremental build with mode set to infodb. The search results appear in a different order each time for the same search as before. His quick fix is to sort the results when taken out of the database, but he thinks that the bug itself implies that there is something dependent on the order of the data coming out of the DB that expects it to be in a certain order.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • main/trunk/greenstone2/perllib/dbutil/sqlite.pm

    r23399 r23683  
    136136 
    137137 
    138   my $keys_str = read_infodb_cmd($infodb_file_path,"SELECT key FROM data;"); 
     138  my $keys_str = read_infodb_cmd($infodb_file_path,"SELECT key FROM data ORDER BY key;"); 
    139139 
    140140  my @keys = split(/\n/,$keys_str);