REPLACE( ) is not working in WHERE condition in version 1.7.3

[pradeep-nagarajan]

We are getting below exception for WHERE REPLACE(metaData->field1,"arc","") = "test"

TypeError: (A || "").split is not a function
    at Object.D.REPLACE (webpack-loader.js:2:352024)
    at s.Query.eval [as wherefn] (eval at E.Select.compileWhere (webpack-loader.js:2:316925), <anonymous>:3:1671)
    at Bt (webpack-loader.js:2:290783)
    at Bt (webpack-loader.js:2:291572)
    at c (webpack-loader.js:2:290761)
    at r (webpack-loader.js:2:290608)
    at Object.eval [as datafn] (eval at <anonymous> (webpack-loader.js:2:309928), <anonymous>:3:57)
    at webpack-loader.js:2:306365
    at Array.forEach (<anonymous>)
    at webpack-loader.js:2:306312

[soundarrajan-official]

I am interested to solve this issue, so can you please assign me for this issue ?

[mathiasrw]

Sure. Thank you.

[mathiasrw]

@soundarrajan-official How are things unfolding?

[mathiasrw]

@soundarrajan-official Are you able to make a test that confirmes this?

[ambujsahu81]

Hi @mathiasrw , I wanted to work on this issue but i am failing to create a valid test which can result in the exception mentioned in the issue.

I tried something like this and it worked fine:

var dataArray = [ 
    { id: 1, metaData: {field: "Testarc"} }, 
    { id: 2, metaData: {field: "TestGrc"} }, 
    { id: 3, metaData: {field: "arcTest"} }, 
    { id: 4, metaData: {field: "Test"}},
    { id: 5, metaData: {field: "Tarcest"}},
    { id: 6, metaData: {field: "TarcGest"}},
   ];

console.log(alasql('SELECT id FROM ? WHERE REPLACE(metaData->field, "arc", "") = "Test"', [dataArray]));
// output: [ { id: 1 }, { id: 3 }, { id: 4 }, { id: 5 } ] this is the correct result.

[yugkhokhar]

I would to like to work on this issue

[yugkhokhar]

Sure, I will work on it and give you update about it