[
http://jira.codehaus.org/browse/GEOT-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrea Aime reopened GEOT-2325:
-------------------------------
Gusy, sorry for this but I have to reopen the jira.
The last patch I provided to make the test pass in Oracle modified only the
prepared statement path. Unfortunately I did not run the postgis tests with ps
enabled, which started to fail when that patch was attached.
So the thing is like this: oracle does not accept table aliases with "as", so
the original path broke it. Postgis pretends to have a table alias set when a
subquery is used in the from clause, so my patch broke it.
Both seem to accept a table alias if the "as" is not included in the mix, but I
don't know if this will work against mysql, db2 and sqlserver.
I'm about to attache a further patch that uses the above approach in both the
ps and non ps path. Can you try it out against the databases I miss?
> jdbc-ng: add support for aggregate functions
> --------------------------------------------
>
> Key: GEOT-2325
> URL: http://jira.codehaus.org/browse/GEOT-2325
> Project: GeoTools
> Issue Type: Improvement
> Components: data jdbc-ng
> Reporter: Andrea Aime
> Assignee: Jody Garnett
> Fix For: 2.5.8, 2.6-RC1
>
> Attachments: GEOT-2325-db2.patch, GEOT-2325-final.patch,
> GEOT-2325-jdbc.patch, GEOT-2325-main.patch, GEOT-2325-oracle.patch
>
>
> Postgis datastore has native support for the aggregation functions used to
> create thematic maps (e.g., styler and company in GeoServer).
> The functions used are pretty standard, replicate the support in jdbc-ng
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
