Hello Freddy,
Which monetdb version are you using ('5' is not the version of the
On Tue, Mar 06, 2012 at 02:31:37PM +0100, Freddy Priyatna wrote:
> Dear all,
>
> I've been using MonetDB version 5 on Ubuntu machine for evaluating BSBM
software package)? Can you please send us the output of the command
'mserver5 --version'?
Can you please give us the CREATE TABLE statements? We can not run your
> queries. The dataset and queries can be found here[1].
queries without creating the tables first.
With the latest release, i.e., Dec2011-SP1, this simple query seems
>
> It seems that there are some queries that are not supported on MonetDB :
> 1) SELECT p.nr, p.label
> FROM product p, producttypeproduct ptp
> WHERE p.nr=ptp.product
> AND "productType"=35
> AND "propertyNum1">500
> AND "propertyNum3"<2000
> AND 168 IN (SELECT "productFeature" FROM productfeatureproduct WHERE
> productfeatureproduct.product=p.nr)
> AND 147 NOT IN (SELECT "productFeature" FROM productfeatureproduct WHERE
> product=p.nr)
> >From the error, the subquery seems can't refer to the table alias "p".
>
> 2) SELECT distinct p.nr, p.label
> FROM product p, product po,
> (Select distinct pfp1.product FROM productfeatureproduct pfp1,
> (SELECT "productFeature" FROM productfeatureproduct WHERE product=2)
> pfp2
> WHERE pfp2."productFeature"=pfp1."productFeature") pfp
> WHERE p.nr=pfp.product AND po.nr=2 AND p.nr <> po.nr
> AND p."propertyNum1" < (po."propertyNum1"+120) AND p."propertyNum1" >
> (po."propertyNum1"-120)
> AND p."propertyNum2" < (po."propertyNum2"+170) AND p."propertyNum2" >
> (po."propertyNum2"-170)
> This is strange, because if I just comment one of the last 2 lines, the
> query works. But the last two lines can't be used together.
>
> 3) SELECT nr, label
> FROM product
> WHERE label like "%countries%";
> It seems that MonetDB doesn't support regex.
>
> 4) SELECT *
> FROM (select label from product where nr=2) p left join
> ((select o.nr as onr, o.price, v.nr as vnr, v.label from offer o,
> vendor v where 2=o.product AND
> o.vendor=v.nr AND v.country='GB' AND o."validTo">'2008-07-01') ov
> right join
> (select r.nr as rnr, r.title, pn.nr as pnnr, pn.name, r.rating1,
> r.rating2 from review r, person pn where r.product=2 AND
> r.person=pn.nr) rpn on (1=1)) on (1=1);
> It seems that MonetDB can't do join with true condition because when I
> tried to run a simple query :
> SELECT * FROM product p RIGHT JOIN offer o ON (1=1)
> Then MonetDB gives an error.
working:
$ mclient
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.7.8 (unreleased), 'demo'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>create table t1 (x int, y int, v float);
operation successful (25.398ms)
sql>create table t2 (x int, y int, v float);
operation successful (26.987ms)
sql>SELECT * FROM t1 t3 RIGHT JOIN t2 t4 ON (1=1);
+---+---+---+---+---+---+
| x | y | v | x | y | v |
+===+===+===+===+===+===+
+---+---+---+---+---+---+
0 tuples (4.595ms)
Regards,
Jennie
>
> Could anyone please help me how to run the queries above?
>
> Many thanks in advance.
> Freddy
>
>
>
>
> [1]
> http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/spec/ExploreUseCase/index.html#queriesRelational
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users