-------------------------------------------------------------------------------

Test set: org.hibernate.test.legacy.ParentChildTest

-------------------------------------------------------------------------------

Tests run: 18, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.25 sec <<< FAILURE!

testComplexCriteria(org.hibernate.test.legacy.ParentChildTest) Time elapsed: 0.453 sec <<< ERROR!

org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2235)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)

at org.hibernate.loader.Loader.list(Loader.java:2124)

at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:117)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1531)

at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)

at org.hibernate.test.legacy.ParentChildTest.testComplexCriteria(ParentChildTest.java:248)

Caused by: java.sql.SQLException: Column not found: FOO4_.STRING_ in statement [select this_.baz_id_column_ as baz1_1219_11_, this_.count_count as count2_1219_11_, this_.name_b as name3_1219_11_, this_.foo as foo1219_11_, this_.superBaz as superBaz1219_11_, this_.str as str1219_11_, foo6_."foo_idcolumnname123" as foo1_1211_0_, foo6_.version as version1211_0_, foo6_.foo as foo1211_0_, foo6_.long_ as long5_1211_0_, foo6_."integer__" as integer6_1211_0_, foo6_.float_ as float7_1211_0_, foo6_.x as x1211_0_, foo6_.double_ as double9_1211_0_, foo6_.date_ as date10_1211_0_, foo6_.timestamp_ as timestamp11_1211_0_, foo6_.boolean_ as boolean12_1211_0_, foo6_.bool_ as bool13_1211_0_, foo6_.null_ as null14_1211_0_, foo6_.short_ as short15_1211_0_, foo6_.char_ as char16_1211_0_, foo6_.zero_ as zero17_1211_0_, foo6_.int_ as int18_1211_0_, foo6_.string_ as string19_1211_0_, foo6_.byte_ as byte20_1211_0_, foo6_.yesno as yesno1211_0_, foo6_.blobb_ as blobb22_1211_0_, foo6_.nullBlob as nullBlob1211_0_, foo6_.bin_ as bin24_1211_0_, foo6_."localeayzabc123" as localea25_1211_0_, foo6_.first_name as first26_1211_0_, foo6_.surname as surname1211_0_, foo6_.count_ as count28_1211_0_, foo6_.name_ as name29_1211_0_, foo6_.g__ as g30_1211_0_, foo6_.cmpnt_null_ as cmpnt31_1211_0_, foo6_.subname as subname1211_0_, foo6_.fee_sub as fee33_1211_0_, foo6_.null_cmpnt_ as null34_1211_0_, foo6_1_.joinedProp as joinedProp1215_0_, foo6_2_.dependent as dependent1216_0_, foo6_.the_time as the35_1211_0_, foo6_.baz as baz1211_0_, foo6_.bar_string as bar37_1211_0_, foo6_.bar_count as bar38_1211_0_, foo6_.name as name1211_0_, foo6_.clazz as clazz1211_0_, foo6_.gen_id as gen41_1211_0_, foo6_3_.name_name as name2_1218_0_, foo6_.int_/2 as formula34_0_, foo6_."foo_subclass_1234" as foo2_1211_0_, glarch7_.tha_key as tha1_1246_1_, glarch7_.version as version1246_1_, glarch7_.namecvbnmasdf as namecvbn3_1246_1_, glarch7_.next_ as next4_1246_1_, glarch7_.order_ as order5_1246_1_, glarch7_.foo as foo1246_1_, glarch7_.bar as bar1246_1_, glarch7_.x as x1246_1_, glarch7_.immutable as immutable1246_1_, glarch7_."any_id_of_object" as any10_1246_1_, glarch7_."any_class_of_object" as any11_1246_1_, glarch7_.count_ as count12_1246_1_, glarch7_.glarch_ as glarch13_1246_1_, fee8_.id_ as id1_1256_2_, fee8_.fi as fi1256_2_, fee8_.fee as fee1256_2_, fee8_.anotherFee as anotherFee1256_2_, fee8_.qux as qux1256_2_, fee8_.count_ as count6_1256_2_, fee8_.name as name1256_2_, fee8_.null_prop as null8_1256_2_, fee9_.id_ as id1_1256_3_, fee9_.fi as fi1256_3_, fee9_.fee as fee1256_3_, fee9_.anotherFee as anotherFee1256_3_, fee9_.qux as qux1256_3_, fee9_.count_ as count6_1256_3_, fee9_.name as name1256_3_, fee9_.null_prop as null8_1256_3_, fee10_.id_ as id1_1256_4_, fee10_.fi as fi1256_4_, fee10_.fee as fee1256_4_, fee10_.anotherFee as anotherFee1256_4_, fee10_.qux as qux1256_4_, fee10_.count_ as count6_1256_4_, fee10_.name as name1256_4_, fee10_.null_prop as null8_1256_4_, baz11_.baz_id_column_ as baz1_1219_5_, baz11_.count_count as count2_1219_5_, baz11_.name_b as name3_1219_5_, baz11_.foo as foo1219_5_, baz11_.superBaz as superBaz1219_5_, baz11_.str as str1219_5_, topglarche12_.idtopglarch as idtopgl16_13_, topglarche12_.tha_key as tha1_13_, topglarche12_.mapkey as mapkey13_, topglarche12_.tha_key as tha1_1246_6_, topglarche12_.version as version1246_6_, topglarche12_.namecvbnmasdf as namecvbn3_1246_6_, topglarche12_.next_ as next4_1246_6_, topglarche12_.order_ as order5_1246_6_, topglarche12_.foo as foo1246_6_, topglarche12_.bar as bar1246_6_, topglarche12_.x as x1246_6_, topglarche12_.immutable as immutable1246_6_, topglarche12_."any_id_of_object" as any10_1246_6_, topglarche12_."any_class_of_object" as any11_1246_6_, topglarche12_.count_ as count12_1246_6_, topglarche12_.glarch_ as glarch13_1246_6_, baz13_.baz_id_column_ as baz1_1219_7_, baz13_.count_count as count2_1219_7_, baz13_.name_b as name3_1219_7_, baz13_.foo as foo1219_7_, baz13_.superBaz as superBaz1219_7_, baz13_.str as str1219_7_, foo3_."foo_idcolumnname123" as foo1_1211_8_, foo3_.version as version1211_8_, foo3_.foo as foo1211_8_, foo3_.long_ as long5_1211_8_, foo3_."integer__" as integer6_1211_8_, foo3_.float_ as float7_1211_8_, foo3_.x as x1211_8_, foo3_.double_ as double9_1211_8_, foo3_.date_ as date10_1211_8_, foo3_.timestamp_ as timestamp11_1211_8_, foo3_.boolean_ as boolean12_1211_8_, foo3_.bool_ as bool13_1211_8_, foo3_.null_ as null14_1211_8_, foo3_.short_ as short15_1211_8_, foo3_.char_ as char16_1211_8_, foo3_.zero_ as zero17_1211_8_, foo3_.int_ as int18_1211_8_, foo3_.string_ as string19_1211_8_, foo3_.byte_ as byte20_1211_8_, foo3_.yesno as yesno1211_8_, foo3_.blobb_ as blobb22_1211_8_, foo3_.nullBlob as nullBlob1211_8_, foo3_.bin_ as bin24_1211_8_, foo3_."localeayzabc123" as localea25_1211_8_, foo3_.first_name as first26_1211_8_, foo3_.surname as surname1211_8_, foo3_.count_ as count28_1211_8_, foo3_.name_ as name29_1211_8_, foo3_.g__ as g30_1211_8_, foo3_.cmpnt_null_ as cmpnt31_1211_8_, foo3_.subname as subname1211_8_, foo3_.fee_sub as fee33_1211_8_, foo3_.null_cmpnt_ as null34_1211_8_, foo3_1_.joinedProp as joinedProp1215_8_, foo3_2_.dependent as dependent1216_8_, foo3_.the_time as the35_1211_8_, foo3_.baz as baz1211_8_, foo3_.bar_string as bar37_1211_8_, foo3_.bar_count as bar38_1211_8_, foo3_.name as name1211_8_, foo3_.clazz as clazz1211_8_, foo3_.gen_id as gen41_1211_8_, foo3_3_.name_name as name2_1218_8_, foo3_.int_/2 as formula34_8_, foo3_."foo_subclass_1234" as foo2_1211_8_, glarch1_.tha_key as tha1_1246_9_, glarch1_.version as version1246_9_, glarch1_.namecvbnmasdf as namecvbn3_1246_9_, glarch1_.next_ as next4_1246_9_, glarch1_.order_ as order5_1246_9_, glarch1_.foo as foo1246_9_, glarch1_.bar as bar1246_9_, glarch1_.x as x1246_9_, glarch1_.immutable as immutable1246_9_, glarch1_."any_id_of_object" as any10_1246_9_, glarch1_."any_class_of_object" as any11_1246_9_, glarch1_.count_ as count12_1246_9_, glarch1_.glarch_ as glarch13_1246_9_, glarch2_.tha_key as tha1_1246_10_, glarch2_.version as version1246_10_, glarch2_.namecvbnmasdf as namecvbn3_1246_10_, glarch2_.next_ as next4_1246_10_, glarch2_.order_ as order5_1246_10_, glarch2_.foo as foo1246_10_, glarch2_.bar as bar1246_10_, glarch2_.x as x1246_10_, glarch2_.immutable as immutable1246_10_, glarch2_."any_id_of_object" as any10_1246_10_, glarch2_."any_class_of_object" as any11_1246_10_, glarch2_.count_ as count12_1246_10_, glarch2_.glarch_ as glarch13_1246_10_ from baz this_ left outer join "foos" foo6_ on this_.foo=foo6_."foo_idcolumnname123" left outer join jointable foo6_1_ on foo6_."foo_idcolumnname123"=foo6_1_.fooid left outer join foo_dep_table foo6_2_ on foo6_."foo_idcolumnname123"=foo6_2_.fooid left outer join bar_join_table foo6_3_ on foo6_."foo_idcolumnname123"=foo6_3_.bar_id left outer join "glarchez" glarch7_ on foo6_.g__=glarch7_.tha_key left outer join "the fees" fee8_ on foo6_2_.dependent=fee8_.id_ left outer join "the fees" fee9_ on fee8_.fee=fee9_.id_ left outer join "the fees" fee10_ on fee9_.anotherFee=fee10_.id_ left outer join baz baz11_ on foo6_.baz=baz11_.baz_id_column_ left outer join "glarchez" topglarche12_ on baz11_.baz_id_column_=topglarche12_.idtopglarch left outer join baz baz13_ on baz11_.superBaz=baz13_.baz_id_column_ inner join "foos" foo3_ on this_.baz_id_column_=foo3_.baz_id and foo3_."foo_subclass_1234" in ('F', 'B', 'T') left outer join jointable foo3_1_ on foo3_."foo_idcolumnname123"=foo3_1_.fooid left outer join foo_dep_table foo3_2_ on foo3_."foo_idcolumnname123"=foo3_2_.fooid left outer join bar_join_table foo3_3_ on foo3_."foo_idcolumnname123"=foo3_3_.bar_id inner join fooArray fooarray15_ on this_.baz_id_column_=fooarray15_.id_ and ( fooarray15_.i<8) inner join "glarchez" glarch1_ on this_.baz_id_column_=glarch1_.idtopglarch inner join "glarchez" glarch2_ on glarch1_.tha_key=glarch2_.array_key where glarch1_.namecvbnmasdf is not null and glarch2_.namecvbnmasdf=glarch2_.namecvbnmasdf and glarch2_.namecvbnmasdf=? and glarch2_.x>? and foo3_.null_ is null and foo3_.string_=? and foo3_."integer__"<? and foo4_.string_=?]

at org.hsqldb.jdbc.Util.throwError(Unknown Source)

at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1578)

at org.hibernate.loader.Loader.doQuery(Loader.java:696)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

at org.hibernate.loader.Loader.doList(Loader.java:2232)

... 35 more