Sometimes data only has a single value

[domoritz]

I simply try to use a second brush.

The server shows this error

QueryResultError {
    code: queryResultErrorCode.noData
    message: "No data returned from the query."
    received: 0
    query: {"name":"DEP_DELAY-9","text":"\n      SELECT width_bucket(\"DEP_DELAY\", $1, $2, $3) as bucket, count(*)\n      FROM flights\n      WHERE $4 < \"DEP_DELAY\" and \"DEP_DELAY\" < $5 and \"DISTANCE\" < $6 and $7 < \"ARR_DELAY\" and \"ARR_DELAY\" < $8\n      GROUP BY bucket order by bucket asc;\n    ","values":[0,100,25,0,100,1016.1363636363637,39.09090909090909,59.77272727272728]}
}

But the query seems to be correct and returns data if I run it in psql. Any ideas?

[domoritz]

Could it be that there is some confusion with values (in value space) and indexes (in pixel space)?

[mathisonian]

A couple things -

I've fixed the bug where you get a distribution like in the screenshot, e.g.

{ 0: 10000, 1: 0, 2: 0 ... 25: 0 }

There is still a problem where if you have prepared statements enabled sometimes no rows are returned at all (I never get this unless prepared statements are turned on - is this the same for you @domoritz?). I've confirmed as well that the queries are being properly formatted and they do return data when run against postgres.

I asked the guy who wrote pg-promise and he confirmed that this definitely looks like an issue at the postgres level and not in the node.js layer, so at least (afaict) we've isolated it to the prepared statements in postgres

[domoritz]

This is so old it probably isn't relevant any more.