what error message are you getting? HK wrote: > Hello, > > I was using the h2 1.2, an update to 1.3. > > 1.2 worked fine in SQL there. > But an error in 1.3. > > > create table TEST_GROUP_CLASS > ( > GCL_SID1 integer not null, > GCL_SID2 integer not null, > GCL_SID3 integer not null, > GCL_SID4 integer not null, > GCL_SID5 integer not null, > primary key (GCL_SID1, > GCL_SID2, > GCL_SID3, > GCL_SID4, > GCL_SID5 > ) > ) ; > > create table TEST_GROUPM > ( > GRP_SID integer not null, > GRP_NAME varchar(20), > primary key (GRP_SID) > ) ; > > > > This error occurs in SQL > > select count(*) from > ( > select > GC.GCL_SID1 as GCL_SID1, > GC.GCL_SID2 as GCL_SID2, > GC.GCL_SID3 as GCL_SID3, > GC.GCL_SID4 as GCL_SID4, > GC.GCL_SID5 as GCL_SID5, > GI1.GRP_NAME as GNAME1, > GI2.GRP_NAME as GNAME2, > GI3.GRP_NAME as GNAME3, > GI4.GRP_NAME as GNAME4, > GI5.GRP_NAME as GNAME5 > from > ((((( > TEST_GROUP_CLASS GC > left join TEST_GROUPM GI1 on GC.GCL_SID1 = GI1.GRP_SID) > left join TEST_GROUPM GI2 on GC.GCL_SID2 = GI2.GRP_SID) > left join TEST_GROUPM GI3 on GC.GCL_SID3 = GI3.GRP_SID) > left join TEST_GROUPM GI4 on GC.GCL_SID4 = GI4.GRP_SID) > left join TEST_GROUPM GI5 on GC.GCL_SID5 = GI5.GRP_SID) > ) > > > Is this a bug? > > > > > I'll make simple SQL successfully. > > select > GC.GCL_SID1 as GCL_SID1, > GC.GCL_SID2 as GCL_SID2, > GC.GCL_SID3 as GCL_SID3, > GC.GCL_SID4 as GCL_SID4, > GC.GCL_SID5 as GCL_SID5, > GI1.GRP_NAME as GNAME1, > GI2.GRP_NAME as GNAME2, > GI3.GRP_NAME as GNAME3, > GI4.GRP_NAME as GNAME4, > GI5.GRP_NAME as GNAME5 > from > ((((( > TEST_GROUP_CLASS GC > left join TEST_GROUPM GI1 on GC.GCL_SID1 = GI1.GRP_SID) > left join TEST_GROUPM GI2 on GC.GCL_SID2 = GI2.GRP_SID) > left join TEST_GROUPM GI3 on GC.GCL_SID3 = GI3.GRP_SID) > left join TEST_GROUPM GI4 on GC.GCL_SID4 = GI4.GRP_SID) > left join TEST_GROUPM GI5 on GC.GCL_SID5 = GI5.GRP_SID) > > > Thanks >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
