Issue Bug Closed

#79397SQL error in ReferenceIndexing

Thomas Hohn 01/20/17, 08:27 updated 10/17/17, 23:29

Description

Just with a relative small amount and tables the ReferenceIndexing crashes with an SQL error.
This seems to be due to the fact that the method updateIndex uses the NOT IN () in 2 SQL statements.

There is a limit on the number of elements in a IN clause that can be exceeded and in addition a better
and more efficient way is to use the AND NOT EXISTS (SUB-QUERY)

Reviews 1