Opened 2 years ago

Closed 22 months ago

#849 closed defect (fixed)

directql does not work with input files

Reported by: vliaukevich Owned by: dmisev
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 Changed 2 years ago by dmisev

  • Owner changed from dmisev to bthapaliya
  • Status changed from new to assigned

comment:2 Changed 2 years ago by dmisev

  • Milestone set to 9.1

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

comment:3 Changed 2 years ago by dmisev

  • Owner changed from bthapaliya 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 Changed 22 months ago by dmisev

  • Owner changed from bismaili to dmisev

Patch submitted

comment:5 Changed 22 months ago by dmisev

  • Resolution set to fixed
  • Status changed from assigned to closed
Note: See TracTickets for help on using tickets.