|
Description:
|
Java error from H2:
java.lang.RuntimeException: Failed to get property:
{http://www.opengis.net/wfs/2.0}
boundedBy
Failed to get property:
{http://www.opengis.net/wfs/2.0}
boundedBy
java.io.IOException
null
Column temp_alias_used_for_filter.SITE_ID not found; SQL statement:
SELECT "CLIMATE_OBSERVATION"."FAKE_ID","CLIMATE_OBSERVATION"."SITE_ID","CLIMATE_OBSERVATION"."SHAPE_ID","CLIMATE_OBSERVATION"."SENSOR_ID","CLIMATE_OBSERVATION"."TIMESERIES_ID","CLIMATE_OBSERVATION"."TIME_ID","CLIMATE_OBSERVATION"."VALUE_ID","CLIMATE_OBSERVATION"."MAX_TEMP","CLIMATE_OBSERVATION"."MIN_TEMP","CLIMATE_OBSERVATION"."DATETIME","CLIMATE_OBSERVATION"."ALTITUDE","CLIMATE_OBSERVATION"."START_YEAR","CLIMATE_OBSERVATION"."GEOM" as "GEOM","CLIMATE_OBSERVATION"."NAME","CLIMATE_OBSERVATION"."SAMPLED_FEATURE" FROM "CLIMATE_OBSERVATION" INNER JOIN ( SELECT DISTINCT "SITE_ID" FROM "CLIMATE_OBSERVATION" WHERE "SITE_ID" = 'site.8039' ) temp_alias_used_for_filter ON ( "CLIMATE_OBSERVATION"."SITE_ID" = "temp_alias_used_for_filter"."SITE_ID" ) ORDER BY "CLIMATE_OBSERVATION"."SITE_ID" ASC, CLIMATE_OBSERVATION.FAKE_ID [42122-119]
When temp_alias_used_for_filter is wrapped in quote, it works from H2 console.
I looked in JoiningJDBCFeatureSource, and it appended the alias as a String instead of using getDataStore().dialect.encodeTableName().
The fix should be as simple as replacing it with getDataStore().dialect.encodeTableName().
|
