- using R version 4.4.1 Patched (2024-08-05 r86980)
- using platform: x86_64-pc-linux-gnu
- R was compiled by
gcc-14 (Debian 14.2.0-3) 14.2.0
GNU Fortran (Debian 14.2.0-3) 14.2.0
- running under: Debian GNU/Linux trixie/sid
- using session charset: UTF-8
- checking for file ‘RPostgreSQL/DESCRIPTION’ ... OK
- this is package ‘RPostgreSQL’ version ‘0.7-6’
- checking package namespace information ... OK
- checking package dependencies ... OK
- checking if this is a source package ... OK
- checking if there is a namespace ... OK
- checking for executable files ... OK
- checking for hidden files and directories ... OK
- checking for portable file names ... OK
- checking for sufficient/correct file permissions ... OK
- checking serialization versions ... OK
- checking whether package ‘RPostgreSQL’ can be installed ... OK
See the install log for details.
- used C compiler: ‘gcc-14 (Debian 14.2.0-3) 14.2.0’
- checking package directory ... OK
- checking for future file timestamps ... OK
- checking DESCRIPTION meta-information ... OK
- checking top-level files ... OK
- checking for left-over files ... OK
- checking index information ... OK
- checking package subdirectories ... OK
- checking code files for non-ASCII characters ... OK
- checking R files for syntax errors ... OK
- checking whether the package can be loaded ... [1s/1s] OK
- checking whether the package can be loaded with stated dependencies ... [0s/1s] OK
- checking whether the package can be unloaded cleanly ... [0s/1s] OK
- checking whether the namespace can be loaded with stated dependencies ... [0s/1s] OK
- checking whether the namespace can be unloaded cleanly ... [1s/1s] OK
- checking loading without being on the library search path ... [1s/1s] OK
- checking whether startup messages can be suppressed ... [1s/1s] OK
- checking use of S3 registration ... OK
- checking dependencies in R code ... OK
- checking S3 generic/method consistency ... OK
- checking replacement functions ... OK
- checking foreign function calls ... OK
- checking R code for possible problems ... [6s/9s] OK
- checking Rd files ... [1s/1s] OK
- checking Rd metadata ... OK
- checking Rd line widths ... OK
- checking Rd cross-references ... OK
- checking for missing documentation entries ... OK
- checking for code/documentation mismatches ... OK
- checking Rd \usage sections ... OK
- checking Rd contents ... OK
- checking for unstated dependencies in examples ... OK
- checking line endings in shell scripts ... OK
- checking line endings in C/C++/Fortran sources/headers ... OK
- checking line endings in Makefiles ... OK
- checking compilation flags in Makevars ... OK
- checking for GNU extensions in Makefiles ... OK
- checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK
- checking use of PKG_*FLAGS in Makefiles ... OK
- checking use of SHLIB_OPENMP_*FLAGS in Makefiles ... OK
- checking include directives in Makefiles ... OK
- checking pragmas in C/C++ headers and code ... OK
- checking compilation flags used ... OK
- checking compiled code ... OK
- checking examples ... [1s/1s] OK
- checking for unstated dependencies in ‘tests’ ... OK
- checking tests ... [6s/9s] OK
Running ‘connectWithNull.R’ [0s/0s]
Comparing ‘connectWithNull.Rout’ to ‘connectWithNull.Rout.save’ ...40a41,42
> <PostgreSQLConnection>
> [1] TRUE
Running ‘createTableMixedCaseTest.R’ [0s/0s]
Comparing ‘createTableMixedCaseTest.Rout’ to ‘createTableMixedCaseTest.Rout.save’ ...86a87,94
> Test should create foo1 and Foo2 tables
> Pass - Foo1 Table does not exist.
> Pass - foo1 Table exists.
> Pass - Foo2 Table exists.
> Pass - foo2 Table does not exist.
> Pass - "Foo2" Table does not exist.
> Pass - "foo2" Table does not exist.
> [1] TRUE
Running ‘dataTypeTests.R’ [0s/0s]
Comparing ‘dataTypeTests.Rout’ to ‘dataTypeTests.Rout.save’ ...115a116,125
> Read Numeric values
> GOOD -- all numeric types are as expected
> GOOD -- all numeric values are as expected
> Read Logical values
> GOOD -- all logical types are as expected
> GOOD -- all logical values are as expected
> Read Character values
> GOOD -- all character types are as expected
> GOOD -- all character values are as expected
> DONE
Running ‘dateTZ.R’ [0s/0s]
Comparing ‘dateTZ.Rout’ to ‘dateTZ.Rout.save’ ...89a90,163
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> testing UTC
>
> **** Trying with timestamp
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
>
>
> **** Trying with timestamp with time zone
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing Asia/Tokyo
>
> **** Trying with timestamp
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
>
>
> **** Trying with timestamp with time zone
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing Australlia/South
>
> **** Trying with timestamp
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
>
>
> **** Trying with timestamp with time zone
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> testing America/New_York
>
> **** Trying with timestamp
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
>
>
> **** Trying with timestamp with time zone
> inserted string 1: 2008-07-01 14:15:16.123+00
> inserted string 2: 2000-01-02 03:04:05.678+00
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> PASS
> PASS
> [1] TRUE
Running ‘datetimeTests.R’ [0s/0s]
Comparing ‘datetimeTests.Rout’ to ‘datetimeTests.Rout.save’ ...67a68,88
>
>
> **** Trying with timestamp
> tt zz
> 1 2008-07-01 14:15:16 1
> 2 2000-01-02 03:04:05 2
> name Sclass type len precision scale nullOK
> 1 tt POSIXct TIMESTAMP 8 -1 -1 TRUE
> [1] "2008-07-01 14:15:16 UTC" "2000-01-02 03:04:05 UTC"
> [1] "POSIXct" "POSIXt"
>
>
> **** Trying with date
> tt zz
> 1 2008-07-01 1
> 2 2000-01-02 2
> name Sclass type len precision scale nullOK
> 1 tt Date DATE 4 -1 -1 TRUE
> [1] "2008-07-01" "2000-01-02"
> [1] "Date"
> [1] TRUE
Running ‘datetimestampwrite.R’ [0s/1s]
Comparing ‘datetimestampwrite.Rout’ to ‘datetimestampwrite.Rout.save’ ...82a83,89
> Read Date and TIMESTAMP values
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> Check that read after write gets the same data types
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> DONE
Running ‘dbColumnInfo.R’ [0s/0s]
Comparing ‘dbColumnInfo.Rout’ to ‘dbColumnInfo.Rout.save’ ...49a50,65
> dbColumnInfo
> name Sclass type len precision scale nullOK
> 1 pk integer INTEGER 4 -1 -1 TRUE
> 2 v1 double FLOAT8 8 -1 -1 FALSE
> 3 v2 double FLOAT8 8 -1 -1 TRUE
> 4 ?column? double FLOAT8 8 -1 -1 NA
> name Sclass type len precision scale nullOK
> 1 pk integer INTEGER 4 -1 -1 TRUE
> 2 v1 double FLOAT8 8 -1 -1 FALSE
> 3 v2 double FLOAT8 8 -1 -1 TRUE
> 4 ?column? double FLOAT8 8 -1 -1 NA
> SELECT result
> pk v1 v2 ?column?
> 1 3 2 NA NA
> Removing "AA"
> [1] TRUE
Running ‘dbExistsIssue.R’ [0s/0s]
Comparing ‘dbExistsIssue.Rout’ to ‘dbExistsIssue.Rout.save’ ...56a57,60
> Does rockdata exist? [1] TRUE
> Does public.rockdata exist? [1] FALSE
> [1] "Removing rockdata\n"
> [1] TRUE
Running ‘dbExistsq.R’ [0s/0s]
Comparing ‘dbExistsq.Rout’ to ‘dbExistsq.Rout.save’ ...57a58,62
> Write rock'data
> Does rock'data exist? [1] TRUE
> Does "public.rock'data" exist? [1] FALSE
> Removing rock'data
> [1] TRUE
Running ‘dbExistsqc.R’ [0s/0s]
Comparing ‘dbExistsqc.Rout’ to ‘dbExistsqc.Rout.save’ ...95a96,108
> Does rock.data exist?
> PASS: true
> create schema testschema and change the search_path
> Does rock.data exist?
> PASS: false as the search_path changed
> Does testschema."rock.data" exist?
> PASS: false as the testschema specified
> Does public."rock.data" exist?
> PASS: true despite search_path change
> write in current schema
> Does rock.data exist?
> PASS: true
> [1] TRUE
Running ‘dbGetQueryParams.R’ [0s/0s]
Comparing ‘dbGetQueryParams.Rout’ to ‘dbGetQueryParams.Rout.save’ ...51a52,70
> row.names area peri shape perm
> 1 6 7979 4010.15 0.167045 17.1
> 2 7 9333 4345.75 0.189651 17.1
> 3 8 8209 4344.75 0.164127 17.1
> 4 11 9364 4480.05 0.150944 119.0
> 5 13 10651 4036.54 0.228595 82.4
> 6 17 10962 4608.66 0.204314 58.6
> 7 18 10743 4787.62 0.262727 58.6
> 8 19 11878 4864.22 0.200071 58.6
> 9 20 9867 4479.41 0.144810 58.6
> 10 22 11876 4353.14 0.291029 142.0
> row.names area peri shape perm
> 1 6 7979 4010.15 0.167045 17.1
> 2 7 9333 4345.75 0.189651 17.1
> 3 8 8209 4344.75 0.164127 17.1
> 4 11 9364 4480.05 0.150944 119.0
> 5 20 9867 4479.41 0.144810 58.6
> [1] "Removing rockdata\n"
> [1] TRUE
Running ‘dbListFields.R’ [0s/0s]
Comparing ‘dbListFields.Rout’ to ‘dbListFields.Rout.save’ ...59a60,65
> [1] "pk" "v1" "v2"
> PASS: 3 fields returned
> [1] "pid" "name"
> PASS: 2 fields returned
> Removing "AA"
> [1] TRUE
Running ‘dbTransactionTests.R’ [0s/0s]
Comparing ‘dbTransactionTests.Rout’ to ‘dbTransactionTests.Rout.save’ ...95a96,109
> begin transaction in con1
> create table rockdata in con1
> PASS rockdata is visible through con1
> PASS rockdata is invisible through con2
> commit in con1
> PASS rockdata is visible through con2
> remove the table from con1
> PASS rockdata is invisible through con2
> begin transaction in con1
> create table rockdata in con1
> PASS rockdata is visible through con1
> RollBack con1
> PASS rockdata is invisible through con1
> [1] TRUE
Running ‘dbWriteTableSchema.R’ [0s/0s]
Comparing ‘dbWriteTableSchema.Rout’ to ‘dbWriteTableSchema.Rout.save’ ...52a53,65
> row.names area peri shape perm
> 1 1 4990 2791.90 0.0903296 6.3
> 2 2 7002 3892.60 0.1486220 6.3
> 3 3 7558 3930.66 0.1833120 6.3
> 4 4 7352 3869.32 0.1170630 6.3
> 5 5 7943 3948.54 0.1224170 17.1
> 6 6 7979 4010.15 0.1670450 17.1
> 7 7 9333 4345.75 0.1896510 17.1
> 8 8 8209 4344.75 0.1641270 17.1
> 9 9 8393 3682.04 0.2036540 119.0
> 10 10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
Running ‘dbWriteTableTest.R’ [0s/0s]
Comparing ‘dbWriteTableTest.Rout’ to ‘dbWriteTableTest.Rout.save’ ...52a53,65
> row.names area peri shape perm
> 1 1 4990 2791.90 0.0903296 6.3
> 2 2 7002 3892.60 0.1486220 6.3
> 3 3 7558 3930.66 0.1833120 6.3
> 4 4 7352 3869.32 0.1170630 6.3
> 5 5 7943 3948.54 0.1224170 17.1
> 6 6 7979 4010.15 0.1670450 17.1
> 7 7 9333 4345.75 0.1896510 17.1
> 8 8 8209 4344.75 0.1641270 17.1
> 9 9 8393 3682.04 0.2036540 119.0
> 10 10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
Running ‘dbWriteTabletypes.R’ [0s/0s]
Comparing ‘dbWriteTabletypes.Rout’ to ‘dbWriteTabletypes.Rout.save’ ...234a235,264
> row.names strings
> 1 1 normal
> 2 2 t\tab
> 3 3 v\vertical tab
> 4 4 n\newline
> 5 5 r carriage \retern
> 6 6 back \\ slash
> 7 7 f\form feed
> [1] "Removing rockdata\n"
> 1 normal
> 2 müß
> [1] "Removing rockdata\n"
> PASS: could write small umlaut u and ligature sz
> 1 normal
> 2 kanji漢字
> [1] "Removing rockdata\n"
> PASS: could write kanji
> Read Numeric values
> PASS -- all integer is as expected
> PASS integer value is preservedGOOD -- all numeric values are as expected
> Read Logical values
> GOOD -- all logical types are as expected
> GOOD -- all logical values are as expected
> Read Character values
> GOOD -- all character types are as expected
> GOOD -- all character values are as expected
> Check that read after write gets the same data types
> PASS -- Date type is as expected
> PASS -- TIMESTAMP is received as POSIXct
> DONE
Running ‘dbtemptable.R’ [0s/0s]
Comparing ‘dbtemptable.Rout’ to ‘dbtemptable.Rout.save’ ...48a49,51
> name
> 1 bar
> PASS -- ended without segmentation fault
Running ‘escape.R’ [0s/0s]
Comparing ‘escape.Rout’ to ‘escape.Rout.save’ ...42a43,45
> [1] "aaa"
> [1] "aa''a"
> [1] TRUE
Running ‘loadDriverAndConnect.R’ [0s/0s]
Comparing ‘loadDriverAndConnect.Rout’ to ‘loadDriverAndConnect.Rout.save’ ...39a40,43
> datname encoding datallowconn
> 1 template0 6 FALSE
> 2 template1 6 TRUE
> [1] TRUE
Running ‘openSendQuery.R’ [0s/0s]
Comparing ‘openSendQuery.Rout’ to ‘openSendQuery.Rout.save’ ...68a69,76
> create temp table tmptest with dbGetQuery
> [1] f1
> <0 rows> (or 0-length row.names)
> create temp table tmptest with dbSendQuery
> [1] f2
> <0 rows> (or 0-length row.names)
> PASS tmptest disappeared after disconnection
> [1] TRUE
Running ‘selectWithAlias.R’ [0s/1s]
Comparing ‘selectWithAlias.Rout’ to ‘selectWithAlias.Rout.save’ ...53a54,66
> ar pe sh pr
> 1 4990 2791.90 0.0903296 6.3
> 2 7002 3892.60 0.1486220 6.3
> 3 7558 3930.66 0.1833120 6.3
> 4 7352 3869.32 0.1170630 6.3
> 5 7943 3948.54 0.1224170 17.1
> 6 7979 4010.15 0.1670450 17.1
> 7 9333 4345.75 0.1896510 17.1
> 8 8209 4344.75 0.1641270 17.1
> 9 8393 3682.04 0.2036540 119.0
> 10 6425 3098.65 0.1623940 119.0
> [1] "Removing rockdata\n"
> [1] TRUE
Running ‘utf.R’ [0s/0s]
Comparing ‘utf.Rout’ to ‘utf.Rout.save’ ...67c67,70
< Skip because envirinmental variables are not set to tell the connection params.
---
> GOOD -- all encoding are as expected
> GOOD -- all encoding are as expected
> GOOD -- all encoding are as expected
> DONE
- checking PDF version of manual ... [6s/8s] OK
- checking HTML version of manual ... [1s/3s] OK
- checking for non-standard things in the check directory ... OK
- DONE
Status: OK