Hi,

apparently, our SQL parser reconizes literal 123.12 as (fixed-point) decimal (which is stored using int) rather than as floating point.

Try (all of)

SELECT testFn(cast(123.12 as real)); SELECT testFn(cast(123.12 as float)); SELECT testFn(cast(123.12 as double));

Best, Stefan

----- On Aug 19, 2015, at 8:38 AM, Sherzod Mutalov shmutalov@gmail.com wrote:

Hello Developers-list,

I am writing some C function (something like "cast"), and I have problem with proper handling of value type "any".

Say, I have C function:

str testFn(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci) { str* ret = getArgReference_str(stk, pci, 0); ValPtr sourceValue = &stk->stk[pci->argv[1]];

 char tmp[256] = {0};

 sprintf(&tmp[0], "Source value type is \"%s\" (%d)\n",
 getTypeName(sourceValue->vtype), sourceValue->vtype);

 *ret = GDKstrdup(&tmp[0});

 return MAL_SUCCEED;

}

MAL function:

pattern testFn(value:any_1):str address testFn comment "Test function";

Then I added follow code to sql_types.c, where all built-in types and functions gets initialized:

sql_create_func(sa, "testFn", "somemodule", "testFn", ANY, NULL, STR, SCALE_NONE);

When I want to pass "float" number, I get only integer, for example:

SELECT testFn(123.12);

I will get "int" type of ValRecord. And value of passed argument will be "12312" (without dot-delimiter). But, I expecting double or float value.

Please, help to solve this.

Best regards, Sherzod mailto:shmutalov@gmail.com

---

developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list