Skip Menu | will be shut down on March 1st, 2021.

This queue is for tickets about the SQL-KeywordSearch CPAN distribution.

Report information
The Basics
Id: 27536
Status: new
Priority: 0/
Queue: SQL-KeywordSearch

Owner: Nobody in particular
Requestors: MARKSTOS [...]

Bug Information
Severity: Normal
Broken in: 1.11
Fixed in: (no value)

Subject: PostgreSQL special RE characters can cause failure
Download (untitled) / with headers
text/plain 220b
A search with PostgreSQL for terms like: dog ++\; May cause failure. The attached patch fixes it, probably in a PostgreSQL-specific way. If someone can help with a possible fix for MySQL, I'll make a release. Mark
Subject: keyword.patch
Download keyword.patch
text/x-diff 950b
-- old-alphasite/perllib/SQL/ 2007-06-11 16:50:48.000000000 -0400 +++ new-alphasite/perllib/SQL/ 2007-06-11 16:50:48.000000000 -0400 @@ -166,12 +166,14 @@ $word = "(^|[[:<:]])".$word.'([[:>:]]|$)'; } push @sql, "lower($columns[$i]) $p{operator} "; + # This business with '***=' is a PostgreSQL-specific extension + # that makes sure $word gets treated as a string literal, not an RE. if ($p{interp}) { - push @sql, "lower(",\$word,")"; + push @sql, "lower(",\('***='.$word),")"; } else { push @sql, "lower(?)\n"; - push @bind, $word; + push @bind, '***='.$word; } } push @sql, " ".($p{every_column} ? 'AND' : 'OR' )." " if $i != $#columns;

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to