summaryrefslogtreecommitdiff
path: root/mysql-test/main/check_constraint.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2022-07-06 15:42:21 +0400
committerAlexander Barkov <bar@mariadb.com>2022-07-06 15:42:21 +0400
commit57f5c319af85b645f144425af285d117aeebd47a (patch)
treec50a0a7726171fdf2f1b71e053a83875ca1c21d1 /mysql-test/main/check_constraint.result
parentbdc1134deabb741d5b62a992d7478101adc617b3 (diff)
downloadmariadb-git-57f5c319af85b645f144425af285d117aeebd47a.tar.gz
MDEV-21445 Strange/inconsistent behavior of IN condition when mixing numbers and strings
Diffstat (limited to 'mysql-test/main/check_constraint.result')
-rw-r--r--mysql-test/main/check_constraint.result20
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/main/check_constraint.result b/mysql-test/main/check_constraint.result
index 89c16fabfa2..522a5d39df9 100644
--- a/mysql-test/main/check_constraint.result
+++ b/mysql-test/main/check_constraint.result
@@ -161,32 +161,32 @@ EmployeeID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
FirstName VARCHAR(30) NOT NULL CHECK (CHAR_LENGTH(FirstName > 2))
);
INSERT INTO t1 VALUES (NULL, 'Ken');
-ERROR 22007: Truncated incorrect DOUBLE value: 'Ken'
+ERROR 22007: Truncated incorrect DECIMAL value: 'Ken'
SHOW WARNINGS;
Level Code Message
-Error 1292 Truncated incorrect DOUBLE value: 'Ken'
+Error 1292 Truncated incorrect DECIMAL value: 'Ken'
Error 4025 CONSTRAINT `t1.FirstName` failed for `test`.`t1`
INSERT INTO t1 VALUES (NULL, 'Ken'),(NULL, 'Brian');
-ERROR 22007: Truncated incorrect DOUBLE value: 'Ken'
+ERROR 22007: Truncated incorrect DECIMAL value: 'Ken'
SHOW WARNINGS;
Level Code Message
-Error 1292 Truncated incorrect DOUBLE value: 'Ken'
+Error 1292 Truncated incorrect DECIMAL value: 'Ken'
Error 4025 CONSTRAINT `t1.FirstName` failed for `test`.`t1`
INSERT IGNORE INTO t1 VALUES (NULL, 'Ken');
Warnings:
-Warning 1292 Truncated incorrect DOUBLE value: 'Ken'
+Warning 1292 Truncated incorrect DECIMAL value: 'Ken'
INSERT IGNORE INTO t1 VALUES (NULL, 'Ken'),(NULL, 'Brian');
Warnings:
-Warning 1292 Truncated incorrect DOUBLE value: 'Ken'
-Warning 1292 Truncated incorrect DOUBLE value: 'Brian'
+Warning 1292 Truncated incorrect DECIMAL value: 'Ken'
+Warning 1292 Truncated incorrect DECIMAL value: 'Brian'
set sql_mode="";
INSERT INTO t1 VALUES (NULL, 'Ken');
Warnings:
-Warning 1292 Truncated incorrect DOUBLE value: 'Ken'
+Warning 1292 Truncated incorrect DECIMAL value: 'Ken'
INSERT INTO t1 VALUES (NULL, 'Ken'),(NULL, 'Brian');
Warnings:
-Warning 1292 Truncated incorrect DOUBLE value: 'Ken'
-Warning 1292 Truncated incorrect DOUBLE value: 'Brian'
+Warning 1292 Truncated incorrect DECIMAL value: 'Ken'
+Warning 1292 Truncated incorrect DECIMAL value: 'Brian'
set sql_mode=default;
select * from t1;
EmployeeID FirstName