Skip to content

feat: support subqueries for global tables

Arseniy Volynets requested to merge test_subqueries_with_global_tables into master

Summary

  • Update sbroad submodule to commit adding support for subqueries
  • Add integration tests for sql queries with subqueries and global tables

Supported queries:

  • Queries that reference global tables in subqueries:
select a from segment_t where
b in (select c + d from global_t)
  • Queries that read from global tables and use subquery:
select c from global_t
where d in (select a from segment_t)

Note: the support of subqueries applies only to types of queries currently supported for global tables. Joins, aggregates, except, union all are currently not supported for global tables.

Ensure that

  • New code is covered by tests
  • API is documented
  • Changelog is up to date
  • (if Lua API changed) Lua API version is bumped in luamod.rs
  • (if necessary) A follow-up doc issue is created in picodata/docs and linked here
Edited by Arseniy Volynets

Merge request reports