Opened 13 years ago

Closed 13 years ago

#86 closed defect (fixed)

CSV converter fails if result is 0 dimensioned

Reported by: petwa@… Owned by: Peter Baumann
Priority: major Milestone:
Component: conversion Version:
Keywords: Cc:
Complexity: Medium

Description

To reproduce

Create collection

rasql -q "create collection test_csv2 FloatSet"

and populate

rasql -q 'insert into test_csv2 values marray x in [0:200,0:200] values (float) (x[0] + x[1])'

This query works

rasql -q 'select csv(test_csv2[100,100:100]) from test_csv2' --out string
rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 11.11.2011 18:00:30.
opening database RASBASE at localhost:7001...ok
Executing retrieval query...ok
Query result collection has 1 element(s):
  Result object 1: 200
rasql done.

This does not

rasql -q 'select csv(test_csv2[100,100]) from test_csv2' --out string        
rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 11.11.2011 18:00:30.
opening database RASBASE at localhost:7001...ok
Executing retrieval query...rasdaman error 380: Execution error 380 in line 1, column 8, near token csv: Data type can not be converted to selected data exchange format.
aborting transaction...ok
rasql done.

Change History (2)

comment:1 by petwa@…, 13 years ago

Additionally the following 2 queries (on the same data) which do not use the csv converter also behave strangely

This works as expected

rasql -q 'select  test_csv2[100,100:100] from test_csv2' --out hex
rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 11.11.2011 18:00:30.
opening database RASBASE at localhost:7001...ok
Executing retrieval query...ok
Query result collection has 1 element(s):
  Result object 1:  0  0 48 43 
rasql done.

This gets the wrong result

rasql -q 'select  test_csv2[100,100] from test_csv2' --out hex       
rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 11.11.2011 18:00:30.
opening database RASBASE at localhost:7001...ok
Executing retrieval query...ok
Query result collection has 1 element(s):
  Result element 1: 0
rasql done.

comment:2 by Dimitar Misev, 13 years ago

Resolution: fixed
Status: newclosed

Has been fixed already.

Note: See TracTickets for help on using tickets.