[h2] UNLINK_SCHEMA as opposition of LINK_SCHEMA, LINK_SCHEMA RFE and questions

Hello, may I ask You few questions about LINK_SCHEMA function? 1) Is LINK_SCHEMA on 10+ or 100+ tables and views far more faster that 10+ or 100+ times CREATE LINKED TABLE? In other words is there time improvement due connection establishment? Or does LINK_SCHEMA internally call of 10+ or 100+

RE: [h2] Is it possible to flatten arrays when doing nested array aggregation?

https://www.h2database.com/html/functions.html#unnestThis one.Sent from my Galaxy Original message From: Adam R Date: 26/04/2022 05:59 (GMT+01:00) To: H2 Database Subject: [h2] Is it possible to flatten arrays when doing nested array aggregation? Here's a toy example:CREATE

RE: [h2] Is it possible to flatten arrays when doing nested array aggregation?

Greetings. Why would you not aggregate on the whole table without the subquery?Anyway. If the subquery must be involved then you needed to unroll its arrays first before aggregating it again.Look for the unnest syntax in h2. I know its supported.Best regards AndreasSent from my Galaxy O

[h2] Is it possible to flatten arrays when doing nested array aggregation?

Here's a toy example: CREATE TABLE MY_TABLE (ID INT, NAME VARCHAR); INSERT INTO MY_TABLE VALUES(1, 'a'); INSERT INTO MY_TABLE VALUES(2, 'a'); INSERT INTO MY_TABLE VALUES(3, 'b'); INSERT INTO MY_TABLE VALUES(4, 'b'); SELECT ARRAY_AGG(IDS) AS IDS FROM (SELECT ARRAY_AGG(ID) AS IDS FROM MY_TABLE