Custom Query (2765 matches)

It seems that every rasql query executes opens up a new postgresql connection, and never closes it before exiting. After a couple of hundreds of queries, the postgres DBMS decides to halt because the maximum number of connections has been reached.

Tested with the git repository version of rasdaman (8.1), on 2009-11-09.

Attached is a script that executes lots of rasql queries.

The result of the query

select csv(cov[0:399, 0:343].0) from rgb as cov

should be the encoding of "rgb" as comma-separated values. However, it does not contain the band value 164, which comes out when only a small subset of the image is evaluated:

select csv(cov[200:299, 200:300].0) from rgb as cov

The query select png(((c)*(2))) from rgb AS c returns a weird image. The underlying data of rgb is 3-banded, but the result of this query looks like this 3-band data is assumed to be 1-band. Attached is my result of the above query.

For comparison, the query where the scalar is a char value delivers the correct result: select png(((c)*(2c))) from rgb AS c