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.
