feat: Add runtime bloom filter for merge into

Open JackTan25 opened this issue 1 year ago • 22 comments

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/

Summary

We add target table block bloom filter for merge into runtime filter, so we can avoid scaning many uncorrelated blocks. MergeIntoBloom can make effect in one node for now, I need to refactor it later.

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> set enable_merge_into_source_build_bloom = 0;

SET
  enable_merge_into_source_build_bloom = 0

0 row read in 0.072 sec. Processed 0 row, 0 B (0 row/s, 0 B/s)

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> select count(*) from lineitem_target_origin_200_blocks1;

SELECT
  count(*)
FROM
  lineitem_target_origin_200_blocks1

┌───────────┐
│  count(*) │
│   UInt64  │
├───────────┤
│ 114729502 │
└───────────┘
1 row read in 4.638 sec. Processed 1 row, 1 B (0.22 row/s, 0 B/s)

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> select count(*) from small_table;

SELECT
  count(*)
FROM
  small_table

┌──────────┐
│ count(*) │
│  UInt64  │
├──────────┤
│   2000   │
└──────────┘
1 row read in 0.118 sec. Processed 1 row, 1 B (8.47 row/s, 8 B/s)

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> explain analyze MERGE INTO lineitem_target_origin_200_blocks1 as t1 using small_table as t2 on 
    t1.l_orderkey = t2.l_orderkey and
    t1.l_partkey = t2.l_partkey  and t1.l_suppkey = t2.l_suppkey and
    t1.l_linenumber = t2.l_linenumber and 
    t1.l_quantity = t2.l_quantity and 
    t1.l_extendedprice = t2.l_extendedprice and
    t1.l_discount = t2.l_discount
    when matched then update set     
    t1.l_orderkey = t2.l_orderkey,
    t1.l_partkey = t2.l_partkey,
    t1.l_suppkey = t2.l_suppkey,
    t1.l_linenumber = t2.l_linenumber,
    t1.l_quantity = t2.l_quantity,
    t1.l_extendedprice = t2.l_extendedprice,
    t1.l_discount = t2.l_discount,
    t1.l_tax = t2.l_tax,
    t1.l_returnflag = t2.l_returnflag,
    t1.l_linestatus = t2.l_linestatus,
    t1.l_shipdate = t2.l_shipdate,
    t1.l_commitdate = t2.l_commitdate,
    t1.l_receiptdate = t2.l_receiptdate,
    t1.l_shipinstruct = t2.l_shipinstruct,
    t1.l_shipmode = t2.l_shipmode,
    t1.l_comment = t2.l_comment
    when not matched then insert 
    values(    
    t2.l_orderkey,
    t2.l_partkey,
    t2.l_suppkey,
    t2.l_linenumber,
    t2.l_quantity,
    t2.l_extendedprice,
    t2.l_discount,
    t2.l_tax,
    t2.l_returnflag,
    t2.l_linestatus,
    t2.l_shipdate,
    t2.l_commitdate,
    t2.l_receiptdate,
    t2.l_shipinstruct,
    t2.l_shipmode,
    t2.l_comment);

EXPLAIN ANALYZE MERGE INTO lineitem_target_origin_200_blocks1 AS t1 USING small_table AS t2 ON t1.l_orderkey = t2.l_orderkey
AND t1.l_partkey = t2.l_partkey
AND t1.l_suppkey = t2.l_suppkey
AND t1.l_linenumber = t2.l_linenumber
AND t1.l_quantity = t2.l_quantity
AND t1.l_extendedprice = t2.l_extendedprice
AND t1.l_discount = t2.l_discount
WHEN matched THEN
UPDATE
SET
  t1.l_orderkey = t2.l_orderkey,
  t1.l_partkey = t2.l_partkey,
  t1.l_suppkey = t2.l_suppkey,
  t1.l_linenumber = t2.l_linenumber,
  t1.l_quantity = t2.l_quantity,
  t1.l_extendedprice = t2.l_extendedprice,
  t1.l_discount = t2.l_discount,
  t1.l_tax = t2.l_tax,
  t1.l_returnflag = t2.l_returnflag,
  t1.l_linestatus = t2.l_linestatus,
  t1.l_shipdate = t2.l_shipdate,
  t1.l_commitdate = t2.l_commitdate,
  t1.l_receiptdate = t2.l_receiptdate,
  t1.l_shipinstruct = t2.l_shipinstruct,
  t1.l_shipmode = t2.l_shipmode,
  t1.l_comment = t2.l_comment
  WHEN NOT matched THEN
INSERT
VALUES
(
    t2.l_orderkey,
    t2.l_partkey,
    t2.l_suppkey,
    t2.l_linenumber,
    t2.l_quantity,
    t2.l_extendedprice,
    t2.l_discount,
    t2.l_tax,
    t2.l_returnflag,
    t2.l_linestatus,
    t2.l_shipdate,
    t2.l_commitdate,
    t2.l_receiptdate,
    t2.l_shipinstruct,
    t2.l_shipmode,
    t2.l_comment
  )

