Ticket Hash: | bb4bdb9f7f654b0bb9f34cfbacf5462acb4ce09d | |||
Title: | Zeroblob truncated by an index on an expression | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Severe | Priority: | Immediate | |
Subsystem: | Virtual_Machine | Resolution: | Fixed | |
Last Modified: | 2019-01-25 20:09:23 | |||
Version Found In: | ||||
User Comments: | ||||
drh added on 2019-01-25 20:01:15:
When a table has an index on an expression, then inserting a zeroblob into an indexed column of that table might cause the zeroblob to be truncated. CREATE TABLE t1(a,b,c); CREATE INDEX t1bbc ON t1(b, b+c); INSERT INTO t1(a,b,c) VALUES(1,zeroblob(8),3); SELECT a, b, length(b), c FROM t1; The correct answer is 1,X'0000000000000000',8,3 But the answer returned is: 1,X'',0,3 This issue was discovered during internal testing. There have been no reports of this from the wild. |