[Enhancement] make `insert into tbl values ()` compliance with mysql protocol

[Hastyshell]

Search before asking

• I had searched in the issues and found no similar issues.

Description

In mysql, insert into tbl values() will attempt to insert default values for all columns if their default values are set.

However, insert into tbl values() will result in Column count doesn't match value count in our logic.

Solution

The logic around

doris/fe/fe-core/src/main/java/org/apache/doris/analysis/NativeInsertStmt.java

Lines 494 to 497 in 24fb05e

	// check if size of select item equal with columns mentioned in statement
	if (mentionedColumns.size() != queryStmt.getResultExprs().size()) {
	ErrorReport.reportAnalysisException(ErrorCode.ERR_WRONG_VALUE_COUNT);
	}

should be optimized.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct