Changeset: 0df1ad3492f7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0df1ad3492f7
Added Files:
sql/test/strimps/Tests/strimps_stable_counts2.test
Modified Files:
gdk/gdk_strimps.h
sql/test/strimps/Tests/All
Branch: Jun2023
Log Message:
If --forcemito is enabled them STRIMP_CREATION_THRESHOLD = 100. New strimps
correctness test.
diffs (truncated from 699 to 300 lines):
diff --git a/gdk/gdk_strimps.h b/gdk/gdk_strimps.h
--- a/gdk/gdk_strimps.h
+++ b/gdk/gdk_strimps.h
@@ -18,7 +18,8 @@
#define STRIMP_HISTSIZE 256*256
#define STRIMP_HEADER_SIZE 64
#define STRIMP_PAIRS (STRIMP_HEADER_SIZE - 1)
-#define STRIMP_CREATION_THRESHOLD 5000
+#define STRIMP_CREATION_THRESHOLD \
+ ((ATOMIC_GET(&GDKdebug) & FORCEMITOMASK)? 100 : 5000)
typedef struct {
uint8_t *pbytes;
diff --git a/sql/test/strimps/Tests/All b/sql/test/strimps/Tests/All
--- a/sql/test/strimps/Tests/All
+++ b/sql/test/strimps/Tests/All
@@ -1,3 +1,4 @@
strimps_stable_counts
+strimps_stable_counts2
persisted_strimp
strimps_not_like
diff --git a/sql/test/strimps/Tests/strimps_stable_counts2.test
b/sql/test/strimps/Tests/strimps_stable_counts2.test
new file mode 100644
--- /dev/null
+++ b/sql/test/strimps/Tests/strimps_stable_counts2.test
@@ -0,0 +1,673 @@
+statement ok
+CREATE TABLE fal(x STRING)
+
+statement ok
+CREATE TABLE f(y STRING)
+
+statement ok
+COPY 100 RECORDS INTO fal FROM STDIN
+<COPY_INTO_DATA>
+Mary Garcia
+James Ballard
+Alexandria Harris
+Dakota Howell
+Tracy Glover
+Mark Cook
+James Woodard
+Sophia Stone
+Jeffrey Ramirez
+Ryan Knight
+Taylor Lane
+Christopher Russell
+Daniel Sims
+Tony Watts
+Dwayne Johnson
+Jason Dunlap
+Abigail Burton
+Maria Lewis
+Ashley Taylor
+Emma Abbott
+James Whitney
+Philip Maldonado
+Rachel Taylor
+Tina Singleton
+Ricky Johnson
+Anthony Peterson
+Eugene Mata
+Tyler Terry
+Thomas Morales
+Kathy Moore
+William Franco
+Christopher Williams
+David Carter
+Andrew Alvarado
+John Jenkins
+Anthony Charles
+Jose Tran
+Amy Stafford
+Vincent Malone
+Ashley Waters
+Cindy Huffman
+Anthony Hernandez
+Brett Hardy
+Lisa Matthews
+Jeffrey Ingram
+Jessica Miller
+Karen Jones
+Terry Sanders
+Aaron Rodriguez
+Kyle Ortega
+David Clark
+Brent Garrett
+Scott Young
+Shannon Edwards
+Tiffany Macias
+Ricky Gonzalez
+Devin Logan
+Russell Walker
+Michael Nguyen
+Heather Robinson
+April Lawrence
+Christopher Williams
+Laura Gonzalez
+Patrick Ortiz
+Sylvia Phillips
+Cynthia Kemp
+Stephanie Gillespie
+Elizabeth Joseph
+Jay Collins
+Johnny Gibson
+Dr. Audrey Sellers MD
+Desiree Li
+Heather Brown
+Shelly Bauer
+Donna Anderson
+Amy Sharp
+Olivia Howell
+Margaret Tran
+Alexandra Jarvis
+Glen Ray
+Michael Mendoza
+Sarah Hall
+Dennis Moss
+Wanda Brooks
+Debra Powers
+Shannon Nguyen
+Daisy Mcdonald
+Donna Rivera
+Samuel Jackson
+Wendy Howe
+Connor Howell
+Jeffrey Newman
+Daniel Sullivan
+Megan Dunn
+Laura Holland
+Brendan Bates
+Mary Miller
+Thomas Ramirez
+Leah Holland
+Megan Warren
+
+statement ok
+COPY 100 RECORDS INTO f FROM STDIN
+<COPY_INTO_DATA>
+Noah
+Ronald
+Mary
+Jennifer
+Tanya
+Ivan
+Randy
+Erin
+Ryan
+Scott
+Kathryn
+Brandi
+Rebecca
+Katie
+Diane
+Stephen
+Michael
+Jeremiah
+Timothy
+James
+Mark
+Thomas
+Leslie
+Robert
+Joel
+James
+Anna
+Alan
+Janet
+Samuel
+Tanya
+Russell
+Alexis
+Scott
+Jenna
+Eric
+Andrew
+Sandra
+Stephanie
+Jeremy
+Don
+Lisa
+Jacqueline
+Melissa
+Patricia
+Ana
+Danielle
+Cheryl
+Justin
+Karen
+Pamela
+Beverly
+Becky
+Caitlin
+Michael
+Emma
+Darlene
+Darrell
+David
+Wanda
+Sydney
+Susan
+Louis
+Brittany
+William
+Daniel
+Laura
+Kevin
+Jonathon
+James
+Robert
+Denise
+Cassandra
+Stephanie
+Samuel
+Kaitlyn
+David
+Katrina
+Nathan
+Jessica
+Michelle
+Veronica
+Rachel
+Andrew
+Jennifer
+William
+Melanie
+Larry
+Ronald
+Sally
+Joshua
+Chelsea
+Ashley
+Johnny
+Chad
+Nicole
+Joshua
+Michele
+Joseph
+Carolyn
+
+query TT
+SELECT * FROM fal,f WHERE [fal.x] startswith [f.y] ORDER BY x
+----
+Andrew Alvarado
+Andrew
+Andrew Alvarado
+Andrew
+Ashley Taylor
+Ashley
+Ashley Waters
+Ashley
+Daniel Sims
+Daniel
+Daniel Sullivan
+Daniel
+David Carter
+David
+David Carter
+David
+David Clark
+David
+David Clark
+David
+Donna Anderson
+Don
+Donna Rivera
+Don
+Emma Abbott
+Emma
+James Ballard
+James
+James Ballard
+James
+James Ballard
+James
+James Whitney
+James
+James Whitney
+James
+James Whitney
+James
+James Woodard
+James
+James Woodard
+James
+James Woodard
+James
+Jessica Miller
+Jessica
+Johnny Gibson
+Johnny
+Karen Jones
+Karen
+Laura Gonzalez
+Laura
+Laura Holland
+Laura
+Lisa Matthews
+Lisa
+Mark Cook
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
