Hi, When I download the source code from mercurial and run: 1. bootstrap, configure, make, make install 2. monetdbd start myFarm, mclient demo 3. sql>select 'hello',reverse('hello'); The output is: SELECT: no such unary operator 'reverse(char)' What can be wrong here? I had the original installation from packages, then I apt-get removed them and installed via the make install. Any ideas appreciated. Best regards, Jiri Nadvornik Astronomical Institute AV CR Stellar department Czech Republic mailto:nadvornik.ji@gmail.com nadvornik.ji@gmail.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Did you run this with a pre-existing database? If so, try with a fresh database. The SQL catalog is only initialized when run against a new database. On 31/03/15 16:58, Jiří Nádvorník wrote:
Hi,
When I download the source code from mercurial and run:
1. bootstrap, configure, make, make install
2. monetdbd start myFarm, mclient demo
3. sql>select 'hello',reverse('hello');
The output is:
SELECT: no such unary operator 'reverse(char)'
What can be wrong here? I had the original installation from packages, then I apt-get removed them and installed via the make install.
Any ideas appreciated.
Best regards,
Jiri Nadvornik
Astronomical Institute AV CR
Stellar department
Czech Republic
nadvornik.ji@gmail.com mailto:nadvornik.ji@gmail.com
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQCVAwUBVRq53j7g04AjvIQpAQKRMwP/dvMAqzCAQatkoK/w3i5IpYFDFSUtSVyo spfKrkSTJ/XDwlOt0l8VROSCNCvJG/dRVN1AyZjSDdTsVeMq0qCjc4WzKGmh8XgI G8paLYMJmYbRJjw/IyXwTrlz8n1HpsBbwwGXxugwq7xOzKqYJpJr0NvpkxHKaJcX OpIHbH8cXKw= =8A2w -----END PGP SIGNATURE-----
Hi, if you're logging into another that the "sys" schema, you need to use fully qualified names, i.e., try select "sys"."reverse"('hello'); Stefan ----- Original Message -----
Hi,
When I download the source code from mercurial and run:
1. bootstrap, configure, make, make install
2. monetdbd start myFarm, mclient demo
3. sql>select 'hello',reverse('hello');
The output is:
SELECT: no such unary operator 'reverse(char)'
What can be wrong here? I had the original installation from packages, then I apt-get removed them and installed via the make install.
Any ideas appreciated.
Best regards,
Jiri Nadvornik
Astronomical Institute AV CR
Stellar department
Czech Republic
nadvornik.ji@gmail.com
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Hi Stefan,
select "sys"."reverse"('hello');
Yes this did it, thank you. Cheers, Jiri
-----Original Message----- From: users-list [mailto:users-list- bounces+nadvornik.ji=gmail.com@monetdb.org] On Behalf Of Stefan Manegold Sent: 31. března 2015 17:20 To: Communication channel for MonetDB users Subject: Re: UDF function example
Hi,
if you're logging into another that the "sys" schema, you need to use fully qualified names, i.e., try
select "sys"."reverse"('hello');
Stefan
----- Original Message -----
Hi,
When I download the source code from mercurial and run:
1. bootstrap, configure, make, make install
2. monetdbd start myFarm, mclient demo
3. sql>select 'hello',reverse('hello');
The output is:
SELECT: no such unary operator 'reverse(char)'
What can be wrong here? I had the original installation from packages, then I apt-get removed them and installed via the make install.
Any ideas appreciated.
Best regards,
Jiri Nadvornik
Astronomical Institute AV CR
Stellar department
Czech Republic
nadvornik.ji@gmail.com
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Jiří Nádvorník -
Sjoerd Mullender -
Stefan Manegold