[Bug report] alter mysql table set property using http request did not worked

[zhoukangcn]

Version

main branch

Describe what's wrong

curl -X PUT -H "Accept: application/vnd.gravitino.v1+json" \
-H "Content-Type: application/json" -d '{
  "updates": [
    {
      "@type": "removeProperty",
      "property": "key2"
    }, {
      "@type": "setProperty",
      "property": "key3",
      "value": "value3"
    }
  ]
}' http://localhost:8090/api/metalakes/metalake/catalogs/mysql_test1/schemas/test/tables/test_table1

return 200, but something was wrong:

• removeProperty is not support in catalog-jdbc-mysql
• setProperty did not worked , properties don't contain key3 after request success

Error message and/or stacktrace

N/A

How to reproduce

add a MySQL catalog, database, table use bash beblow

Additional context

No response

[yuqi1129]

@zhoukangcn I remember MySQL catalog only supports setting properties with names that are recognized by MySQL engine like engine,charset, and so on, maybe I have mistaken it.

[zhoukangcn]

I think Gravitino server return 200, which means request success.

Yes MySQL only support properties like engine charset, so I think Gravitino server should return 4xx for request invalid.

[yuqi1129]

This issue needs to be discussed and then we can reach an agreement about what to do next, so I postponed it to the next version.