Changeset: af7741d72cb1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/af7741d72cb1 Added Files: sql/test/strimps/Tests/strimps_with_nulls.test Modified Files: sql/test/strimps/Tests/All Branch: strimps-updates Log Message:
Add test with nulls diffs (137 lines): 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 @@ -3,3 +3,4 @@ strimps_stable_counts2 persisted_strimp strimps_not_like small_string_crash +strimps_with_nulls diff --git a/sql/test/strimps/Tests/strimps_with_nulls.test b/sql/test/strimps/Tests/strimps_with_nulls.test new file mode 100644 --- /dev/null +++ b/sql/test/strimps/Tests/strimps_with_nulls.test @@ -0,0 +1,124 @@ +statement ok +CREATE TABLE fal(x STRING) + +statement ok +COPY 100 RECORDS INTO fal FROM STDIN USING DELIMITERS ',',E'\n','"' NULL AS '' +<COPY_INTO_DATA> +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 +"" +"" + + +statement ok +ALTER TABLE fal SET READ ONLY + +statement ok +CREATE IMPRINTS INDEX fal_index ON fal(x) + +query T +SELECT * FROM fal WHERE x LIKE 'Daniel%' +---- +Daniel Sims +Daniel Sullivan + +query I +SELECT count(*) FROM fal WHERE x IS NULL +---- +4 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
