Changeset 66698a6


Ignore:
Timestamp:
07/08/11 16:19:39 (10 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:
1 edited

Legend:

Unmodified
Added
Removed
  • src/sql/sqlengine.cpp

    r5c41999 r66698a6  
    303303    // INSERT
    304304    QString sql = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id ) "
    305                 "SELECT EVENT.xid_conference, EVENT.id FROM EVENT ");
     305                "SELECT DISTINCT EVENT.xid_conference, EVENT.id FROM EVENT ");
    306306    if( aColumns.contains("ROOM") ){
    307307        sql += "INNER JOIN EVENT_ROOM ON ( EVENT.xid_conference = EVENT_ROOM.xid_conference AND EVENT.id = EVENT_ROOM.xid_event ) ";
Note: See TracChangeset for help on using the changeset viewer.