Changelog

All notable changes to this project are documented in this file.
The format is based on Keep a Changelog.
This project adheres to Semantic Versioning.

1.5.2 (2024-12-18)

Fixed

Force sql_simple_queries to quote in outer select (#954) (2071dc8)

1.5.1 (2024-12-16)

Fixed

deep groupby (#919) (ce24264)
expressions with not on HANA (#925) (e67a31b)
quoted mode (#937) (9e62b22)
sort property is case insensitive (#924) (2c72c87)
track expression type through expressions (#950) (a083f74)

Performance Improvements

Remove $$RN$$ and additional sub selects (#929) (b3743a1)

1.5.0 (2024-11-25)

Added

config options for fuzzy search (#898) (f6593e6)
support current_utctimestamp (#865) (aaf39ad)

Fixed

current_date, current_time, current_timestamp and current_utctimestamp are SAP HANA functions and are callable in upper case (#910) (50ebd10)

1.4.1 (2024-10-30)

Fixed

increase min version cap-js/db-service (#876) (e20eef8)

1.4.0 (2024-10-28)

Added

Improve procedure metadata lookup logic (#862) (da629d9)

Fixed

enable cesu8 by default for hdb driver and encode entries streams (#868) (d85d7e6)
Include binary type with varbinary type in hana-client (#871) (f4d7caf)
nested functions in comparisons (#861) (f3fd254)
properly support default, cds.on.insert and cds.on.update for UPSERT queries (#425) (338e9f5)
SELECT cds.hana.BINARY (#870) (33c3ebe)
Throw error if rows in limit is missing for expand, same as in limit() (#858) (641c3b9)

1.3.2 (2024-10-21)

Fixed

Adjust Decimal formatter to always render a whole number (#853) (027d717)
allocate a new Buffer for each chunk of a Blob stream when using hana-client (#846) (ec75b50)

1.3.1 (2024-10-15)

Fixed

combination of groupby and orderby (#825) (10e0534)
Improved behavioral consistency between the database services (#837) (b6f7187)
list optimization for Buffer values (#817) (3e60de2)
null as default value (#845) (0041ec0)

1.3.0 (2024-10-01)

Added

Add quoted mode support (#681) (43c7a6c)

1.2.0 (2024-09-03)

Added

wrap client if @dynatrace/oneagent-sdk is present (#777) (147b88e)

Fixed

Add {list:[{val}]} json function support (#784) (ce5f856)
Allow applications to configure acquireTimeoutMillis (#796) (abac818)
deep groupby expand queries (#768) (5423cf3)
Enforce LargeStrings to be Strings for sql_simple_queries=1 (#774) (c38a9e6)
wrong falsy checks for vals in list optimization (#797) (e818da8)

Changed

requires @sap/cds >= 8.2 (#789) (3bbde18)

1.1.1 (2024-07-25)

Fixed

assocs with default value (#752) (a8660cf)
make name for columns for ordinality unique (#746) (d3f9b23)

1.1.0 (2024-07-08)

Added

Enable native HANA fuzzy search for search function queries (#707) (0b9108c)

Fixed

mtx: sidecar scenario due to usage of wrong credentials (#732) (0b5c91f)

1.0.1 (2024-07-05)

Fixed

Allow numeric Booleans 0 and 1 (#714) (82c4dbe)
Support expand with group by clause (#721) (90c9e6a)

1.0.0 (2024-06-19)

Fixed

Binary columns now return as Buffer for HANAService (#689) (179bd92)
Improve error message for disconnected connections (#678) (eb4ef37)
insertion of arrayed elements (#677) (92cf307)
insertion of large decimals (#686) (ae8abff)
Support static conditions inside unmanaged associations (#682) (e17ddfd)

0.5.0 (2024-05-29)

Added

simple queries (#654) (ba77f9e)

0.4.0 (2024-05-16)

Added

Allow hex engine to be used (#641) (bca0c01)

Fixed

Improve comparator check for combined and nested expressions (#632) (8e1cb4b)
Support multi byte characters (#639) (4cfa77f)

Changed

@sap/hana-client optional peer dependency (#631) (89d7149)

0.3.0 (2024-05-08)

Added

select decimals as strings if cds.env.features.string_decimals (#616) (39addbf)

Fixed

Add multi concat function (#624) (df436fe)
Align all quote functions with @sap/cds-compiler (#619) (42e9828)
Change sql property to query for errors (#611) (585577a)
Disconnect HANA tenant when deleted (#589) (a107db9)
Align "not found" behavior (#603) (54d2efb)
Allow custom fuzzy search cqn (#620) (80383f0)
Allow HANA to use != and == inside xpr combinations (#607) (c578e9f)
Reference column alias in order by (#615) (7cd3a26)
Remove encoding from hana-client streams (#623) (fed8f6f)
Support associations with static values (#604) (05babcf)
improved = and != with val null (#626) (cbcfe3b)
Improved placeholders and limit clause (#567) (d5d5dbb)

0.2.0 (2024-04-12)

Added

Odata built-in query functions (#558) (6e63367)
support HANA stored procedures (#542) (52a00a0)

0.1.0 (2024-03-22)

Added

also support lowercase matchespattern function (#528) (6ea574e)
forUpdate and forShareLock (#148) (99a1170)
hana: drop prepared statements after end of transaction (#537) (b1f864e)

Fixed

use keyword list from compiler (#525) (c6993d9)
improve search inside where clause detection (#538) (51b8af3)
reduce service manager calls for failing tenants (#533) (e95fd17)
Add views with parameters support (#488) (3790ec0)
issue with reused select cqns (#505) (916d175)
joins without columns are rejected (#535) (eb9beda)
mass insert for unknown entities (#540) (f2ea4af)

Changed

this package now requires @cap-js/db-service >= v1.7.0 (#545) (2cec27d)

0.0.6 (2024-02-28)

Added

cds.Vector support for the HANAService (#442) (1057a13)

Fixed

TypeError for cds bind in MTX scenario (#482) (38722fe)
Allow SELECT.join queries again with full infer call (#469) (5329ec0)

0.0.5 (2024-02-16)

Fixed

sqlite: Retain Error object for unique constraint violation (#446) (d27ee79)
hana: ensure the database connection does not enable auto commit (#448) (b2ca1da)
hana: Ensure xpr with logical operator to only contain comparisons (#452) (a2ecb22)
ignore virtual keys in UPSERT(#463) (49adbf3)
select without columns from unknown entity (#466) (eb857de)

0.0.4 (2024-02-02)

Added

Add fallback for @cap-js/hana for unknown entities (#403) (e7dd6de)
SELECT returns binaries as Buffers (#416) (d4240d5)
SELECT returns LargeBinaries as streams unless feature flag "stream_compat" is set (#251) (8165a4a)
Support Readable Streams inside INSERT.entries (#343) (f6faf89)

Fixed

Ensure globally unique aliases with large expand queries (#396) (c1df747)
enumeration issue with session context in @cap-js/hana (#399) (8106a20)
ignore empty order by (#392) (a69fed0)
improve != and == implementation for @cap-js/hana (#426) (9b7b5a0)
show clear error message when unable to load project package.json (#419) (2ebf783)
UPSERT for @cap-js/hana for entities with multiple keys (#418) (9bbac6e)

0.0.3 (2023-12-20)

Added

Compress HANA expand queries by reducing duplicated statements (#383) (3d29351)

Fixed

cqn2sql: supporting calculated elements (#387) (2153fb9)

Performance Improvements

HANA list placeholder (#380) (3eadfea)

0.0.2 (2023-12-11)

Fixed

add missing mappings for hdb driver (#375) (199a720)

0.0.1 (2023-12-06)

Initial alpha release