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@xxxxxxxxxxx> 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@xxxxxxxxxxx
