Changeset: be41c8cdf35d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/be41c8cdf35d Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test monetdb5/modules/atoms/str.c sql/server/sql_atom.c Branch: default Log Message:
Merge with Dec2023 branch. diffs (truncated from 676 to 300 lines): diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test --- a/clients/Tests/MAL-signatures-hge.test +++ b/clients/Tests/MAL-signatures-hge.test @@ -50692,7 +50692,7 @@ str contains pattern str.contains(X_0:str, X_1:str, X_2:bit):bit STRcontains; -Check if string chaystack contains string needle, icase flag. +Check if string haystack contains string needle, icase flag. str containsjoin pattern str.containsjoin(X_0:bat[:str], X_1:bat[:str], X_2:bat[:bit], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, X_7:bit) (X_8:bat[:oid], X_9:bat[:oid]) diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.test +++ b/clients/Tests/MAL-signatures.test @@ -39017,7 +39017,7 @@ str contains pattern str.contains(X_0:str, X_1:str, X_2:bit):bit STRcontains; -Check if string chaystack contains string needle, icase flag. +Check if string haystack contains string needle, icase flag. str containsjoin pattern str.containsjoin(X_0:bat[:str], X_1:bat[:str], X_2:bat[:bit], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, X_7:bit) (X_8:bat[:oid], X_9:bat[:oid]) diff --git a/monetdb5/mal/Tests/All b/monetdb5/mal/Tests/All --- a/monetdb5/mal/Tests/All +++ b/monetdb5/mal/Tests/All @@ -7,7 +7,6 @@ tst005 tst006 tst007 tst008 -tst009 tst010 tst011 tst012 diff --git a/monetdb5/modules/atoms/Tests/startswith_join.test b/monetdb5/modules/atoms/Tests/startswith_join.test --- a/monetdb5/modules/atoms/Tests/startswith_join.test +++ b/monetdb5/modules/atoms/Tests/startswith_join.test @@ -99,3 +99,333 @@ drop table foo statement ok drop table bar + +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 rowsort +SELECT * FROM fal,f WHERE [fal.x] startswith [f.y] +---- +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 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
