From @ndre_m|ku|ec @end|ng |rom hotm@||@com  Sun Jan  8 06:12:33 2023
From: @ndre_m|ku|ec @end|ng |rom hotm@||@com (Andre Mikulec)
Date: Sun, 8 Jan 2023 05:12:33 +0000
Subject: [Rd] Looking for R for Windows (rversion: 4.2.2) in
 base/old/%rversion%/R-%rversion%-win.exe
Message-ID: <SA1PR14MB464299BE2DB514FB72367D069CF99@SA1PR14MB4642.namprd14.prod.outlook.com>

Peter Dalgaard, R-devel team, et al.,

Hi, my name is Andre Mikulec.

I am an `common` committer to Postgres PL/R . . .
https://github.com/postgres-plr/plr/commits?author=AndreMikulec

https://github.com/postgres-plr/plr
`PL/R - PostgreSQL support for R as a procedural language (PL)`

However, now and different from the past,
the `windows/base/old` R 4.2.2 download location URL link now, redirects to the wrong `R 4.2.1` location.

Historically,
Previous and Current(still called `old`) Windows versions of R
have been stored here (below) and the current(old) version of R would have been 4.2.2. and would have pointed to R 4.2.2.

https://cran.r-project.org/bin/windows/base/old/

```
In this directory (and its URL redirect (->)):
R 4.2.2 (October, 2022) -> https://cran.r-project.org/bin/windows/base/old/4.2.1 (NEED 4.2.2)
R 4.2.1 (June, 2022) -> https://cran.r-project.org/bin/windows/base/old/4.2.1/
```

So, something has changed `R 4.2.2 (October, 2022)` now redirects to `base/old/4.2.1`.

Now and in the past, Appveyor builds of PL/R rely a specific version of R in an exact location:

https://github.com/postgres-plr/plr/blob/4ac054e61c62f72a9cd3a38f66476d037b3e27a5/appveyor.yml#L25
```
 - pg: REL_15_0
    PlatformToolset: v141
    configuration: Release
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017
    rversion: 4.2.1
```

Notice (above and) below the variable `rversion: 4.2.1`
and the hard coded location `base/old/%rversion%/R-%rversion%-win.exe`.

https://github.com/postgres-plr/plr/blob/4ac054e61c62f72a9cd3a38f66476d037b3e27a5/appveyor.yml#L108
```
- if not exist R-%rversion%-win.exe appveyor downloadfile https://cran.r-project.org/bin/windows/base/old/%rversion%/R-%rversion%-win.exe
```

E.g. the most recent PL/R build (a month ago) using R 4.2.1
`PL/R - PostgreSQL support for R as a procedural language (PL)` build:

https://ci.appveyor.com/project/davecramer/plr-daun5/build/job/7lqs9pkgartjhxwt?fullLog=true#L15
```
Cache 'R-4.2.1-win.exe' - Restored
Running Install scripts
if not exist R-%rversion%-win.exe appveyor downloadfile https://cran.r-project.org/bin/windows/base/old/%rversion%/R-%rversion%-win.exe
R-%rversion%-win.exe /VERYSILENT
```

Now, where may One find a `specific version of R in an exact location`?

Please help.

Thanks,
Andre Mikulec


	[[alternative HTML version deleted]]



[Rd] Looking for R for Windows (rversion: 4.2.2) in base/old/%rversion%/R-%rversion%-win.exe
Andre Mikulec