Changeset: 8e32d3dfe267 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8e32d3dfe267 Added Files: sql/test/mapi/Tests/mal_int128.mal.test sql/test/mapi/Tests/sql_dec38.test sql/test/mapi/Tests/sql_int128.test Modified Files: testing/SQLogicConvertNotes Branch: mtest Log Message:
add tests for mapi diffs (200 lines): diff --git a/sql/test/mapi/Tests/mal_int128.mal.test b/sql/test/mapi/Tests/mal_int128.mal.test new file mode 100644 --- /dev/null +++ b/sql/test/mapi/Tests/mal_int128.mal.test @@ -0,0 +1,70 @@ +statement ok +a:hge := 1234567890987654321:hge + +statement ok +b:hge := 10000000000:hge + +statement ok +c:hge := calc.*(a,b) + +statement ok +d:hge := calc.*(c,b) + +statement ok +e:hge := calc.+(d,a) + +query T rowsort +io.print(a) +---- +1234567890987654321 + +query T rowsort +io.print(b) +---- +10000000000 + +query T rowsort +io.print(c) +---- +12345678909876543210000000000 + +query T rowsort +io.print(d) +---- +123456789098765432100000000000000000000 + +query T rowsort +io.print(e) +---- +123456789098765432101234567890987654321 + +query T rowsort +io.print(123456789098765432101234567890987654321) +---- +123456789098765432101234567890987654321 + +query T rowsort +io.print(123456789098765432101234567890987654321H) +---- +123456789098765432101234567890987654321 + +query T rowsort +io.print(123456789098765432101234567890987654321:hge) +---- +123456789098765432101234567890987654321 + +statement ok +z := bat.new(:hge) + +statement ok +z := bat.append(z,123456789098765432101234567890987654321) + +statement ok +z := bat.append(z,123456789098765432101234567890987654321H) + +statement ok +z := bat.append(z,123456789098765432101234567890987654321:hge) + +statement error +io.print(z) + diff --git a/sql/test/mapi/Tests/sql_dec38.test b/sql/test/mapi/Tests/sql_dec38.test new file mode 100644 --- /dev/null +++ b/sql/test/mapi/Tests/sql_dec38.test @@ -0,0 +1,19 @@ +statement ok +START TRANSACTION + +statement ok +CREATE TABLE sql_dec38 (d38_0 DECIMAL(38,0), d38_19 DECIMAL(38,19), d38_38 DECIMAL(38,38)) + +statement ok +INSERT INTO sql_dec38 VALUES (12345678901234567899876543210987654321, 1234567890123456789.9876543210987654321, .12345678901234567899876543210987654321) + +query RRR rowsort +SELECT * FROM sql_dec38 +---- +12345678901234567525491324606797053952.000 +1234567890123456768.000 +0.123 + +statement ok +ROLLBACK + diff --git a/sql/test/mapi/Tests/sql_int128.test b/sql/test/mapi/Tests/sql_int128.test new file mode 100644 --- /dev/null +++ b/sql/test/mapi/Tests/sql_int128.test @@ -0,0 +1,85 @@ +statement ok +CREATE TABLE mytest(a HUGEINT, b HUGEINT, c HUGEINT, d HUGEINT, e HUGEINT) + +statement ok +INSERT INTO mytest VALUES (1234567890987654321, 10000000000, NULL, NULL, NULL) + +query T rowsort +explain UPDATE mytest SET a = 1234567890987654321 +---- +41 values hashing to 1c084d228b7b2124b93eb0427491dda0 + +query T rowsort +explain UPDATE mytest SET b = 10000000000 +---- +41 values hashing to 88f71d6252adaf84f68dd1f9d52ce321 + +query T rowsort +explain UPDATE mytest SET c = a * b +---- +43 values hashing to 7e215ac0e5f6dc086d0c5e744494aa1e + +query T rowsort +explain UPDATE mytest SET d = c * b +---- +43 values hashing to 2c0ddf982d5fe5bea549c9f97fa04d6e + +query T rowsort +explain UPDATE mytest SET e = d + a +---- +43 values hashing to 9e2989edc560d0df97c5a8cc52aa5955 + +statement ok + UPDATE mytest SET a = 1234567890987654321 + +statement ok + UPDATE mytest SET b = 10000000000 + +statement ok + UPDATE mytest SET c = a * b + +statement ok + UPDATE mytest SET d = c * b + +statement ok + UPDATE mytest SET e = d + a + +query IIIII rowsort +SELECT a, b, c, d, e from mytest +---- +1234567890987654321 +10000000000 +12345678909876543210000000000 +123456789098765432100000000000000000000 +123456789098765432101234567890987654321 + +statement ok +DROP TABLE mytest + +query I rowsort +SELECT 123456789098765432101234567890987654321 +---- +123456789098765432101234567890987654321 + +statement ok +START TRANSACTION + +statement ok +CREATE TABLE sql_int128 (i HUGEINT) + +query T rowsort +explain INSERT INTO sql_int128 VALUES (123456789098765432101234567890987654321) +---- +34 values hashing to a8230839e57945f6864ae7638d25f0b5 + +statement ok + INSERT INTO sql_int128 VALUES (123456789098765432101234567890987654321) + +query I rowsort +SELECT * FROM sql_int128 +---- +123456789098765432101234567890987654321 + +statement ok +ROLLBACK + diff --git a/testing/SQLogicConvertNotes b/testing/SQLogicConvertNotes --- a/testing/SQLogicConvertNotes +++ b/testing/SQLogicConvertNotes @@ -39,6 +39,7 @@ Converted folders progress: - sql/test/analytics/Tests pass - sql/test/scanner/Tests pass - sql/test/quantiles/Tests pass +- sql/test/mapi/Tests pass - sql/test/json/Tests pass - sql/test/Tests pass - sql/test/ADT2006 pass _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
