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