[MonetDB-users] !ERROR: err:FORG0001

newer
[MonetDB-users] cvs version (0.23)...

older
[MonetDB-users] urlbox in MonetDB5

Jorge Martín Cuervo

7 Apr 2008 7 Apr '08

8:41 a.m.

Hi all, i have some error messages from mclient when i try to run an xquery. First i've got: ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double' and i removed the return type from function, and later i've got: ERROR = !ERROR: err:FORG0001: could not cast value from string to double. is there any way to know where is the error (like the before message)? thanks. -- ;-) ____________________________________ Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

Show replies by date

Jan Rittinger

7 Apr 7 Apr

9:11 a.m.

Hi Jorge, your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore. Regards, Jan P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]'). On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...

Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

-- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

Jorge Martín Cuervo

9:27 a.m.

Thanks Jan, but can a active some debug info or similar to print the stack trace when a runtime error is triggered? i think it could be very usefull. ;) thanks again. El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...

Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

-- ;-) ____________________________________ Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

Jan Rittinger

9:36 a.m.

Hi Jorge, we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you. I would have suggested you a function like the following declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () }; but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption). The other solution would be to look into the data and find a better filter based on path step predicates. Jan On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...

Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...
Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

-- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

Jorge Martín Cuervo

9:46 a.m.

Thanks Jan, I'll try to rewrite some parts of the xquery as you said. best regards. El lun, 07-04-2008 a las 11:36 +0200, Jan Rittinger escribió:

...

Hi Jorge,

we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you.

I would have suggested you a function like the following

declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () };

but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption).

The other solution would be to look into the data and find a better filter based on path step predicates.

Jan

On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...
Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

Jan Rittinger

11:14 a.m.

Hi Jorge, I just extended the implementation of fn:number to cope with NaN values in equality predicates. In case you have trouble avoiding the restriction you can try out the CVS head version (-- the nightly build will be available tomorrow). To make use of my changes you have to activate the (not yet standard) algebra code generation (using '\G' in your mclient). Jan On 04/07/2008 11:46 AM, Jorge Martín Cuervo wrote with possible deletions:

...

Thanks Jan,

I'll try to rewrite some parts of the xquery as you said.

best regards.

El lun, 07-04-2008 a las 11:36 +0200, Jan Rittinger escribió:

...
Hi Jorge,

we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you.

I would have suggested you a function like the following

declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () };

but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption).

The other solution would be to look into the data and find a better filter based on path step predicates.

Jan

On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...
Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

-- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

Jorge Martín Cuervo

8 Apr 8 Apr

8:32 a.m.

Hi Jan, I made a checkout of the cvs modules and after compile buildtools successfully and when i tried to compile MonetDB: [jmartin@outsourcing1 MonetDB]$ ./bootstrap automake 1.9.6 is 1.7 or newer. Good. autoconf 2.59 is 2.57 or newer. Good. libtool 1.5.22 is 1.4 or newer. Good. Python 2.4.3 is 2.0.0 or newer. Good. Traceback (most recent call last): File "/home/jmartin/monetdbcvs/bin/autogen.py", line 29, in ? from autogen import am ImportError: No module named autogen please help. El lun, 07-04-2008 a las 13:14 +0200, Jan Rittinger escribió:

...

Hi Jorge,

I just extended the implementation of fn:number to cope with NaN values in equality predicates.

In case you have trouble avoiding the restriction you can try out the CVS head version (-- the nightly build will be available tomorrow). To make use of my changes you have to activate the (not yet standard) algebra code generation (using '\G' in your mclient).

Jan

On 04/07/2008 11:46 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

I'll try to rewrite some parts of the xquery as you said.

best regards.

El lun, 07-04-2008 a las 11:36 +0200, Jan Rittinger escribió:

...
Hi Jorge,

we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you.

I would have suggested you a function like the following

declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () };

but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption).

The other solution would be to look into the data and find a better filter based on path step predicates.

Jan

On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...
Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi</a>'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

