[MDEV-25262] include modern checksum in VIEW frm defination (not md5) Created: 2021-03-26  Updated: 2021-04-08

Status: Open
Project: MariaDB Server
Component/s: Views
Fix Version/s: None

Type: Task Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-25372 Deprecate SHA-1 algorithm from mariad... Open

 Description   

ew.

$ cat /tmp/build-mariadb-server-10.6-test-datadir/test/v1.frm 
TYPE=VIEW
 
query=select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1`
 
md5=241984afc55470952f685ea3db8dae21
 
updatable=1
 
algorithm=0
 
definer_user=dan
 
definer_host=localhost
 
suid=2
 
with_check_option=0
 
timestamp=2021-03-26 01:02:39
 
create-version=2
 
source=SELECT * FROM t1 FOR UPDATE
 
client_cs_name=utf8
 
connection_cl_name=utf8_general_ci
 
view_body_utf8=select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1`
 
mariadb-version=100600



 Comments   
Comment by Sergei Golubchik [ 2021-03-29 ]

I'd suggest to start from actually verifying the checksum, advanced or not.

Otherwise I can suggest many things to do in the server that would be better use of your time than improving a checksum that nobody ever verifies.

Generated at Thu Feb 08 09:36:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.