NHibernate 的 BUG?

[liqianhong]

Voucher12 和Voucher11 继承 VoucherEntity
VoucherEntity 包含属性 ID,CanPrint

Voucher12 包含一属性HandleCharge 为 Voucher11的实列

有这样一个HQL
From Voucher12 v Where v.CanPrint = true or v.HandleCharge.CanPrint =true
结果所有 Voucher11里 CanPrint=true的记录全被关联起来了
并不象期望的那样

From Voucher12 a inner join Voucher11 b
where a.ID = B.ID and ( a.CanPrint =true or b.CanPrint = true)


产生的结果和这个差不多
From Voucher12 a inner join Voucher11 b
where ( a.ID = B.ID and a.CanPrint =true ) or b.CanPrint = true)

[roapzone]

http://www.cnblogs.com/Roping/archive/2007/03/27/689805.html

[liqianhong]

我看了一下,和我说的情况不一样,那个例子是多表更新的问题.
而我的这个例子是生成的sql语句不对造成的

[liqianhong]

From Voucher12 v Where v.CanPrint = true or v.HandleCharge.CanPrint =true
生成 sql 为

select ..
from voucherdata12 a inner join voucherinfo b on a.id = b.id,
voucherdata11 c inner join voucherinfo d on c.id = d.id
where b.canprint = 1 or (d.id = b.id and d.canprint=1)

不是我们期望的那样,
where d.id = b.id and (b.canprint = 1 or d.canprint=1)