character set introducer needs to be supported for some filter functions

[jennifersp]

CREATE TABLE `mytable` ( 
  `pk` int NOT NULL,
  `col2` int DEFAULT (date_format(now(),_utf8mb4'%Y')),
  `col3` varchar(20) NOT NULL DEFAULT 'sometext', 
PRIMARY KEY (`pk`), 
CONSTRAINT `status` CHECK ((`col3` like _utf8mb4'%sometext%')) 
);

error message : unsupported feature: unary operator: _utf8mb4

[VinaiRachakonda]

Let's fix this ASAP

[jennifersp]

fixed in dolthub/go-mysql-server#960