Changeset: 23715c6abab5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=23715c6abab5
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.sql
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:
Use smaller numbers, so the query doesn't give errors on non hugeint platforms
diffs (57 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -66,20 +66,20 @@ select "insert"('屁{珙', 1, 1, '1'), "insert"('屁{珙', 1, 1,
'抔'), "insert"('屁抔珙', 1, 1, 'ಜ'), "insert"('a', 0, 1, 'ಜ'), "insert"('a', 0, 0,
'ಜ');
select "insert"('屁{珙', 1, 1, '1'), "insert"('屁{珙', 1, 1, '抔'), "insert"('屁抔珙',
1, 1, 'ಜ') from t0;
ROLLBACK;
-CREATE TABLE t0(c0 boolean, c1 boolean, c2 serial, UNIQUE(c0, c1)); -- Bug 6920
-INSERT INTO t0(c1) VALUES((0.5968066098520423) NOT BETWEEN SYMMETRIC
(CAST(length(upper(r'z')) AS INT)) AND (1347145665)), (FALSE);
+CREATE TABLE t0(c0 boolean, c1 boolean, c2 int, UNIQUE(c0, c1)); -- Bug 6920
+INSERT INTO t0(c1) VALUES((0.5) NOT BETWEEN SYMMETRIC
(CAST(length(upper(r'z')) AS INT)) AND (2)), (FALSE);
INSERT INTO t0(c0) VALUES(TRUE);
INSERT INTO t0(c1) VALUES(FALSE), (TRUE);
-INSERT INTO t0(c2, c0, c1) VALUES(1347145665, (ltrim(lower(r'K'),
((upper(r'296348087'))||(- (1582370739))))) IS NOT NULL, (((lower(r'ö
-eg#K,纗HSJw!{cOw⇒l/l!B*H'))||(((CAST(0.12411368110083143 AS
INT))+(-1795901173))))) IN (lower(CAST(TRUE AS STRING)))), (-1795901173, NULL,
(0.9575114678279173) NOT IN (2.96348087E8, 0.5010777753365665)), (1922411524,
TRUE, (0.5020325273627405) NOT IN (-1388966352, 1163825182));
+INSERT INTO t0(c2, c0, c1) VALUES(2, (ltrim(lower(r'K'), ((upper(r'4'))||(-
(7))))) IS NOT NULL, (((lower(r'ö
+eg#K,纗HSJw!{cOw⇒l/l!B*H'))||(((CAST(0.1 AS INT))+(-5))))) IN (lower(CAST(TRUE
AS STRING)))), (-9, NULL, (0.3) NOT IN (2.96348087E8, 0.3)), (4, TRUE, (0.5)
NOT IN (-3, 4));
INSERT INTO t0(c1) VALUES(TRUE);
INSERT INTO t0(c1, c2) VALUES(FALSE, 623585248);
-INSERT INTO t0(c0) VALUES(NOT (NOT ((((-1388966352)*(-984145454))) NOT IN
(0.7356286)))), (FALSE);
+INSERT INTO t0(c0) VALUES(NOT (NOT ((((-1)*(-9))) NOT IN (0.7)))), (FALSE);
INSERT INTO t0(c0) VALUES(TRUE);
-INSERT INTO t0(c2) VALUES(-1235619315);
+INSERT INTO t0(c2) VALUES(-1);
DELETE FROM t0 WHERE (t0.c0) = FALSE;
-INSERT INTO t0(c1, c0, c2) VALUES(TRUE, ((+ (-
(1580722914)))>(charindex(CAST(0.347536126443453330381316845887340605258941650390625
AS STRING), ((CAST(TRUE AS
STRING(771)))||(0.2182260714120349831546263885684311389923095703125)),
length(r'd')))), -1819817735);
-UPDATE t0 SET c2 = DEFAULT WHERE ((((t0.c1)OR(CAST(t0.c2 AS
BOOLEAN))))OR((CAST(0.6873694879073857 AS DECIMAL)) NOT IN
(0.10021624439224552371996423971722833812236785888671875)));
+INSERT INTO t0(c1, c0, c2) VALUES(TRUE, ((+ (- (1)))>(charindex(CAST(0.3 AS
STRING), ((CAST(TRUE AS STRING(771)))||(0.2)), length(r'd')))), -1);
+UPDATE t0 SET c2 = 1 WHERE ((((t0.c1)OR(CAST(t0.c2 AS BOOLEAN))))OR((CAST(0.6
AS DECIMAL)) NOT IN (0.1)));
SELECT t0.c0 FROM t0 WHERE ((CAST(t0.c2 AS INT)) NOT BETWEEN ASYMMETRIC
(abs(t0.c2)) AND (((t0.c2)/(t0.c2)))) NOT BETWEEN ASYMMETRIC (t0.c0) AND
((t0.c2) NOT IN (t0.c2));
SELECT t0.c0 FROM t0 WHERE (t0.c2) BETWEEN (t0.c0) AND ((t0.c2) NOT IN
(t0.c2));
DROP TABLE t0;
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -159,20 +159,11 @@ stdout of test 'sqlancer03` in directory
% c0 # name
% boolean # type
% 5 # length
-[ NULL ]
-[ NULL ]
+[ true ]
[ true ]
-[ NULL ]
-[ NULL ]
[ true ]
-[ NULL ]
-[ true ]
-[ NULL ]
-[ NULL ]
[ true ]
[ false ]
-[ true ]
-[ NULL ]
#SELECT t0.c0 FROM t0 WHERE (t0.c2) BETWEEN (t0.c0) AND ((t0.c2) NOT IN
(t0.c2));
% sys.t0 # table_name
% c0 # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
