Skip to content

CREATE VIEW over a TINYBLOB column reports ERR_CONVERTOR but it actually creates a usable view in polardbx-sql #286

Description

@123lpygithub

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions