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