Last updated on 2024-09-30 07:50:41 CEST.
| Package | NOTE | OK |
|---|---|---|
| RPostgreSQL | 5 | 8 |
Current CRAN status: NOTE: 5, OK: 8
Version: 0.7-6
Check: tests
Result: NOTE
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/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/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/1s]
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/1s]
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/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/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
Flavor: r-devel-linux-x86_64-debian-clang
Version: 0.7-6
Check: tests
Result: NOTE
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/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/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/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/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
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 0.7-6
Check: tests
Result: NOTE
Running ‘connectWithNull.R’
Comparing ‘connectWithNull.Rout’ to ‘connectWithNull.Rout.save’ ...40a41,42
> <PostgreSQLConnection>
> [1] TRUE
Running ‘createTableMixedCaseTest.R’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
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’
Comparing ‘dbtemptable.Rout’ to ‘dbtemptable.Rout.save’ ...48a49,51
> name
> 1 bar
> PASS -- ended without segmentation fault
Running ‘escape.R’
Comparing ‘escape.Rout’ to ‘escape.Rout.save’ ...42a43,45
> [1] "aaa"
> [1] "aa''a"
> [1] TRUE
Running ‘loadDriverAndConnect.R’
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’
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’
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’
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
Flavors: r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc
Version: 0.7-6
Check: tests
Result: NOTE
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
Flavor: r-devel-windows-x86_64
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.