like-operator on index-scan

From: Andreas Degert <ad(at)papyrus-gmbh(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: like-operator on index-scan
Date: 2000-09-13 08:36:54
Message-ID: 87snr47knt.fsf@tarzan.noname
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I'd like to know if anyone can reproduce a strange error in V7.02
(debian i386). It happens when an index-scan is done in an index with
more than 80 entries, using a like-match, where the %-wildcard
directly follows a '/'. A simple example (which creates a database
testdb) is appended. In my installation the first count is 99, the
second 0.

ciao
Andreas

#! /bin/sh
set -e
psql <<.
\set ON_ERROR_STOP 1
create database testdb;
\c testdb
create table test (a text);
.
i=1
while test $i -lt 100; do
echo "insert into test values('/a');"
i=`expr $i + 1`
done | psql -d testdb
psql -d testdb <<.
select count(*) from test where a like '/%';
create index test1 on test(a);
select count(*) from test where a like '/%';
\c template1
drop database testdb;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Degert 2000-09-13 08:44:46 null in constraints
Previous Message Zeugswetter Andreas SB 2000-09-13 08:24:01 AW: Status of new relation file naming