[MDEV-17587] Add support for deterministic functions in virtual columns Created: 2018-10-31  Updated: 2023-12-17

Status: Open
Project: MariaDB Server
Component/s: Virtual Columns
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Chris J.M. Assignee: Unassigned
Resolution: Unresolved Votes: 6
Labels: None


 Description   

A current limitation of virtual columns is that they do not allow stored functions in their definitions, even if the function is deterministic.

The current workaround is to use a view that uses the stored functions to define its columns. However, this adds complexity to DB architecture by introducing a new table.

Since ensuring that virtual column definitions are deterministic is important, only stored functions marked as DETERMINISTIC should be allowed in virtual column definitions. One implementation question is whether Maria should check to enforce that the functions marked as deterministic really are as deterministic as they claim or if we leave it as the DBA's responsibility to ensure the functions they mark as deterministic really will return the same result every time they have the same inputs.



 Comments   
Comment by Brad Lanier [ 2023-12-17 ]

Please just leave the deterministic question to the DBA's for now so that we can get this implemented. You can add the deeper analysis later if the demand is there.

Generated at Thu Feb 08 08:37:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.