Hi dear community.
Today I want to share with you some funny and weird error
messages which can be extremely annoying
So let’s begin:
CREATE temporary TABLE `sbtest1_temp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', `json_test_v` json GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) VIRTUAL, `json_test_s` json GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) STORED, `json_test_index` varchar(255) GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) STORED, PRIMARY KEY (`id`), KEY `k_1` (`k`), KEY `json_test_index` (`json_test_index`) ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1 COMPRESSION='lz4' ENCRYPTION='Y' ERROR 1478 (HY000): InnoDB: Unsupported encryption option for temporary tables.
Okay, let’s disable it:
CREATE temporary TABLE `sbtest1_temp` ( `id` int(11) NOT NULL AUTO_INCREMENT, …[Read more]