Re: [Hibernate-devel] 0.9.6

[Gavin_King/Cirrus%<CI...@ci...>]

Doug, I can't reproduce that result - what i get is:

SELECT bar.foo_id as foo_id0, baz1.idcode as idcode1, bar.class as class0,
bar.baz as baz0, bar.bar_string as bar_string0, bar.bar_count as
bar_count0, bar.name as name0, bar.importantDates as importantDates0,
bar.the_time as the_time0, bar.foo as foo0, bar.long_ as long_0,
bar.integer_ as integer_0, bar.float_ as float_0, bar.double_ as double_0,
bar.bytes as bytes0, bar.date_ as date_0, bar.timestamp_ as timestamp_0,
bar.boolean_ as boolean_0, bar.bool_ as bool_0, bar.null_ as null_0,
bar.short_ as short_0, bar.zero_ as zero_0, bar.int_ as int_0, bar.string_
as string_0, bar.byte_ as byte_0, bar.yesno as yesno0, bar.blobb_ as
blobb_0, bar.nullBlob as nullBlob0, bar.status_ as status_0, bar.bin_ as
bin_0, bar.first_name as first_name0, bar.surname as surname0, bar.count_
as count_0, bar.name_ as name_0, bar.subcount as subcount0, bar.subname as
subname0, baz1.count_ as count_1, baz1.name_ as name_1, baz1.stringSet as
stringSet1, baz1.stringDateMap as stringDateMap1, baz1.fooArray as
fooArray1, baz1.stringArr
ay as stringArray1, baz1.setArray as setArray1, baz1.stringArrayMap as
stringArrayMap1, baz1.setList as setList1, baz1.customs as customs1
FROM foos bar, Baz baz1
WHERE 1=1 and bar.class in ('cirrus.hibernate.test.Bar')
AND ( ( baz1.count_=667  and bar.baz = baz1.idcode ) )


which still has one slight problem: we unnecessarily grab columns from Baz
that we arent going to use. I will fix that.

not sure why you are getting a distinct select....