Changeset: 05311c27f175 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/05311c27f175
Modified Files:
sql/test/BugTracker-2026/Tests/7925-inconsistent-compare-varchar-to-bte-bug.test
sql/test/BugTracker-2026/Tests/All
Branch: default
Log Message:
approved output for test of issue #7925, correctly gives errors.
diffs (45 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/7925-inconsistent-compare-varchar-to-bte-bug.test
b/sql/test/BugTracker-2026/Tests/7925-inconsistent-compare-varchar-to-bte-bug.test
---
a/sql/test/BugTracker-2026/Tests/7925-inconsistent-compare-varchar-to-bte-bug.test
+++
b/sql/test/BugTracker-2026/Tests/7925-inconsistent-compare-varchar-to-bte-bug.test
@@ -16,7 +16,7 @@ INSERT INTO t_bug15 VALUES
(4, -26, 0, 'gamma', -74)
-- original window query
-query I nosort
+statement error 22018!conversion of string to type bte failed.
SELECT v
FROM (
SELECT v,
@@ -30,11 +30,10 @@ FROM (
WHERE wa >= 1
AND wa < 3
ORDER BY v
-----
-- equivalent rewrite
-- MonetDB fails with error: 22018!conversion of string to type bte failed.
-query I nosort
+statement error 22018!conversion of string to type bte failed.
SELECT t1.v
FROM t_bug15 AS t1
WHERE (
@@ -52,7 +51,6 @@ WHERE (
LIMIT 1 OFFSET 1
) < 3
ORDER BY t1.v
-----
-- equivalent rewrite, but with manually changed comparisons against varchars
query I nosort
diff --git a/sql/test/BugTracker-2026/Tests/All
b/sql/test/BugTracker-2026/Tests/All
--- a/sql/test/BugTracker-2026/Tests/All
+++ b/sql/test/BugTracker-2026/Tests/All
@@ -119,7 +119,7 @@ KNOWNFAIL?7774-insert-into-renamed-table
KNOWNFAIL?7922-sum-overflow-error-bug
7923-sum-decimal-conversion-overflow-bug
KNOWNFAIL?7924-sum-double-overflow-bug
-KNOWNFAIL?7925-inconsistent-compare-varchar-to-bte-bug
+7925-inconsistent-compare-varchar-to-bte-bug
KNOWNFAIL?7926-lag-null-changes-error-issue
7927-ALGouterselect-assertion-failure
KNOWNFAIL?7928-rel2bin_semijoin-assertion-failure
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]