- using R Under development (unstable) (2012-02-24 r58481)
- using platform: x86_64-pc-mingw32 (64-bit)
- using session charset: ISO8859-1
- checking for file 'RPostgreSQL/DESCRIPTION' ... OK
- this is package 'RPostgreSQL' version '0.3-2'
- 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 whether package 'RPostgreSQL' can be installed ... OK
- checking installed package size ... OK
- checking package directory ... OK
- checking for portable file names ... OK
- checking DESCRIPTION meta-information ... OK
- checking top-level 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
- loading checks for arch 'i386'
** 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
- loading checks for arch 'x64'
** 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 for unstated 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 ... OK
- checking Rd files ... 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 C/C++/Fortran sources/headers ... OK
- checking line endings in Makefiles ... OK
- checking for portable compilation flags in Makevars ... OK
- checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK
- checking compiled code ... NOTE
File 'd:/Rcompile/CRANpkg/lib/2.15/RPostgreSQL/libs/i386/RPostgreSQL.dll':
Found 'exit', possibly from 'exit' (C), 'stop' (Fortran)
File 'd:/Rcompile/CRANpkg/lib/2.15/RPostgreSQL/libs/x64/RPostgreSQL.dll':
Found 'exit', possibly from 'exit' (C), 'stop' (Fortran)
Compiled code should not call functions which might terminate R nor
write to stdout/stderr instead of to the console. The detected symbols
are linked into the code but might come from libraries and not actually
be called.
See 'Writing portable packages' in the 'Writing R Extensions' manual.
- checking sizes of PDF files under 'inst/doc' ... OK
- checking installed files from 'inst/doc' ... OK
- checking examples ...
** running examples for arch 'i386' ... OK
** running examples for arch 'x64' ... OK
- checking for unstated dependencies in tests ... OK
- checking tests ...
** running tests for arch 'i386' OK
Running 'connectWithNull.R'
Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...41,42d40
< <PostgreSQLConnection:(5548,0)>
< [1] TRUE
Running 'createTableMixedCaseTest.R'
Comparing 'createTableMixedCaseTest.Rout' to 'createTableMixedCaseTest.Rout.save' ...87,94d86
< 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'
Comparing 'dataTypeTests.Rout' to 'dataTypeTests.Rout.save' ...116,125d115
< 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 'datetimeTests.R'
Comparing 'datetimeTests.Rout' to 'datetimeTests.Rout.save' ...66,96d65
<
<
< **** 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 timestamp with time zone
< 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 TIMESTAMPTZOID 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'
Running 'dbColumnInfo.R'
Comparing 'dbColumnInfo.Rout' to 'dbColumnInfo.Rout.save' ...49,59d48
< dbColumnInfo
< name Sclass type len precision scale nullOK
< 1 pk integer INTEGER 4 -1 -1 FALSE
< 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
61,64d49
< > proc.time()
< user system elapsed
< 0.74 0.06 1.07
< HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index »aa_pkey« für Tabelle »aa«
Running 'dbExistsIssue.R'
Comparing 'dbExistsIssue.Rout' to 'dbExistsIssue.Rout.save' ...57,60d56
< Does rockdata exist? [1] TRUE
< Does public.rockdata exist? [1] FALSE
< [1] "Removing rockdata\n"
< [1] TRUE
Running 'dbExistsq.R'
Comparing 'dbExistsq.Rout' to 'dbExistsq.Rout.save' ...58,62d57
< Write rock'data
< Does rock'data exist? [1] TRUE
< Does "public.rock'data" exist? [1] FALSE
< Removing rock'data
< [1] TRUE
Running 'dbExistsqc.R'
Running 'dbListFields.R'
Running 'dbWriteTableFailTest.R'
Running 'dbWriteTableSchema.R'
Running 'dbWriteTableTest.R'
Comparing 'dbWriteTableTest.Rout' to 'dbWriteTableTest.Rout.save' ...53,65d52
< 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'
Running 'dbtemptable.R'
Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ...49,51d48
< name
< 1 bar
< PASS -- ended without segmentation fault
Running 'escape.R'
Comparing 'escape.Rout' to 'escape.Rout.save' ...43,45d42
< [1] "aaa"
< [1] "aa''a"
< [1] TRUE
Running 'loadDriverAndConnect.R'
Comparing 'loadDriverAndConnect.Rout' to 'loadDriverAndConnect.Rout.save' ...40,43d39
< datname encoding datallowconn
< 1 template0 24 FALSE
< 2 template1 24 TRUE
< [1] TRUE
Running 'selectWhereZero.R'
Comparing 'selectWhereZero.Rout' to 'selectWhereZero.Rout.save' ...56,67d55
< Error in postgresqlExecStatement(conn, statement, ...) :
< RS-DBI driver: (could not Retrieve the result : FEHLER: Operator existiert nicht: text = integer
< LINE 1: select * from tmpirisdata where "Species"=0
< ^
< HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
< )
< NULL
< [1] "Removing tmpirisdata\n"
< PASS: reached to the end of the test code without segmentation fault
< Warning message:
< In postgresqlQuickSQL(conn, statement, ...) :
< Could not create executeselect * from tmpirisdata where "Species"=0
Running 'selectWithAlias.R'
Comparing 'selectWithAlias.Rout' to 'selectWithAlias.Rout.save' ...54,66d53
< 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 tests for arch 'x64' OK
Running 'connectWithNull.R'
Comparing 'connectWithNull.Rout' to 'connectWithNull.Rout.save' ...41,42d40
< <PostgreSQLConnection:(4968,0)>
< [1] TRUE
Running 'createTableMixedCaseTest.R'
Comparing 'createTableMixedCaseTest.Rout' to 'createTableMixedCaseTest.Rout.save' ...87,94d86
< 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'
Comparing 'dataTypeTests.Rout' to 'dataTypeTests.Rout.save' ...116,125d115
< 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 'datetimeTests.R'
Comparing 'datetimeTests.Rout' to 'datetimeTests.Rout.save' ...66,96d65
<
<
< **** 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 timestamp with time zone
< 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 TIMESTAMPTZOID 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'
Running 'dbColumnInfo.R'
Comparing 'dbColumnInfo.Rout' to 'dbColumnInfo.Rout.save' ...49,59d48
< dbColumnInfo
< name Sclass type len precision scale nullOK
< 1 pk integer INTEGER 4 -1 -1 FALSE
< 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
61,64d49
< > proc.time()
< user system elapsed
< 0.74 0.14 1.07
< HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index »aa_pkey« für Tabelle »aa«
Running 'dbExistsIssue.R'
Comparing 'dbExistsIssue.Rout' to 'dbExistsIssue.Rout.save' ...57,60d56
< Does rockdata exist? [1] TRUE
< Does public.rockdata exist? [1] FALSE
< [1] "Removing rockdata\n"
< [1] TRUE
Running 'dbExistsq.R'
Comparing 'dbExistsq.Rout' to 'dbExistsq.Rout.save' ...58,62d57
< Write rock'data
< Does rock'data exist? [1] TRUE
< Does "public.rock'data" exist? [1] FALSE
< Removing rock'data
< [1] TRUE
Running 'dbExistsqc.R'
Running 'dbListFields.R'
Running 'dbWriteTableFailTest.R'
Running 'dbWriteTableSchema.R'
Running 'dbWriteTableTest.R'
Comparing 'dbWriteTableTest.Rout' to 'dbWriteTableTest.Rout.save' ...53,65d52
< 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'
Running 'dbtemptable.R'
Comparing 'dbtemptable.Rout' to 'dbtemptable.Rout.save' ...49,51d48
< name
< 1 bar
< PASS -- ended without segmentation fault
Running 'escape.R'
Comparing 'escape.Rout' to 'escape.Rout.save' ...43,45d42
< [1] "aaa"
< [1] "aa''a"
< [1] TRUE
Running 'loadDriverAndConnect.R'
Comparing 'loadDriverAndConnect.Rout' to 'loadDriverAndConnect.Rout.save' ...40,43d39
< datname encoding datallowconn
< 1 template0 24 FALSE
< 2 template1 24 TRUE
< [1] TRUE
Running 'selectWhereZero.R'
Comparing 'selectWhereZero.Rout' to 'selectWhereZero.Rout.save' ...56,67d55
< Error in postgresqlExecStatement(conn, statement, ...) :
< RS-DBI driver: (could not Retrieve the result : FEHLER: Operator existiert nicht: text = integer
< LINE 1: select * from tmpirisdata where "Species"=0
< ^
< HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
< )
< NULL
< [1] "Removing tmpirisdata\n"
< PASS: reached to the end of the test code without segmentation fault
< Warning message:
< In postgresqlQuickSQL(conn, statement, ...) :
< Could not create executeselect * from tmpirisdata where "Species"=0
Running 'selectWithAlias.R'
Comparing 'selectWithAlias.Rout' to 'selectWithAlias.Rout.save' ...54,66d53
< 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
- checking PDF version of manual ... OK
NOTE: There was 1 note.
See
'd:/Rcompile/CRANpkg/local/2.15/RPostgreSQL.Rcheck/00check.log'
for details.