databases/R-cran-RSQLite: Update to 2.3.6

While I'm here,

- remove conditionals regarding llvm16 build fix as port build fine
  without it.
- add test target

ChangeLog: https://cran.r-project.org/web/packages/RSQLite/news/news.html

Differential Revision:	https://reviews.freebsd.org/D44592

*/*: Fix build with llvm16 on 13.2-STABLE

As like as HEAD(14.0-RELEASE) llvm16 was merged in base for 13.2-STABLE
with the OSVERSION 1302507.

- Utilize USE_CXXSTD=c++14 or similar solution where applicable
- Update conditionals to addtionally check for OSVERSION greater than
  1302507 and less than 1400000

Approved by:	portmgr (blanket)
Sponsored by:	The FreeBSD Foundation

databases/R-cran-RSQLite: Fix build with llvm16

Approved by:	portmgr (blanket)
Sponsored by:	The FreeBSD Foundation

*: Bump PORTREVISIONs for math/mpc update to 1.3.1

databases/R-cran-RSQLite: update to 2.2.19

Changes:
  * Upgrade bundled SQLite to 3.40.0
  * Add missing boost headers for icpc compiler

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

databases/R-cran-RSQLite: update to version 2.2.14

Changes:
  * Upgrade bundled SQLite to version 3.38.5

Remove # $FreeBSD$ from Makefiles.

math/R: Update to version 4.0.0

Upstream changes:
https://stat.ethz.ch/pipermail/r-announce/2020/000653.html

Also bump PORTREVISION of ports that depend on math/R.

Submitted by:	wen (in part)
Reviewed by:	jwb, Rainer Hurling <rhurlin@gwdg.de>, thierry
Differential Revision:	https://reviews.freebsd.org/D24572

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

Bump PORTREVISIONs of all users of math/mpc that we just updated to
version 1.1.0 (via revision 464079).

qa: add check for NO_ARCH

If NO_ARCH is set then check that no FreeBSD elf(5) files are in $STAGEDIR.
If an elf(5) file is bundles as part of the package, but is not meant to be
run directly (i.e. the elf(5) file is a payload, and not compiled) then
those files can be added to NO_ARCH_IGNORE to avoid the check from failing,

Changes to ports:
 - Ports that have NO_ARCH set, but actually compile files have had NO_ARCH
   removed.
 - Ports that have elf(5) payloads have had those files added to
   NO_ARCH_IGNORE.
 - R-cran ports that do not set USES=cran:compiles have NO_ARCH set,

PR:		218976
Reviewed by:	antoine, mat
Approved by:	portmgr

- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

Update to 1.0.0

databases/R-cran-RSQLite: update 0.11.2 -> 0.11.4

- Fix RUN_DEPENDS variable assignment
- Pet portlint
- Maintainer's timeout

PR:		190803
Submitted by:	Bartek Rutkowski <robak@FreeBSD.org>
Approved by:	mentors (implicit)

Update the default version of GCC in the Ports Collection from GCC 4.7.4
to GCC 4.8.3.

Part II, Bump PORTREVISIONs.

PR:		192025
Tested by:	antoine (-exp runs)
Approved by:	portmgr (implicit)

Update the default version of GCC used in the Ports Collection from
GCC 4.6.4 to GCC 4.7.3.  This entails updating the lang/gcc port as
well as changing the default in Mk/bsd.default-versions.mk.

Part II, Bump PORTREVISIONs.

PR:		182136
Supported by:	Christoph Moench-Tegeder <cmt@burggraben.net> (fixing many ports)
Tested by:	bdrewery (two -exp runs)

Convert Mk/bsd.cran.mk to the Uses framework.

PR:		ports/184699
Reviewed by:	bapt
Approved by:	portmgr (bdrewery), wen (maintainer, timeout > 2 weeks)

Add stage support to Mk/bsd.cran.mk and all USE_R_MOD ports (aka R-cran-*).

Since this patch converts all affected ports, bsd.cran.mk no longer supports
NO_STAGE and errors out if NO_STAGE is set.

Exp-run:	ports/184216
Reviewed by:	bdrewery
Approved by:	portsmgr, wen

Update math/R to 3.0.2 patched r64207 and math/R-cran-SuppDists to 1.1-9.1;
adjust dependent ports

Reviewed by:	pfg, thierry, tota

Update to libmpc version 1.0.1 which brings the following fixes:

 - Switched to automake 1.11.6, see CVE-2012-3386.
 - #14669: Fixed extraction of CC from gmp.h.
 - Fixed case of intermediate zero real or imaginary part in mpc_fma,
   found by hydra with GMP_CHECK_RANDOMIZE=1346362345.

This is on top of the following changes from version 1.0

 - Licence change towards LGPLv3+ for the code and GFDLv1.3+ (with no
   invariant sections) for the documentation.
 - 100% of all lines are covered by tests
 - Renamed functions
   . mpc_mul_2exp to mpc_mul_2ui
   . mpc_div_2exp to mpc_div_2ui

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

Update math/R to 3.0.1-patched, and adjust dependent ports;
synchronize math/rpy with upstream repository

Reviewed by:	wen
Approved by:	wen, tota

update math/R to 2.15.3, and adjust dependent ports

update the R base ports to 2.15.2 and adjust dependent ports

Reviewed by:	thierry, tota, wen

Update to 0.11.2

Database Interface R driver for SQLite. This package embeds the SQLite database
engine in R and provides an interface compliant with the DBI package.

WWW:	http://cran.r-project.org/web/packages/RSQLite/