Opened 10 years ago
Closed 9 years ago
#849 closed defect (fixed)
directql does not work with input files
Reported by: | Veranika Liaukevich | Owned by: | Dimitar Misev |
---|---|---|---|
Priority: | major | Milestone: | 9.1 |
Component: | applications | Version: | development |
Keywords: | Cc: | ||
Complexity: | Medium |
Description
directql returns empty results for queries with input files:
$ directql -q 'select sdom(decode($1))' -f ~/Pictures/aok.png --out string directql: rasdaman query tool v1.0, rasdaman v9.0.5-gffe716e -- generated on 04.11.2014 15:19:10. opening database RASBASE at localhost:5432...conn = RASBASE ok fetching type information for GreyString from database, using readonly transaction...ok reading file /home/nika/Pictures/aok.png...ok constant 1: GMarray Oid...................: Type Structure........: Type Schema...........: marray< char > Domain................: [0:291217] Base Type Schema......: char Base Type Length......: 1 Data format.......... : Array Data size (bytes).... : 291218 Executing retrieval query...Getting result...ok directql done.
Insert and update queries which use files and are sent via directql does not affect data.
directql -q 'insert into rgb values decode($1)' -f ~/Pictures/aok.png --out string --user rasadmin --passwd rasadmin
directql -q 'update rgb set rgb[0:1,0:1] values decode($1)[0:1, 0:1]' -f ~/Pictures/aok.png --out string --user rasadmin --passwd rasadmin
Change History (5)
comment:1 by , 10 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:2 by , 10 years ago
Milestone: | → 9.1 |
---|
comment:3 by , 10 years ago
Owner: | changed from | to
---|
So the common code should be put in raslib/clientsutil.cc
rasql should be considered as having the most recent bug-fixed code, as directql hasn't been used so much.
comment:5 by , 9 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Common code from rasql and directql should be refactored in a class in raslib, so we avoid duplication.