drizzleslap where condition not random

[Andrew Hutchings]

drizzleslap WHERE condition is not random.

bin/drizzleslap --only-print --label=update-commit --concurrency=50 --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --number-of-queries=100000 --auto-generate-sql-write-number=50000 --commit=8 --engine=innodb > out.sq

grep 796c4422-1d94-102a-9d6d-00e0812d out.sql | wc -l
1000000

796c4422-1d94-102a-9d6d-00e0812d is as every where condition in this case it seems

[Andrew Hutchings (linuxjedi)]

This only affects --only-print and BLACKHOLE engine.

This is a flaw in the way mysqlslap (and therefore drizzleslap) is designed. By default it uses NULL or uuid() drizzle function to insert and does this on multiple threads and then a select on the pkey to fill the pkey list.

To fix this INSERT generation needs to be completely re-written to generate uuids in code and in a different place so that there are no duplicates.

This will require an OO re-write of drizzleslap. Which may be something for another time. For now Won't Fix.