[MDEV-20941] virtual column causes 2013 error upon insert Created: 2019-11-01 Updated: 2019-12-09 Resolved: 2019-12-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Insert |
| Affects Version/s: | 10.3.17 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | V H Lemoine | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
linux Ubuntu 18.04 mariadb 10.3.17 |
||
| Attachments: |
|
| Description |
|
Using this table with virtual column 'trDomain' I'm experiencing no problems CREATE TABLE `sslinfo` ( But when I change the column trDomain to: * `trDomain` varchar(255) GENERATED ALWAYS AS (concat('<tr data-color=\'',(to_days(`toDate`) - to_days(curdate())) DIV 20,'\'><td>',`domain`,'</td><td>',date_format(`fromDate`,'%Y-%m-%d %H:%i'),'</td><td>',date_format(`toDate`,'%Y-%m-%d %H:%i'),'</td><td>',`ExpireInDays`,'</td></tr>')) VIRTUAL, mariadb db gives a 2013 error upon insert. |
| Comments |
| Comment by Elena Stepanova [ 2019-11-05 ] |
|
It doesn't fail for me, and unfortunately since the server didn't produce a proper stack trace, we can't compare the failure with other known bugs regarding virtual columns. If it happens for you all the time, maybe you have an example of a crash with a better stack trace in the log? Or, could you maybe try to install dbgsym packages and enable the coredump, then possibly the crash report will be better, and if not, you'll be able to get a stack trace from the core file? |