============================================================================== 
Simba JDBC Driver with SQL Connector for Google BigQuery Release Notes 
============================================================================== 

The release notes provide details of enhancements, features, known issues, 
and workflow changes in Simba JDBC Driver for Google BigQuery 1.2.2, as well 
as the version history. 


1.2.2 ========================================================================

Released 2019-09-23

Enhancements & New Features 

 * [GBQJ-303] Avro library update
 
   The driver now uses Avro version 1.9.

   As a result of this update, the driver no longer supports JDBC 4.1. For 
   more information, see "Workflow Changes" in this document.


Resolved Issues
The following issues have been resolved in Simba JDBC Driver for Google 
BigQuery 1.2.2. 

 * [GBJQ-298] Some data types are returned differently in nested ARRAY and 
   STRUCT formats than they are in flat data.

   This issue has been resolved. The following data types in nested ARRAY and 
   STRUCT formats are now returned differently to match the representation 
   that would be expected if they were in flat columns:
   - BYTES
   - DATE
   - DATETIME
   - NUMERIC
   - TIME
   - TIMESTAMP

   Note: The Storage API returns NUMERIC data in a nested ARRAY or STRUCT 
   with trailing zeroes. The REST API trims the trailing zeroes.

 * [GBQJ-309] The driver incorrectly rounds BigDecimal parameter values that 
   are bound to prepared statements. 


Known Issues
The following are known issues that you may encounter due to limitations in
the data source, the driver, or an application.

 * TRACE level logs incorrectly contain stack trace for function entrances.

   When logging at the TRACE level (LogLevel=6), function entrance logs are 
   generated for each function that is called. These logs incorrectly 
   include a stack trace.

 * Query prefixes are not supported.

   The driver does not support query prefixes. To specify whether your query
   statements are to be processed using standard SQL or legacy BigQuery SQL, 
   you must configure the QueryDialect connection property. 

   By default, QueryDialect is set to "SQL" so that the driver uses standard
   SQL syntax. To use BigQuery SQL instead, set the property to "BIG_QUERY".

 * Support for ODBC Escape Sequences is limited.

   The only supported ODBC Escape Sequences are Scalar Functions of the form 
   {fn func(args)} if func is supported by the Google BigQuery data source 
   engine. 

 * When casting data, you must specify the data type according to Google 
   BigQuery standards.

   When casting data to a specific data type, you must use the corresponding 
   data type name shown in the "Casting" section of the Query Reference:
   https://cloud.google.com/bigquery/sql-reference/functions-and-operators#casting. 

   For example, to cast the "salary" column to the INTEGER type, you must 
   specify INT64 instead of INTEGER: 

      SELECT position, CAST(salary AS INT64) from Employee


Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver. 


1.2.2 ------------------------------------------------------------------------

 * Removed support for JDBC 4.1 (Java 7)

   Beginning with this release, the driver no longer supports JDBC 4.1 (Java 
   7). Only JDBC 4.2 (Java 8) is supported.


Version History ==============================================================

1.2.1 ------------------------------------------------------------------------

Released 2019-05-15

Enhancements & New Features 

 * [GBQJ-291] Updated Google Cloud BigQuery Storage API
 
   The driver has been updated to use version 0.85 of the Google Cloud 
   BigQuery Storage API.


1.2.0 ------------------------------------------------------------------------

Released 2019-03-01

Enhancements & New Features 

 * [GBJQ-269] Support for the BigQuery Storage API

   The driver can now use BigQuery Storage API to more efficiently process
   large result sets. For more information, see the Installation and 
   Configuration Guide.

 * [GBQJ-273] Updated OAuth URLs

   The URLs used by the driver for OAuth authentication have been updated
   to remain current.


Resolved Issues
The following issues were resolved in Simba JDBC Driver for Google BigQuery 
1.2.0. 

 * [GBQJ-284] In some cases, when executing a query that takes a long time 
   to complete, the query fails and the driver returns a GeneralException 
   error.

   This issue has been resolved. The driver now returns a more informative
   error message if a long-running query times out.

 * [GBQJ-274] In some cases, the driver cannot retrieve arrays with primitive 
   types.


==============================================================================