On Tue, Nov 23, 2021 at 09:15:06AM +0100, Matthias Apitz wrote: > > Hello, > > We encounter the following problem in a 13.1 server on Linux: > > sisis=# select desk, feldnr from titel_worte where desk = '2' and feldnr = 257; > desk | feldnr > ------+-------- > 2 | 257 > (1 row) > > > but: > > sisis=# select * from titel_worte where desk = '2' and feldnr = 257; > desknr | feldnr | desk | deskorg | gesanz | aufanz | katkey1 | katkey2 > --------+--------+------+---------+--------+--------+---------+--------- > (0 row) > > sisis=# select desk, feldnr, deskorg from titel_worte where desk = '2' and feldnr = 257; > desk | feldnr | deskorg > ------+--------+--------- > (0 row) > > The table was created as: > > create table titel_worte ( > desknr serial , > feldnr SMALLINT , > desk VARCHAR (245) , > deskorg VARCHAR (245) , > gesanz INTEGER , > aufanz INTEGER , > katkey1 INTEGER , > katkey2 INTEGER > ) > ; > > There are no messages in the serverlog when the SELECT fails to show the > row. > > What could be the reason for this? Thanks Broken index could. Then this anomaly shoud have gone after reindex table. > > matthias > -- > Matthias Apitz, ??? guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 > Public GnuPG key: http://www.unixarea.de/key.pub >
