By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 10.6.7-MariaDB |
| id | field1 | field2 | gen_aux1 | gen_aux2 | gen |
|---|---|---|---|---|---|
| 1 | hello | world | 0 | 1 | 0 |
| 2 | hello lorem | hello ipsum | 1 | 1 | 1 |
| id | field1 | field2 | gen_aux1 | gen_aux2 | gen |
|---|---|---|---|---|---|
| 2 | hello lorem | hello ipsum | 1 | 1 | null |
| 1 | hello | world | 0 | 1 | null |