1) SELECT p.nr, p.label
FROM product p, producttypeproduct ptp
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
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
<Stefan.Manegold@cwi.nl>
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) |