Hello Gabor, That's true. I forgot to mention in my previous e-mail that you can have a look at the sql/test/sciql/Tests/All file, the enabled tests there indicate implemented features. Regards, Jennie On May 03, 2013, at 08:00, Gabor Urbanics wrote:

Hi Jennie,

Thanks for the apt response! Is it the same with altering a _bounded_ array? So e.g. the query

alter table "my_bounded_array" alter column X integer dimension[1:1:10]

is not supposed to increase X's cardinality if it originally was defined as dimension[1:1:5], isn't it?

Thanks again!

Best regards, Gabor

On 2 May 2013 13:31, Ying Zhang wrote: Hello Gabor,

First of all, thank you very much for you interest in MonetDB/SciQL.

Since the implementation of the SciQL language is still an ongoing work, compile the "sciql" branch from the Mercurial repository is the only way to get SciQL support.

The incorrect results you got from inserting into unbounded array is because it's not supported yet. Except creation, operations on unbounded arrays are generally not supported yet. I have tried to give an error message for unsupported features, but there are too many to cover them all. My apologies for the confusion!

With kind regards,

Jennie

On May 02, 2013, at 09:22, Gabor Urbanics wrote:

...

Hi All,

I have a question about MonetDB/SciQL, in particular regards to the unbounded arrays and their updates.

I've created two arrays (one bounded and an unbounded) essentially with the same schemata in my database as follows: """ sql>\d ARRAY sys.facts ARRAY sys.facts_bounded sql>\d sys.source CREATE TABLE "sys"."source" ( "x" INTEGER, "y" INTEGER, "v" VARCHAR(32) ); sql>\d sys.facts CREATE ARRAY "sys"."facts" ( "x" INTEGER DIMENSION [0:1:1], "y" INTEGER DIMENSION [0:1:*], "v" VARCHAR(32) ); """

My goal at the moment is to use the unbounded array as it would fit very well the domain of my application: several coordinates-like columns and a couple of attributes, but the ranges of the coordinates are not known beforehand.

Unfortunately, I am facing some problems when I try to insert values into the unbounded array: """ sql>insert into sys.facts values (0,0,'42'); 0 affected rows (0.938ms) """

On the other hand, the same insert operation works just fine with the bounded array: """ sql>insert into sys.facts_bounded values (0,0,'42'); 1 affected row (20.594ms) sql>select * from sys.facts_bounded; +------+------+------+ | x | y | v | +======+======+======+ | 0 | 0 | 42 | | 0 | 1 | null | ... (5 lines omitted for brevity) | 1 | 3 | null | +------+------+------+ 8 tuples (0.612ms) """

I would like to know if this is the supposed way one can insert values into unbounded arrays or I am doing something wrong.

I compiled the source from the branch "sciql" from the mercurial repository 2 days ago, as my understanding was that the built versions do not support SciQL. Is there any other way I can get a MonetDB with SciQL support?

If it helps anything, the beginning of the welcome message of the mserver5 is as follows: """ # MonetDB 5 server v11.16.0 # This is an unreleased version # Serving database 'monetdb5', using 4 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked """

Any help or suggestion is appreciated!

Best regards, Gabor

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list