[MacPorts] #63074: configure: error: "Failed to run sqlite3_libversion_number test program" during `port selfupdate` on linux

[MacPorts]

#63074: configure: error: "Failed to run sqlite3_libversion_number test program"
during `port selfupdate` on linux
--------------------------+----------------------
  Reporter:  arjunsalyan  |      Owner:  jmroot
      Type:  defect       |     Status:  assigned
  Priority:  Normal       |  Milestone:
 Component:  base         |    Version:
Resolution:               |   Keywords:
      Port:               |
--------------------------+----------------------
Changes (by mojca):

 * status:  new => assigned
 * owner:  (none) => jmroot


Comment:

 The problematic command is this one:
 {{{
 cc -o conftest -g -O2 -lsqlite3 conftest.c >&5
 }}}
 which apparently doesn't work. It works for me if I make `-lsqlite3` the
 last argument.

 Basically, the following would work:
 {{{
 cc -o conftest -g -O2 conftest.c -lsqlite3 >&5
 }}}

 The test program is:
 {{{
 #include <stdio.h>
 #include <sqlite3.h>
 int main(int argc, char* argv[])
 {
     int vers = sqlite3_libversion_number();
     if (argc > 1) {
         printf("%d\n", vers);
     }
     return 0;
 }
 }}}

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