Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2025 02:11 AM - edited 03-21-2025 02:14 AM
Thanks for feedback @MarcoI've also tested with an older All-purpose Runtime 12.2 LTS and it works.
But its alarming that the latest runtime does not work as expected.
I will post SQL code so it will be easier for other to test. Both these queries give wrong results:
%sql
WITH a AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'bbb' as produktkod
),
b AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'ccc' as produktkod
)
SELECT a.*
FROM a
WHERE exists (
select 1 from b where a.produktkod = b.produktkod
);
%sql
WITH a AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'bbb' as produktkod
),
b AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'ccc' as produktkod
)
SELECT a.*,
(SELECT COUNT(1)
FROM b
WHERE b.produktkod = a.produktkod) as match_count
FROM a;
WITH a AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'bbb' as produktkod
),
b AS (
SELECT 'aaa' as produktkod
UNION ALL
SELECT 'ccc' as produktkod
)
SELECT a.*,
(SELECT COUNT(1)
FROM b
WHERE b.produktkod = a.produktkod) as match_count
FROM a;
