Changeset: 73cec69fb75d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/73cec69fb75d Added Files: sql/test/BugTracker-2024/Tests/atom_cmp-Bug-7477.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7477 diffs (32 lines): diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -37,3 +37,4 @@ SQLunionfunc-Bug-7473 VLTgenerator_table-Bug-7474 exp_equal-Bug-7475 rel2bin_join-Bug-7476 +atom_cmp-Bug-7477 diff --git a/sql/test/BugTracker-2024/Tests/atom_cmp-Bug-7477.test b/sql/test/BugTracker-2024/Tests/atom_cmp-Bug-7477.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/atom_cmp-Bug-7477.test @@ -0,0 +1,19 @@ +-- trying first without function "abs ( x )" +statement error TypeException:user.main[12]:'calc.==' undefined in: X_0:bit := calc.==(X_1:str, X_2:bte); +SELECT - 66 x GROUP BY x HAVING ( x IN ( SELECT '' x WHERE ( x = ( x = 1 ) ) UNION SELECT 1 ) ) + +-- changing '' into 1, so a string into int +query I nosort +SELECT - 66 x GROUP BY x HAVING ( x IN ( SELECT 1 x WHERE ( x = ( x = 1 ) ) UNION SELECT 1 ) ) +---- +-66 + +query I nosort +SELECT - 66 x GROUP BY x HAVING ( abs ( x ) IN ( SELECT 1 x WHERE ( x = ( x = 1 ) ) UNION SELECT 1 ) ) +---- +-66 + +skipif knownfail +statement error TypeException:user.main[12]:'calc.==' undefined in: X_0:bit := calc.==(X_1:str, X_2:bte); +SELECT - 66 x GROUP BY x HAVING ( abs ( x ) IN ( SELECT '' x WHERE ( x = ( x = 1 ) ) UNION SELECT 1 ) ) + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
