Changeset 66698a6 for src/sql/sqlengine.cpp

Timestamp:

07/08/11 16:19:39 (11 years ago)

Author:

gregor herrmann <gregoa@…>

Branches:

master, qt5

Children:

47eda2b

Parents:

5c41999

Message:

Avoid duplicate search results by using SELECT DISTINCT when filling the SEARCH_EVENT table.

File:

• src/sql/sqlengine.cpp (modified) (1 diff)

src/sql/sqlengine.cpp

@@ -303 +303 @@
     // INSERT
     QString sql = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id ) "
-                "SELECT EVENT.xid_conference, EVENT.id FROM EVENT ");
+                "SELECT DISTINCT EVENT.xid_conference, EVENT.id FROM EVENT ");
     if( aColumns.contains("ROOM") ){
         sql += "INNER JOIN EVENT_ROOM ON ( EVENT.xid_conference = EVENT_ROOM.xid_conference AND EVENT.id = EVENT_ROOM.xid_event ) ";