Opened 9 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 Dimitar Misev, 9 years ago

Owner: changed from Dimitar Misev to Bidesh Thapaliya
Status: newassigned

comment:2 by Dimitar Misev, 9 years ago

Milestone: 9.1

Common code from rasql and directql should be refactored in a class in raslib, so we avoid duplication.

comment:3 by Dimitar Misev, 9 years ago

Owner: changed from Bidesh Thapaliya to bismaili

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:4 by Dimitar Misev, 9 years ago

Owner: changed from bismaili to Dimitar Misev

Patch submitted

comment:5 by Dimitar Misev, 9 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.