As the error message says,
instead of "chr", the MAL parser expects a valid MAL type.

As opposed to the (wrong) documentation at
https://monetdb.org/Documentation/Manuals/MonetDB/MAL/Types ,
MAL (and all of MonetDB for that matter)
does not support any "chr" (or single-byte single-character) type.

See also (new) bug report #3959:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3959

SQL type "CHAR[ACTER] '(' length ')'" (just like SQL types
"VARCHAR '(' length ')' | CHARACTER VARYING '(' length ')'" and
"TEXT | STRING | CLOB | CHARACTER LARGE OBJECT")
all map to MAL type ":str", which in turn maps to (MonetDB) C type "str",
which in turn is defined as "char *".

Hope this helps.

Stefan

----- On Mar 22, 2016, at 4:50 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:

> I am trying to write a C User Defined Function. It works in Neatbeans. What I
> want is, to take value from cells, insert them in text or char array and
> compare each corresponding array position to each other. As values I will have
> "1"s and "0s". E.g "101010100011". THe code I wrote in udf.c:
>
> /* Comparing bag of words */
>
> char
> BitAnd(char Cell1[], char Cell2[])
> {
> Cell1[10000];
> Cell2[10000];
> int counter;
> float result;
> int strlen = sizeof(Cell1)/sizeof(Cell1[0])-1;
> int i;
> for (i=0; i < strlen; i++) {
> if (Cell1[i] == Cell2[i]) {
> counter++;
> }
> }
>
> result = (float)counter / strlen;
>
>
> }
>
> /* MAL wrapper */
> char
> UDFBitAnd(char Cell1[], char Cell2[])
> {
> /* assert calling sanity */
> assert(Cell1[] != NULL && Cell2[] != NULL);
> return MAL_SUCCEED;
>
> }
>
>
> In udf.mal I have:
>
> command BitAnd(Cell1:chr,Cell2:chr):flt
> address UDFBitAnd
> comment "Compare bag of words";
>
> In 80_udf.sql:
>
> -- Comparing bag of words
> create function BitAnd(Cell1[] char, Cell2[] char)
> returns float external name udf.BitAnd;
>
> I compiled Monetdb, but when I try to connect with "monetdb" to db it gives me
> error. In the log file I found:
>
> MSG voc[18857]: !SyntaxException:parseError:command
> BitAnd(Cell1:chr,Cell2:chr):flt
> MSG voc[18857]: !SyntaxException:parseError: ^Type identifier expected
> MSG voc[18857]: !SyntaxException:parseError:command
> BitAnd(Cell1:chr,Cell2:chr):flt
> MSG voc[18857]: !SyntaxException:parseError: ^',' expected
> MSG merovingian[8780]: database 'voc' (18857) has exited with exit status 0
> MSG merovingian[8780]: database 'voc' has shut down
> ERR merovingian[8780]: client error: database 'voc' started up, but failed to
> open up a communication channel
>
>
>

> _______________________________________________
> 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