marklogic / marklogic-geo-data-services

Geo Data Services supporting Esri Koop Provider and WFS (future)
https://marklogic.github.io/marklogic-geo-data-services/
Other
2 stars 5 forks source link

Decimal overflow when generating histogram #107

Open mitchshepherd opened 1 year ago

mitchshepherd commented 1 year ago
:::req.url
/marklogic/GDeltGKG/FeatureServer/4/query?f=json&outStatistics=%5B%7B%22statisticType%22%3A%22count%22%2C%22onStatisticField%22%3A%22urltone%22%2C%22outStatisticFieldName%22%3A%22count_2%22%7D%2C%7B%22statisticType%22%3A%22min%22%2C%22onStatisticField%22%3A%22urltone%22%2C%22outStatisticFieldName%22%3A%22min_2%22%7D%2C%7B%22statisticType%22%3A%22max%22%2C%22onStatisticField%22%3A%22urltone%22%2C%22outStatisticFieldName%22%3A%22max_2%22%7D%2C%7B%22statisticType%22%3A%22avg%22%2C%22onStatisticField%22%3A%22urltone%22%2C%22outStatisticFieldName%22%3A%22avg_2%22%7D%2C%7B%22statisticType%22%3A%22stddev%22%2C%22onStatisticField%22%3A%22urltone%22%2C%22outStatisticFieldName%22%3A%22stddev_2%22%7D%5D&where=1%3D1&callback=dojo.io.script.jsonp_dojoIoScript82._jsonpCallback
:::req.params
{ id: 'GDeltGKG', layer: '4', method: 'query' }
:::req.query
{ f: 'json',
  outStatistics: '[{"statisticType":"count","onStatisticField":"urltone","outStatisticFieldName":"count_2"},{"statisticType":"min","onStatisticField":"urltone","outStatisticFieldName":"min_2"},{"statisticType":"max","onStatisticField":"urltone","outStatisticFieldName":"max_2"},{"statisticType":"avg","onStatisticField":"urltone","outStatisticFieldName":"avg_2"},{"statisticType":"stddev","onStatisticField":"urltone","outStatisticFieldName":"stddev_2"}]',
  where: '1=1',
  callback: 'dojo.io.script.jsonp_dojoIoScript82._jsonpCallback' }
{
  "message": "KoopProvider: response with invalid 500 status",
  "statusCode": 500,
  "body": {
    "errorResponse": {
      "statusCode": 500,
      "status": "Error handling request",
      "messageCode": "RESTAPI-SRVEXERR",
      "message": "XDMP-DECOVRFLW: plan.execute(plan.sparql(\" *{ SELECT count(urltone) AS count_2)  min(urltone) AS min_2)  max(urltone) AS max_2)  avg(urltone) AS avg_2)  stddev@native/varianceplugin(urltone) AS stddev_2)  CONSTRAIN  { CONSTRAIN  {  <http://marklogic.com/templateview>  . } } GROUP BY ORDER BY OFFSET ?offset OFFSET \\\"0\\\"^^<http://www.w3.org/2001/XMLSchema#unsignedLong> LIMIT ?limit }\"), {offset:0, limit:9007199254740991}) -- Decimal overflow"
    }
  }
}

Copied issue from koop-provider-marklogic by jkerr5 commented on Nov 22, 2017