marregui

feat(sql): Implement ALTER TABLE DETACH PARTITION as a complement to ATTACH

1

Following the behaviour of drop partition, minus deleting the folder, plus copying the _meta data to effect checks on attach if it exists within the partition.detached folder.

### Describe the bug Given this table definition (as a practical example): ```sql create table sensor_data ( sensor_id symbol, temperature double, measurement_timestamp timestamp ) timestamp(measurement_timestamp) partition by month; ``` and...

I don't see this as a bug, it is more of a case of compatibility with Postgres. Most of our functions belong in the namespace `null` whose OID is `-1861355723`,...

Add DECLARE CURSOR support

1

**Tableau Desktop Pro edition 2020.2.2** Tableau requires cursors to access the result set: ``` declare "SQL_CUR0x7fd83880dc00" cursor with hold for SELECT "office_supplies"."date" AS "date", "office_supplies"."item" AS "item", "office_supplies"."region" AS "region",...

``` 18/211 Test #18: ClusteringTests.KShapeDouble .....................................***Failed 18.02 sec Running main() from C:\dev\vcpkg\buildtrees\gtest\src\ase-1.10.0-9cde347ce0.clean\googletest\src\gtest_main.cc Note: Google Test filter = ClusteringTests.KShapeDouble [==========] Running 1 test from 1 test suite. [----------] Global test environment...

``` 17/211 Test #17: ClusteringTests.KShapeFloat ......................................***Failed 18.88 sec Running main() from C:\dev\vcpkg\buildtrees\gtest\src\ase-1.10.0-9cde347ce0.clean\googletest\src\gtest_main.cc Note: Google Test filter = ClusteringTests.KShapeFloat [==========] Running 1 test from 1 test suite. [----------] Global test environment...

``` 166/211 Test #166: MatrixTests.FindBestDiscordsMultipleProfiles .....................***Failed 19.85 sec Running main() from C:\dev\vcpkg\buildtrees\gtest\src\ase-1.10.0-9cde347ce0.clean\googletest\src\gtest_main.cc Note: Google Test filter = MatrixTests.FindBestDiscordsMultipleProfiles [==========] Running 1 test from 1 test suite. [----------] Global test environment...

``` 74/211 Test #74: FeaturesTests.FftAggregated ......................................***Failed 11.05 sec Running main() from C:\dev\vcpkg\buildtrees\gtest\src\ase-1.10.0-9cde347ce0.clean\googletest\src\gtest_main.cc Note: Google Test filter = FeaturesTests.FftAggregated [==========] Running 1 test from 1 test suite. [----------] Global test environment...

feat(sql): Add support for dropping symbol column index

4

Closes https://github.com/questdb/questdb/issues/2148 Documents https://github.com/questdb/questdb/pull/2183

fix(core): Remove potential infinite loop in BitmapIndexUtils

1

closes https://github.com/questdb/questdb/issues/2232 The loop had no limit, and there was no test for null memory.