Custom Query (2765 matches)

rasdaman should be improved to be able to use marray objects which are not necessarily in the database in its query processing. Those marray objects are usually passed using the $1 symbol. For example: select jpeg(inv_tiff($1) + r) from mr as r' —file anything.tif

Currently, the $1 symbol is only used when data is to be inserted, however, i will like to use it in the select statement. Using the $1 symbol in insert statement currently returns this error.

rasdaman:~$ rasql -q 'select inv_jpeg($1) + r from rgb as r' —file rasql_1.jpeg rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 27.07.2010 09:46:21. opening database RASBASE at localhost:7001...ok fetching type information for GreyString from database, using readonly transaction…ok reading file rasql_1.jpeg…ok

constant 1: GMarray Oid……………….: Type Structure……..: Type Schema………..: marray< char > Domain…………….: [0:19834] Base Type Schema……: char Base Type Length……: 1 Data format………. : Array Data size (bytes)…. : 19835

Executing retrieval query…rasdaman error 373: Execution error 373 in line 1, column 17, near token #MDD0#: Unsatisfied MDD constant parameter. aborting transaction…ok rasql done.

Furthermore, it will be appropriate if rasdaman can handle several of these marray objects which are not in the database in a query processing e.g rasql -q 'select inv_jpeg($1) + inv_tiff($2) + r from rgb as r' —file jpegimage.jpeg tiffimage.tiff

The server fails to check right username and password used for logging into Rasdaman database. Chances are high that the error is in the RN protocol directory. The reasons might be

1. Parameters for Username and Password are not evaluated.
2. Parameters are not transferred to Server.

In cases where WCPS returns scalar values, the value returned by rasj is usually wrong and different from the value obtained if the equivalent query was to run on rasdaman For example, using the mr2 sampleimage as an example, Query using rasql: rasql -q 'select max_cells(r) from mr2 as r' —out string ……. Result element 1: 253

Query using WCPS: for c in (mr2) return max©

result = -3