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 |