db-service: v1.9.0

1.9.0 (2024-05-08)

Added

• Add missing func cqn structures (#629) (9d7539a)

Fixed

• order by: reject non-fk traversals of own columns in order by (#599) (3288d63)
• Align all quote functions with @sap/cds-compiler (#619) (42e9828)
• assign artificial alias if selecting from anonymous subquery (#608) (e1a7711)
• avoid spread operator (#630) (a39fb65)
• flat update with arbitrary where clauses (#598) (f108798)
• improved = and != with val null for HANA and Postgres (#626) (cbcfe3b)
• Improved placeholders and limit clause (#567) (d5d5dbb)
• multiple result responses (#602) (bf0bed4)
• only consider persisted columns for simple operations (#592) (6e31bda)

Changed

• require >= sap/cds-compiler@4.9 (f4d09e2)
• require >= sap/cds@7.9.0 (#627) (f4d09e2)

postgres: v1.7.0

1.7.0 (2024-04-12)

Added

• Odata built-in query functions (#558) (6e63367)

hana: v0.2.0

0.2.0 (2024-04-12)

Added

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

db-service: v1.8.0

1.8.0 (2024-04-12)

Added

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

Fixed

• expand: Only accept on structures, assocs or table aliases (#551) (3248512)
• order by: for localized sorting, prepend table alias (#546) (a273a92)
• etag with stream_compat (#562) (b0a3a41)
• exclude cds.LargeBinary from wildcard expansion (#577) (6661d63)
• Reduce insert queries for deep update (#568) (55e5114)
• Reduced count query complexity when possible (#553) (3331f02)

sqlite: v1.6.0

1.6.0 (2024-03-22)

Added

• forUpdate and forShareLock (#148) (99a1170)
• hana: drop prepared statements after end of transaction (#537) (b1f864e)

Fixed

• sqlite: use keyword list from compiler (#526) (a227c61)

postgres: v1.6.0

1.6.0 (2024-03-22)

Added

• also support lowercase matchespattern function (#528) (6ea574e)
• forUpdate and forShareLock (#148) (99a1170)

Changed

• use new cds build API @sap/cds-dk >= 7.5.0 (#508) (ef22ebe)

hana: v0.1.0

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

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

db-service: v1.7.0

1.7.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)
• orderby: allow to disable collations with @cds.collate: false (#492) (820f971)

Fixed

• cqn2sql: Smart quoting of columns inside UPSERT rows (#519) (78fe10b)
• deep delete for views without navigation (#434) (3ebc9c2)
• Getting rid of quirks mode (#514) (c9aa6e8)
• issue with reused select cqns (#505) (916d175)
• joins without columns are rejected (#535) (eb9beda)
• search: dont search non string aggregations (#527) (c87900c)
• search: search on aggregated results in HAVING clause (#524) (61d348e)

hana: v0.0.6

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)

db-service: v1.6.4

1.6.4 (2024-02-28)

Fixed

• cqn2sql: smart quoting also for update statements (#475) (1688f77)
• INSERT with first undefined value (#484) (c21e3c4)
• Allow SELECT.join queries again with full infer call (#469) (5329ec0)
• optimize foreign key access in a join relevant path (#481) (5e30de4), closes #479