Oh,This is the raw text query of the Query.I misunderstood.Now, I think this issue is not a bug.
Join graph segments (f indicates final):
seg[0]: [0]
seg[1]: sd[0] (f)
seg[2]: autoint[0] (f)
seg[3]: default[0] (f)
seg[4]: [1]
seg[5]: cint[1]
Join graph nodes:
node[0]: complicatetable c(5/1)
node[1]: complicatetable2 c2(3/1) (sargs 1)
Join graph equivalence classes:
eqclass[0]: sd[0] cint[1]
Join graph edges:
term[0]: c.sd=c2.cint (sel 1) (join term) (mergeable) (inner-join) (indexable sd[0] cint[1]) (loc 0)
Join graph terms:
term[1]: c2.cint range (min inf_le 4) (sel 0.1) (rank 2) (sarg term) (not-join eligible) (indexable cint[1]) (loc 0)
Query plan:
temp(group by)
subplan: idx-join (inner join)
outer: iscan
class: c2 node[1]
index: pk_complicatetable2_cint term[1] (covers)
cost: 1 card 1
inner: iscan
class: c node[0]
index: pk_complicatetable_sd term[0]
cost: 1 card 5
cost: 2 card 5
sort: 1 asc
cost: 8 card 5
Query stmt:
select c.sd, c.autoint, c.[default] from complicatetable c, complicatetable2 c2 where (c2.cint<= ?:0 ) and c.sd=c2.cint group by c.sd
Please check the raw text query plan.
It also hasn't a query plan for "where" clauses.
It's graph query plan can make something if it's raw text query plan had informations.