Hello, I encountered some errors while trying to build an SQL request and I would appreciate your input on it.
Using H2 engine, I tried to have a subquery inside a subquery and there is an exception about unique alias being null. Something like: select ... from ( select ... from ( select ... from table) ) Is this a limitation on the number of subqueries? a bug? I'm doing this to be able to reuse formulas, I don't really need subqueries, is there a better way to do that? Using Calcite engine, this limitation does not seem to exist, but I had another exception (without much details except that it failed) when trying to do more than one join with subqueries: with sq1 as ( select * from ( values ... ) ) with sq2 as ( select * from ( values ... ) ) select ... from table left join sq1 on ... left join sq2 on ... Am I doing something wrong? Also, is there a timeline for Calcite official release (out of beta, I cannot find the info)? Thanks in advance, Loïc This message and any attachments (the "message") is intended solely for the intended addressees and is confidential. If you receive this message in error,or are not the intended recipient(s), please delete it and any copies from your systems and immediately notify the sender. Any unauthorized view, use that does not comply with its purpose, dissemination or disclosure, either whole or partial, is prohibited. Since the internet cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS (and its subsidiaries) shall not be liable for the message if modified, changed or falsified. Do not print this message unless it is necessary, consider the environment. ---------------------------------------------------------------------------------------------------------------------------------- Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur ou s'il ne vous est pas destine, merci de le detruire ainsi que toute copie de votre systeme et d'en avertir immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de ce message qui n'est pas conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer l'integrite de ce message electronique susceptible d'alteration, BNP Paribas (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese ou il aurait ete modifie, deforme ou falsifie. N'imprimez ce message que si necessaire, pensez a l'environnement.
