[MacPorts] #64588: macports fails to build for ppc with gcc11: cregistry errors

[MacPorts]

#64588: macports fails to build for ppc with gcc11: cregistry errors
---------------------------+------------------------------
  Reporter:  barracuda156  |      Owner:  (none)
      Type:  defect        |     Status:  new
  Priority:  Normal        |  Milestone:
 Component:  base          |    Version:  2.7.1
Resolution:                |   Keywords:  powerpc, leopard
      Port:  macports      |
---------------------------+------------------------------

Comment (by ryandesign):

 Because on some OS/Xcode versions the SQLite version in the header (in the
 SDK) may be newer than the library actually installed on the OS, MacPorts
 checks both the version in the header and the version in the library and
 uses the earlier one. In your case it found an empty version in the
 header, which is surprising:
 {{{
 configure:8214: checking for SQLite version in header
 configure:8239: /opt/svacchanda/gcc11/bin/gcc -arch ppc -E   conftest.c
 configure:8239: $? = 0
 configure:8251: result:
 }}}
 If it had not found the header, or the header did not have
 SQLITE_VERSION_NUMBER in it, then it would have errored, but it appears to
 have found the header, and the header appears to have defined
 SQLITE_VERSION_NUMBER to be empty. MacPorts then checked the library and
 found a sensible version number:
 {{{
 configure:8255: checking for SQLite version at runtime
 configure:8283: /opt/svacchanda/gcc11/bin/gcc -arch ppc -o conftest -g -O2
 -lsqlite3 conftest.c  >&5
 configure:8283: $? = 0
 configure:8283: ./conftest
 configure:8283: $? = 0
 configure:8296: result: 3004000
 }}}
 It then apparently decided that the empty version in the header was
 perhaps equivalent to 0 and therefore earlier than the 3004000 version in
 the library and kept the empty version from the header, which of course
 failed to be a vaild number later.

 Can you check your sqlite3.h file and see what it says about
 SQLITE_VERSION_NUMBER?

-- 
Ticket URL: <https://trac.macports.org/ticket/64588#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS