Changeset: a56dde194473 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a56dde194473 Added Files: sql/test/BugTracker-2017/Tests/double-groupby-column.Bug-6207.sql sql/test/BugTracker-2017/Tests/double-groupby-column.Bug-6207.stable.err sql/test/BugTracker-2017/Tests/double-groupby-column.Bug-6207.stable.out sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.sql sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.err sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct.Bug-6411.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct.Bug-6411.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in.Bug-6433.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in.Bug-6433.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in.Bug-6433.stable.out sql/test/BugTracker-2017/Tests/sqlitelogictest-select-not-in.Bug-6435.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-select-not-in.Bug-6435.stable.err sql/test/BugTracker-2017/Tests/sqlitelogictest-select-not-in.Bug-6435.stable.out sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.out sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.sql sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.stable.err sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.stable.out sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.stable.err sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.stable.out sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.stable.err sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.stable.out sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.stable.err sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.stable.out sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.stable.err sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.stable.out sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.stable.err sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.stable.out sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.sql sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.out sql/test/bugs/Tests/in.sql sql/test/bugs/Tests/in.stable.err sql/test/bugs/Tests/in.stable.out sql/test/mergetables/Tests/mergedb.Bug-6820.sql sql/test/mergetables/Tests/mergedb.Bug-6820.stable.err sql/test/mergetables/Tests/mergedb.Bug-6820.stable.out sql/test/mergetables/Tests/mergedb_create.sql sql/test/mergetables/Tests/mergedb_create.stable.err sql/test/mergetables/Tests/mergedb_create.stable.out sql/test/mergetables/Tests/mergedb_drop.sql sql/test/mergetables/Tests/mergedb_drop.stable.err sql/test/mergetables/Tests/mergedb_drop.stable.out sql/test/mergetables/Tests/sqlsmith.Bug-6426.sql sql/test/mergetables/Tests/sqlsmith.Bug-6426.stable.err sql/test/mergetables/Tests/sqlsmith.Bug-6426.stable.out Removed Files: ChangeLog.Dec2016 buildtools/ChangeLog.Dec2016 clients/ChangeLog.Dec2016 clients/mapilib/ChangeLog.Dec2016 common/stream/ChangeLog.Dec2016 gdk/ChangeLog.Dec2016 geom/ChangeLog.Dec2016 monetdb5/ChangeLog.Dec2016 sql/ChangeLog.Dec2016 testing/ChangeLog.Dec2016 tools/merovingian/ChangeLog.Dec2016 Modified Files: .hgtags MonetDB.spec NT/monetdb_config.h.in NT/rules.msc clients/R/Tests/All clients/R/Tests/copy_into_fwf.stable.out clients/R/Tests/dbi.R clients/R/Tests/dbi.stable.err clients/R/Tests/deps-install.R clients/R/Tests/deps-test.R clients/R/Tests/dplyr-flights.R clients/R/Tests/dplyr-flights.reqtests clients/R/Tests/dplyr.R clients/R/Tests/install.R clients/mapilib/mapi.rc clients/odbc/driver/SQLGetInfo.c clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc common/stream/stream.c configure.ag debian/changelog gdk/ChangeLog-Archive gdk/gdk_atoms.c gdk/gdk_batop.c gdk/gdk_calc_compare.h gdk/gdk_logger.c gdk/gdk_private.h gdk/gdk_utils.c gdk/libbat.rc libversions monetdb5/mal/mal.c monetdb5/mal/mal_client.c monetdb5/mal/mal_function.c monetdb5/mal/mal_import.c monetdb5/mal/mal_instruction.c monetdb5/mal/mal_interpreter.c monetdb5/mal/mal_linker.c monetdb5/mal/mal_listing.c monetdb5/mal/mal_namespace.c monetdb5/mal/mal_parser.c monetdb5/mal/mal_sabaoth.c monetdb5/mal/mal_session.c monetdb5/modules/atoms/mtime.c monetdb5/modules/atoms/str.c monetdb5/modules/mal/mal_mapi.c monetdb5/modules/mal/mdb.c monetdb5/modules/mal/remote.c monetdb5/optimizer/opt_constants.c monetdb5/optimizer/opt_mergetable.c monetdb5/optimizer/opt_pipes.c monetdb5/optimizer/opt_remap.c monetdb5/optimizer/opt_remoteQueries.c monetdb5/tools/libmonetdb5.rc sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_user.c sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128 sql/backends/monet5/vaults/bam/Tests/query2.6.sql sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out.Windows sql/include/sql_catalog.h sql/include/sql_mem.h sql/scripts/51_sys_schema_extension.sql sql/server/rel_dump.c sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_optimizer.c sql/server/rel_rel.c sql/server/rel_select.c sql/server/rel_updates.c sql/server/sql_parser.y sql/server/sql_semantic.c sql/storage/bat/bat_storage.c sql/storage/store.c sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out sql/test/BugTracker-2008/Tests/count_with_order_by_and_limit_crashes.SF-2229936.stable.err sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.sql sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out.int128 sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.sql sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.stable.out sql/test/BugTracker-2012/Tests/querycache.Bug-3212.stable.out sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.stable.out sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.sql sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128 sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out sql/test/BugTracker-2017/Tests/case.Bug-6386.sql sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out sql/test/BugTracker-2017/Tests/function_and_mergetable.Bug-6288.sql sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out sql/test/BugTracker/Tests/caching.SF-1651599.stable.out sql/test/BugTracker/Tests/drop_schema_crash.SF-1504794.stable.err sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.err sql/test/Dependencies/Tests/Dependencies.stable.err sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/LSST/Tests/dbQuery036.stable.err sql/test/Skyserver/drop_user.sql sql/test/Tests/marcin3.stable.err sql/test/Tests/str-pad.sql sql/test/Tests/str-pad.stable.out sql/test/bugs/Tests/All sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out sql/test/bugs/Tests/union_all-bug-sf-941788.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/mapi/Tests/sql_int128.stable.out.int128 sql/test/mergetables/Tests/All sql/test/mergetables/Tests/mergequery.stable.out sql/test/mergetables/Tests/part-elim.stable.out sql/test/pg_regress/Tests/strings.stable.out sql/test/pg_regress/Tests/strings_cast.stable.out sql/test/remote/Tests/partition_elim.stable.out vertoo.data Branch: acticloud Log Message:
Advance acticloud to Jul2017-SP2 release (Merge with Jul2017 branch) diffs (truncated from 15535 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -680,3 +680,8 @@ 1534ee14ff84fe5629becc6a5b5e2990b694d5a3 269ab71a82190d6024b3a920837089d657893493 Jul2017_5 1534ee14ff84fe5629becc6a5b5e2990b694d5a3 Jul2017_SP1_release 269ab71a82190d6024b3a920837089d657893493 Jul2017_SP1_release +fce449d5af88de715fde36624815a56ef34c56bb Jul2017_7 +fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release +3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_9 +fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release +3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_SP2_release diff --git a/ChangeLog.Dec2016 b/ChangeLog.Dec2016 deleted file mode 100644 --- a/ChangeLog.Dec2016 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -1,5 +1,5 @@ %define name MonetDB -%define version 11.27.6 +%define version 11.27.10 %{!?buildno: %global buildno %(date +%Y%m%d)} # groups of related archs @@ -132,7 +132,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Jul2017-SP1/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Jul2017-SP2/%{name}-%{version}.tar.bz2 # we need systemd for the _unitdir macro to exist # we need checkpolicy and selinux-policy-devel for the SELinux policy @@ -970,7 +970,7 @@ fi --enable-monetdb5=yes \ --enable-netcdf=no \ --enable-odbc=yes \ - --enable-optimize=yes \ + --enable-optimize=no \ --enable-profile=no \ --enable-pyintegration=%{?with_pyintegration:yes}%{!?with_pyintegration:no} \ --enable-rintegration=%{?with_rintegration:yes}%{!?with_rintegration:no} \ @@ -1041,6 +1041,85 @@ done %postun -p /sbin/ldconfig %changelog +* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023 +- Rebuilt. +- BZ#6207: identifier ambiguous when grouping and selecting the same + column twice +- BZ#6335: Sqlitelogictest crash in complex SQL query +- BZ#6405: Compilation error if DISABLE_PARENT_HASH not defined +- BZ#6412: Overflow in sys.epoch +- BZ#6413: Wrong answer for TPC-H Q17 +- BZ#6414: Using RPAD returns: could not allocate space +- BZ#6416: Sqlitelogictest crash in aggregation query with a NOT IN clause +- BZ#6417: Segfault encountered (sqlsmith) +- BZ#6418: Segfault in renaming (sqlsmith) +- BZ#6419: segfault in rel_optimizer (sqlsmith) +- BZ#6420: Assertion error in mergetable task (sqlsmith) +- BZ#6422: Another assertion error in rel_or (sqlsmith) +- BZ#6423: Dereference null pointer (sqlsmith) +- BZ#6424: Assertion error in rel_rename_expr (sqlsmith) +- BZ#6425: Assertion error in exp_bin (sqlsmith) +- BZ#6426: Assertion error in rel_find_exp_ (sqlsmith) +- BZ#6427: Assertion error in eq_typeswitchloop (sqlsmith) +- BZ#6428: Sqlitelogictest crash in aggregation query +- BZ#6430: Assertion raised in another eq_typeswitch error (sqlsmith) +- BZ#6431: Sqlitelogictest crash in aggregation query with a long + having clause +- BZ#6432: Assertion error in exp_bin (sqlsmith) +- BZ#6433: Sqlitelogictest crash in complex SELECT query with IN operator +- BZ#6435: Sqlitelogictest crash in simple select query +- BZ#6437: System schemas "profiler" and "json" shouldn't be allowed to + be dropped. +- BZ#6438: Implement functionality to enforce the restrict option in: + DROP SCHEMA xyz RESTRICT; +- BZ#6440: Faulty plan generated. Query returns more rows than expected + or existing in the view sys.tables. + +* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023 +- gdk: A serious bug, possibly resulting in database corruption, having to + do with appending data to a string BAT was fixed. + +* Wed Oct 11 2017 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.27.7-20171011 +- Rebuilt. +- BZ#4017: server crashes when executing particular loopback query in + embedded python +- BZ#6239: Incorrect profiling +- BZ#6261: New handling of delta tables hurts badly reusage of bats +- BZ#6287: should the CORR function return some numeric type that allows + fractions? +- BZ#6321: Two-column aggregation on join result extremely slow. +- BZ#6343: MERGE TABLE issue: unable to find +- BZ#6348: Interference of procedure/table name +- BZ#6350: Carriage return and form feed in TEXT fields are returned as + 'r' and 'f' in jdbcclient and ResultSets +- BZ#6352: Scope resolution problem (sqlsmith) +- BZ#6353: implicit NULL value not propagated in distributed/remote query +- BZ#6374: Wrong answer from merge table after content changes +- BZ#6379: Table UDF: SEGV raised when invoking a non existing function +- BZ#6380: unable to create new databases from clean installation +- BZ#6381: Parser misses error messages in conditional +- BZ#6382: Can't set JSON fields via PreparedStatement +- BZ#6384: crash when setting a wrong listenaddr +- BZ#6385: AGGREGATE UDFs with more than 2 parameters incorrectly + processed +- BZ#6386: Unexpected error from server for query with long floats +- BZ#6387: Performance degradation on multi column sort +- BZ#6388: JDBC Connection via user voc produces errors when fetching + certain meta data information +- BZ#6392: SELECT EXISTS (empty table) returns 'true' +- BZ#6395: BAT leak of scalar result sets +- BZ#6397: Isolation of generating functions not correct +- BZ#6398: Null Matches in outer join are not supported +- BZ#6399: UDF crashes when subquery and scalar values are passed + as pameters +- BZ#6400: getCharacterStream() currently not supported +- BZ#6404: COPY INTO crashes if table has primary key or foreign key + constraint +- BZ#6409: sqllogictest crash on aggregation query with NOT IN clause + in HAVING clause +- BZ#6410: Sqlitelogictest crash on aggregation query with IN clause +- BZ#6411: Sqlitelogictest crash in aggregation query + * Thu Jul 27 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.5-20170727 - Rebuilt. - BZ#6375: MAL profiler truncates JSON objects larger than 8192 characters diff --git a/NT/monetdb_config.h.in b/NT/monetdb_config.h.in --- a/NT/monetdb_config.h.in +++ b/NT/monetdb_config.h.in @@ -762,7 +762,7 @@ #define PACKAGE "MonetDB" /* Define to the version of this package. */ -#define PACKAGE_VERSION "11.27.6" +#define PACKAGE_VERSION "11.27.10" /* Define to the address where bug reports for this package should be sent. */ #define PACKAGE_BUGREPORT "https://bugs.monetdb.org/" diff --git a/NT/rules.msc b/NT/rules.msc --- a/NT/rules.msc +++ b/NT/rules.msc @@ -6,7 +6,7 @@ # # Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. -VERSION=11.27.6 +VERSION=11.27.10 # ^^^^^^ # Maintained via vertoo. Please don't modify by hand! # Contact monetdb-develop...@lists.sourceforge.net for details and/or assistance. diff --git a/buildtools/ChangeLog.Dec2016 b/buildtools/ChangeLog.Dec2016 deleted file mode 100644 --- a/buildtools/ChangeLog.Dec2016 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for buildtools -# This file is updated with Maddlog - diff --git a/clients/ChangeLog.Dec2016 b/clients/ChangeLog.Dec2016 deleted file mode 100644 --- a/clients/ChangeLog.Dec2016 +++ /dev/null @@ -1,7 +0,0 @@ -# ChangeLog file for clients -# This file is updated with Maddlog - -* Mon Jun 12 2017 Sjoerd Mullender <sjo...@acm.org> -- A bug was fixed in the implementation of the functions SQLTables in - the ODBC driver where not enough memory was allocated. - diff --git a/clients/R/Tests/All b/clients/R/Tests/All --- a/clients/R/Tests/All +++ b/clients/R/Tests/All @@ -1,8 +1,8 @@ HAVE_LIBR?deps-install HAVE_LIBR?install HAVE_LIBR?deps-test -HAVE_LIBR&HAVE_PERL?dbi -HAVE_LIBR?dplyr +HAVE_LIBR?dbi +#HAVE_LIBR?dplyr too slow HAVE_LIBR?dplyr-flights HAVE_LIBR?copy_into_fwf HAVE_LIBR&NOT_WIN32?dbapply diff --git a/clients/R/Tests/copy_into_fwf.stable.out b/clients/R/Tests/copy_into_fwf.stable.out --- a/clients/R/Tests/copy_into_fwf.stable.out +++ b/clients/R/Tests/copy_into_fwf.stable.out @@ -26,6 +26,8 @@ Ready. <MonetDBResult> SQL CREATE TABLE mtcars (mpg DOUBLE PRECISION, cyl DOUBLE PRECISION, disp DOUBLE PRECISION, hp DOUBLE PRECISION, drat DOUBLE PRECISION, wt DOUBLE PRECISION, qsec DOUBLE PRECISION, vs DOUBLE PRECISION, am DOUBLE PRECISION, gear DOUBLE PRECISION, carb DOUBLE PRECISION) + ROWS Fetched: 0 [complete] + Changed: NA mpg cyl disp hp drat wt qsec vs am gear carb 1 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4 2 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4 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 @@ -198,7 +198,7 @@ stopifnot(identical(1L, as.integer(dbGet # reserved words in data frame column names stopifnot(dbIsValid(conn)) dbBegin(conn) -dbWriteTable(conn, "evilt", data.frame(year=42, month=12, day=24, some.dot=12), transaction=F) +dbWriteTable(conn, "evilt", data.frame(year=42, month=12, day=24, some.dot=12)) stopifnot(dbExistsTable(conn, "evilt")) dbRollback(conn) @@ -208,7 +208,7 @@ dbBegin(conn) data(api, package="survey") x <- apiclus1 x$idkey <- seq( nrow( x ) ) -dbWriteTable( conn , 'x' , x , transaction=F) +dbWriteTable( conn , 'x' , x ) stopifnot(dbExistsTable(conn, "x")) dbRollback(conn) @@ -217,7 +217,7 @@ stopifnot(!is.null(dbGetQuery(conn, "SEL #non-standard dbwritetable use dbBegin(conn) -dbWriteTable(conn, "vectable", 1:1000, transaction=F) +dbWriteTable(conn, "vectable", 1:1000) stopifnot(dbExistsTable(conn, "vectable")) dbRollback(conn) diff --git a/clients/R/Tests/dbi.stable.err b/clients/R/Tests/dbi.stable.err --- a/clients/R/Tests/dbi.stable.err +++ b/clients/R/Tests/dbi.stable.err @@ -33,19 +33,16 @@ stderr of test 'dbi` in directory 'clien Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Warning message: 'MonetDBLite::isIdCurrent' is deprecated. -Use 'dbIsValid' instead. +Use 'use dbIsValid() instead' instead. See help("Deprecated") Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. -Treating character vector parameter as file name(s) for monetdb.read.csv() Identifier(s) "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. -Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. -Identifier(s) "Need to quote this table name" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "some.dot" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. Identifier(s) "year", "month", "day" are reserved SQL keywords and need(s) to be quoted in queries. Identifier(s) "sch.wide", "comp.imp", "yr.rnd", "acs.k3", "acs.46", "acs.core", "pct.resp", "not.hsg", "some.col", "col.grad", "grad.sch", "avg.ed", "api.stu" contain uppercase or reserved SQL characters and need(s) to be quoted in queries. 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 @@ -1,13 +1,11 @@ # autoinstall DBI and digest, we need those to install MonetDB.R +options(warn = -1) +packages_required <- c("digest", "DBI") cat("#~BeginProfilingOutput~#\n", file=stderr()) cat("#~BeginProfilingOutput~#\n", file=stdout()) -repos <- "http://cran.rstudio.com/" -packages_required <- c("devtools", "digest") -install.packages(packages_required, repos=repos, quiet=T) -update.packages(repos=repos, ask=F, oldPkgs=packages_required) -devtools::install_github("rstats-db/DBI", quiet=T) +install.packages(packages_required, repos="http://cran.rstudio.com/") cat("#~EndProfilingOutput~#\n", file=stderr()) cat("#~EndProfilingOutput~#\n\n", file=stdout()) 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 @@ -1,26 +1,16 @@ -packages_required <- c('Rcpp', 'dplyr', 'Lahman', 'nycflights13', 'gdata', 'survey') +packages_required <- c("assertthat","testthat","survey","nycflights13","RSQLite","dbplyr","dplyr","gdata","callr","devtools","DBItest") install_or_upgrade_packages <- function(lp) { np <- lp[!(lp %in% installed.packages()[,"Package"])] repos <- 'http://cran.rstudio.com/' if(length(np)) install.packages(np, repos=repos, quiet=T) update.packages(repos=repos, ask=F, oldPkgs=lp, quiet=T) - - # dev dplyr - if (packageVersion("devtools") < 1.6) { - install.packages("devtools") - } - devtools::install_github("hadley/lazyeval") - devtools::install_github("hadley/dplyr") - } _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list