Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can the entity XML function be improved? #595

Open
daiagou opened this issue Jun 2, 2023 · 0 comments
Open

Can the entity XML function be improved? #595

daiagou opened this issue Jun 2, 2023 · 0 comments

Comments

@daiagou
Copy link

daiagou commented Jun 2, 2023

Background: Mobi's SQL operations can be replaced by XML, either DDL or DML. This is great.
But the problem is that it is not perfect. We still need to use SQL for many functions. Part of the XML and part of the SQL clearly impose an additional burden on operations and maintenance.
Specifically, let me list the situations that are currently not supported:

  1. Flexible adjustment of field length. For example, if my varchar defaults to 40 and I need to adjust it to 32, I need to configure a '<dictionary-type type="varchar32" java-type="java.lang.String" default-sql-type=“VARCHAR(32)"/>' in the configuration file. Once I need to change the configuration, I need to restart the instance, which is obviously not good. Of course, there are usually not many changes in the situation.
  2. Default values are not supported
  3. Does not support self growth
  4. Does not support null or not

My suggestion is to add these support options so that the XML functionality will be more robust, such as:
<field name="id" type=“bigint” length=“20” defalut-value=“0” not-null=“true” auto-inc=“true" is-pk="true"/>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant