Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
create or replace table t (a varchar(16), i int, c int unsigned as (crc32(i,a))); |
insert into t (a,i) values ('foo',1); |
select * from t; |
preview-10.8-MDEV-27265-misc 3d04e67d |
+------+------+------------+ |
| a | i | c |
|
+------+------+------------+ |
| foo | 1 | 2212294583 |
|
+------+------+------------+ |
1 row in set, 1 warning (0.001 sec) |
|
MariaDB [test]> show warnings;
|
+---------+------+------------------------------------------+ |
| Level | Code | Message | |
+---------+------+------------------------------------------+ |
| Warning | 1292 | Truncated incorrect INTEGER value: 'foo' | |
+---------+------+------------------------------------------+ |
1 row in set (0.000 sec) |
This works (from the same table):
MariaDB [test]> select crc32(i,a) from t; |
+------------+ |
| crc32(i,a) |
|
+------------+ |
| 2377191190 |
|
+------------+ |
1 row in set (0.001 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-27208 Implement 2-ary CRC32() and the CRC32C() function
- Closed