Horton

Thread

  1. SELECT fails to present result rows depending on the columns to show

    Matthias Apitz <guru@unixarea.de> — 2021-11-23T08:15:06Z

    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

	matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

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

    Ilya Anfimov <ilan@tzirechnoy.com> — 2021-11-23T08:31:21Z

    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
>

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

    shammat@gmx.net — 2021-11-23T09:09:36Z

    Ilya Anfimov schrieb am 23.11.2021 um 09:31:
>> 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.

Ilya refers to the problems decribed here:

https://wiki.postgresql.org/wiki/Locale_data_changes

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

    Matthias Apitz <guru@unixarea.de> — 2021-11-23T12:39:49Z

    El día martes, noviembre 23, 2021 a las 10:09:36 +0100, Thomas Kellerer escribió:

> >  Broken index could. Then this anomaly shoud have gone after reindex table.
> 
> Ilya refers to the problems decribed here:
> 
> https://wiki.postgresql.org/wiki/Locale_data_changes
> 
> 

Thanks for the pointer. What is written there matches with the system
patch by our IT department some days ago to all our SLES 15 servers.

We have to talk and see what we have todo.

    matthias