6. Changelog

Each release is named after space stuff, with each release starting with a successive alphabet letter.

6.1. v1.0.0-alpha1 (Aurora)

This was the initial release and its goal was to get the most basic implementations of SELECT, INSERT, UPDATE and DELETE working.

  1. SELECT statement supports single expression from a single table, with support for ORDER BY on a single column. [#6]
  2. DELETE statement with WHERE clause. [#7]
  3. UPDATE statement with WHERE clause. [#8]
  4. INSERT statement.
  5. CREATE NOTIFICATION and DROP NOTIFICATION. [#3]
  6. Added logical operators: AND, OR and NOT.
  7. Added containment operators: BETWEEN and NOT BETWEEN.
  8. Added mathematical operators: +, -, *, /, ^ and %.
  9. Added comparison operators: =, <>, <, >, <=, >= and alias !=.
  10. Added set membership operators: IN and NOT IN.
  11. Added type checking operators: IS and IS NOT. [#2]
  12. Added pattern matching operators: LIKE and NOT LIKE. [#1]
  13. Added functions: ABS(), BIT_LENGTH(), CEIL(), CHAR_LENGTH(), FLOOR(), OCTET_LENGTH(). [#4]

6.2. v1.0.0-alpha2 (Binary Star)

The focus of this release was on GROUP BY and aggregate functions.

  1. GROUP BY single column for SELECT. [#10]
  2. Added aggregate functions AVG(), COUNT(), MAX(), MIN() and SUM(). [#10]
  3. Added string concatenation (||) operator. [#9]
  4. Added ILIKE and NOT ILIKE operators. [#11]
  5. Reformatted documentation to work with Rippledoc. [#11]

6.3. v1.0.0-alpha3 (Comet)

This releases theme was indexing. At the moment only exact lookups are supported.

  1. Added support for LIMIT and OFFSET. [#12]
  2. Added support for EXPLAIN on SELECT queries. [#14]
  3. Added CREATE INDEX and DROP INDEX. [#15]
  4. Added COS(). [#13]
  5. Added SIN(). [#13]
  6. Added SQRT(). [#13]
  7. Added TAN(). [#13]
  8. The query planner now understands some basic impossible WHERE clauses.

6.4. v1.0.0-alpha4 (Dark Matter)

The focus of this release was on supporting transactions.

  1. Support for START TRANSACTION, COMMIT and ROLLBACK. [#16] [#17]
  2. Refactored documentation for Sphinx, hosted on tesseractdb.readthedocs.org.