<pre style='margin:0'>
Clemens Lang (neverpanic) pushed a commit to branch master
in repository macports-www.
</pre>
<p><a href="https://github.com/macports/macports-www/commit/dfcfe616afb9ad3b185ffa51cd910ec5463cb3dd">https://github.com/macports/macports-www/commit/dfcfe616afb9ad3b185ffa51cd910ec5463cb3dd</a></p>
<pre style="white-space: pre; background: #F8F8F8"><span style='display:block; white-space:pre;color:#808000;'>commit dfcfe616afb9ad3b185ffa51cd910ec5463cb3dd
</span>Author: Clemens Lang <cal@macports.org>
AuthorDate: Sun Feb 12 15:44:58 2017 +0100
<span style='display:block; white-space:pre;color:#404040;'> portlist: Search case-insensitive
</span><span style='display:block; white-space:pre;color:#404040;'>
</span><span style='display:block; white-space:pre;color:#404040;'> When switching to PostgreSQL, all searches seem to have become
</span><span style='display:block; white-space:pre;color:#404040;'> case-sensitive by default. Since this is not what we want, use ILIKE
</span><span style='display:block; white-space:pre;color:#404040;'> wherever we compare search strings.
</span><span style='display:block; white-space:pre;color:#404040;'>
</span><span style='display:block; white-space:pre;color:#404040;'> Closes: https://trac.macports.org/ticket/53552
</span>---
ports.php | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
<span style='display:block; white-space:pre;color:#808080;'>diff --git a/ports.php b/ports.php
</span><span style='display:block; white-space:pre;color:#808080;'>index a8b58d6..e651807 100644
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>--- a/ports.php
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>+++ b/ports.php
</span><span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -92,28 +92,28 @@
</span> switch ($by) {
case 'name':
#TODO: was pg_escape_string. Current charset taken into account ?
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "p.name LIKE '%" . pg_escape_string($substr) . "%'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "p.name ILIKE '%" . pg_escape_string($substr) . "%'";
</span> break;
case 'category':
$tables .= ", categories AS c";
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "c.portfile = p.name AND c.category = '" . pg_escape_string($substr) . "'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "c.portfile = p.name AND c.category ILIKE '" . pg_escape_string($substr) . "'";
</span> break;
case 'maintainer':
$tables .= ", maintainers AS m";
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "m.portfile = p.name AND m.maintainer LIKE '%" . pg_escape_string($substr) . "%'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "m.portfile = p.name AND m.maintainer ILIKE '%" . pg_escape_string($substr) . "%'";
</span> break;
case 'variant':
$tables .= ", variants AS v";
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "v.portfile = p.name AND v.variant = '" . pg_escape_string($substr) . "'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "v.portfile = p.name AND v.variant ILIKE '" . pg_escape_string($substr) . "'";
</span> break;
case 'platform':
$tables .= ", platforms AS pl";
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "pl.portfile = p.name AND pl.platform = '" . pg_escape_string($substr) . "'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "pl.portfile = p.name AND pl.platform ILIKE '" . pg_escape_string($substr) . "'";
</span> break;
/*
case 'license':
$tables .= ", $portsdb_name.licenses AS lc";
<span style='display:block; white-space:pre;background:#ffe0e0;'>- $criteria = "lc.portfile = p.name AND lc.license = '" . pg_escape_string($substr) . "'";
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ $criteria = "lc.portfile = p.name AND lc.license ILIKE '" . pg_escape_string($substr) . "'";
</span> break;
*/
case 'all':
</pre><pre style='margin:0'>
</pre>