If I would like to use casting in a form of:

round(msp.plat::numeric,1)

Then getting errors. It's replacing or tries to replace ":numeric" with something else.

Comments

metzlerd’s picture

metzlerd commented

Yep, I need to refactor the replacement REGX to fix this.

In the meantime you know you can get around this with the ANSII SQL syntax?:

round(CAST(msp.plat as numeric),1)

janeks’s picture

janeks commented

Of course :)

metzlerd’s picture

metzlerd commented
Version: 7.x-1.1 » 7.x-3.1
Status: Active » Fixed

This has been fixed in the dev snapshot and will be in the 7.x-3.2 and later releases. The regular expression replacement at the top of Frx.inc is as follows: 

define('FRX_SQL_TOKEN', '/(?<!:):[a-zA-Z]([a-zA-Z]|[0-9]|[_\.])+/');

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.