1.7.0

Highlights

• Fixed behavior of maxRows option of IOperation.fetchChunk(). Now it will return chunks of requested size (#200)
• Improved CloudFetch memory usage and overall performance (#204, #207, #209)
• Remove protocol version check when using query parameters (#213)
• Fix IOperation.hasMoreRows() behavior to avoid fetching data beyond the end of dataset. Also, now it will work properly prior to fetching first chunk (#205)

Full diff: 1.6.1...1.7.0

Query parameters support

In this release we also finally enable both named and ordinal query parameters support. Usage examples:

// obtain session object as usual

// Using named parameters
const operation = session.executeStatement('SELECT :p1 AS "str_param", :p2 AS "number_param"', {
  namedParameters: {
    p1: 'Hello, World',
    p2: 3.14,
  },
});

// Using ordinal parameters
const operation = session.executeStatement('SELECT ? AS "str_param", ? AS "number_param"', {
  ordinalParameters: ['Hello, World', 3.14],
});

Please note that either named or ordinal parameters can be used in the single query, but not both simultaneously

CloudFetch performance improvements

This release includes various improvements to CloudFetch feature. It remains disabled by default, but we strongly encourage you to start using it:

// obtain session object as usual

// Using named parameters
const operation = session.executeStatement('...', {
  useCloudFetch: true,
});