Dear Adrian,
Thanks for your reply.
>Did you run ANALYZE on the 12.5 server after restoring the data to it?
No, I did not run ANALYZE on the 12.5 server after restoring the data.
When I change the select clause like this ( crew_base.crewid → count(*) ), I can retrieve the number of data rows.
Please refer to my previous reply for more information.
At 2022-08-18 12:18:31, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:
>On 8/17/22 20:01, gzh wrote:
>> Hi,
>>
>>
>> I have had a Perl Website working for 7 years and have had no problems
>>
>> until a few weeks ago I replaced my database server with a newer one.
>
>Did you run ANALYZE on the 12.5 server after restoring the data to it?
>
>
>>
>> gzh
>>
>>
>
>
>--
>Adrian Klaver
>adrian.klaver@aklaver.com