Lists: | pgsql-jdbc |
---|
From: | Nicolas Modrzyk <Nicolas(dot)Modrzyk(at)inrialpes(dot)fr> |
---|---|
To: | c-jdbc(at)objectweb(dot)org, pgsql-jdbc(at)postgresql(dot)org |
Cc: | gvp <blindvit(at)gala(dot)net> |
Subject: | Re: [c-jdbc] Bug Report |
Date: | 2004-11-22 17:48:52 |
Message-ID: | 41A22684.3060107@inrialpes.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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]
>
From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Nicolas Modrzyk <Nicolas(dot)Modrzyk(at)inrialpes(dot)fr> |
Cc: | c-jdbc(at)objectweb(dot)org, pgsql-jdbc(at)postgresql(dot)org, gvp <blindvit(at)gala(dot)net> |
Subject: | Re: [c-jdbc] Bug Report |
Date: | 2004-11-22 20:59:01 |
Message-ID: | 41A25315.5080108@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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