7.1 Pre-release

7.1 Alpha1 is now available. Even though 7.0 was just released, we have been working hard to pack more features and fixes into 7.1. What is already available:

SQL Support

• Added NULLS FIST/LAST handling - including pushdown support.
  
• Added enhanced numeric stat aggregate functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, with pushdown and aggregate decomposition.
  
• Added support for the boolean aggregate functions ANY, SOME, EVERY.
  
• Added support for using boolean value expression as both criteria and expressions, e.g. "... where boolean_value" or "select x = 1 as boolean_value ...".
  
• Changed named procedure syntax to accept param=>value, rather than param=value.
  

Parallel Source Queries - reestablished parallel execution of source queries within a query plan along with a prioritized work system to help prevent resource contention.

SHOW Statement - added client handling for the SHOW statement to retrieve query plan information and see execution property values.

ODBC access and many caching improvements will be coming shortly.

The Teiid Team