Re: [c-jdbc] Bug Report

Hi All,

Could anyone let us know how to understand the attached query ?
From what I know this is an Orion (java application server) generated
query for postgresql...

The C-JDBC parsing seems to fail because we can't find a proper FROM
keyword to select the depedencies of the query.
Since this is not seemingly SQL92 standard, can anyone from the
postgresql team give us some information ?

Thank you,

Nicolas Modrzyk,

>------------------------------------------------------------------------
>
>create table temp.zz_deltasrollAll_1100866542312_cache2_weekly as select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK47-2004WEEK48'::text as roll, "2004WEEK47-2004WEEK48" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK48-2004WEEK49'::text as roll, "2004WEEK48-2004WEEK49" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK49-2004WEEK50'::text as roll, "2004WEEK49-2004WEEK50" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK50-2004WEEK51'::text as roll, "2004WEEK50-2004WEEK51" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK51-2004WEEK52'::text as roll, "2004WEEK51-2004WEEK52" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2004WEEK52-2005WEEK01'::text as roll, "2004WEEK52-2005WEEK01" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2005WEEK01-2005WEEK02'::text as roll, "2005WEEK01-2005WEEK02" as value from temp.zz_deltasroll_1100866542312 union select hubid, czcode, type2, order_, itemid, item, hour, caseid, '2005WEEK02-2005WEEK03' [... 10 more lines]
>