Re: SELECT fails to present result rows depending on the columns to show

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@unixarea.de, http://www.unixarea.de/ +49-176-38902045
> Public GnuPG key: http://www.unixarea.de/key.pub
>