{"id":267,"date":"2017-02-25T14:11:33","date_gmt":"2017-02-25T14:11:33","guid":{"rendered":"https:\/\/reldb.org\/c\/?p=267"},"modified":"2017-02-25T14:11:59","modified_gmt":"2017-02-25T14:11:59","slug":"rel-version-3-006-now-available","status":"publish","type":"post","link":"https:\/\/reldb.org\/c\/index.php\/rel-version-3-006-now-available\/","title":{"rendered":"Rel version 3.006 now available!"},"content":{"rendered":"<p>This is a minor maintenance release of <em>Rel<\/em>, an implementation of Date &#038; Darwen&#8217;s <strong>Tutorial D<\/strong> database language. It makes some improvements to the <em>Rel<\/em> user interface, now provides a selection of built-in operators that previously had to be loaded from a script, and fixes various minor bugs.<\/p>\n<p><strong>IMPORTANT NOTE<\/strong>: Once opened with this or later versions of <em>Rel<\/em>, databases cannot be read by earlier versions.<\/p>\n<p>The following enhancements have been made:<\/p>\n<p>&#8211; In the <em>Rel<\/em> DBMS, all operators previously found in the UsefulOperatorsAndViews.rel script are now built-in, and the sys.OperatorsBuiltin relvar provides documentation of built-in relvars via the Definition attribute. In the <em>Rel<\/em> UI, this can be displayed by double-clicking on an Operator, or by pressing the associated Play button.<\/p>\n<p>&#8211; The <em>Rel<\/em> DBMS&#8217;s storage engine has been updated to Oracle Berkeley DB JE version 7.3.7<\/p>\n<p>&#8211; The <em>Rel<\/em> DBMS now supports external <em>Rel<\/em> DBMS relvars. This requires that a standalone <em>Rel<\/em> DBMS be running on the specified host.<br \/>\nE.g.:<br \/>\nVAR myvar EXTERNAL RELVAR &#8220;host,username,password,relvarname&#8221;;<br \/>\nVAR myvar EXTERNAL RELVAR &#8220;host,user,pass,vname,1234&#8221;; \/\/ port is 1234<\/p>\n<p>&#8211; The <em>Rel<\/em> DBMS now provides built-in QUOTE(CHAR) RETURNS CHAR and UNQUOTE(CHAR) RETURNS CHAR operators to quote\/unquote delimiters and special characters.<\/p>\n<p>The following bugs have been fixed:<\/p>\n<p>&#8211; <em>Rel<\/em> DBMS: External relvar column name cleanup erroneously turned \u2018g&#8217; and &#8216;i&#8217; to &#8216;_&#8217;. Fixed.<\/p>\n<p>&#8211; <em>Rel<\/em> DBMS: Extraneous spaces are no longer inserted into EXTERNAL ACCDB and EXTERNAL JDBC relvar definitions.<\/p>\n<p>&#8211; <em>Rel<\/em> DBMS: The UPDATE operator (not statement) allowed duplicate tuples to be emitted. Fixed.<\/p>\n<p>&#8211; <em>Rel<\/em> DBMS: The IN operator sometimes returned an incorrect result if the tuple operand had a different attribute order from the relation operand. Fixed.<\/p>\n<p>&#8211; <em>Rel<\/em> UI: In Rev, single quotes in a RESTRICT, EXTEND, SUMMARIZE or UPDATE expression caused the expression not to be saved. Fixed.<\/p>\n<p>For more information or to download <em>Rel<\/em>, go to <a href=\"http:\/\/reldb.org\">http:\/\/reldb.org<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a minor maintenance release of Rel, an implementation of Date &#038; Darwen&#8217;s Tutorial D database language. It makes some improvements to the Rel user interface, now provides a selection of built-in operators that previously had to be loaded from a script, and fixes various minor bugs. IMPORTANT NOTE: Once opened with this or <a href=\"https:\/\/reldb.org\/c\/index.php\/rel-version-3-006-now-available\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Rel version 3.006 now available!<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-267","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":2,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":269,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/267\/revisions\/269"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media\/165"}],"wp:attachment":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}