LIKE fails when new lines are present

[Hydrocharged]

LIKE does not search a string when it contains a new line anywhere in the string. It does not error, but does not return the line even though the text is contained within, when the expected behavior is to return all rows that match.

Attached is a patch that may be applied to the latest as of the time of this issue filing. This adds a new SELECT test for the LIKE issue, along with a new memory table, and changes the relevant tests to also look for the new table.

patch.txt

[erizocosmico]

Thank you for reporting this issue, we'll take a look as soon as we can.

[agarciamontoro]

Thank you for the catch, @Hydrocharged! Could you open a PR with the tests that you provided? The fix for them is already in #817.

[agarciamontoro]

The fix is already merged (see #817), but the tests are not. I'm reopening this so we can track the tests from @Hydrocharged.

[agarciamontoro]

Tests merged in #820.