Changeset: d7a0e21aaf80 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d7a0e21aaf80 Added Files: sql/backends/monet5/generator/Tests/rangejoin.sql sql/backends/monet5/generator/Tests/rangejoin.stable.err sql/backends/monet5/generator/Tests/rangejoin.stable.out sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err.int128 sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out.int128 sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.sql sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err.int128 sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out.int128 sql/test/BugTracker-2014/Tests/orderby_column_exp.Bug-3620.sql sql/test/BugTracker-2014/Tests/orderby_column_exp.Bug-3620.stable.err sql/test/BugTracker-2014/Tests/orderby_column_exp.Bug-3620.stable.out sql/test/pg_regress/Tests/loadwisconsin.stable.err sql/test/pg_regress/Tests/loadwisconsin.stable.out Modified Files: buildtools/doc/windowsbuild.rst clients/R/MonetDB.R/R/dbi.R clients/R/Tests/survey.R clients/R/Tests/survey.stable.err clients/Tests/MAL-signatures_all.stable.out clients/Tests/MAL-signatures_all.stable.out.int128 clients/Tests/MAL-signatures_fits_geom.stable.out clients/Tests/MAL-signatures_fits_geom.stable.out.int128 clients/Tests/MAL-signatures_geom.stable.out clients/Tests/MAL-signatures_geom.stable.out.int128 clients/Tests/MAL-signatures_none.stable.out clients/Tests/MAL-signatures_none.stable.out.int128 clients/Tests/exports.stable.out clients/mapiclient/tomograph.c clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc gdk/gdk.h gdk/gdk_align.c gdk/gdk_atoms.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_private.h gdk/libbat.rc geom/monetdb5/geom.c geom/monetdb5/geom.mal geom/sql/40_geom.sql monetdb5/modules/atoms/inet.mal monetdb5/modules/atoms/mtime.c monetdb5/modules/kernel/algebra.c monetdb5/modules/kernel/algebra.h monetdb5/modules/kernel/algebra.mal monetdb5/optimizer/opt_generator.c monetdb5/tools/libmonetdb5.rc sql/ChangeLog.Oct2014 sql/backends/monet5/Tests/limithack.stable.out sql/backends/monet5/Tests/simpleSQL.stable.out sql/backends/monet5/generator/Tests/All sql/backends/monet5/generator/generator.c sql/backends/monet5/generator/generator.h sql/backends/monet5/generator/generator.mal sql/backends/monet5/sql.c sql/backends/monet5/sql.h sql/backends/monet5/sql.mal sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_upgrades.c sql/common/sql_types.c sql/common/sql_types.h sql/server/rel_optimizer.c sql/server/rel_psm.c sql/server/rel_select.c sql/server/sql_mvc.h sql/server/sql_parser.y sql/storage/bat/bat_logger.c sql/storage/bat/bat_storage.c sql/storage/bat/bat_storage.h sql/storage/bat/bat_table.c sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.sql sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out sql/test/BugTracker-2014/Tests/All sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1_bam.stable.out sql/test/leaks/Tests/check1_nogeom.stable.out sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2_bam.stable.out sql/test/leaks/Tests/check2_nogeom.stable.out sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3_bam.stable.out sql/test/leaks/Tests/check3_nogeom.stable.out sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4_bam.stable.out sql/test/leaks/Tests/check4_nogeom.stable.out sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5_bam.stable.out sql/test/leaks/Tests/check5_nogeom.stable.out sql/test/leaks/Tests/drop3.stable.out sql/test/leaks/Tests/drop3_bam.stable.out sql/test/leaks/Tests/drop3_nogeom.stable.out sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select1_bam.stable.out sql/test/leaks/Tests/select1_nogeom.stable.out sql/test/leaks/Tests/select2.stable.out sql/test/leaks/Tests/select2_bam.stable.out sql/test/leaks/Tests/select2_nogeom.stable.out sql/test/leaks/Tests/temp1.stable.out sql/test/leaks/Tests/temp1_bam.stable.out sql/test/leaks/Tests/temp1_nogeom.stable.out sql/test/leaks/Tests/temp2.stable.out sql/test/leaks/Tests/temp2_bam.stable.out sql/test/leaks/Tests/temp2_nogeom.stable.out sql/test/leaks/Tests/temp3.stable.out sql/test/leaks/Tests/temp3_bam.stable.out sql/test/leaks/Tests/temp3_nogeom.stable.out sql/test/pg_regress/Tests/All sql/test/pg_regress/Tests/alter_table.sql sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/alter_table.stable.out sql/test/pg_regress/Tests/arrays.stable.err sql/test/pg_regress/Tests/boolean.stable.err sql/test/pg_regress/Tests/case.stable.err sql/test/pg_regress/Tests/char.stable.err sql/test/pg_regress/Tests/comments.stable.err sql/test/pg_regress/Tests/create_aggregate.stable.err sql/test/pg_regress/Tests/create_misc.stable.err sql/test/pg_regress/Tests/create_misc.stable.out sql/test/pg_regress/Tests/create_operator.stable.err sql/test/pg_regress/Tests/create_table.sql sql/test/pg_regress/Tests/create_table.stable.err sql/test/pg_regress/Tests/date.stable.err sql/test/pg_regress/Tests/date.stable.out sql/test/pg_regress/Tests/drop.stable.err sql/test/pg_regress/Tests/float4.stable.err sql/test/pg_regress/Tests/float8.stable.err sql/test/pg_regress/Tests/inet.stable.err sql/test/pg_regress/Tests/insert.stable.err sql/test/pg_regress/Tests/int2.stable.err sql/test/pg_regress/Tests/int4.stable.err sql/test/pg_regress/Tests/int8.stable.err sql/test/pg_regress/Tests/interval.stable.err sql/test/pg_regress/Tests/limit.stable.err sql/test/pg_regress/Tests/limit.stable.out sql/test/pg_regress/Tests/numeric.stable.err sql/test/pg_regress/Tests/numeric_big.stable.err sql/test/pg_regress/Tests/numerology.stable.err sql/test/pg_regress/Tests/oid.stable.err sql/test/pg_regress/Tests/random.stable.out sql/test/pg_regress/Tests/select_into.stable.err sql/test/pg_regress/Tests/strings.stable.err sql/test/pg_regress/Tests/strings_cast.stable.err sql/test/pg_regress/Tests/strings_concat.stable.err sql/test/pg_regress/Tests/timestamp.sql sql/test/pg_regress/Tests/timestamp.stable.err sql/test/pg_regress/Tests/timestamp.stable.out sql/test/pg_regress/Tests/timestamptz.sql sql/test/pg_regress/Tests/timestamptz.stable.err sql/test/pg_regress/Tests/timestamptz.stable.out sql/test/pg_regress/Tests/vacuum.sql sql/test/pg_regress/Tests/vacuum.stable.out sql/test/pg_regress/Tests/varchar.stable.err sql/test/pg_regress/Tests/without_oid.sql sql/test/pg_regress/Tests/without_oid.stable.err sql/test/pg_regress/Tests/without_oid.stable.out sql/test/testdb-upgrade-chain/Tests/dump.stable.out sql/test/testdb-upgrade-chain/Tests/dump.stable.out.Windows sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/dump.stable.out.Windows Branch: mosaic Log Message:
Merge with default branch. diffs (truncated from 76385 to 300 lines): diff --git a/buildtools/doc/windowsbuild.rst b/buildtools/doc/windowsbuild.rst --- a/buildtools/doc/windowsbuild.rst +++ b/buildtools/doc/windowsbuild.rst @@ -23,12 +23,11 @@ Building MonetDB On Windows +++++++++++++++++++++++++++ In this document we describe how to build the MonetDB suite of -programs on Windows using the sources from our source repository at -`our server`__. This document is mainly targeted at building on -Windows on a 32-bit architecture, but there are notes throughout about -building on Windows on a 64-bit architecture which is indicated with -Windows64. We have successfully built on Windows XP, Windows Server, -and Windows 7. +programs on Windows using the sources from `our source repository`__. +This document is mainly targeted at building on Windows on a 32-bit +architecture, but there are notes throughout about building on Windows +on a 64-bit architecture which is indicated with Windows64. We have +successfully built on Windows XP, Windows Server, and Windows 7. __ http://dev.monetdb.org/hg/MonetDB/ @@ -172,7 +171,8 @@ the build process would be much more lik here). We currently use Microsoft Visual Studio 2010 and Intel(R) C++ -Compiler XE 13.1.2.190, the latter using Microsoft Visual Studio 10.0. +Compiler XE 13.1.2.190, the latter using Microsoft Visual Studio +10.0. Older versions haven't been tried in a long time. __ http://www.cygwin.com/ __ http://www.mingw.org/ @@ -262,7 +262,27 @@ Files\PCRE``. For Windows64, select the correct compiler (``Visual Studio 10 2010 Win64``) and proceed normally. When building the 32 bit version on Windows64, choose ``C:/Program Files (x86)/PCRE`` for the -``CMAKE_INSTALL_PREFIX`` value, otherwise choose ``C:/Program Files/PCRE``. +``CMAKE_INSTALL_PREFIX`` value, otherwise choose ``C:/Program +Files/PCRE``. + +In order to get a version number in the DLL that is produced, we added +a file ``version.rc`` to the sources for the ``pcre`` subproject. The +contents of the file are:: + + #include <Windows.h> + VS_VERSION_INFO VERSIONINFO + FILEVERSION 8,36,0,0 // change as appropriate + PRODUCTVERSION 8,36,0,0 // change as appropriate + FILEFLAGSMASK 0x3fL + FILEFLAGS 0 + FILEOS VOS_NT_WINDOWS32 + FILETYPE VFT_DLL + FILESUBTYPE VFT2_UNKNOWN + BEGIN + BLOCK "StringFileInfo" + BEGIN + END + END __ http://www.pcre.org/ @@ -338,6 +358,29 @@ Studio 2008 a warning. ``d`` to the definitions of ``XML_SO``, ``XML_IMP``, ``XML_A``, and ``XML_A_DLL``. Also add ``d`` to the ``zlib.lib`` and ``iconv.lib``. +In order to get a version number in the DLL that is produced, we added +a file ``version.rc`` in the ``win32`` folder. The contents of the +file are:: + + #include <Windows.h> + VS_VERSION_INFO VERSIONINFO + FILEVERSION 2,9,2,0 // change as appropriate + PRODUCTVERSION 2,9,2,0 // change as appropriate + FILEFLAGSMASK 0x3fL + FILEFLAGS 0 + FILEOS VOS_NT_WINDOWS32 + FILETYPE VFT_DLL + FILESUBTYPE VFT2_UNKNOWN + BEGIN + BLOCK "StringFileInfo" + BEGIN + END + END + +To use it, we also added ``version.res`` after ``$(XML_OBJS)`` in +``win32\Makefile.msvc`` both in the list of dependencies of +``$(BINDIR)\$(XML_SO)`` and in the command to produce said file. + After this, you may want to move the file ``libxml2.dll`` from the ``lib`` folder to the ``bin`` folder. @@ -366,6 +409,32 @@ in the instructions. .. On Windows64, add WIN64=YES to the nmake command line. +.. For a debug build, add ``BUILD_DEBUG=YES`` to the ``nmake`` command + line. + +In order to get a version number in the DLL that is produced, we added +a file ``version.rc`` in the ``src`` folder. The contents of the +file are:: + + #include <Windows.h> + VS_VERSION_INFO VERSIONINFO + FILEVERSION 3,4,2,0 // change as appropriate + PRODUCTVERSION 3,4,2,0 // change as appropriate + FILEFLAGSMASK 0x3fL + FILEFLAGS 0 + FILEOS VOS_NT_WINDOWS32 + FILETYPE VFT_DLL + FILESUBTYPE VFT2_UNKNOWN + BEGIN + BLOCK "StringFileInfo" + BEGIN + END + END + +To use it, we also added ``version.res`` at the end of the definition +of the ``OBJ`` macro and to the list of dependencies of and the +command for ``$(CDLLNAME)`` in ``src\Makefile.vc``. + After this, install the library somewhere, e.g. in ``C:\geos-3.4.2.win32``:: @@ -524,6 +593,28 @@ the following patches to the files ``mak #else # define BZ_API(func) func +In order to get a version number in the DLL that is produced, we added +a file ``version.rc`` in the top-level folder. The contents of the +file are:: + + #include <Windows.h> + VS_VERSION_INFO VERSIONINFO + FILEVERSION 1,0,6,0 // change as appropriate + PRODUCTVERSION 1,0,6,0 // change as appropriate + FILEFLAGSMASK 0x3fL + FILEFLAGS 0 + FILEOS VOS_NT_WINDOWS32 + FILETYPE VFT_DLL + FILESUBTYPE VFT2_UNKNOWN + BEGIN + BLOCK "StringFileInfo" + BEGIN + END + END + +To use it, we also added ``version.res`` to the list of dependencies of and the +command for ``lib`` in ``makefile.msc``. + After this, compile using ``nmake /f makefile.msc`` and copy the files ``bzlib.h``, ``libbz2.dll``, and ``libbz2.lib`` to a location where the MonetDB build process can find them, @@ -533,9 +624,9 @@ e.g. ``C:\bzip2-1.0.5.win32``. mt /nologo /manifest libbz2.dll.manifest /Outputresource:libbz2.dll;2 .. For a debug build, change the definition of CFLAGS to contain -.. ``-MDd -D_DEBUG -Od`` instead of ``-MD -Ox``, and change all -.. occurences of ``libbz2.dll`` and ``libbz2.lib`` to ``libbz2d.dll`` -.. and ``libbz2d.lib``. + ``-MDd -D_DEBUG -Od`` instead of ``-MD -Ox``, and change all + occurences of ``libbz2.dll`` and ``libbz2.lib`` to ``libbz2d.dll`` + and ``libbz2d.lib``. Fix the ``LIBBZ2`` definitions in ``buildtools\conf\winrules.msc`` so that they refer to the location where you installed the library and diff --git a/clients/R/MonetDB.R/R/dbi.R b/clients/R/MonetDB.R/R/dbi.R --- a/clients/R/MonetDB.R/R/dbi.R +++ b/clients/R/MonetDB.R/R/dbi.R @@ -46,8 +46,8 @@ setMethod("dbConnect", "MonetDBDriver", password="monetdb", host="localhost", port=50000L, timeout=86400L, wait=FALSE, language="sql", ..., url="") { - if (substring(url, 1, 10) == "monetdb://") { - dbname <- url + if (substring(dbname, 1, 10) == "monetdb://") { + url <- dbname } timeout <- as.integer(timeout) diff --git a/clients/R/Tests/survey.R b/clients/R/Tests/survey.R --- a/clients/R/Tests/survey.R +++ b/clients/R/Tests/survey.R @@ -2,8 +2,10 @@ ll <- NULL if (Sys.getenv("TSTTRGDIR") != "") { ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir") } -library(MonetDB.R,quietly=T,lib.loc=ll) -library(sqlsurvey,quietly=T) +suppressMessages({ + library(MonetDB.R,quietly=T,lib.loc=ll) + library(sqlsurvey,quietly=T) +}) args <- commandArgs(trailingOnly = TRUE) dbport <- 50000 diff --git a/clients/R/Tests/survey.stable.err b/clients/R/Tests/survey.stable.err --- a/clients/R/Tests/survey.stable.err +++ b/clients/R/Tests/survey.stable.err @@ -30,18 +30,8 @@ stderr of test 'survey` in directory 'cl # 14:26:23 > "R" "--vanilla" "--slave" "--args" "38676" # 14:26:23 > -KernSmooth 2.23 loaded -Copyright M. P. Wand 1997-2009 -Loading required package: grid -Attaching package: 'survey' +# 13:05:49 > +# 13:05:49 > "Done." +# 13:05:49 > -The following object is masked from 'package:graphics': - - dotchart - - -# 14:26:26 > -# 14:26:26 > "Done." -# 14:26:26 > - diff --git a/clients/Tests/MAL-signatures_all.stable.out b/clients/Tests/MAL-signatures_all.stable.out --- a/clients/Tests/MAL-signatures_all.stable.out +++ b/clients/Tests/MAL-signatures_all.stable.out @@ -138,8 +138,8 @@ command aggr.avg(b:bat[:oid,:bte],e:bat[ address AGGRavg12_dbl; comment Grouped tail average on bte -command aggr.avg(b:bat[:oid,:any_2]):dbl -address ALGavg; +pattern aggr.avg(b:bat[:oid,:any_2]):dbl +address CMDcalcavg; comment Gives the avg of all tail values function aggr.corr(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:dbl]; @@ -34544,7 +34544,7 @@ pattern calc.==(v1:bit,v2:bit):bit address CMDvarEQ; comment Return V1 == V2 -command calc.=(v:inet,w:inet):bit +command calc.==(v:inet,w:inet):bit address INET_comp_EQ; comment Equality of two inets @@ -41458,7 +41458,11 @@ pattern sql.copy_from(sname:str,tname:st address mvc_import_table_wrap; comment Import a table from bstream s with the given tuple and seperators (sep/rsep) -pattern sql.create_func_upgrade_oct2014(f:str):int +pattern sql.create_view_upgrade_oct2014(sname:str,v:str):int +address UPGcreate_view; +comment Create the view described by f, needed for the Oct2014 upgrade + +pattern sql.create_func_upgrade_oct2014(sname:str,f:str):int address UPGcreate_func; comment Create the function described by f, needed for the Oct2014 upgrade diff --git a/clients/Tests/MAL-signatures_all.stable.out.int128 b/clients/Tests/MAL-signatures_all.stable.out.int128 --- a/clients/Tests/MAL-signatures_all.stable.out.int128 +++ b/clients/Tests/MAL-signatures_all.stable.out.int128 @@ -149,8 +149,8 @@ command aggr.avg(b:bat[:oid,:bte],e:bat[ address AGGRavg12_dbl; comment Grouped tail average on bte -command aggr.avg(b:bat[:oid,:any_2]):dbl -address ALGavg; +pattern aggr.avg(b:bat[:oid,:any_2]):dbl +address CMDcalcavg; comment Gives the avg of all tail values function aggr.corr(e1:bat[:oid,:hge],e2:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:hge]; @@ -44521,7 +44521,7 @@ pattern calc.==(v1:bte,v2:hge):bit address CMDvarEQ; comment Return V1 == V2 -command calc.=(v:inet,w:inet):bit +command calc.==(v:inet,w:inet):bit address INET_comp_EQ; comment Equality of two inets @@ -52441,7 +52441,11 @@ pattern sql.copy_from(sname:str,tname:st address mvc_import_table_wrap; comment Import a table from bstream s with the given tuple and seperators (sep/rsep) -pattern sql.create_func_upgrade_oct2014(f:str):int +pattern sql.create_view_upgrade_oct2014(sname:str,v:str):int +address UPGcreate_view; +comment Create the view described by f, needed for the Oct2014 upgrade + +pattern sql.create_func_upgrade_oct2014(sname:str,f:str):int address UPGcreate_func; comment Create the function described by f, needed for the Oct2014 upgrade diff --git a/clients/Tests/MAL-signatures_fits_geom.stable.out b/clients/Tests/MAL-signatures_fits_geom.stable.out --- a/clients/Tests/MAL-signatures_fits_geom.stable.out +++ b/clients/Tests/MAL-signatures_fits_geom.stable.out @@ -138,8 +138,8 @@ command aggr.avg(b:bat[:oid,:bte],e:bat[ address AGGRavg12_dbl; comment Grouped tail average on bte -command aggr.avg(b:bat[:oid,:any_2]):dbl _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
