I created a stored procedure that use an array from a SQL query and execute in a loop a dynamic query.
The stored Proc works on the Cloud SSDB (vs 7.6.22) and not on SSDB Cluster In a Box (vs. 7.8.17 )
>
> -- Cloud
> memsql_original_server_version 7.6.11
> memsql_version 7.6.22
> memsql_version_date Sun Sep 4 15:43:10 2022 -0400
> -- > Works
>
> -- Cloud
> Tested on 7.9.14
> -- > Works
>
> -- Staging
> | memsql_original_server_version | 7.8.17 |
> | memsql_version | 7.8.17 |
> | memsql_version_date | Mon Oct 10 14:59:31 2022 -0400 |
> -- > DOES NOT Works