-[ EXPLAIN ]-----------------------------------
HashJoin
├── output columns: [t1.l_orderkey (#16), t1.l_partkey (#17), t1.l_suppkey (#18), t1.l_linenumber (#19), t1.l_quantity (#20), t1.l_extendedprice (#21), t1.l_discount (#22), t1.l_tax (#23), t1.l_returnflag (#24), t1.l_linestatus (#25), t1.l_shipdate (#26), t1.l_commitdate (#27), t1.l_receiptdate (#28), t1.l_shipinstruct (#29), t1.l_shipmode (#30), t1.l_comment (#31), t1._row_id (#32), t2.l_orderkey (#0), t2.l_partkey (#1), t2.l_suppkey (#2), t2.l_linenumber (#3), t2.l_quantity (#4), t2.l_extendedprice (#5), t2.l_discount (#6), t2.l_tax (#7), t2.l_returnflag (#8), t2.l_linestatus (#9), t2.l_shipdate (#10), t2.l_commitdate (#11), t2.l_receiptdate (#12), t2.l_shipinstruct (#13), t2.l_shipmode (#14), t2.l_comment (#15)]
├── join type: RIGHT OUTER
├── build keys: [t2.l_orderkey (#0), t2.l_partkey (#1), t2.l_suppkey (#2), t2.l_linenumber (#3), t2.l_quantity (#4), t2.l_extendedprice (#5), t2.l_discount (#6)]
├── probe keys: [t1.l_orderkey (#16), t1.l_partkey (#17), t1.l_suppkey (#18), t1.l_linenumber (#19), t1.l_quantity (#20), t1.l_extendedprice (#21), t1.l_discount (#22)]
├── filters: []
├── estimated rows: 100000.00
├── cpu time: 29.065481ms
├── wait time: 2.593427483s
├── output rows: 100 thousand
├── output bytes: 15.50 MiB
├── memory usage: 28.52 MiB
├── TableScan(Build)
│   ├── table: default.merge_into_bloom.small_table
│   ├── output columns: [l_orderkey (#0), l_partkey (#1), l_suppkey (#2), l_linenumber (#3), l_quantity (#4), l_extendedprice (#5), l_discount (#6), l_tax (#7), l_returnflag (#8), l_linestatus (#9), l_shipdate (#10), l_commitdate (#11), l_receiptdate (#12), l_shipinstruct (#13), l_shipmode (#14), l_comment (#15)]
│   ├── read rows: 100000
│   ├── read bytes: 4120661
│   ├── partitions total: 1
│   ├── partitions scanned: 1
│   ├── pruning stats: [segments: <range pruning: 1 to 1>, blocks: <range pruning: 1 to 1, bloom pruning: 0 to 0>]
│   ├── push downs: [filters: [], limit: NONE]
│   ├── estimated rows: 100000.00
│   ├── cpu time: 28.051247ms
│   ├── wait time: 103.529285ms
│   ├── output rows: 100 thousand
│   ├── output bytes: 15.50 MiB
│   ├── bytes scanned: 15.50 MiB
│   └── memory usage: 10.60 MiB
└── TableScan(Probe)
    ├── table: default.merge_into_bloom.lineitem_target_origin_200_blocks1
    ├── output columns: [l_orderkey (#16), l_partkey (#17), l_suppkey (#18), l_linenumber (#19), l_quantity (#20), l_extendedprice (#21), l_discount (#22), l_tax (#23), l_returnflag (#24), l_linestatus (#25), l_shipdate (#26), l_commitdate (#27), l_receiptdate (#28), l_shipinstruct (#29), l_shipmode (#30), l_comment (#31), _row_id (#32)]
    ├── read rows: 114729502
    ├── read bytes: 3459114063
    ├── partitions total: 200
    ├── partitions scanned: 200
    ├── pruning stats: [segments: <range pruning: 1 to 1>, blocks: <range pruning: 200 to 200, bloom pruning: 0 to 0>]
    ├── push downs: [filters: [], limit: NONE]
    ├── estimated rows: 114729502.00
    ├── cpu time: 44.85101412s
    ├── wait time: 465.593236569s
    ├── bytes scanned: 7.81 KiB
    └── memory usage: 6.55 GiB

42 rows explain in 9.124 sec. Processed 0 rows, 0 B (0 rows/s, 0 B/s)

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> set enable_merge_into_source_build_bloom = 1;

SET
  enable_merge_into_source_build_bloom = 1

0 row read in 0.053 sec. Processed 0 row, 0 B (0 row/s, 0 B/s)

deploy@(merge_into_bloom_performance_test)/merge_into_bloom> explain analyze MERGE INTO lineitem_target_origin_200_blocks1 as t1 using small_table as t2 on
    t1.l_orderkey = t2.l_orderkey and
    t1.l_partkey = t2.l_partkey  and t1.l_suppkey = t2.l_suppkey and
    t1.l_linenumber = t2.l_linenumber and
    t1.l_quantity = t2.l_quantity and
    t1.l_extendedprice = t2.l_extendedprice and
    t1.l_discount = t2.l_discount
    when matched then update set
    t1.l_orderkey = t2.l_orderkey,
    t1.l_partkey = t2.l_partkey,
    t1.l_suppkey = t2.l_suppkey,
    t1.l_linenumber = t2.l_linenumber,
    t1.l_quantity = t2.l_quantity,
    t1.l_extendedprice = t2.l_extendedprice,
    t1.l_discount = t2.l_discount,
    t1.l_tax = t2.l_tax,
    t1.l_returnflag = t2.l_returnflag,
    t1.l_linestatus = t2.l_linestatus,
    t1.l_shipdate = t2.l_shipdate,
    t1.l_commitdate = t2.l_commitdate,
    t1.l_receiptdate = t2.l_receiptdate,
    t1.l_shipinstruct = t2.l_shipinstruct,
    t1.l_shipmode = t2.l_shipmode,
    t1.l_comment = t2.l_comment
    when not matched then insert
    values(
    t2.l_orderkey,
    t2.l_partkey,
    t2.l_suppkey,
    t2.l_linenumber,
    t2.l_quantity,
    t2.l_extendedprice,
    t2.l_discount,
    t2.l_tax,
    t2.l_returnflag,
    t2.l_linestatus,
    t2.l_shipdate,
    t2.l_commitdate,
    t2.l_receiptdate,
    t2.l_shipinstruct,
    t2.l_shipmode,
    t2.l_comment);

EXPLAIN ANALYZE MERGE INTO lineitem_target_origin_200_blocks1 AS t1 USING small_table AS t2 ON t1.l_orderkey = t2.l_orderkey
AND t1.l_partkey = t2.l_partkey
AND t1.l_suppkey = t2.l_suppkey
AND t1.l_linenumber = t2.l_linenumber
AND t1.l_quantity = t2.l_quantity
AND t1.l_extendedprice = t2.l_extendedprice
AND t1.l_discount = t2.l_discount
WHEN matched THEN
UPDATE
SET
  t1.l_orderkey = t2.l_orderkey,
  t1.l_partkey = t2.l_partkey,
  t1.l_suppkey = t2.l_suppkey,
  t1.l_linenumber = t2.l_linenumber,
  t1.l_quantity = t2.l_quantity,
  t1.l_extendedprice = t2.l_extendedprice,
  t1.l_discount = t2.l_discount,
  t1.l_tax = t2.l_tax,
  t1.l_returnflag = t2.l_returnflag,
  t1.l_linestatus = t2.l_linestatus,
  t1.l_shipdate = t2.l_shipdate,
  t1.l_commitdate = t2.l_commitdate,
  t1.l_receiptdate = t2.l_receiptdate,
  t1.l_shipinstruct = t2.l_shipinstruct,
  t1.l_shipmode = t2.l_shipmode,
  t1.l_comment = t2.l_comment
  WHEN NOT matched THEN
INSERT
VALUES
(
    t2.l_orderkey,
    t2.l_partkey,
    t2.l_suppkey,
    t2.l_linenumber,
    t2.l_quantity,
    t2.l_extendedprice,
    t2.l_discount,
    t2.l_tax,
    t2.l_returnflag,
    t2.l_linestatus,
    t2.l_shipdate,
    t2.l_commitdate,
    t2.l_receiptdate,
    t2.l_shipinstruct,
    t2.l_shipmode,
    t2.l_comment
  )

-[ EXPLAIN ]-----------------------------------
HashJoin
├── output columns: [t1.l_orderkey (#16), t1.l_partkey (#17), t1.l_suppkey (#18), t1.l_linenumber (#19), t1.l_quantity (#20), t1.l_extendedprice (#21), t1.l_discount (#22), t1.l_tax (#23), t1.l_returnflag (#24), t1.l_linestatus (#25), t1.l_shipdate (#26), t1.l_commitdate (#27), t1.l_receiptdate (#28), t1.l_shipinstruct (#29), t1.l_shipmode (#30), t1.l_comment (#31), t1._row_id (#32), t2.l_orderkey (#0), t2.l_partkey (#1), t2.l_suppkey (#2), t2.l_linenumber (#3), t2.l_quantity (#4), t2.l_extendedprice (#5), t2.l_discount (#6), t2.l_tax (#7), t2.l_returnflag (#8), t2.l_linestatus (#9), t2.l_shipdate (#10), t2.l_commitdate (#11), t2.l_receiptdate (#12), t2.l_shipinstruct (#13), t2.l_shipmode (#14), t2.l_comment (#15)]
├── join type: RIGHT OUTER
├── build keys: [t2.l_orderkey (#0), t2.l_partkey (#1), t2.l_suppkey (#2), t2.l_linenumber (#3), t2.l_quantity (#4), t2.l_extendedprice (#5), t2.l_discount (#6)]
├── probe keys: [t1.l_orderkey (#16), t1.l_partkey (#17), t1.l_suppkey (#18), t1.l_linenumber (#19), t1.l_quantity (#20), t1.l_extendedprice (#21), t1.l_discount (#22)]
├── filters: []
├── estimated rows: 2000.00
├── cpu time: 1.05525ms
├── wait time: 3.208607068s
├── output rows: 2 thousand
├── output bytes: 318.22 KiB
├── memory usage: 581.40 KiB
├── TableScan(Build)
│   ├── table: default.merge_into_bloom.small_table
│   ├── output columns: [l_orderkey (#0), l_partkey (#1), l_suppkey (#2), l_linenumber (#3), l_quantity (#4), l_extendedprice (#5), l_discount (#6), l_tax (#7), l_returnflag (#8), l_linestatus (#9), l_shipdate (#10), l_commitdate (#11), l_receiptdate (#12), l_shipinstruct (#13), l_shipmode (#14), l_comment (#15)]
│   ├── read rows: 2000
│   ├── read bytes: 85444
│   ├── partitions total: 1
│   ├── partitions scanned: 1
│   ├── pruning stats: [segments: <range pruning: 1 to 1>, blocks: <range pruning: 1 to 1, bloom pruning: 0 to 0>]
│   ├── push downs: [filters: [], limit: NONE]
│   ├── estimated rows: 2000.00
│   ├── cpu time: 982.799µs
│   ├── wait time: 125.644631ms
│   ├── output rows: 2 thousand
│   ├── output bytes: 317.16 KiB
│   ├── bytes scanned: 317.16 KiB
│   └── memory usage: 146.00 KiB
└── TableScan(Probe)
    ├── table: default.merge_into_bloom.lineitem_target_origin_200_blocks1
    ├── output columns: [l_orderkey (#16), l_partkey (#17), l_suppkey (#18), l_linenumber (#19), l_quantity (#20), l_extendedprice (#21), l_discount (#22), l_tax (#23), l_returnflag (#24), l_linestatus (#25), l_shipdate (#26), l_commitdate (#27), l_receiptdate (#28), l_shipinstruct (#29), l_shipmode (#30), l_comment (#31), _row_id (#32)]
    ├── read rows: 114729502
    ├── read bytes: 3459114063
    ├── partitions total: 200
    ├── partitions scanned: 200
    ├── pruning stats: [segments: <range pruning: 1 to 1>, blocks: <range pruning: 200 to 200, bloom pruning: 0 to 0>]
    ├── push downs: [filters: [], limit: NONE]
    ├── estimated rows: 114729502.00
    ├── cpu time: 50.827865723s
    ├── wait time: 422.608834142s
    ├── bytes scanned: 7.66 KiB
    ├── parts pruned by merge into target table bloom filter: 4
    └── memory usage: 6.74 GiB

43 rows explain in 8.838 sec. Processed 0 rows, 0 B (0 rows/s, 0 B/s)

improve 0.2s. Seems the bloom filter false positive is too high. 200 blocks, we can only prune 4 blocks. The data is too random, so it's hard to prune.

Tests

[ ] Unit Test
[x] Logic Test
[ ] Benchmark Test
[ ] No Test - Explain why

Type of change

[ ] Bug Fix (non-breaking change which fixes an issue)
[x] New Feature (non-breaking change which adds functionality)
[ ] Breaking Change (fix or feature that could cause existing functionality not to work as expected)
[ ] Documentation Update
[ ] Refactoring
[ ] Performance Improvement
[ ] Other (please describe):

This change is

Mar 15 '24 12:03 JackTan25

Docker Image for PR

tag: pr-14970-0ba3213

note: this image tag is only available for internal use, please check the internal doc for more details.

Mar 21 '24 15:03 github-actions[bot]

Docker Image for PR

tag: pr-14970-a234536

note: this image tag is only available for internal use, please check the internal doc for more details.

Mar 21 '24 17:03 github-actions[bot]

Docker Image for PR

tag: pr-14970-1787d63

note: this image tag is only available for internal use, please check the internal doc for more details.

Mar 21 '24 18:03 github-actions[bot]

Let's hold on this, I find a bug on cloud test. @dantengsky @xudong963

Mar 22 '24 07:03 JackTan25

Docker Image for PR

tag: pr-14970-308a3f9

note: this image tag is only available for internal use, please check the internal doc for more details.

Mar 22 '24 15:03 github-actions[bot]

distributed_wizard_test: Passed

Click me

Preparing to run MERGE-INTO-C1...
Executing command: bendsql --query=-- MERGE-INTO-C1: Asset Types Distribution
SELECT asset_type, COUNT(*) AS count
FROM assets
GROUP BY asset_type
ORDER BY count DESC, asset_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

Executing command: snowsql --query -- MERGE-INTO-C1: Asset Types Distribution
SELECT asset_type, COUNT(*) AS count
FROM assets
GROUP BY asset_type
ORDER BY count DESC, asset_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

OK - MERGE-INTO-C1
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

Preparing to run MERGE-INTO-C2...
Executing command: bendsql --query=

-- MERGE-INTO-C2: Aggregated Quantity and Value Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       SUM(value) AS total_value,
       AVG(value) AS average_value
FROM assets -D mergeinto
Command executed successfully. Output:
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

Executing command: snowsql --query 

-- MERGE-INTO-C2: Aggregated Quantity and Value Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       SUM(value) AS total_value,
       AVG(value) AS average_value
FROM assets --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

OK - MERGE-INTO-C2
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

Preparing to run MERGE-INTO-C3...
Executing command: bendsql --query=

-- MERGE-INTO-C3: Assets Counts by User
SELECT user_id, COUNT(*) AS count
FROM assets
GROUP BY user_id
ORDER BY count DESC, user_id
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

Executing command: snowsql --query 

-- MERGE-INTO-C3: Assets Counts by User
SELECT user_id, COUNT(*) AS count
FROM assets
GROUP BY user_id
ORDER BY count DESC, user_id
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

OK - MERGE-INTO-C3
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

Preparing to run MERGE-INTO-C4...
Executing command: bendsql --query=

-- MERGE-INTO-C4: Date Range Analysis of Last Update
SELECT CASE
           WHEN last_updated < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM assets
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-12-31	410014
Before 2022	39986

Executing command: snowsql --query 

-- MERGE-INTO-C4: Date Range Analysis of Last Update
SELECT CASE
           WHEN last_updated < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM assets
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-12-31	410014
Before 2022	39986

OK - MERGE-INTO-C4
After 2021-12-31	410014
Before 2022	39986

Preparing to run MERGE-INTO-C5...
Executing command: bendsql --query=

-- MERGE-INTO-C5: General Status Distribution
SELECT status, COUNT(*) AS count
FROM orders
GROUP BY status
ORDER BY count DESC, status
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

Executing command: snowsql --query 

-- MERGE-INTO-C5: General Status Distribution
SELECT status, COUNT(*) AS count
FROM orders
GROUP BY status
ORDER BY count DESC, status
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

OK - MERGE-INTO-C5
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

Preparing to run MERGE-INTO-C6...
Executing command: bendsql --query=

-- MERGE-INTO-C6: General Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM orders -D mergeinto
Command executed successfully. Output:
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

Executing command: snowsql --query 

-- MERGE-INTO-C6: General Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM orders --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

OK - MERGE-INTO-C6
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

Preparing to run MERGE-INTO-C7...
Executing command: bendsql --query=

-- MERGE-INTO-C7: New Orders vs Existing Orders Count
SELECT CASE
           WHEN order_id > 500000 THEN 'New Order'
           ELSE 'Existing Order'
           END AS order_category,
       COUNT(*) AS count
FROM orders
GROUP BY order_category
ORDER BY count DESC
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
New Order	1649995
Existing Order	750030

Executing command: snowsql --query 

-- MERGE-INTO-C7: New Orders vs Existing Orders Count
SELECT CASE
           WHEN order_id > 500000 THEN 'New Order'
           ELSE 'Existing Order'
           END AS order_category,
       COUNT(*) AS count
FROM orders
GROUP BY order_category
ORDER BY count DESC
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
New Order	1649995
Existing Order	750030

OK - MERGE-INTO-C7
New Order	1649995
Existing Order	750030

Preparing to run MERGE-INTO-C8...
Executing command: bendsql --query=

-- MERGE-INTO-C8: Order Type Distribution
SELECT order_type, COUNT(*) AS count
FROM orders
GROUP BY order_type
ORDER BY count DESC, order_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
buy	1274986
sell	1125039

Executing command: snowsql --query 

-- MERGE-INTO-C8: Order Type Distribution
SELECT order_type, COUNT(*) AS count
FROM orders
GROUP BY order_type
ORDER BY count DESC, order_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
buy	1274986
sell	1125039

OK - MERGE-INTO-C8
buy	1274986
sell	1125039

Preparing to run MERGE-INTO-C9...
Executing command: bendsql --query=

-- MERGE-INTO-C9: Date Range Analysis
SELECT CASE
           WHEN created_at < '2022-01-01' THEN 'Before 2022'
           WHEN created_at BETWEEN '2021-01-01' AND '2021-06-30' THEN 'First Half 2021'
           ELSE 'After 2021-06-30'
           END AS date_range,
       COUNT(*) AS count
FROM orders
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-06-30	150000
Before 2022	2250025

Executing command: snowsql --query 

-- MERGE-INTO-C9: Date Range Analysis
SELECT CASE
           WHEN created_at < '2022-01-01' THEN 'Before 2022'
           WHEN created_at BETWEEN '2021-01-01' AND '2021-06-30' THEN 'First Half 2021'
           ELSE 'After 2021-06-30'
           END AS date_range,
       COUNT(*) AS count
FROM orders
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-06-30	150000
Before 2022	2250025

OK - MERGE-INTO-C9
After 2021-06-30	150000
Before 2022	2250025

Preparing to run MERGE-INTO-C10...
Executing command: bendsql --query=

-- MERGE-INTO-C10: Price Analysis After Adjustments
SELECT SUM(price) AS total_price,
       AVG(price) AS average_price,
       MIN(price) AS min_price,
       MAX(price) AS max_price
FROM orders -D mergeinto
Command executed successfully. Output:
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

Executing command: snowsql --query 

-- MERGE-INTO-C10: Price Analysis After Adjustments
SELECT SUM(price) AS total_price,
       AVG(price) AS average_price,
       MIN(price) AS min_price,
       MAX(price) AS max_price
FROM orders --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

OK - MERGE-INTO-C10
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

Preparing to run MERGE-INTO-C11...
Executing command: bendsql --query=

-- MERGE-INTO-C11: Transaction Types Distribution
SELECT transaction_type, COUNT(*) AS count
FROM transactions
GROUP BY transaction_type
ORDER BY count DESC, transaction_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
trade	505920
deposit	26492
withdrawal	26129

Executing command: snowsql --query 

-- MERGE-INTO-C11: Transaction Types Distribution
SELECT transaction_type, COUNT(*) AS count
FROM transactions
GROUP BY transaction_type
ORDER BY count DESC, transaction_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
trade	505920
deposit	26492
withdrawal	26129

OK - MERGE-INTO-C11
trade	505920
deposit	26492
withdrawal	26129

Preparing to run MERGE-INTO-C12...
Executing command: bendsql --query=

-- MERGE-INTO-C12: Aggregated Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM transactions -D mergeinto
Command executed successfully. Output:
73627261.57298446	131.820692792444	0.00106899	664.06985910

Executing command: snowsql --query 

-- MERGE-INTO-C12: Aggregated Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM transactions --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
73627261.57298446	131.820692792444	0.00106899	664.06985910

OK - MERGE-INTO-C12
73627261.57298446	131.820692792444	0.00106899	664.06985910

Preparing to run MERGE-INTO-C13...
Executing command: bendsql --query=

-- MERGE-INTO-C13: Transaction Counts by User and Asset Type
SELECT user_id, asset_type, COUNT(*) AS count
FROM transactions
GROUP BY user_id, asset_type
ORDER BY count DESC, user_id, asset_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

Executing command: snowsql --query 

-- MERGE-INTO-C13: Transaction Counts by User and Asset Type
SELECT user_id, asset_type, COUNT(*) AS count
FROM transactions
GROUP BY user_id, asset_type
ORDER BY count DESC, user_id, asset_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

OK - MERGE-INTO-C13
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

Preparing to run MERGE-INTO-C14...
Executing command: bendsql --query=

-- MERGE-INTO-C14: Date Range Analysis of Transactions
SELECT CASE
           WHEN transaction_time < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM transactions
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-12-31	483526
Before 2022	75015

Executing command: snowsql --query 

-- MERGE-INTO-C14: Date Range Analysis of Transactions
SELECT CASE
           WHEN transaction_time < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM transactions
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-12-31	483526
Before 2022	75015

OK - MERGE-INTO-C14
After 2021-12-31	483526
Before 2022	75015

Preparing to run MERGE-INTO-C15...
Executing command: bendsql --query=

-- MERGE-INTO-C15: asserts
SELECT asset_type, SUM(quantity) AS total_quantity, SUM(value) AS total_value
FROM assets
GROUP BY asset_type ORDER BY asset_type ASC -D mergeinto
Command executed successfully. Output:
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

Executing command: snowsql --query 

-- MERGE-INTO-C15: asserts
SELECT asset_type, SUM(quantity) AS total_quantity, SUM(value) AS total_value
FROM assets
GROUP BY asset_type ORDER BY asset_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

OK - MERGE-INTO-C15
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

Preparing to run MERGE-INTO-C16...
Executing command: bendsql --query=

-- MERGE-INTO-C16: orders
SELECT asset_type, SUM(quantity) AS total_quantity, AVG(price) AS average_price
FROM orders
GROUP BY asset_type ORDER BY asset_type ASC -D mergeinto
Command executed successfully. Output:
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

Executing command: snowsql --query 

-- MERGE-INTO-C16: orders
SELECT asset_type, SUM(quantity) AS total_quantity, AVG(price) AS average_price
FROM orders
GROUP BY asset_type ORDER BY asset_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

OK - MERGE-INTO-C16
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

Preparing to run MERGE-INTO-C17...
Executing command: bendsql --query=

-- MERGE-INTO-C17: transactions
SELECT transaction_type, SUM(quantity) AS total_quantity
FROM transactions
GROUP BY transaction_type ORDER BY transaction_type ASC -D mergeinto
Command executed successfully. Output:
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

Executing command: snowsql --query 

-- MERGE-INTO-C17: transactions
SELECT transaction_type, SUM(quantity) AS total_quantity
FROM transactions
GROUP BY transaction_type ORDER BY transaction_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

OK - MERGE-INTO-C17
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

Mar 23 '24 06:03 JackTan25

standalone_wizard_standalone_test(in distributed cluster): Passed

Click me

Preparing to run MERGE-INTO-C1...
Executing command: bendsql --query=-- MERGE-INTO-C1: Asset Types Distribution
SELECT asset_type, COUNT(*) AS count
FROM assets
GROUP BY asset_type
ORDER BY count DESC, asset_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

Executing command: snowsql --query -- MERGE-INTO-C1: Asset Types Distribution
SELECT asset_type, COUNT(*) AS count
FROM assets
GROUP BY asset_type
ORDER BY count DESC, asset_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

OK - MERGE-INTO-C1
NEW_ASSET	150000
BTC	104817
ETH	104808
XRP	90375

Preparing to run MERGE-INTO-C2...
Executing command: bendsql --query=

-- MERGE-INTO-C2: Aggregated Quantity and Value Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       SUM(value) AS total_value,
       AVG(value) AS average_value
FROM assets -D mergeinto
Command executed successfully. Output:
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

Executing command: snowsql --query 

-- MERGE-INTO-C2: Aggregated Quantity and Value Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       SUM(value) AS total_value,
       AVG(value) AS average_value
FROM assets --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

OK - MERGE-INTO-C2
165342725.20941540	367.428278243145	1653427252.09414242	3674.282782431428

Preparing to run MERGE-INTO-C3...
Executing command: bendsql --query=

-- MERGE-INTO-C3: Assets Counts by User
SELECT user_id, COUNT(*) AS count
FROM assets
GROUP BY user_id
ORDER BY count DESC, user_id
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

Executing command: snowsql --query 

-- MERGE-INTO-C3: Assets Counts by User
SELECT user_id, COUNT(*) AS count
FROM assets
GROUP BY user_id
ORDER BY count DESC, user_id
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

OK - MERGE-INTO-C3
0	6
2	6
4	6
6	6
8	6
10	6
12	6
14	6
16	6
18	6
20	6
22	6
24	6

Preparing to run MERGE-INTO-C4...
Executing command: bendsql --query=

-- MERGE-INTO-C4: Date Range Analysis of Last Update
SELECT CASE
           WHEN last_updated < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM assets
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-12-31	410014
Before 2022	39986

Executing command: snowsql --query 

-- MERGE-INTO-C4: Date Range Analysis of Last Update
SELECT CASE
           WHEN last_updated < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM assets
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-12-31	410014
Before 2022	39986

OK - MERGE-INTO-C4
After 2021-12-31	410014
Before 2022	39986

Preparing to run MERGE-INTO-C5...
Executing command: bendsql --query=

-- MERGE-INTO-C5: General Status Distribution
SELECT status, COUNT(*) AS count
FROM orders
GROUP BY status
ORDER BY count DESC, status
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

Executing command: snowsql --query 

-- MERGE-INTO-C5: General Status Distribution
SELECT status, COUNT(*) AS count
FROM orders
GROUP BY status
ORDER BY count DESC, status
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

OK - MERGE-INTO-C5
avg	1049532
completed	350986
pending	348300
cancelled	300714
Pending	150000
above_avg	100418
below_avg	100075

Preparing to run MERGE-INTO-C6...
Executing command: bendsql --query=

-- MERGE-INTO-C6: General Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM orders -D mergeinto
Command executed successfully. Output:
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

Executing command: snowsql --query 

-- MERGE-INTO-C6: General Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM orders --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

OK - MERGE-INTO-C6
1526855542.46298600	636.183182451427	0.00005807	8910.78518320

Preparing to run MERGE-INTO-C7...
Executing command: bendsql --query=

-- MERGE-INTO-C7: New Orders vs Existing Orders Count
SELECT CASE
           WHEN order_id > 500000 THEN 'New Order'
           ELSE 'Existing Order'
           END AS order_category,
       COUNT(*) AS count
FROM orders
GROUP BY order_category
ORDER BY count DESC
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
New Order	1649995
Existing Order	750030

Executing command: snowsql --query 

-- MERGE-INTO-C7: New Orders vs Existing Orders Count
SELECT CASE
           WHEN order_id > 500000 THEN 'New Order'
           ELSE 'Existing Order'
           END AS order_category,
       COUNT(*) AS count
FROM orders
GROUP BY order_category
ORDER BY count DESC
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
New Order	1649995
Existing Order	750030

OK - MERGE-INTO-C7
New Order	1649995
Existing Order	750030

Preparing to run MERGE-INTO-C8...
Executing command: bendsql --query=

-- MERGE-INTO-C8: Order Type Distribution
SELECT order_type, COUNT(*) AS count
FROM orders
GROUP BY order_type
ORDER BY count DESC, order_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
buy	1274986
sell	1125039

Executing command: snowsql --query 

-- MERGE-INTO-C8: Order Type Distribution
SELECT order_type, COUNT(*) AS count
FROM orders
GROUP BY order_type
ORDER BY count DESC, order_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
buy	1274986
sell	1125039

OK - MERGE-INTO-C8
buy	1274986
sell	1125039

Preparing to run MERGE-INTO-C9...
Executing command: bendsql --query=

-- MERGE-INTO-C9: Date Range Analysis
SELECT CASE
           WHEN created_at < '2022-01-01' THEN 'Before 2022'
           WHEN created_at BETWEEN '2021-01-01' AND '2021-06-30' THEN 'First Half 2021'
           ELSE 'After 2021-06-30'
           END AS date_range,
       COUNT(*) AS count
FROM orders
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-06-30	150000
Before 2022	2250025

Executing command: snowsql --query 

-- MERGE-INTO-C9: Date Range Analysis
SELECT CASE
           WHEN created_at < '2022-01-01' THEN 'Before 2022'
           WHEN created_at BETWEEN '2021-01-01' AND '2021-06-30' THEN 'First Half 2021'
           ELSE 'After 2021-06-30'
           END AS date_range,
       COUNT(*) AS count
FROM orders
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-06-30	150000
Before 2022	2250025

OK - MERGE-INTO-C9
After 2021-06-30	150000
Before 2022	2250025

Preparing to run MERGE-INTO-C10...
Executing command: bendsql --query=

-- MERGE-INTO-C10: Price Analysis After Adjustments
SELECT SUM(price) AS total_price,
       AVG(price) AS average_price,
       MIN(price) AS min_price,
       MAX(price) AS max_price
FROM orders -D mergeinto
Command executed successfully. Output:
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

Executing command: snowsql --query 

-- MERGE-INTO-C10: Price Analysis After Adjustments
SELECT SUM(price) AS total_price,
       AVG(price) AS average_price,
       MIN(price) AS min_price,
       MAX(price) AS max_price
FROM orders --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

OK - MERGE-INTO-C10
2874615680.22030825	1197.744056924535	0.00058074	10990.07262787

Preparing to run MERGE-INTO-C11...
Executing command: bendsql --query=

-- MERGE-INTO-C11: Transaction Types Distribution
SELECT transaction_type, COUNT(*) AS count
FROM transactions
GROUP BY transaction_type
ORDER BY count DESC, transaction_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
trade	505920
deposit	26492
withdrawal	26129

Executing command: snowsql --query 

-- MERGE-INTO-C11: Transaction Types Distribution
SELECT transaction_type, COUNT(*) AS count
FROM transactions
GROUP BY transaction_type
ORDER BY count DESC, transaction_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
trade	505920
deposit	26492
withdrawal	26129

OK - MERGE-INTO-C11
trade	505920
deposit	26492
withdrawal	26129

Preparing to run MERGE-INTO-C12...
Executing command: bendsql --query=

-- MERGE-INTO-C12: Aggregated Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM transactions -D mergeinto
Command executed successfully. Output:
73627261.57298446	131.820692792444	0.00106899	664.06985910

Executing command: snowsql --query 

-- MERGE-INTO-C12: Aggregated Quantity Statistics
SELECT SUM(quantity) AS total_quantity,
       AVG(quantity) AS average_quantity,
       MIN(quantity) AS min_quantity,
       MAX(quantity) AS max_quantity
FROM transactions --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
73627261.57298446	131.820692792444	0.00106899	664.06985910

OK - MERGE-INTO-C12
73627261.57298446	131.820692792444	0.00106899	664.06985910

Preparing to run MERGE-INTO-C13...
Executing command: bendsql --query=

-- MERGE-INTO-C13: Transaction Counts by User and Asset Type
SELECT user_id, asset_type, COUNT(*) AS count
FROM transactions
GROUP BY user_id, asset_type
ORDER BY count DESC, user_id, asset_type
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

Executing command: snowsql --query 

-- MERGE-INTO-C13: Transaction Counts by User and Asset Type
SELECT user_id, asset_type, COUNT(*) AS count
FROM transactions
GROUP BY user_id, asset_type
ORDER BY count DESC, user_id, asset_type
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

OK - MERGE-INTO-C13
804	ETH	15
1216	ETH	15
216	BTC	14
425	ETH	14
844	BTC	14
1231	ETH	14
1539	ETH	14
1603	ETH	14
1926	ETH	14
2609	BTC	14
2704	ETH	14
2827	ETH	14
2841	BTC	14

Preparing to run MERGE-INTO-C14...
Executing command: bendsql --query=

-- MERGE-INTO-C14: Date Range Analysis of Transactions
SELECT CASE
           WHEN transaction_time < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM transactions
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 -D mergeinto
Command executed successfully. Output:
After 2021-12-31	483526
Before 2022	75015

Executing command: snowsql --query 

-- MERGE-INTO-C14: Date Range Analysis of Transactions
SELECT CASE
           WHEN transaction_time < '2022-01-01' THEN 'Before 2022'
           ELSE 'After 2021-12-31'
           END AS date_range,
       COUNT(*) AS count
FROM transactions
GROUP BY date_range
ORDER BY date_range
    LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
After 2021-12-31	483526
Before 2022	75015

OK - MERGE-INTO-C14
After 2021-12-31	483526
Before 2022	75015

Preparing to run MERGE-INTO-C15...
Executing command: bendsql --query=

-- MERGE-INTO-C15: asserts
SELECT asset_type, SUM(quantity) AS total_quantity, SUM(value) AS total_value
FROM assets
GROUP BY asset_type ORDER BY asset_type ASC -D mergeinto
Command executed successfully. Output:
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

Executing command: snowsql --query 

-- MERGE-INTO-C15: asserts
SELECT asset_type, SUM(quantity) AS total_quantity, SUM(value) AS total_value
FROM assets
GROUP BY asset_type ORDER BY asset_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

OK - MERGE-INTO-C15
BTC	54537998.34092175	545379983.40921303
ETH	50387362.73309448	503873627.33094612
NEW_ASSET	15000000.00000000	150000000.00000000
XRP	45417364.13539917	454173641.35398327

Preparing to run MERGE-INTO-C16...
Executing command: bendsql --query=

-- MERGE-INTO-C16: orders
SELECT asset_type, SUM(quantity) AS total_quantity, AVG(price) AS average_price
FROM orders
GROUP BY asset_type ORDER BY asset_type ASC -D mergeinto
Command executed successfully. Output:
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

Executing command: snowsql --query 

-- MERGE-INTO-C16: orders
SELECT asset_type, SUM(quantity) AS total_quantity, AVG(price) AS average_price
FROM orders
GROUP BY asset_type ORDER BY asset_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

OK - MERGE-INTO-C16
BTC	577143846.60937705	1321.552983291813
ETH	532400471.20223598	1228.552050777431
NEW_ORDER	7500000.00000000	500.000000000000
XRP	409811224.65137297	1172.281276438386

Preparing to run MERGE-INTO-C17...
Executing command: bendsql --query=

-- MERGE-INTO-C17: transactions
SELECT transaction_type, SUM(quantity) AS total_quantity
FROM transactions
GROUP BY transaction_type ORDER BY transaction_type ASC -D mergeinto
Command executed successfully. Output:
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

Executing command: snowsql --query 

-- MERGE-INTO-C17: transactions
SELECT transaction_type, SUM(quantity) AS total_quantity
FROM transactions
GROUP BY transaction_type ORDER BY transaction_type ASC --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH
Command executed successfully. Output:
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

OK - MERGE-INTO-C17
deposit	5712183.27889012
trade	62705473.53457811
withdrawal	5209604.75951623

Mar 23 '24 09:03 JackTan25

source_build_distributed_update_optmization_pk_bloom: Passed

Click me

Preparing to run Unknown Query...
Executing command: bendsql --query=-- test lineitem_target_origin_200_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks1 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query -- test lineitem_target_origin_200_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check

-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check

-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- =============================================================

-- test lineitem_target_origin_200_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks2 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query 


-- =============================================================

-- test lineitem_target_origin_200_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks3 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks4 -D mergeinto_performance
Command executed successfully. Output:
114641243	25.50089644	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks4 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114641243	25.50089644	104948.50	0.00

OK - Unknown Query
114641243	25.50089644	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114641243

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114641243

OK - Unknown Query
114641243

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

OK - Unknown Query
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

OK - Unknown Query
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57796308

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57796308

OK - Unknown Query
57796308

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial1 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial2 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- =======================================================
-- test lineitem_target_origin_200_blocks_partial3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial3 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 


-- =======================================================
-- test lineitem_target_origin_200_blocks_partial3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks1 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks2 -D mergeinto_performance
Command executed successfully. Output:
254913155	25.49995315	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
254913155	25.49995315	104948.50	0.00

OK - Unknown Query
254913155	25.49995315	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
254913155

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
254913155

OK - Unknown Query
254913155

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

OK - Unknown Query
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
128345631

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
128345631

OK - Unknown Query
128345631

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks3 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks4 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks4 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block1 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block2 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block3 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Mar 23 '24 09:03 JackTan25

source_build_standalone_update_optmization_pk_bloom: Passed

Click me

Preparing to run Unknown Query...
Executing command: bendsql --query=-- test lineitem_target_origin_200_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks1 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query -- test lineitem_target_origin_200_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check

-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check

-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- =============================================================

-- test lineitem_target_origin_200_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks2 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query 


-- =============================================================

-- test lineitem_target_origin_200_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks3 -D mergeinto_performance
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502	25.50088990	104948.50	0.00

OK - Unknown Query
114729502	25.50088990	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114729502

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114729502

OK - Unknown Query
114729502

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	57381835
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57840341

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57840341

OK - Unknown Query
57840341

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks4 -D mergeinto_performance
Command executed successfully. Output:
114641243	25.50089644	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks4 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114641243	25.50089644	104948.50	0.00

OK - Unknown Query
114641243	25.50089644	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
114641243

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
114641243

OK - Unknown Query
114641243

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

OK - Unknown Query
34	1	1
34	2	1
34	3	1
68	1	1
68	2	1
68	3	1
68	4	1
68	5	1
68	6	1
68	7	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

OK - Unknown Query
A	F	28276963
N	F	739278
N	O	57342820
R	F	28282182

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
57796308

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
57796308

OK - Unknown Query
57796308

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial1 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial2 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- =======================================================
-- test lineitem_target_origin_200_blocks_partial3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial3 -D mergeinto_performance
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

Executing command: snowsql --query 


-- =======================================================
-- test lineitem_target_origin_200_blocks_partial3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731	25.50115337	104948.50	0.00

OK - Unknown Query
103255731	25.50115337	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
103255731

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
103255731

OK - Unknown Query
103255731

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

OK - Unknown Query
A	F	28301281
N	F	739905
N	O	45908064
R	F	28306481

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
51393942

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
51393942

OK - Unknown Query
51393942

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3 -D mergeinto_performance
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_200_blocks_partial_plus_50_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690	25.50090575	104948.50	0.00

OK - Unknown Query
129126690	25.50090575	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
129126690

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
129126690

OK - Unknown Query
129126690

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

OK - Unknown Query
A	F	35392860
N	F	923652
N	O	57413635
R	F	35396543

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
64269361

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
64269361

OK - Unknown Query
64269361

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_200_blocks_partial_plus_50_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks1 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks2 -D mergeinto_performance
Command executed successfully. Output:
254913155	25.49995315	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
254913155	25.49995315	104948.50	0.00

OK - Unknown Query
254913155	25.49995315	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
254913155

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
254913155

OK - Unknown Query
254913155

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

OK - Unknown Query
A	F	63598486
N	F	1659105
N	O	126042296
R	F	63613268

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
128345631

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
128345631

OK - Unknown Query
128345631

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks3 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_400_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks4 -D mergeinto_performance
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_400_blocks4 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_400_blocks4 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196	25.49995718	104948.50	0.00

OK - Unknown Query
229042196	25.49995718	104948.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
229042196

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
229042196

OK - Unknown Query
229042196

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

OK - Unknown Query
1	1	1
1	2	1
1	3	1
1	4	1
1	5	1
1	6	1
2	1	1
3	1	1
3	2	1
3	3	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_400_blocks4
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

OK - Unknown Query
A	F	56506907
N	F	1475358
N	O	114536725
R	F	56523206

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_400_blocks4
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
115470212

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
115470212

OK - Unknown Query
115470212

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_400_blocks4
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block1 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block1 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block1 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block1
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block1
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block1
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block1
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block1
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block2 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block2 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block2 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block2
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block2
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block2
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block2
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block2
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- =======================================================
-- test lineitem_target_origin_one_block3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block3 -D mergeinto_performance
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

Executing command: snowsql --query 

-- =======================================================
-- test lineitem_target_origin_one_block3 table

-- 1. Basic Statistics Query
SELECT 
    COUNT(*) as total_records,
    AVG(l_quantity) as avg_quantity,
    MAX(l_extendedprice) as max_price,
    MIN(l_discount) as min_discount
FROM lineitem_target_origin_one_block3 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015	25.50743796	104768.50	0.00

OK - Unknown Query
574015	25.50743796	104768.50	0.00

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' -D mergeinto_performance
Command executed successfully. Output:
574015

Executing command: snowsql --query 

-- 2. data range and valid check
SELECT 
    COUNT(*) 
FROM lineitem_target_origin_one_block3
WHERE l_shipdate < '2000-01-01' OR l_shipdate > '2024-01-01' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
574015

OK - Unknown Query
574015

Preparing to run Unknown Query...
Executing command: bendsql --query=


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 -D mergeinto_performance
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Executing command: snowsql --query 


-- 3. unique composite check
SELECT 
    l_orderkey, l_linenumber, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_orderkey, l_linenumber
HAVING COUNT(*) >= 1 order by l_orderkey, l_linenumber limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

OK - Unknown Query
11983072	1	1
11983072	2	1
11983072	3	1
11983072	4	1
11983072	5	1
11983073	1	1
11983073	2	1
11983073	3	1
11983073	4	1
11983074	1	1

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 -D mergeinto_performance
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Executing command: snowsql --query 

-- 4. correlated check


-- 5. test specific value
SELECT 
    l_returnflag, l_linestatus, COUNT(*)
FROM lineitem_target_origin_one_block3
GROUP BY l_returnflag, l_linestatus order by l_returnflag, l_linestatus limit 10 --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
A	F	142333
N	F	3628
N	O	286316
R	F	141738

OK - Unknown Query
A	F	142333
N	F	3628
N	O	286316
R	F	141738

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL -D mergeinto_performance
Command executed successfully. Output:
0

Executing command: snowsql --query 

-- 6 .non null check
SELECT COUNT(*) FROM lineitem_target_origin_one_block3
WHERE l_orderkey IS NULL OR l_partkey IS NULL OR l_quantity IS NULL --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
0

OK - Unknown Query
0

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate -D mergeinto_performance
Command executed successfully. Output:
289491

Executing command: snowsql --query 

-- 7. Continuous-time
SELECT 
    COUNT(*)
FROM lineitem_target_origin_one_block3
WHERE l_shipdate > l_commitdate OR l_shipdate > l_receiptdate --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
289491

OK - Unknown Query
289491

Preparing to run Unknown Query...
Executing command: bendsql --query=

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' -D mergeinto_performance
Command executed successfully. Output:
NULL

Executing command: snowsql --query 

-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31' --dbname mergeinto_performance --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false --warehouse COMPUTE_WH_MEDIUM
Command executed successfully. Output:
None

DIFFERENCE FOUND

Unknown Query:


-- 8. aggregation at condition filter.
SELECT 
    SUM(l_extendedprice * (1 - l_discount)) as total_sales
FROM lineitem_target_origin_one_block3
WHERE l_shipdate BETWEEN '2023-01-01' AND '2023-12-31'
Differences:

bendsql:
NULL

snowsql:
None

Mar 23 '24 11:03 JackTan25

What's the performance? It's better to add to the PR summary.

Mar 23 '24 11:03 bohutang

What's the performance? It's better to add to the PR summary.

let me finish the correctess test first.

Mar 23 '24 12:03 JackTan25

standalone_wizard_standalone_in_standalone_mode_test: Passed

Click me

```sql Preparing to run MERGE-INTO-C1... Executing command: bendsql --query=-- MERGE-INTO-C1: Asset Types Distribution SELECT asset_type, COUNT(*) AS count FROM assets GROUP BY asset_type ORDER BY count DESC, asset_type LIMIT 13 -D mergeinto Command executed successfully. Output: NEW_ASSET 150000 BTC 104817 ETH 104808 XRP 90375

Executing command: snowsql --query -- MERGE-INTO-C1: Asset Types Distribution SELECT asset_type, COUNT(*) AS count FROM assets GROUP BY asset_type ORDER BY count DESC, asset_type LIMIT 13 --dbname mergeinto --schemaname PUBLIC -o output_format=tsv -o header=false -o timing=false -o friendly=false -o log_level=DEBUG --warehouse COMPUTE_WH Command executed successfully. Output: NEW_ASSET 150000 BTC 104817 ETH 104808 XRP 90375

OK - MERGE-INTO-C1 NEW_ASSET 150000 BTC 104817 ETH 104808 XRP 90375

Preparing to run MERGE-INTO-C2... Executing command: bendsql --query=

-- MERGE-INTO-C2: Aggregated Quantity and Value Statistics SELECT SUM(quantity) AS total_quantity, AVG(quantity) AS average_quantity, SUM(value) AS total_value, AVG(value) AS average_value FROM assets -D mergeinto Command executed successfully. Output: 165342725.20941540 367.428278243145 1653427252.09414242 3674.282782431428