From owner-svn-ports-head@freebsd.org Fri Jun 5 18:05:05 2020 Return-Path: Delivered-To: svn-ports-head@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 093AC333157; Fri, 5 Jun 2020 18:05:05 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 49drCN4rbMz4RgT; Fri, 5 Jun 2020 18:05:04 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id A19AB1518D; Fri, 5 Jun 2020 18:05:04 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id 055I54B7079022; Fri, 5 Jun 2020 18:05:04 GMT (envelope-from pi@FreeBSD.org) Received: (from pi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id 055I543i079020; Fri, 5 Jun 2020 18:05:04 GMT (envelope-from pi@FreeBSD.org) Message-Id: <202006051805.055I543i079020@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: pi set sender to pi@FreeBSD.org using -f From: Kurt Jaeger Date: Fri, 5 Jun 2020 18:05:04 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r538042 - head/databases/cego X-SVN-Group: ports-head X-SVN-Commit-Author: pi X-SVN-Commit-Paths: head/databases/cego X-SVN-Commit-Revision: 538042 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 05 Jun 2020 18:05:05 -0000 Author: pi Date: Fri Jun 5 18:05:04 2020 New Revision: 538042 URL: https://svnweb.freebsd.org/changeset/ports/538042 Log: databases/cego: update 2.45.9 -> 2.45.16 - Fix in CegoBtreeManager for duplicate null handling. The corresponding btree value has to be checked to be null. For this, the method CegoBTreeValue::isNull has been introduced - Fix in CegoFieldValue::negate, for FIXED_TYPE values, trailing zeros have to be treated. Otherwise, select null - a from t1 where a = 0.10 will result in 0.1 - Patch in 'update with return' clause. It seems to be useful, that in combination with return, update should return after first matching tuple providing the updated tuple in the return clause. So the values for the tuple can be stored in procedure variables. create table t1 ( a int, b string(30)); insert into t1 values ( 1, 'DONE'); insert into t1 values ( 2, 'DONE'); insert into t1 values ( 3, 'WAIT'); insert into t1 values ( 4, 'DONE'); insert into t1 values ( 5, 'WAIT'); update t1 set b = 'DONE' where b = 'WAIT' return :a = a; Just the tuple with a = 3 is update and the value of a is returned in the procedure variable :a - For update with return statements, added the on first option. Since the return variable can only store one return values, this option specifies, if the update should return after first tuple or if all matching tuples should be updated. - In CegoMain, changed separator token for tsdef from ":;" to "=", since for mingw configurations, absolute path handling was broken. This resulted in adapations for mkdb and cgmkdb scripts. - Fix in CegoObjectManager::getObjectListByTable, if object does not exist, an exception is thrown now. This resulted in a fix for CegoQueryHelper::checkIndexForPredicate, where now the table alias has to be mapped to the correct physical table name ( via coList as a new method argument ) - Fix in CegoAttrDesc::evalTableReferences to treat alias objects in joins - Grammar expansion to support inner/left outer/right outer joins without a condition. This might be useful for specific join order to use appropriate table indices ( see dbcheck/check088.sql ) - Fix in CegoQueryHelper::checkIndexForPredicate, index evaluation for alias objects was still not treated - Fix in CegoDistCursor::getPlan and CegoAction::getJoinPlanString to cover execution plan for alias objects Submitted by: Björn Lemke Modified: head/databases/cego/Makefile head/databases/cego/distinfo Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Fri Jun 5 17:56:22 2020 (r538041) +++ head/databases/cego/Makefile Fri Jun 5 18:05:04 2020 (r538042) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.45.9 +PORTVERSION= 2.45.16 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Fri Jun 5 17:56:22 2020 (r538041) +++ head/databases/cego/distinfo Fri Jun 5 18:05:04 2020 (r538042) @@ -1,3 +1,3 @@ -TIMESTAMP = 1575231065 -SHA256 (cego-2.45.9.tar.gz) = 18760a58fca980b33ad408d9f42c614bd282cf30a7d52068bd6dad753dbcda5b -SIZE (cego-2.45.9.tar.gz) = 3152889 +TIMESTAMP = 1591378135 +SHA256 (cego-2.45.16.tar.gz) = 31168d3e6c5b30693c5d7a412ac25a8604c1fcead9e7250ceb6cfd91bf97170b +SIZE (cego-2.45.16.tar.gz) = 3154656