Changeset 23683 for main

Timestamp:

2011-02-11T14:23:41+13:00 (13 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.

File:

• main/trunk/greenstone2/perllib/dbutil/sqlite.pm (modified) (1 diff)

main/trunk/greenstone2/perllib/dbutil/sqlite.pm

@@ -136 +136 @@
 
 
-  my $keys_str = read_infodb_cmd($infodb_file_path,"SELECT key FROM data;");
+  my $keys_str = read_infodb_cmd($infodb_file_path,"SELECT key FROM data ORDER BY key;");
 
   my @keys = split(/\n/,$keys_str);