【TiDBer Chat Session 84】What incompatibility/unsupported issues did you encounter while replacing MySQL with TiDB?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【TiDBer 唠嗑茶话会 84】你在TiDB 替换 mysql 的过程中遇到了哪些不兼容/不支持的问题?

| username: TiDB社区小助手

To make TiDB better, this chat session aims to have everyone share the incompatibilities or unsupported issues you encountered while replacing MySQL with TiDB.

This topic:

What incompatibilities/unsupported issues did you encounter while replacing MySQL with TiDB?

Issue Feedback Template:

  • Software Name:
  • Incompatibility/Unsupported Issue;
  • Issue 1
  • Issue 2
  • Issue 3

Reply Reference

  • Software Name: apitable https://apitable.com/
  • Incompatibility/Unsupported Issue;
    1. Multi-schema change: MySQL supports specifying the second field dynamically appended after the newly added column in a single statement. Currently, we do not support appending non-existing columns simultaneously (in the same alter table statement, adding a column and specifying the next field after the previous one).
    1. Adding a column and index simultaneously: ALTER table apitable_widget ADD COLUMN space_id varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Space ID’ AFTER id, ADD INDEX k_space_id (space_id) USING BTREE
    1. test@5.7.25-TiDB-v7.3.0> create table json_table_a(a json not null default ‘{}’ ); ERROR 1101 (42000): BLOB/TEXT/JSON column ‘a’ can’t have a default value

Activity Rewards

Participation Award

Reply as required to this chat session to receive 30 points reward~

Activity Time:

2023.9.1-2023.9.8

| username: ShawnYan | Original post link

Stored procedure

| username: TiDB_C罗 | Original post link

It does not support ALTER TABLE t ADD COLUMN ..., ADD COLUMN. I tested it on version 7.2 and it is supported. However, it does not support this form: ALTER TABLE t (t ADD COLUMN ..., ADD COLUMN).

| username: 昵称想不起来了 | Original post link

Does not support stored procedures, triggers…

| username: 大飞哥online | Original post link

Does not support transactional DDL.

| username: Jellybean | Original post link

Does not support stored procedures and triggers. The business must be modified.

| username: tidb菜鸟一只 | Original post link

Does not support procedural function triggers, and there is also a syntax for join on and subqueries.

| username: TiDBer_m6V1BalM | Original post link

Does not support stored procedures and triggers, a bit frustrating…

| username: xfworld | Original post link

It’s too slow with a small amount of data… :upside_down_face: :upside_down_face: :upside_down_face:

| username: 望海崖2084 | Original post link

Learned.

| username: Soysauce520 | Original post link

MySQL 8.0 has update for skip locked.

| username: 像风一样的男子 | Original post link

I’m not used to not having stored procedures and triggers now.

| username: tony5413 | Original post link

Triggers and stored procedures

| username: 天蓝色的小九 | Original post link

Stored procedure

| username: TiDBer_vfJBUcxl | Original post link

Stored procedure

| username: cassblanca | Original post link

Stored Procedure, Trigger, User-Defined Function, Materialized View

| username: redgame | Original post link

Stored procedure

| username: 半瓶醋仙 | Original post link

Progress control, visualization plugin

| username: dba-kit | Original post link

The assistant said that alter table t add column col1 int, add column col2 int after col1 is not supported.