Ying Zhang

9:35 a.m.

Hello Jorge, You need to set your PYTHONPATH environment variable. Please have a look at the explanation in $SRCDIR/buildtools/autogen/ README Regards, Jennie On Apr 08, 2008, at 10:32 , Jorge Martín Cuervo wrote:

...

Hi Jan,

I made a checkout of the cvs modules and after compile buildtools successfully and when i tried to compile MonetDB:

[jmartin@outsourcing1 MonetDB]$ ./bootstrap automake 1.9.6 is 1.7 or newer. Good. autoconf 2.59 is 2.57 or newer. Good. libtool 1.5.22 is 1.4 or newer. Good. Python 2.4.3 is 2.0.0 or newer. Good. Traceback (most recent call last): File "/home/jmartin/monetdbcvs/bin/autogen.py", line 29, in ? from autogen import am ImportError: No module named autogen

please help.

El lun, 07-04-2008 a las 13:14 +0200, Jan Rittinger escribió:

...
Hi Jorge,

I just extended the implementation of fn:number to cope with NaN values in equality predicates.

In case you have trouble avoiding the restriction you can try out the CVS head version (-- the nightly build will be available tomorrow). To make use of my changes you have to activate the (not yet standard) algebra code generation (using '\G' in your mclient).

Jan

On 04/07/2008 11:46 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

I'll try to rewrite some parts of the xquery as you said.

best regards.

El lun, 07-04-2008 a las 11:36 +0200, Jan Rittinger escribió:

...
Hi Jorge,

we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you.

I would have suggested you a function like the following

declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () };

but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption).

The other solution would be to look into the data and find a better filter based on path step predicates.

Jan

On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió:

...
Hi Jorge,

your first error triggers a compile-time error. Here we know where the error appears. The second error on the other side is a runtime error (a cast failing because some strings cannot be converted to double) where we have no query information anymore.

Regards, Jan

P.S.: My best guess is that your query has a predicate with a comparison between a number and the result of a path step (like e.g., '/a/[b>3.14]') where not all resulting nodes can be cast to double (as e.g., in the following XML fragment '<a>42pi'). In this situations you might add calls to the built-in function fn:number() to modify the casting behavior (e.g., '/a/[number(b)>3.14]').

