The bool type not null allows inserting null values

Translated
1

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

Original topic: bool 类型 not null允许插入 null 值。

| username: 梦想是个厨子

Under sql_mode set to NO_ENGINE_SUBSTITUTION;
Differences in behavior between TIDB and MySQL

image
image1378×272 41.8 KB

2
| username: Miracle | Original post link

Is TiDB’s sql_mode inconsistent with MySQL’s?

3
| username: 梦想是个厨子 | Original post link

I set sql_mode to NO_ENGINE_SUBSTITUTION, but TiDB and MySQL behave inconsistently. I’ve updated the issue with a screenshot.

4
| username: xingzhenxiang | Original post link

I didn’t change the sql_mode and it can still be inserted.

image
image834×606 47.2 KB

5
| username: forever | Original post link

show warning to check

6
| username: 有猫万事足 | Original post link

Version 7.3 did not change sql_mode and did not reproduce the issue.

7
| username: xingzhenxiang | Original post link

The image you provided is not accessible. Please provide the text content that needs to be translated.

8
| username: 大飞哥online | Original post link

A warning prompt and a direct error.

9
| username: xingzhenxiang | Original post link

It’s still more practical to report errors.

10
| username: 大飞哥online | Original post link

That’s true.

11
| username: 梦想是个厨子 | Original post link

Here’s the problem: after the program migration, it became incompatible.

12
| username: ajin0514 | Original post link

How did you solve it?