Changeset: 83ec245ac136 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/83ec245ac136 Modified Files: sql/test/bincopy/Tests/bincopy_support.py Branch: default Log Message:
"Approve" after changeset 8e968b9a4945. diffs (188 lines): diff --git a/sql/test/bincopy/Tests/bincopy_support.py b/sql/test/bincopy/Tests/bincopy_support.py --- a/sql/test/bincopy/Tests/bincopy_support.py +++ b/sql/test/bincopy/Tests/bincopy_support.py @@ -94,19 +94,19 @@ INTS = (""" CREATE TABLE foo(id INT NOT NULL); COPY BINARY INTO foo(id) FROM @ints@ @ON@; SELECT COUNT(DISTINCT id) FROM foo; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) MORE_INTS = (""" CREATE TABLE foo(id INT NOT NULL, i INT); COPY BINARY INTO foo(id, i) FROM @ints@, @more_ints@ @ON@; SELECT COUNT(id) FROM foo WHERE i = id + 1; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) STRINGS = (""" CREATE TABLE foo(id INT NOT NULL, s VARCHAR(20)); COPY BINARY INTO foo(id, s) FROM @ints@, @strings@ @ON@; SELECT COUNT(id) FROM foo WHERE s = ('int' || id); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) NULL_INTS = (""" CREATE TABLE foo(id INT NOT NULL, i INT); @@ -114,7 +114,7 @@ COPY BINARY INTO foo(id, i) FROM @ints@, SELECT COUNT(id) FROM foo WHERE (id % 2 = 0 AND i IS NULL) OR (id % 2 = 1 AND i = id); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) LARGE_STRINGS = (""" CREATE TABLE foo(id INT NOT NULL, s TEXT); @@ -122,7 +122,7 @@ COPY BINARY INTO foo(id, s) FROM @ints@, SELECT COUNT(id) FROM foo WHERE (id % 10000 <> 0 AND LENGTH(s) = 9) OR (id % 10000 = 0 AND LENGTH(s) = 280000 + 9); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) BROKEN_STRINGS = (""" CREATE TABLE foo(id INT NOT NULL, s TEXT); @@ -135,7 +135,7 @@ NEWLINE_STRINGS = (r""" CREATE TABLE foo(id INT NOT NULL, s TEXT); COPY BINARY INTO foo(id, s) FROM @ints@, @newline_strings@ @ON@; SELECT COUNT(id) FROM foo WHERE s = (E'RN\nR\r' || id); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) NULL_STRINGS = (""" CREATE TABLE foo(id INT NOT NULL, s TEXT); @@ -143,7 +143,7 @@ COPY BINARY INTO foo(id, s) FROM @ints@, SELECT COUNT(id) FROM foo WHERE (id % 2 = 0 AND s IS NULL) OR (id % 2 = 1 AND s = 'banana'); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) TIMESTAMPS = (""" CREATE TABLE foo( @@ -212,19 +212,19 @@ SELECT * FROM foo WHERE 1000000 * CAST(EXTRACT(SECOND FROM tm) AS DECIMAL(13,6)) <> 1000000 * "second" + ms LIMIT 4; -""", [f"{NRECS} affected rows"]) +""", []) PARTIAL = (""" CREATE TABLE foo(id INT NOT NULL, i INT, j INT NULL); COPY BINARY INTO foo(id, i) FROM @ints@, @more_ints@ @ON@; SELECT COUNT(id) FROM foo WHERE i = id + 1 AND j IS NULL; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) BOOLS = (""" CREATE TABLE foo(id INT NOT NULL, b BOOL); COPY BINARY INTO foo(id, b) FROM @ints@, @bools@ @ON@; SELECT COUNT(id) FROM foo WHERE b = (id % 2 <> 0); -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) INCONSISTENT_LENGTH = (""" CREATE TABLE foo(id INT NOT NULL, i INT); @@ -237,13 +237,13 @@ FLOATS = (""" CREATE TABLE foo(id INT NOT NULL, r REAL); COPY BINARY INTO foo(id, r) FROM @ints@, @floats@ @ON@; SELECT COUNT(id) FROM foo WHERE CAST(id AS REAL) + 0.5 = r; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) DOUBLES = (""" CREATE TABLE foo(id INT NOT NULL, d DOUBLE); COPY BINARY INTO foo(id, d) FROM @ints@, @doubles@ @ON@; SELECT COUNT(id) FROM foo WHERE CAST(id AS REAL) + 0.5 = d; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) INTEGER_TYPES = (""" CREATE TABLE foo(t TINYINT, s SMALLINT, i INT, b BIGINT); @@ -281,7 +281,7 @@ FROM verified GROUP BY t_s, s_i, i_b ORDER BY t_s, s_i, i_b ; -""", [f"{NRECS} affected rows", f"true,true,true,{NRECS}"]) +""", [f"true,true,true,{NRECS}"]) HUGE_INTS = (""" CREATE TABLE foo(b BIGINT, h HUGEINT); @@ -314,7 +314,7 @@ FROM verified GROUP BY b_h ORDER BY b_h ; -""", [f"{NRECS} affected rows", f"true,{NRECS}"]) +""", [f"true,{NRECS}"]) DECIMALS = (""" -- 1..2 TINYINT @@ -366,7 +366,7 @@ SELECT FROM verified GROUP BY d1_1_ok, d2_1_ok, d3_2_ok, d4_2_ok, d5_2_ok, d9_2_ok, d10_2_ok, d18_2_ok ; -""", [f"{NRECS} affected rows", f"true,true,true,true,true,true,true,true,{NRECS}"]) +""", [f"true,true,true,true,true,true,true,true,{NRECS}"]) HUGE_DECIMALS = (""" -- 19..38 HUGEINT @@ -385,7 +385,7 @@ SELECT FROM foo GROUP BY d19_ok, d38_ok ; -""", [f"{NRECS} affected rows", f"true,true{NRECS}"]) +""", [f"true,true{NRECS}"]) URLS = (""" -- currently every string is accepted as a url @@ -393,7 +393,7 @@ URLS = (""" CREATE TABLE foo(u URL); COPY BINARY INTO foo FROM @strings@ @ON@; SELECT COUNT(*) FROM foo; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) JSON_OBJECTS = (""" CREATE TABLE foo(i INT, j JSON); @@ -402,7 +402,7 @@ SELECT COUNT(*) FROM foo WHERE (i % 100 = 99 AND j IS NULL) OR (i % 100 <> 99 AND j IS NOT NULL) ; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) UUIDS = (""" CREATE TABLE foo(t CHAR(16), u UUID); @@ -411,7 +411,7 @@ SELECT COUNT(*) FROM foo WHERE t = CAST(u AS TEXT) OR u IS NULL ; -""", [f"{NRECS} affected rows", f"{NRECS}"]) +""", [f"{NRECS}"]) LITTLE_ENDIANS = (""" CREATE TABLE foo(t TINYINT, s SMALLINT, i INT, b BIGINT, f FLOAT(4), d DOUBLE); @@ -454,7 +454,7 @@ FROM verified GROUP BY t_s, s_i, i_b, f_d ORDER BY t_s, s_i, i_b, f_d ; -""", [f"{NRECS} affected rows", f"true,true,true,true,{NRECS}"]) +""", [f"true,true,true,true,{NRECS}"]) BIG_ENDIANS = (""" CREATE TABLE foo(t TINYINT, s SMALLINT, i INT, b BIGINT, f FLOAT(4), d DOUBLE); @@ -497,7 +497,7 @@ FROM verified GROUP BY t_s, s_i, i_b, f_d ORDER BY t_s, s_i, i_b, f_d ; -""", [f"{NRECS} affected rows", f"true,true,true,true,{NRECS}"]) +""", [f"true,true,true,true,{NRECS}"]) NATIVE_ENDIANS = (""" CREATE TABLE foo(t TINYINT, s SMALLINT, i INT, b BIGINT, f FLOAT(4), d DOUBLE); @@ -541,4 +541,4 @@ GROUP BY t_s, s_i, i_b, f_d ORDER BY t_s, s_i, i_b, f_d LIMIT 4; ; -""", [f"{NRECS} affected rows", f"true,true,true,true,{NRECS}"]) +""", [f"true,true,true,true,{NRECS}"]) _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list