* using log directory ‘/srv/hornik/tmp/CRAN/nolock.Rcheck’ * using R Under development (unstable) (2023-09-13 r85142) * using platform: x86_64-pc-linux-gnu * R was compiled by Debian clang version 16.0.6 (11) GNU Fortran (Debian 13.2.0-2) 13.2.0 * running under: Debian GNU/Linux trixie/sid * using session charset: UTF-8 * checking for file ‘nolock/DESCRIPTION’ ... OK * checking extension type ... Package * this is package ‘nolock’ version ‘1.0.1’ * package encoding: UTF-8 * checking CRAN incoming feasibility ... [2s/2s] NOTE Maintainer: ‘Arkadiusz W. Pajda ’ New submission * 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 ‘nolock’ can be installed ... [1s/1s] OK * 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 R files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... [0s/0s] OK * checking whether the package can be loaded with stated dependencies ... [0s/0s] OK * checking whether the package can be unloaded cleanly ... [0s/0s] OK * checking whether the namespace can be loaded with stated dependencies ... [0s/0s] OK * checking whether the namespace can be unloaded cleanly ... [0s/0s] OK * checking loading without being on the library search path ... [0s/0s] 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 ... [2s/2s] OK * checking Rd files ... [0s/0s] 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 examples ... [0s/0s] ERROR Running examples in ‘nolock-Ex.R’ failed The error most likely occurred in: > base::assign(".ptime", proc.time(), pos = "CheckExEnv") > ### Name: nolock > ### Title: 'Append WITH (NOLOCK) to SQL Queries' > ### Aliases: nolock > > ### ** Examples > > # Define a 'SQL' query as a parameter in the nolock(query) function > # or use the nolock() function which opens a temporary 'SQL' text document. > # Enter your 'SQL' query for editing there. It will be modified. > # The finalized query will be copied to the clipboard. > > example_SQL <- " + WITH CTE AS ( + SELECT + C.TABLE_NAME, + C.COLUMN_NAME, + T.TABLE_TYPE + FROM + INFORMATION_SCHEMA.COLUMNS AS C + JOIN + INFORMATION_SCHEMA.TABLES T ON C.TABLE_NAME = T.TABLE_NAME + ) + + SELECT * FROM CTE;" > > # Process the 'SQL' query using nolock() by specifying the query: > nolock(query = example_SQL) Please enter a valid 'SQL' query into the opened temporal file... Error in utils:::check_screen_device("editor") : editor should not be used in examples etc Calls: nolock -> file.edit -> editor -> Execution halted * checking PDF version of manual ... [2s/2s] OK * checking HTML version of manual ... [0s/0s] OK * checking for non-standard things in the check directory ... OK * checking for detritus in the temp directory ... OK * DONE Status: 1 ERROR, 1 NOTE