age

This release adds the following enhancements and functionality:

• Add an upgrading SQL script file from 0.5.0 to 0.6.0
• Add upgrading file age--0.6.0--0.7.0.sql
• Refactor function get_agtype_value_object_value
• Age load issue (issue #188)
• Refactor agtype_access_operator
• Bugfix - Remove INLINE from function declaration
• Rebase VLE code
• Implement Merge Clause
• Bugfix: chained union logic
• Allow a path of one vertex
• Created functions for load graph from CSV files
• Add UNION into EXPLAIN grammar rule
• Implement UNWIND clause(issue #173)
• Bugfix:(nodejs) Corrects parsing for independence value(issue #177)
• Feat: Implement OPTIONAL MATCH (issue #175)

• The release supports the following:
  • Refactor and bug fix of DELETE’s usage of currentCommandId.
  • Add Labels creation functions (issue #115).
  • Refactor and bug fix of SET’s usage of currentCommandId.
  • Add regular expression comparisons with ‘~=’.
  • Add relationships() function.
  • Add range() function.
  • Add keys() function.
  • Update README.
  • Add labels() function.
  • Add nodes() function.
  • Add XOR operator.
  • Fix Mac OS X compilation (issue #82).
  • Create issue templates (issue #90).
  • Fix nodejs driver (issue #104).
  • Add reverse() function for lists.
  • Refactor code for CREATE vertex and edge labels (issue #136).
  • Add AGTYPE parser and driver support to Python and Golang.
  • Fix incorrect parse tree for EXISTS (issue #141).
  • Add VLE core to the MATCH clause.
  • Fix licensing issues in the master branch.
  • Refactor VLE edge uniqueness.
  • Add AGTYPE and GRAPHID send and receive functions.
  • Add precision parameter to round().
  • Fix SET clause (issue #165).
  • Add typecasting to int4[].
  • Updated documentation.
  • Add new docker file.
  • Add zero boundary case to VLE.
  • Add ASF licenses for Python and Golang drivers.
  • Fix for zero boundary case.
  • Fix for paths of length one.

• The release supports the following:
  • Add VLE SRF (Set Returning Function).
  • Fix Vertex, Edge, and Path serialization bug (AGE2-307).
  • Fix CREATE passback bug (AGE2-337).
  • Fix CREATE transaction block bug (AGE2-345).
  • Fix parallel build errors.
  • Fix Travis CI compiler warnings.

• The release supports the following:
  • Added Support for Agtype to be used in Hash Joins
  • Added Support for DELETE to be the last clause in a Cypher statement
  • Fixed a bug where DELETE, REMOVE, and SET would not update a vertex/edge
  • Added support for SKIP and LIMIT as sub-clauses for the WITH and RETURN statement
  • Added support for CASE statement
  • Added support for PostgreSQL EXPLAIN utility command
  • Added operator overload for agtype to numeric
  • Added ANTLR4 grammar file to be used with the JDBC and NodeJS drivers
  • Added NULL regression tests
  • Added label function

• The release supports the following:
  • Added Auto Group By aggregation support for RETURN and WITH clauses.
  • Added support for more input types in aggregate functions.
  • Added support for DISTINCT in functions.
  • Added explicit type cast from AGTYPEOID to TEXTOID.
  • Added explicit type casting Agtype to PG's shortint, int, and Bigint
  • Added type casting from AGTYPEOID to INT8OID and FLOATOID. For use with user defined (non-AGE) functions within the cypher query.
  • Added overloading for INT8OID mathematical operators.
  • Added * and optional edge grammar components.
  • Changed input types for typecasting functions to “any”.
  • Added support for the DELETE clause.
  • Added support for Stored Procedures and PL/pgSQL.
  • Added a basic agtype parser for the NodeJS driver.

• Added openCypher functionality for standard and user defined functions.

  • Added the following openCypher functions:
    • Trigonometric: e, sqrt, exp, log, log10, degrees, radians, pi, sin, cos, tan, asin, acos, atan, & atan2.
    • String: replace, split, left, right, substring, rTrim, lTrim, trim, toUpper, toLower, reverse, & toString.
    • Numeric: rand, abs, ceil, floor, round, & sign.
  • Added user defined functions of the form:
    • schema.function

• Currently working on aggregate function support.

  • Added the following openCypher aggregate functions:
    • min, max, stDev, stDevP, percentileCont, percentileDisc & count.
    • avg & sum are added but may need to be reworked.

• Added Exists clause:

  • exists(property)
  • exists(pattern)

• Property Constraints

  • The MATCH clause supports using property constraints.

• Set Clause Added

  • Support for updating a single property value
  • Multiple SET clauses can be used in a single query
  • Supported to work with MATCH, CREATE, and REMOVE clauses

• Remove Clause Added

  • Support for removing a single property values
  • Multiple REMOVE clauses can be used in a single query
  • Supported to work with MATCH, CREATE, and SET clauses

• Define Extension’s Behaviour when dropped

  • Added a process to occur when the extension is dropped in Postgres.

• Extend Agtype
  • Support for Numeric types.
  • Support for Edge types.
  • Support for Path types.
• Type Casting
  • Type annotations ‘::’ can be added to scalar values, arrays and objects.
  • Casting to a numeric ‘::numeric’ from an integer, float, or string.
  • Casting to a float ‘::float’ from an integer, numeric, or string.
  • Addition of float constants (inf, -inf, NaN) to string input and output.
  • Casting to a vertex ‘::vertex’ from an agtype object.
  • Casting to an edge “::edge’ from an agtype object.
  • Casting to a path ‘::path’ from an agtype array.
• Scalar Functions
  • id() Returns the id of a vertex or edge.
  • start_id() Returns the start id of a vertex or edge.
  • end_id() Returns the end id of a vertex or edge.
  • type() Returns the relationship name of an edge.
  • properties() Returns the properties object of a vertex or edge.
  • head() Returns the head of a list.
  • last() Returns the last element in a list.
  • length() Returns the length of a path.
  • size() Returns the length of a string or the number of elements in a list.
  • startNode() Returns the start vertex for an edge.
  • endNode() Returns the end vertex for an edge.
  • timestamp() Returns the system time in milliseconds from Epoch.
  • toBoolean() Converts a string to a boolean.
  • toFloat() Converts an integer, numeric, or string to a float.
  • toInteger() Converts a float, numeric, or string to an integer.
  • coalesce() Returns the first non null expression in a list of expressions.
• Labels for Vertices/Edges
  • Newly created Edges can be assigned with a label.
  • Newly created Labels vertices do not require a label.
• Improve Match Clause
  • Support Edges - Match clauses support paths.
  • Support Patterns - Match clauses support multiple paths.
  • Support Vertices with no variable assignment.
  • Support Edges and Paths with variable assignment.
• Improve Create Clause
  • Support Edges - Create Clause supports paths.
  • Support Patterns - Create Clause supports multiple paths.

This release supports the following openCypher clauses.

• CREATE clause with a node that has a label
  • It must be in queries by itself.
• MATCH clause with a node that has a label
• RETURN clause without aggregation
• WITH clause without aggregation

Function call expression is not supported.

For more information, please refer to the documentation in doc/ directory.