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

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


1.0.5 ========================================================================

Released 2017-03-09

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

 * Driver returns an error when retrieving metadata from a table that does not 
   have a schema.
   
 * Driver returns a NullPointerException when using prepared statements.
 
 * When executing a statement that contains comments before an INSERT, UPDATE, 
   or DELETE query, the driver returns a normal result set instead of a row 
   count.
 

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

 * 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 datatype 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
 

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

1.0.4 ------------------------------------------------------------------------

Released 2017-02-24

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

 * Driver returns NULL for REMARKS column in DatabaseMetadata.getTables 
   ResultSet.

 * Driver DatabaseMetadata.getTypeInfo returns different type names from 
   DatabaseMetadata.getColumns.

 * Driver returns <Error> for projected literal value for TIME values of 
   00:00:00.000000 and 12:00:00.000000.

 * Driver returns inconsistent catalog name in ResultSet in getCatalogs vs 
   other methods.

 * Driver returns a wrong value for TIME type projected via an aggregate.

 * Driver returns column type name TYPE_TIMESTAMP and not TIMESTAMP.

 * Performance of JDBC DatabaseMetadata requests can be extremely slow, 
   impacting application response times.

 * QueryMode connection option does not default to SQL.


1.0.3 ------------------------------------------------------------------------

Released 2017-01-26

Resolved Issues
The following issue has been resolved in Simba JDBC Driver for Google 
BigQuery 1.0.3. 

 * Driver incorrectly reports quotation marks (") as the quoted identifier.
 
   The driver now correctly reports backquotes (`) as the quoted identifier
   when parsing queries using Standard SQL (QueryDialect=SQL), in accordance 
   with the BigQuery specification.


1.0.2 ------------------------------------------------------------------------

Released 2016-10-21

Enhancements & New Features 

 * Date and time data types addition

   The driver supports DATE, TIME, and DATETIME data. For SQL and Java 
   mappings for these data types, see the Simba JDBC Driver for Google 
   BigQuery Installation & Configuration Guide.


1.0.1 ------------------------------------------------------------------------

Released 2016-06-10

Enhancements & New Features 

 * Client libraries updated to latest version

   The client libraries have been updated to version 1.22.

 * Positional parameters support

   The driver supports positional parameters in parameterized queries.

 * DML (INSERT, UPDATE, DELETE) support

   The driver supports DML write-back statements INSERT, UPDATE, and DELETE.

 * BYTES data type addition

   The driver supports BYTES data, and returns this data as SQL_VARBINARY.

 * Returning raw JSON for ARRAY/REPEATED type of fields.

   For ARRAY and REPEATED fields, the driver now returns the data as a text 
   representation of the JSON object.

 * Removed MaxRequestsPerSecond, OAuthClientId, and OAuthClientSecret options

   These options are no longer supported by the driver.

 * Updated SQLDialect option

   The SQLDialect option now supports values of either SQL to indicate 
   SQL:2011 or BIG_QUERY to indicate legacy Google BigQuery SQL. The default 
   value is SQL.


1.0.0 ------------------------------------------------------------------------

Released 2016-06-10

 * Version 1.0.0 was the initial release of the Simba JDBC Driver for Google 
   BigQuery.


============================================================================== 
Contact Us 
==============================================================================  

If you have difficulty using Simba JDBC Driver for Google BigQuery, please 
contact our Technical Support staff. We welcome your questions, comments and 
feature requests. 

Important: To help us assist you, prior to contacting Technical Support please 
prepare a detailed summary of the client and server environment including 
operating system, product version, patch level and configuration. 

You can contact Technical Support via the Magnitude Support Community at 
http://magnitudesoftware.com/online-support/.

You can also follow us on Twitter @SimbaTech and @Mag_SW
