| Subject: | TRIM(FROM) broken in select list |
SQL-Statement/SQL-Parser 1.23 cannot handle the "FROM" word in a TRIM() function in a SELECT clause. Here's an excerpt of the attached demonstration script showing some failures:
SELECT TRIM(BOTH 'x' FROM col) FROM tbl
------------------------------
Can't find alias in FROM clause! at /home/mjp/.perl/5.10/lib/site_perl/5.10.1/SQL/Parser.pm line 2894, <DATA> line 8.
... and so on. See also this discussion forum post: http://stackoverflow.com/questions/1975526/do-sqlstatements-regex-and-trim-work-with-dbdcsv
SELECT TRIM(BOTH 'x' FROM col) FROM tbl
------------------------------
Can't find alias in FROM clause! at /home/mjp/.perl/5.10/lib/site_perl/5.10.1/SQL/Parser.pm line 2894, <DATA> line 8.
... and so on. See also this discussion forum post: http://stackoverflow.com/questions/1975526/do-sqlstatements-regex-and-trim-work-with-dbdcsv
| Subject: | trim-bug.orig |
Message body not shown because it is not plain text.