[erlang-bugs] Bug in QLC ?

Torbjorn Tornkvist tobbe@REDACTED
Tue Mar 25 13:59:11 CET 2008


Hans Bolinder wrote:
> [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

Thanx a lot for that info!

Cheers, Tobbe

> 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
> _______________________________________________
> erlang-bugs mailing list
> erlang-bugs@REDACTED
> http://www.erlang.org/mailman/listinfo/erlang-bugs
> 




More information about the erlang-bugs mailing list