Changeset: d521b395579b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d521b395579b
Added Files:
MacOSX/MonetDB_logo.png
clients/R/Tests/dplyr.timeout
monetdb5/modules/mal/Tests/orderidx04.stable.err
monetdb5/modules/mal/Tests/orderidx04.stable.out
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.err.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single
sql/test/BugTracker-2016/Tests/storagemodel.sql
sql/test/BugTracker-2016/Tests/storagemodel.stable.err
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
Removed Files:
MacOSX/MonetDB logo.png
sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql
sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.err
sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out
Modified Files:
MacOSX/MonetDB.pkgproj
NT/updatecodes.py
clients/R/Tests/All
clients/R/Tests/dbapply.R
clients/R/Tests/dbi.R
clients/R/Tests/deps-install.R
clients/R/Tests/deps-test.R
clients/R/Tests/dplyr-flights.R
clients/R/Tests/dplyr-flights.stable.out
clients/R/Tests/dplyr.R
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
clients/Tests/exports.stable.out
clients/mapiclient/mclient.c
gdk/gdk.h
gdk/gdk_bbp.c
gdk/gdk_join.c
gdk/gdk_logger.c
gdk/gdk_storage.c
gdk/gdk_tm.c
gdk/gdk_utils.c
java/ChangeLog.Jul2015
java/ChangeLog.Jun2016
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
monetdb5/extras/mal_optimizer_template/opt_sql_append.c
monetdb5/extras/rapi/rapi.c
monetdb5/mal/mal.c
monetdb5/mal/mal.h
monetdb5/mal/mal_debugger.c
monetdb5/mal/mal_instruction.c
monetdb5/mal/mal_instruction.h
monetdb5/mal/mal_listing.c
monetdb5/modules/atoms/str.c
monetdb5/modules/atoms/str.h
monetdb5/modules/atoms/str.mal
monetdb5/modules/kernel/batstr.c
monetdb5/modules/kernel/batstr.mal
monetdb5/modules/kernel/status.c
monetdb5/modules/mal/01_batcalc.mal
monetdb5/modules/mal/bbp.c
monetdb5/modules/mal/manifold.c
monetdb5/optimizer/Tests/manifold2.stable.out.single
monetdb5/optimizer/opt_costModel.c
monetdb5/optimizer/opt_support.c
monetdb5/optimizer/opt_wrapper.c
monetdb5/optimizer/optimizer.c
monetdb5/scheduler/run_isolate.c
sql/backends/monet5/sql_decimal.mal.sh
sql/backends/monet5/sql_decimal_hge.mal.sh
sql/backends/monet5/sql_gencode.c
sql/backends/monet5/sql_optimizer.c
sql/backends/monet5/sql_upgrades.c
sql/benchmarks/ssbm/Tests/01-explain.stable.out
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/05-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-explain.stable.out
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/17-explain.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/21-plan.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
sql/common/sql_types.c
sql/jdbc/tests/Tests/Test_CisValid.stable.err
sql/jdbc/tests/Tests/Test_Rmetadata.stable.out
sql/scripts/45_uuid.sql
sql/server/rel_optimizer.c
sql/server/rel_partition.c
sql/server/sql_mvc.c
sql/server/sql_parser.y
sql/server/sql_qc.c
sql/storage/store.c
sql/test/ADT2006/Tests/bram.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/var_char_cast_truncate.SF-1150907.stable.out
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2016/Tests/All
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.32bit
sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/Tests/decimal2.stable.out
sql/test/Tests/str-pad.stable.out
sql/test/Tests/str-trim.stable.out
sql/test/Tests/string.stable.out
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out
sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out
sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out
sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/check.stable.out
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/check.stable.out
sql/test/emptydb-upgrade/Tests/check.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/leaks/Tests/check0.stable.out
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check1.stable.out.int128
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check2.stable.out.int128
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check3.stable.out.int128
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check4.stable.out.int128
sql/test/leaks/Tests/check5.stable.out
sql/test/leaks/Tests/check5.stable.out.int128
sql/test/leaks/Tests/select1.stable.out
sql/test/leaks/Tests/select2.stable.out
sql/test/orderidx/Tests/simpletable.sql
sql/test/orderidx/Tests/simpletable.stable.out
sql/test/orderidx/Tests/smalltable.sql
sql/test/orderidx/Tests/smalltable.stable.out
sql/test/pg_regress/Tests/strings.stable.out
sql/test/pg_regress/Tests/without_oid.stable.out.oid32
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
testing/Mtest.py.in
tools/mserver/mserver5.c
Branch: jit
Log Message:
merge with default
diffs (truncated from 36267 to 300 lines):
diff --git a/MacOSX/MonetDB.pkgproj b/MacOSX/MonetDB.pkgproj
--- a/MacOSX/MonetDB.pkgproj
+++ b/MacOSX/MonetDB.pkgproj
@@ -544,7 +544,7 @@
<key>BACKGROUND_PATH</key>
<dict>
<key>PATH</key>
- <string>MonetDB logo.png</string>
+ <string>MonetDB_logo.png</string>
<key>PATH_TYPE</key>
<integer>1</integer>
</dict>
diff --git a/MacOSX/MonetDB logo.png b/MacOSX/MonetDB_logo.png
rename from MacOSX/MonetDB logo.png
rename to MacOSX/MonetDB_logo.png
diff --git a/NT/updatecodes.py b/NT/updatecodes.py
--- a/NT/updatecodes.py
+++ b/NT/updatecodes.py
@@ -13,20 +13,22 @@ prcdre = re.compile('"ProductCode" = "8:
pacdre = re.compile('"PackageCode" = "8:{(.*)}"')
def update(f):
- p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE)
+ p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE,
+ universal_newlines = True)
u, e = p.communicate()
- productcode = u.strip('\r\n').upper()
- p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE)
+ productcode = u.strip('\n').upper()
+ p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE,
+ universal_newlines = True)
u, e = p.communicate()
- packagecode = u.strip('\r\n').upper()
- fp = open(f, 'rb')
+ packagecode = u.strip('\n').upper()
+ fp = open(f)
data = fp.read()
fp.close()
repl = '"ProductCode" = "8:{%s}"' % productcode
data = prcdre.sub(repl, data)
repl = '"PackageCode" = "8:{%s}"' % packagecode
data = pacdre.sub(repl, data)
- fp = open(f, 'wb')
+ fp = open(f, 'w')
fp.write(data)
fp.close()
diff --git a/clients/R/Tests/All b/clients/R/Tests/All
--- a/clients/R/Tests/All
+++ b/clients/R/Tests/All
@@ -1,6 +1,6 @@
HAVE_LIBR?deps-install
+HAVE_LIBR?install
HAVE_LIBR?deps-test
-HAVE_LIBR?install
HAVE_LIBR?dbi
HAVE_LIBR?survey
HAVE_LIBR?dplyr
diff --git a/clients/R/Tests/dbapply.R b/clients/R/Tests/dbapply.R
--- a/clients/R/Tests/dbapply.R
+++ b/clients/R/Tests/dbapply.R
@@ -1,6 +1,5 @@
-ll <- NULL
if (Sys.getenv("TSTTRGDIR") != "") {
- ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")
+ .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")))
}
library(DBI, quietly = T)
diff --git a/clients/R/Tests/dbi.R b/clients/R/Tests/dbi.R
--- a/clients/R/Tests/dbi.R
+++ b/clients/R/Tests/dbi.R
@@ -1,6 +1,5 @@
-ll <- NULL
if (Sys.getenv("TSTTRGDIR") != "") {
- ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")
+ .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")))
}
library(DBI)
diff --git a/clients/R/Tests/deps-install.R b/clients/R/Tests/deps-install.R
--- a/clients/R/Tests/deps-install.R
+++ b/clients/R/Tests/deps-install.R
@@ -3,6 +3,9 @@ dir.create(unlist(strsplit(Sys.getenv("R
# autoinstall DBI and digest, we need those to install MonetDB.R
dd <- capture.output(suppressMessages(suppressWarnings({
- install.packages(c("devtools", "digest"),
repos="http://cran.rstudio.com/", quiet=T)
+ repos <- "http://cran.rstudio.com/"
+ lp <- c("devtools", "digest")
+ install.packages(lp, repos=repos, quiet=T)
+ update.packages(repos=repos, ask=F, oldPkgs=lp)
devtools::install_github("rstats-db/DBI", quiet=T)
})))
diff --git a/clients/R/Tests/deps-test.R b/clients/R/Tests/deps-test.R
--- a/clients/R/Tests/deps-test.R
+++ b/clients/R/Tests/deps-test.R
@@ -5,6 +5,5 @@ dd <- capture.output(suppressMessages(su
repos <-
c('http://download.r-forge.r-project.org','http://cran.rstudio.com/')
if(length(np)) install.packages(np,repos=repos, quiet=T)
update.packages(repos=repos, ask=F, oldPkgs=lp, quiet=T)
- x <- lapply(lp,function(x){library(x,character.only=TRUE,quietly=T)})
})(c('Rcpp', 'dplyr','survey','sqlsurvey','Lahman','nycflights13'))
})))
diff --git a/clients/R/Tests/dplyr-flights.R b/clients/R/Tests/dplyr-flights.R
--- a/clients/R/Tests/dplyr-flights.R
+++ b/clients/R/Tests/dplyr-flights.R
@@ -1,6 +1,5 @@
-ll <- NULL
if (Sys.getenv("TSTTRGDIR") != "") {
- ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")
+ .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")))
}
ff <- textConnection("asdf", open="w")
# hide output from connect and attach since it would blow up the test output
diff --git a/clients/R/Tests/dplyr-flights.stable.out
b/clients/R/Tests/dplyr-flights.stable.out
--- a/clients/R/Tests/dplyr-flights.stable.out
+++ b/clients/R/Tests/dplyr-flights.stable.out
@@ -30,25 +30,25 @@ Ready.
# 11:44:05 >
[1] TRUE
-[1] 336776 16
-[1] 42 16
-[1] 42 16
-[1] 42 16
-[1] 42 16
-[1] 42 16
+[1] 336776 19
+[1] 42 19
+[1] 42 19
+[1] 42 19
+[1] 42 19
+[1] 42 19
[1] 42 3
[1] 42 3
-[1] 42 13
-[1] 42 1
[1] 42 16
[1] 42 1
+[1] 42 19
+[1] 42 1
[1] 42 2
-[1] 42 18
-[1] 42 18
+[1] 42 21
+[1] 42 21
[1] 42 2
[1] 1 1
-[1] 10 16
-[1] 42 16
+[1] 10 19
+[1] 42 19
[1] 42 3
[1] 42 4
[1] 42 4
diff --git a/clients/R/Tests/dplyr.R b/clients/R/Tests/dplyr.R
--- a/clients/R/Tests/dplyr.R
+++ b/clients/R/Tests/dplyr.R
@@ -1,6 +1,5 @@
-ll <- NULL
if (Sys.getenv("TSTTRGDIR") != "") {
- ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")
+ .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir")))
}
ff <- textConnection("asdf", open="w")
# hide output from connect and attach since it would blow up the test output
diff --git a/clients/R/Tests/dplyr.timeout b/clients/R/Tests/dplyr.timeout
new file mode 100644
--- /dev/null
+++ b/clients/R/Tests/dplyr.timeout
@@ -0,0 +1,1 @@
+2
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -16,17 +16,9 @@ stdout of test 'MAL-signatures` in direc
Ready.
-# 15:16:50 >
-# 15:16:50 > "mclient" "-lmal" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-9622" "--port=32080"
-# 15:16:50 >
-
-command aggr.avg(b:bat[:hge],g:bat[:oid],e:bat[:any_1])
(X_4:bat[:dbl],X_5:bat[:wrd])
-address AGGRavg23_dbl;
-comment Grouped tail average on hge, also returns count
-
-command aggr.avg(b:bat[:hge],g:bat[:oid],e:bat[:any_1]):bat[:dbl]
-address AGGRavg13_dbl;
-comment Grouped tail average on hge
+# 12:27:16 >
+# 12:27:16 > "mclient" "-lmal" "-ftest" "-Eutf-8"
"--host=/var/tmp/mtest-25748" "--port=36923"
+# 12:27:16 >
command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1])
(X_4:bat[:dbl],X_5:bat[:wrd])
address AGGRavg23_dbl;
@@ -88,8 +80,6 @@ pattern aggr.avg(b:bat[:any_2]):dbl
address CMDcalcavg;
comment Gives the avg of all tail values
-function aggr.corr(e1:bat[:hge],e2:bat[:hge]):hge;
-function aggr.covar(e1:bat[:hge],e2:bat[:hge]):hge;
function aggr.corr(e1:bat[:dbl],e2:bat[:dbl]):dbl;
function aggr.covar(e1:bat[:dbl],e2:bat[:dbl]):dbl;
function aggr.corr(e1:bat[:flt],e2:bat[:flt]):flt;
@@ -523,142 +513,6 @@ pattern aggr.prod(b:bat[:bte]):bte
address CMDBATprod;
comment Calculate aggregate product of B.
-pattern aggr.prod(b:bat[:hge],s:bat[:oid],nil_if_empty:bit):dbl
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:hge],s:bat[:oid]):dbl
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:hge],nil_if_empty:bit):dbl
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:hge]):dbl
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:hge],s:bat[:oid],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:hge],s:bat[:oid]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:hge],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:hge]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:lng],s:bat[:oid],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:lng],s:bat[:oid]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:lng],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:lng]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:wrd],s:bat[:oid],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:wrd],s:bat[:oid]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:wrd],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:wrd]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:int],s:bat[:oid]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:int],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:int]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B.
-
-pattern aggr.prod(b:bat[:sht],s:bat[:oid],nil_if_empty:bit):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:sht],s:bat[:oid]):hge
-address CMDBATprod;
-comment Calculate aggregate product of B with candidate list.
-
-pattern aggr.prod(b:bat[:sht],nil_if_empty:bit):hge
-address CMDBATprod;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list