20-RSMAs¶

¶

RSMAs basic

1. Create two databases d0 and d1 with retention policy and stt_trigger.

2. Create stable and table with various data types including decimal and composite key.

3. Insert data into tables.

4. Create rsma on tables with various functions.

5. Alter rsma to add more functions.

6. Show rsma and verify.

7. Drop rsma and verify.

8. Trim database to trigger retention policy.

9. Rollup database and verify rsma results.

10. Rollup vgroups and verify rsma results.

11. Test decimal data type and composite key with add/drop column operations.

12. Exceptional cases.

13. Retention task monitor.

14. Rollup automatically when execute: trim database.

15. Rollup manually when execute: rollup database.

16. SSMigrate with/without rsma and verify the result.