Dear Stefan,
You are right, here you have the error message for each query :
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)
Error: 42S22!SELECT: no such column 'p.nr'
SQLState: null
ErrorCode: 0
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)
Error: TypeException:user.s945_1[155]:'algebra.join' undefined in:
_267:bat[:oid,:int] := algebra.join(_266:bat[:oid,:void],
_115:bat[:oid,:int])
39000!program contains errors
SQLState: null
ErrorCode: 0
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);
.
.
.
TypeException:user.s946_1[472]:'algebra.leftjoin' undefined in: _639:any :=
algebra.leftjoin(_324:any, _638:any)
TypeException:user.s946_1[474]:'bat.append' undefined in: _641:any :=
bat.append(_640:bat[:oid,:int], _639:any, _637:bit)
TypeException:user.s946_1[475]:'bat.append' undefined in: _642:any :=
bat.append(_641:any, _614:any, _637:bit)
39000!program contains errors
SQLState: null
ErrorCode: 0
Thanks in advance
Freddy
2012/3/6 Stefan Manegold
Hi Freddy,
On Tue, Mar 06, 2012 at 03:03:27PM +0100, Ying Zhang wrote:
Hello Freddy,
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
Which monetdb version are you using ('5' is not the version of the software package)? Can you please send us the output of the command 'mserver5 --version'?
queries. The dataset and queries can be found here[1].
Can you please give us the CREATE TABLE statements? We can not run your queries without creating the tables first.
In addition or as initial alternative, it would be very helpful for us, if you could share the excat error messages with us.
Thanks!
Stefan
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ 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