polardbx-sql reports a CREATE VIEW failure for a minimal TINYBLOB projection, but the view object is nevertheless created successfully and remains visible and usable afterwards.
This is a concrete DDL state/return mismatch: the client receives an error, while the schema change has already committed.
polardbx-sql version: 5.4.19-SNAPSHOT
How to repeat:
DROP DATABASE IF EXISTS t1;
CREATE DATABASE t1;
USE t1;
CREATE TABLE t (
c1 TINYBLOB
);
CREATE VIEW V AS
SELECT c1 FROM t;
SHOW CREATE VIEW V;
Observed behavior:
CREATE VIEW V AS SELECT c1 FROM t; returns:
ERR-CODE: [PXC-4602][ERR_CONVERTOR] convertor error:
Unsupported convert: [com.alibaba.polardbx.optimizer.core.datatype.Blob,java.lang.Integer]
But SHOW CREATE VIEW V; immediately succeeds and shows the created view definition.
polardbx-sqlreports aCREATE VIEWfailure for a minimalTINYBLOBprojection, but the view object is nevertheless created successfully and remains visible and usable afterwards.This is a concrete DDL state/return mismatch: the client receives an error, while the schema change has already committed.
polardbx-sqlversion:5.4.19-SNAPSHOTHow to repeat:
Observed behavior:
CREATE VIEW V AS SELECT c1 FROM t;returns:But
SHOW CREATE VIEW V;immediately succeeds and shows the created view definition.