On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible deletions: > Hi all, i have some error messages from mclient when i try to > run an > xquery. > > First i've got: > > ERROR = !type error: body of hr:fw() evaluates to `double | > integer' > which is not a subtype of `xs:double' > > and i removed the return type from function, and later i've got: > > ERROR = !ERROR: err:FORG0001: could not cast value from string > to > double. > > > is there any way to know where is the error (like the before > message)? > > > thanks. >

-- ;-) ____________________________________ Jorge Martin Cuervo

Outsourcing Emarketplace deFacto Powered by Standards

email voice +34 985 129 820 voice +34 660 026 384 ____________________________________

DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación.

This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Jorge Martín Cuervo

10:01 a.m.

Thanks but i've found this script: http://monetdb.cwi.nl/projects/monetdb//download.php?target=/projects/monetd... i run with --cvs param and seems to go well, still compiling now. is this correct? or i've to continue with the "manual" process? El mar, 08-04-2008 a las 11:35 +0200, Ying Zhang escribió:

...

Hello Jorge,

You need to set your PYTHONPATH environment variable. Please have a look at the explanation in $SRCDIR/buildtools/autogen/ README

Regards,

Jennie

On Apr 08, 2008, at 10:32 , Jorge Martín Cuervo wrote:

...
Hi Jan,

I made a checkout of the cvs modules and after compile buildtools successfully and when i tried to compile MonetDB:

[jmartin@outsourcing1 MonetDB]$ ./bootstrap automake 1.9.6 is 1.7 or newer. Good. autoconf 2.59 is 2.57 or newer. Good. libtool 1.5.22 is 1.4 or newer. Good. Python 2.4.3 is 2.0.0 or newer. Good. Traceback (most recent call last): File "/home/jmartin/monetdbcvs/bin/autogen.py", line 29, in ? from autogen import am ImportError: No module named autogen

please help.

El lun, 07-04-2008 a las 13:14 +0200, Jan Rittinger escribió:

...
Hi Jorge,

I just extended the implementation of fn:number to cope with NaN values in equality predicates.

In case you have trouble avoiding the restriction you can try out the CVS head version (-- the nightly build will be available tomorrow). To make use of my changes you have to activate the (not yet standard) algebra code generation (using '\G' in your mclient).

Jan

On 04/07/2008 11:46 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

I'll try to rewrite some parts of the xquery as you said.

best regards.

El lun, 07-04-2008 a las 11:36 +0200, Jan Rittinger escribió:

...
Hi Jorge,

we compile XQuery into relational algebra and afterwards into the MonetDB specific language MIL. The query plan (our correspondent for a stack trace) thus will not help you.

I would have suggested you a function like the following

declare function mynumber ($foo as xs:string*) as xs:double* { for $a in $foo return if ($a castable as xs:double) then number($a) else () };

but I just detected (to my astonishment) that we do not support the castable concept yet. The only solution I thus see is a filter that looks for strings starting with digits instead of checking for castable. (This is admittedly a very ugly adaption).

The other solution would be to look into the data and find a better filter based on path step predicates.

Jan

On 04/07/2008 11:27 AM, Jorge Martín Cuervo wrote with possible deletions:

...
Thanks Jan,

but can a active some debug info or similar to print the stack trace when a runtime error is triggered?

i think it could be very usefull. ;)

thanks again.

El lun, 07-04-2008 a las 11:11 +0200, Jan Rittinger escribió: > Hi Jorge, > > your first error triggers a compile-time error. Here we know > where the > error appears. The second error on the other side is a runtime > error (a > cast failing because some strings cannot be converted to > double) where > we have no query information anymore. > > Regards, > Jan > > P.S.: My best guess is that your query has a predicate with a > comparison > between a number and the result of a path step (like e.g., > '/a/[b>3.14]') where not all resulting nodes can be cast to > double (as > e.g., in the following XML fragment '<a>42pi a>'). In > this situations you might add calls to the built-in function > fn:number() > to modify the casting behavior (e.g., '/a/[number(b)>3.14]'). > > > On 04/07/2008 10:41 AM, Jorge Martín Cuervo wrote with possible > deletions: >> Hi all, i have some error messages from mclient when i try to >> run an >> xquery. >> >> First i've got: >> >> ERROR = !type error: body of hr:fw() evaluates to `double | >> integer' >> which is not a subtype of `xs:double' >> >> and i removed the return type from function, and later i've got: >> >> ERROR = !ERROR: err:FORG0001: could not cast value from string >> to >> double. >> >> >> is there any way to know where is the error (like the before >> message)? >> >> >> thanks. >>

-- ;-) ____________________________________ Jorge Martin Cuervo

Outsourcing Emarketplace deFacto Powered by Standards

email voice +34 985 129 820 voice +34 660 026 384 ____________________________________

DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación.

This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users -- ;-)

Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

Fabian Groffen

10:47 a.m.

On 08-04-2008 12:01:07 +0200, Jorge Martín Cuervo wrote:

...

Thanks but i've found this script:

http://monetdb.cwi.nl/projects/monetdb//download.php?target=/projects/monetd...

i run with --cvs param and seems to go well, still compiling now.

is this correct? or i've to continue with the "manual" process?

The script should do all the magic for you that you need to just prepare the sources to compile them. End result is a compiled binary.

Jorge Martín Cuervo

11:04 a.m.

