[MDEV-19913] Query with virtual columns are stored in query cache even when in expression of virtual columns exists CURRENT_TIMESTAMP() Created: 2019-07-01 Updated: 2023-11-28 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Query Cache, Virtual Columns |
| Affects Version/s: | 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10 |
| Fix Version/s: | 10.4, 10.5, 10.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Peter Stöcker | Assignee: | Oleksandr Byelkin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | querycache, virtual_columns | ||
| Environment: |
with 10.3 and 10.4 system on Windows and Linux |
||
| Issue Links: |
|
||||||||
| Description |
|
With the following procedure you can reproduce the bug: 1. Query cache needs to be ON CREATE TABLE `test`.`virtualtest` ( 3. Insert data INSERT INTO `virtualtest` (`aDateTime`) VALUES (TIMESTAMPADD(SECOND,30,CURRENT_TIMESTAMP())); 4. Select the data SELECT * FROM `virtualtest` a; Expected behaviour: Conclusion: |