Changeset: e5836983087f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e5836983087f
Added Files:
sql/test/BugTracker-2026/Tests/7855-ntile.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
add test for issue #7855
diffs (15 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7855-ntile.test
b/sql/test/BugTracker-2026/Tests/7855-ntile.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7855-ntile.test
@@ -0,0 +1,2 @@
+statement error ntile must be greater than zero.
+SELECT x , CASE WHEN x > 12 THEN 1 ELSE 0 END AS x FROM ( SELECT 10 AS x UNION
SELECT 11 AS x GROUP BY CUBE ( x , x ) UNION SELECT 12 AS x UNION SELECT 13 AS
x ) WHERE x IN ( WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION SELECT x + 1 FROM x
WHERE x < 20 ) SELECT x AS x FROM x WHERE x NOT IN ( 8 , 12 , CAST( 0.000000 AS
FLOAT ) , 24 , 32 ) OR x = 512 GROUP BY x HAVING NOT x < ANY ( CASE WHEN NULLIF
( ( WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION SELECT x + 1 FROM ( SELECT *
FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL right_shift ( NULL , - NTILE (
'{la.2.3,1.2.3.4.5.6,""}' IS NULL ) OVER ( ) * COUNT ( * ) + - - 58 - 83 * MAX
( - 327 + 0 ) ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT * FROM x
WHERE x IS NULL AND x < 1 ) WHERE ( x % 7 ) = 0 ) GROUP BY x HAVING NOT x = ANY
( - NULLIF ( 87 , CASE CAST( NULL AS INTEGER ) WHEN 13 / ( 0.490000 * - (
1000000 ) ) THEN 39 WHEN 70 * - 95 THEN 60 ELSE 15 + 25 END * 5 ) ) ) ) WHERE x
< 8 ) SELECT - COUNT ( * ) FROM x AS x WHERE NOT ( - x
) BETWEEN - x AND NULL ) , NULL ) IS NULL THEN 1 ELSE 0 END AND 6 IN ( SELECT
MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) ORDER BY
1 , 2 LIMIT 0 OFFSET 0 ) ) )
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
@@ -55,3 +55,4 @@ KNOWNFAIL?7774-insert-into-renamed-table
7851-assertion-failure
7853-in-rcte-generator
7854-rcte-trims
+7855-ntile
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
