* using log directory 'd:/Rcompile/CRANpkg/local/4.2/RPostgreSQL.Rcheck' * using R version 4.2.3 (2023-03-15 ucrt) * using platform: x86_64-w64-mingw32 (64-bit) * 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 hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'RPostgreSQL' can be installed ... OK * checking installed package size ... OK * checking package directory ... 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 R files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... OK * checking whether the package can be loaded with stated dependencies ... OK * checking whether the package can be unloaded cleanly ... OK * checking whether the namespace can be loaded with stated dependencies ... OK * checking whether the namespace can be unloaded cleanly ... OK * checking loading without being on the library search path ... 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 ... [5s] OK * checking Rd files ... [1s] OK * checking Rd metadata ... 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 include directives in Makefiles ... OK * checking pragmas in C/C++ headers and code ... OK * checking compiled code ... OK * checking examples ... [2s] OK * checking for unstated dependencies in 'tests' ... OK * checking tests ... [12s] OK Running 'connectWithNull.R' [0s] Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...40a41,42 > <PostgreSQLConnection> > [1] TRUE Running 'createTableMixedCaseTest.R' [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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ...48a49,51 > name > 1 bar > PASS -- ended without segmentation fault Running 'escape.R' [0s] Comparing 'escape.Rout' to 'escape.Rout.save' ...42a43,45 > [1] "aaa" > [1] "aa''a" > [1] TRUE Running 'loadDriverAndConnect.R' [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] 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] 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] 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 ... OK * checking HTML version of manual ... OK * DONE Status: OK