Thread: Re: [c-jdbc] Bug Report

Re: [c-jdbc] Bug Report

From
Nicolas Modrzyk
Date:
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_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2004WEEK48-2004WEEK49'::textas roll, "2004WEEK48-2004WEEK49" as value from temp.zz_deltasroll_1100866542312 union
selecthubid, 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_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2004WEEK51-2004WEEK52'::textas roll, "2004WEEK51-2004WEEK52" as value from temp.zz_deltasroll_1100866542312 union
selecthubid, 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_1100866542312union select hubid, czcode, type2, order_, itemid, item, hour, caseid,
'2005WEEK02-2005WEEK03'[... 10 more lines] 
>



Re: [c-jdbc] Bug Report

From
Oliver Jowett
Date:
Nicolas Modrzyk wrote:
> 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 ?

I am confused. Are you encountering a C-JDBC problem, a PostgreSQL JDBC
driver problem, a PostgreSQL backend query parsing problem, or something
else again? Exactly what error or misbehaviour do you see?

The query itself does not seem too painful, it is a CREATE TABLE AS with
a query part that has lots of UNIONs:

   CREATE TABLE ... AS
     SELECT ... FROM ...
     UNION
     SELECT ... FROM ...
     UNION
     SELECT ... FROM ...
     [...]

-O