Changeset: b5c2c1a3240c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b5c2c1a3240c Added Files: sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.sql sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.stable.err sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.stable.out sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.reqtests sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.sql sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.stable.err sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.stable.out sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.sql sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.err sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out testing/Mfilter.py Removed Files: testing/Mfilter.py.in Modified Files: .hgtags MonetDB.spec NT/installer32/MonetDB-ODBC-Installer.vdproj NT/installer32/MonetDB5-Geom-Module.vdproj NT/installer32/MonetDB5-SQL-Installer.vdproj NT/installer64/MonetDB-ODBC-Installer.vdproj NT/installer64/MonetDB5-Geom-Module.vdproj NT/installer64/MonetDB5-SQL-Installer.vdproj NT/monetdb_config.h.in NT/rules.msc clients/ChangeLog-Archive clients/ChangeLog.Jul2015 clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.sql clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/mapiclient/dump.c clients/mapiclient/mclient.c clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc clients/python2/setup.py clients/python3/setup.py configure.ag debian/changelog debian/monetdb-testing-python.install gdk/gdk_logger.c gdk/gdk_private.h gdk/gdk_utils.c gdk/libbat.rc java/Makefile.ag java/build.properties java/pom.xml java/release.txt libversions monetdb5/extras/rapi/rapi.c monetdb5/modules/atoms/inet.c monetdb5/modules/atoms/json.mal monetdb5/modules/atoms/uuid.mal monetdb5/modules/atoms/xml.c monetdb5/tools/libmonetdb5.rc sql/ChangeLog sql/backends/monet5/Tests/All sql/backends/monet5/Tests/rapi14.sql sql/backends/monet5/Tests/rapi14.stable.err sql/backends/monet5/Tests/rapi14.stable.out sql/backends/monet5/UDF/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/Tests/udf-reverse.stable.out sql/backends/monet5/bam/bam_export.c sql/backends/monet5/sql_gencode.c 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/04-explain.stable.out 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/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11-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/14-explain.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/15-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/19-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2015/Tests/All sql/test/mapi/Tests/sql_int128.stable.out sql/test/testdb/Tests/testdb-dump.stable.out sql/test/testdb/Tests/testdb-dump.stable.out.Windows sql/test/testdb/Tests/testdb-load.sql testing/Makefile.ag testing/Mtest.py.in vertoo.data Branch: embedded Log Message:
merge with default diffs (truncated from 12449 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -605,3 +605,5 @@ 30be7bd4aec0b5daf3d2f3a26a1043c04b88bb6d c7c0a76e663e34bcddae683b385c8e5a919ffd84 Jul2015_5 30be7bd4aec0b5daf3d2f3a26a1043c04b88bb6d Jul2015_release c7c0a76e663e34bcddae683b385c8e5a919ffd84 Jul2015_release +d1bce2fabbc36a3a3b996b09e55e764a626026a8 Jul2015_7 +d1bce2fabbc36a3a3b996b09e55e764a626026a8 Jul2015_SP1_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -91,7 +91,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPL - http://www.monetdb.org/Legal/MonetDBLicense URL: http://www.monetdb.org/ -Source: http://dev.monetdb.org/downloads/sources/Jul2015/%{name}-%{version}.tar.bz2 +Source: http://dev.monetdb.org/downloads/sources/Jul2015-SP1/%{name}-%{version}.tar.bz2 BuildRequires: bison BuildRequires: bzip2-devel @@ -920,7 +920,6 @@ developer, but if you do want to test, t # %exclude %{_bindir}/*.pyc # %exclude %{_bindir}/*.pyo %{_bindir}/Mapprove.py -%{_bindir}/Mfilter.py %{_bindir}/Mtest.py %dir %{python_sitelib}/MonetDBtesting %{python_sitelib}/MonetDBtesting/* @@ -996,6 +995,42 @@ rm -f %{buildroot}%{_bindir}/Maddlog %postun -p /sbin/ldconfig %changelog +* Tue Oct 20 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- Rebuilt. +- BZ#3789: Query on large string table fails on HEAPextend +- BZ#3794: table function sys.rejects() and view sys.rejects() are listed + are metadata objects but give an (incorrect) error when they are queried +- BZ#3797: COPY INTO with incorrect number columns +- BZ#3798: SELECT query with INTERSECT causes assertion failure +- BZ#3800: LIKE is broken for many patterns +- BZ#3802: Disk space never freed: a logical ref is keeped on a deleted + BATs +- BZ#3803: SQL query parser fails to parse valid SELECT query with a + CASE .. END in it. It fails with parser error: identifier 'x' ambiguous +- BZ#3804: `monetdb status` command crashes under certain conditions +- BZ#3809: Inefficient plan is generated for queries with many (>= 24) + joined tables which take a long time or an HEAPalloc error. I get Error: + GDK reported error. HEAPalloc: Insufficient space for HEAP of 400000000 + bytes. +- BZ#3810: Fix statistics gathering +- BZ#3811: NOT LIKE not working if the operand doesn't contains wildcards. +- BZ#3813: COPY INTO fails on perfectly clean CSV file +- BZ#3814: Server crash when using bitwise NOT operation in SQL query +- BZ#3818: Crash when performing UNION/GROUP BY over tables with + different columns +- BZ#3819: order of tables in FROM-clause has negative impact on generated + plan (using crossproducts instead of joins) +- BZ#3820: mclient accepts table with repeated constraint which causes + crash on insert +- BZ#3821: Unexpected error when using a number instead of a boolean +- BZ#3822: Yet another LIKE operator issue +- BZ#3825: MonetDB not cleaning intermediate results which leads to + filling up disk space and ultimately server crash + +* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- clients: In the SQL formatter of mclient (the default) we now properly align + East Asian wide characters. + * Mon Aug 24 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.5-20150824 - Rebuilt. - BZ#3730: SAMPLE function not sampling randomly diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive --- a/clients/ChangeLog-Archive +++ b/clients/ChangeLog-Archive @@ -1,6 +1,10 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- In the SQL formatter of mclient (the default) we now properly align + East Asian wide characters. + * Thu Feb 19 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.1-20150807 - Added a new output format to mclient: --format=expanded (or -fx). In this format, column values are shown in full and below each other. diff --git a/clients/ChangeLog.Jul2015 b/clients/ChangeLog.Jul2015 --- a/clients/ChangeLog.Jul2015 +++ b/clients/ChangeLog.Jul2015 @@ -1,7 +1,3 @@ # ChangeLog file for clients # This file is updated with Maddlog -* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> -- In the SQL formatter of mclient (the default) we now properly align - East Asian wide characters. - 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 @@ -3121,6 +3121,30 @@ command batxml.xml(src:bat[:oid,:str]):b address BATXMLstr2xml; comment Cast the string to an xml compliant string. +command batmtime.diff(b1:bat[:oid,:timestamp],b2:bat[:oid,:timestamp]):bat[:oid,:lng] +address MTIMEtimestamp_diff_bulk; +comment Difference of two sets of timestamp. + +command batmtime.diff(b1:bat[:oid,:date],b2:bat[:oid,:date]):bat[:oid,:int] +address MTIMEdate_diff_bulk; +comment Difference of two sets of date. + +command batmtime.day(d:bat[:oid,:date]):bat[:oid,:int] +address MTIMEdate_extract_day_bulk; +command batmtime.hours(d:bat[:oid,:daytime]):bat[:oid,:int] +address MTIMEdaytime_extract_hours_bulk; +command batmtime.milliseconds(d:bat[:oid,:daytime]):bat[:oid,:int] +address MTIMEdaytime_extract_milliseconds_bulk; +command batmtime.minutes(d:bat[:oid,:daytime]):bat[:oid,:int] +address MTIMEdaytime_extract_minutes_bulk; +command batmtime.month(d:bat[:oid,:date]):bat[:oid,:int] +address MTIMEdate_extract_month_bulk; +command batmtime.sql_seconds(d:bat[:oid,:daytime]):bat[:oid,:int] +address MTIMEdaytime_extract_sql_seconds_bulk; +command batmtime.seconds(d:bat[:oid,:daytime]):bat[:oid,:int] +address MTIMEdaytime_extract_seconds_bulk; +command batmtime.year(d:bat[:oid,:date]):bat[:oid,:int] +address MTIMEdate_extract_year_bulk; pattern batcalc.!=(v:dbl,b:bat[:oid,:dbl],s:bat[:oid,:oid]):bat[:oid,:bit] address CMDbatNE; comment Return V != B with candidates list @@ -4441,6 +4465,14 @@ pattern batcalc.!=(b1:bat[:oid,:date],b2 address CMDbatNE; comment Return B1 != B2 +pattern batcalc.!=(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatNE; +comment Return B1 != B2 + +pattern batcalc.!=(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatNE; +comment Return B1 != B2 + pattern batcalc.%(v:dbl,b:bat[:oid,:dbl],s:bat[:oid,:oid]):bat[:oid,:dbl] address CMDbatMODsignal; comment Return V % B with candidates list, signal error on divide by zero @@ -15049,6 +15081,22 @@ pattern batcalc.<(b1:bat[:oid,:date],b2: address CMDbatLT; comment Return B1 < B2 +pattern batcalc.<=(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatLE; +comment Return B1 <= B2 + +pattern batcalc.<(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatLT; +comment Return B1 < B2 + +pattern batcalc.<=(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatLE; +comment Return B1 <= B2 + +pattern batcalc.<(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatLT; +comment Return B1 < B2 + pattern batcalc.==(v:dbl,b:bat[:oid,:dbl],s:bat[:oid,:oid]):bat[:oid,:bit] address CMDbatEQ; comment Return V == B with candidates list @@ -16369,6 +16417,14 @@ pattern batcalc.==(b1:bat[:oid,:date],b2 address CMDbatEQ; comment Return B1 == B2 +pattern batcalc.==(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatEQ; +comment Return B1 == B2 + +pattern batcalc.==(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatEQ; +comment Return B1 == B2 + pattern batcalc.>=(v:dbl,b:bat[:oid,:dbl],s:bat[:oid,:oid]):bat[:oid,:bit] address CMDbatGE; comment Return V >= B with candidates list @@ -19609,6 +19665,22 @@ pattern batcalc.>(b1:bat[:oid,:date],b2: address CMDbatGT; comment Return B1 > B2 +pattern batcalc.>=(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatGE; +comment Return B1 >= B2 + +pattern batcalc.>(b1:bat[:oid,:json],b2:bat[:oid,:json]):bat[:oid,:bit] +address CMDbatGT; +comment Return B1 > B2 + +pattern batcalc.>=(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatGE; +comment Return B1 >= B2 + +pattern batcalc.>(b1:bat[:oid,:uuid],b2:bat[:oid,:uuid]):bat[:oid,:bit] +address CMDbatGT; +comment Return B1 > B2 + pattern batcalc.avg(b:bat[:oid,:dbl],s:bat[:oid,:oid]) (X_3:dbl,X_4:lng) address CMDcalcavg; comment average and number of non-nil values of B with candidates list @@ -30697,6 +30769,7 @@ command batcalc.timestamp(secs:bat[:oid, address MTIMEtimestamp_bulk; command batcalc.timestamp(d:bat[:oid,:date]):bat[:oid,:timestamp] address MTIMEtimestamp_create_from_date_bulk; +function batcalc.uuid(u:bat[:oid,:uuid]):bat[:oid,:uuid]; command batcalc.wrd(s1:int,v:bat[:oid,:lng],d2:int,s2:int):bat[:oid,:wrd] address batlng_dec2dec_wrd; comment cast decimal(lng) to decimal(wrd) and check for overflow @@ -31087,30 +31160,6 @@ comment Return B1 XOR B2 command batcalc.xml(src:bat[:oid,:str]):bat[:oid,:xml] address BATXMLstr2xml; -command batmtime.diff(b1:bat[:oid,:timestamp],b2:bat[:oid,:timestamp]):bat[:oid,:lng] -address MTIMEtimestamp_diff_bulk; -comment Difference of two sets of timestamp. - -command batmtime.diff(b1:bat[:oid,:date],b2:bat[:oid,:date]):bat[:oid,:int] -address MTIMEdate_diff_bulk; -comment Difference of two sets of date. - -command batmtime.day(d:bat[:oid,:date]):bat[:oid,:int] -address MTIMEdate_extract_day_bulk; -command batmtime.hours(d:bat[:oid,:daytime]):bat[:oid,:int] -address MTIMEdaytime_extract_hours_bulk; -command batmtime.milliseconds(d:bat[:oid,:daytime]):bat[:oid,:int] -address MTIMEdaytime_extract_milliseconds_bulk; -command batmtime.minutes(d:bat[:oid,:daytime]):bat[:oid,:int] -address MTIMEdaytime_extract_minutes_bulk; -command batmtime.month(d:bat[:oid,:date]):bat[:oid,:int] -address MTIMEdate_extract_month_bulk; -command batmtime.sql_seconds(d:bat[:oid,:daytime]):bat[:oid,:int] -address MTIMEdaytime_extract_sql_seconds_bulk; -command batmtime.seconds(d:bat[:oid,:daytime]):bat[:oid,:int] -address MTIMEdaytime_extract_seconds_bulk; -command batmtime.year(d:bat[:oid,:date]):bat[:oid,:int] -address MTIMEdate_extract_year_bulk; command batmkey.hash(b:bat[:oid,:any_1]):bat[:oid,:wrd] address MKEYbathash; comment calculate a hash value @@ -31705,6 +31754,14 @@ pattern calc.!=(v:date,w:date):bit address CMDvarNE; comment Equality of two dates +pattern calc.!=(l:json,r:json):bit +address CMDvarNE; +comment Return V1 != V2 + +pattern calc.!=(l:uuid,r:uuid):bit +address CMDvarNE; +comment Return V1 != V2 + pattern calc.%(v1:dbl,v2:dbl):dbl address CMDvarMODsignal; comment Return V1 % V2, signal error on divide by zero @@ -33809,6 +33866,22 @@ pattern calc.<(v:date,w:date):bit address CMDvarLT; comment Equality of two dates +pattern calc.<=(l:json,r:json):bit +address CMDvarLE; +comment Return V1 <= V2 + +pattern calc.<(l:json,r:json):bit +address CMDvarLT; +comment Return V1 < V2 + +pattern calc.<=(l:uuid,r:uuid):bit +address CMDvarLE; +comment Return V1 <= V2 + +pattern calc.<(l:uuid,r:uuid):bit +address CMDvarLT; +comment Return V1 < V2 + pattern calc.==(v1:dbl,v2:dbl):bit address CMDvarEQ; comment Return V1 == V2 @@ -34033,9 +34106,13 @@ pattern calc.==(v:date,w:date):bit address CMDvarEQ; comment Equality of two dates -command calc.==(l:uuid,r:uuid):bit -address UUIDequal; -comment Compare two UUID values for equality +pattern calc.==(l:json,r:json):bit +address CMDvarEQ; +comment Return V1 == V2 + +pattern calc.==(l:uuid,r:uuid):bit +address CMDvarEQ; +comment Return V1 == V2 pattern calc.>=(v1:dbl,v2:dbl):bit _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
