# Release notes

• Version: 2.1
• Release date: 2019-10-21

# Changes

• Support for Multiple Field Indexes added:

  CREATE INDEX p_name_lastname ON person (name, lastname)  
  SELECT * FROM person WHERE name = 'Lamar' and lastname = 'Tanon'
  

• Indexes now can be used for range queries:

  select * from person where age > 21 and age < 25
  

• Support for new data types added: Int2, int4, int8, timestamp
• Operator UNION support is implemented
• Significantly expanded support for JOIN operations
  • JOIN through foreign-key
  • JOIN through plain fields (non-foreign-key)
  • JOIN through several fields
  • left/right outer JOIN
  • JOIN with the result of a subquery
• Implemented 2 different syntax for the CASE statement:

  case name when ‘Vasya’ then 1 else 0 end
  case when name = ‘Vasya’ and age > 21 then 1 else 0 end
  

• cast (a as int) operator added (alternative a::int syntax)
• support for nested queries in from clause
• support for nested queries in in operator
• operator like is added
• added functions to get database schema