Error matching in javascript target is wrong

[surister]

const query =
    `SELECT A
     FROM tbl1
     where;

    SELECT 1;

    SELECT B
    FROM tbl1
    WHERE;`
const stmt = sqlparse(query)

console.log(stmt[0].exception)

Results to null while it should be an exception.

This only happens in JS target, not python.

[surister]

This happens because the findSuitableError implementation differs from the python one, we use a different trim.

cratedb-sqlparse/cratedb_sqlparse_js/cratedb_sqlparse/parser.js

Line 188 in 58765b9

function trim(string) {

Note: It should not differ, which can sometimes be challenging since they are different programming languages.