Modulo / remainder function in ADQL TAP


I might just be getting the syntax wrong but is the modulo (%) operator supported in the RSP ADQL via TAP.

I’m trying a query of the form,

select objectId from dp02_dc2_catalogs.Object where MOD(objectId,10)=0 limit 1000000

as MOD seems to be the ADQL operator but getting errors (I’ve also tried %)

DALQueryError: Query processing error: QI=?: Failed to instantiate query: ParseException:Failed to instantiate query: "SELECT objectId FROM dp02_dc2_catalogs.Object WHERE MOD(objectId,10)=0 LIMIT 1000000"


1 Like

Just to let you know: we are investigating the technical issue and will reply when we can give a more complete answer.

1 Like