On Tue, Mar 06, 2012 at 03:18:03PM +0100, Freddy Priyatna wrote:
> 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 <
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) |
> >
> >
> > ------------------------------------------------------------------------------
> > 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
--
| 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