[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