{"id":275,"date":"2017-04-13T15:00:58","date_gmt":"2017-04-13T14:00:58","guid":{"rendered":"https:\/\/reldb.org\/c\/?p=275"},"modified":"2017-04-13T15:44:18","modified_gmt":"2017-04-13T14:44:18","slug":"rel-version-3-007-now-available","status":"publish","type":"post","link":"https:\/\/reldb.org\/c\/index.php\/rel-version-3-007-now-available\/","title":{"rendered":"Rel version 3.007 now available!"},"content":{"rendered":"

This is a minor release of Rel<\/em>, an implementation of Date & Darwen’s Tutorial D<\/strong> database language. It adds EQUIV and RANK operators, slightly tweaks the Tutorial D<\/strong> grammar implementation to reduce the need for parentheses, provides infix invocation for certain operators, and fixes some bugs.<\/p>\n

The following enhancements have been made to the Rel<\/em> implementation of Tutorial D<\/strong>:<\/p>\n

– Infix syntax for EXTEND, SUMMARIZE and UPDATE expressions is now available. The prefix syntax has been retained, but these are now allowed:<\/p>\n

S EXTEND {SS := STATUS}
\n S EXTEND: {SS := STATUS}
\n S SUMMARIZE BY {CITY} {SS := SUM(STATUS)}
\n S SUMMARIZE BY {CITY}: {SS := SUM(STATUS)}
\n S UPDATE {STATUS := 2}
\n S UPDATE: {STATUS := 2}<\/code><\/p>\n

– Dyadic and monadic relational operators now have equal precedence, except WHERE (lower precedence) and projection (higher precedence). This means operators may often be “chained” naturally without requiring parentheses. E.g., S RENAME {CITY AS PLACE} WRAP {PLACE, STATUS} AS T is allowed, where previously (S RENAME {CITY AS PLACE}) WRAP {PLACE, STATUS} AS T would have been required. This should not affect existing code.<\/p>\n

– RANK has been implemented, per Date & Darwen’s “Data Types and the Relational Model”. Both prefix and infix syntax are available:<\/p>\n

RANK S BY (ASC STATUS AS Ranking)
\n S RANK BY (ASC STATUS AS Ranking)
\n S RANK (ASC STATUS AS Ranking)<\/code><\/p>\n

– EQUIV has been implemented, per Date & Darwen’s “Database Explorations”.<\/p>\n

The following bugs have been fixed:<\/p>\n

– Case #139 – #142: In the Rel<\/em> UI, a fatal error was sometimes inappropriately generated when a query was cancelled in the command-line view. This has been fixed.<\/p>\n

– Case #153: Errors in built-in or user-defined Java-based operators now generate an error message rather than causing a fatal error.<\/p>\n","protected":false},"excerpt":{"rendered":"

This is a minor release of Rel, an implementation of Date & Darwen’s Tutorial D database language. It adds EQUIV and RANK operators, slightly tweaks the Tutorial D grammar implementation to reduce the need for parentheses, provides infix invocation for certain operators, and fixes some bugs. The following enhancements have been made to the Rel Read more about Rel version 3.007 now available!<\/span>[…]<\/a><\/p>\n","protected":false},"author":1,"featured_media":117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-275","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\/275","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=275"}],"version-history":[{"count":4,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/275\/revisions"}],"predecessor-version":[{"id":279,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/275\/revisions\/279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media\/117"}],"wp:attachment":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media?parent=275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/categories?post=275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/tags?post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}