public String getMysqlType() {
        switch (type) {
            case INLINE_VIEW:
            case VIEW:
            case MATERIALIZED_VIEW:
            case CLOUD_NATIVE_MATERIALIZED_VIEW:
                return "VIEW";
            case SCHEMA:
                return "SYSTEM VIEW";
            default:
                // external table also returns "BASE TABLE" for BI compatibility
                return "BASE TABLE";
        }
    }
@Test
    public void testGetMysqlType() {
        Assert.assertEquals("BASE TABLE", new Table(TableType.OLAP).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.OLAP_EXTERNAL).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.CLOUD_NATIVE).getMysqlType());

        Assert.assertEquals("BASE TABLE", new Table(TableType.MYSQL).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.BROKER).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.ELASTICSEARCH).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.HIVE).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.ICEBERG).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.HUDI).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.JDBC).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.DELTALAKE).getMysqlType());
        Assert.assertEquals("BASE TABLE", new Table(TableType.FILE).getMysqlType());

        Assert.assertEquals("VIEW", new Table(TableType.INLINE_VIEW).getMysqlType());
        Assert.assertEquals("VIEW", new Table(TableType.VIEW).getMysqlType());
        Assert.assertEquals("VIEW", new Table(TableType.MATERIALIZED_VIEW).getMysqlType());
        Assert.assertEquals("VIEW", new Table(TableType.CLOUD_NATIVE_MATERIALIZED_VIEW).getMysqlType());

        Assert.assertEquals("SYSTEM VIEW", new Table(TableType.SCHEMA).getMysqlType());
    }