I suspect that test that high part of UUID will be different, but on fast machines (with not so precise tiers) it can be same. And low part is random so 50% chance test fails.
There is no way to test it reliable without 100 millisecond delay. Doubt we support pause function. Suggest to remove test or replace with SELECT RANDOM_UUID(7) = RANDOM_UUID(7); Maybe add unit test to ValueUuid#getNewRandom воскресенье, 11 августа 2024 г. в 21:46:04 UTC+3, Alex Tsvetkov: > Hi. > > I have strange error while building main branch in github CI. > > I can't reproduce it locally. > > > 15:34:20 00:00.004 org.h2.test.db.TestIgnoreCatalogs > > Test (21023 KB used) > > ERROR: org/h2/test/scripts/functions/numeric/random-uuid.sql > l> ine: 13 > > exp: >> TRUE > > got: >> FALSE > > ------------------------------ > > 15:34:31 00:10.261 org.h2.test.scripts.TestScript FAIL > java.lang.Exception: errors in script found > > ERROR: FAIL () java.lang.Exception: errors in script found > java.lang.Exception: errors in script found ------------------------------ > > java.lang.Exception: errors in script found > > at org.h2.test.scripts.TestScript.test(TestScript.java:245) > > at org.h2.test.TestBase.runTest(TestBase.java:145) > > at org.h2.test.TestAll.addTest(TestAll.java:994) > > at org.h2.test.TestAll.test(TestAll.java:711) > > at org.h2.test.TestAll.runTests(TestAll.java:626) > > at org.h2.test.TestAll.testAll(TestAll.java:551) > > at org.h2.test.TestAll.run(TestAll.java:492) > > at org.h2.test.TestAll.main(TestAll.java:436) > > > Sql contains following lines: > > SELECT RANDOM_UUID(7) < RANDOM_UUID(7); > >> TRUE > > > Any suggestion on how to fix that? > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/50649247-52e0-4b7b-b7d8-f19881193e03n%40googlegroups.com.