Support more debezium source data types

[neverchanje]

Is your feature request related to a problem? Please describe.

• [ ] Null

• [x] Boolean

• [x] Int

• [x] Long

• [x] Float

• [x] Double

• [x] Bytes A bytes Avro schema. Bytes represents a sequence of 8-bit unsigned bytes.

• [x] String A string Avro schema. String represents a Unicode character sequence.

• [x] Array(Box<Schema>) An array Avro schema. Avro arrays are required to have the same type for each element. This variant holds the Schema for the array element type.

• [ ] Map(Box<Schema>) A map Avro schema. Map holds a pointer to the Schema of its values, which must all be the same schema. Map keys are assumed to be strings.

• [x] Union(UnionSchema)

• [x] Record Fields: name: Name aliases: Aliases doc: Documentation fields: Vec<RecordField> lookup: BTreeMap<String, usize> A record Avro schema. The lookup table maps field names to their position in the Vec of fields.

• [x] Enum Fields: name: Name aliases: Aliases doc: Documentation symbols: Vec<String> An enum Avro schema.

• [ ] Fixed Fields: name: Name aliases: Aliases doc: Documentation size: usize A fixed Avro schema.

• [x] Decimal https://github.com/risingwavelabs/risingwave/issues/6848

• [ ] Uuid A universally unique identifier, annotating a string.

• [x] Date Logical type which represents the number of days since the unix epoch. Serialization format is Schema::Int.

• [ ] TimeMillis The time of day in number of milliseconds after midnight with no reference any calendar, time zone or date in particular.

• [ ] TimeMicros The time of day in number of microseconds after midnight with no reference any calendar, time zone or date in particular.

• [x] TimestampMillis An instant in time represented as the number of milliseconds after the UNIX epoch.

• [x] TimestampMicros An instant in time represented as the number of microseconds after the UNIX epoch.

• [x] Duration An amount of time defined by a number of months, days and milliseconds.

• [x] #10352 Fields name: Name

Describe the solution you'd like

The mission is to pass the data type tests in this PR: https://github.com/risingwavelabs/risingwave/pull/9821

Describe alternatives you've considered

No response

Additional context

No response

[neverchanje]

We need to support TimeMillis at first since it corresponds to a commonly-used type in SQL databases.

[github-actions[bot]]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean. Don't worry if you think the issue is still valuable to continue in the future. It's searchable and can be reopened when it's time. 😄