[erlang-bugs] Bug in QLC ?

Hans Bolinder hans.bolinder@REDACTED
Tue Mar 25 13:17:34 CET 2008


[Torbjorn Tornkvist:]
> (Ps. The DSL query was: for every invoice and person record where eid ==
> 308 and inv_pno == pno return invno, fname and lname as a table )

Note that currently qlc will not try to look up the key unless you
write "eid =:= 308". Similarly, qlc will always do a merge join when
columns are compared; lookup join is only considered when columns are
matched ("inv_pno =:= pno"). (I assume here that you don't mix
integers and floating point numbers is such a way that ==/2 has to be
used.).

Use qlc:info() to see how qlc will evaluate a query.

Best regards,

Hans Bolinder, Erlang/OTP team



More information about the erlang-bugs mailing list