This scripts works great! Now i have: [jmartin@outsourcing1 bin]$ ./Mserver --dbinit="module(pathfinder);" !WARNING: GDKlockHome: created directory /home/jmartin/monetdbcvs2/var/MonetDB4/dbfarm/demo/ !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB Server v4.23.0 # based on GDK v1.23.0 # Copyright (c) 1993-2008, CWI. All rights reserved. # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.23.0 loaded # XRPC administrative console at http://127.0.0.1:50001/admin MonetDB> Thanks. Now i'm trying to connect to database from java, is XRPC the way do achieve this? El mar, 08-04-2008 a las 12:47 +0200, Fabian Groffen escribió:

...

On 08-04-2008 12:01:07 +0200, Jorge Martín Cuervo wrote:

...
Thanks but i've found this script:

http://monetdb.cwi.nl/projects/monetdb//download.php?target=/projects/monetd...

i run with --cvs param and seems to go well, still compiling now.

is this correct? or i've to continue with the "manual" process?

The script should do all the magic for you that you need to just prepare the sources to compile them. End result is a compiled binary.

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users -- ;-)

Ying Zhang

11:35 a.m.

On Apr 08, 2008, at 13:04 , Jorge Martín Cuervo wrote:

...

This scripts works great!

Now i have:

[jmartin@outsourcing1 bin]$ ./Mserver --dbinit="module(pathfinder);" !WARNING: GDKlockHome: created directory /home/jmartin/monetdbcvs2/var/MonetDB4/dbfarm/demo/ !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB Server v4.23.0 # based on GDK v1.23.0 # Copyright (c) 1993-2008, CWI. All rights reserved. # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.23.0 loaded # XRPC administrative console at http://127.0.0.1:50001/admin MonetDB>

Thanks.

Now i'm trying to connect to database from java, is XRPC the way do achieve this?

You can use XRPC to exeucte functions on a remote monetdb/xquery database server. In java, you need to build correct xrpc request message. There is java api to help you build messages, please have a look at here: http://monetdb.cwi.nl/projects/monetdb/XQuery/Documentation/Using-XRPC-from-... A quick introduction of xrpc can be found here: http://monetdb.cwi.nl/projects/monetdb/XQuery/QuickTour/XRPC/index.html To build xrpc request messages and handle response messages, you need to know the massage format, which can be found here: http://monetdb.cwi.nl/projects/monetdb/XQuery/Documentation/XRPC-Extension.h... Regards, Jennie

...

El mar, 08-04-2008 a las 12:47 +0200, Fabian Groffen escribió:

...
On 08-04-2008 12:01:07 +0200, Jorge Martín Cuervo wrote:

...
Thanks but i've found this script:

http://monetdb.cwi.nl/projects/monetdb//download.php?target=/projects/monetd...

i run with --cvs param and seems to go well, still compiling now.

is this correct? or i've to continue with the "manual" process?

The script should do all the magic for you that you need to just prepare the sources to compile them. End result is a compiled binary.

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users -- ;-)

Jorge Martin Cuervo

Outsourcing Emarketplace deFacto Powered by Standards

email voice +34 985 129 820 voice +34 660 026 384 ____________________________________

DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación.

This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Jorge Martín Cuervo

7 Apr 7 Apr

9:16 a.m.

Hi again, now i get: ERROR = !ERROR: We do not support the value NaN. Timer 10399.459 msec and now? what should i do? El lun, 07-04-2008 a las 10:41 +0200, Jorge Martín Cuervo escribió:

...

Hi all, i have some error messages from mclient when i try to run an xquery.

First i've got:

ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double'

and i removed the return type from function, and later i've got:

ERROR = !ERROR: err:FORG0001: could not cast value from string to double.

is there any way to know where is the error (like the before message)?

thanks.

-- ;-) ____________________________________ Jorge Martin Cuervo

Outsourcing Emarketplace deFacto Powered by Standards

email voice +34 985 129 820 voice +34 660 026 384 ____________________________________

DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info@defactops.com). También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación.

This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users -- ;-)

6166

Age (days ago)

6167

Last active (days ago)

List overview

Download

12 comments

4 participants

participants (4)

Fabian Groffen
Jan Rittinger
Jorge Martín Cuervo
Ying Zhang