Using def output = count[R] <++ 0 through CLI exec displays errors #47
Description
The recommended workaround to get count[R] to return 0 when the relation R is empty is to use the left_override feature.
This works fine in the RAI web console and when using exec from the Julia SDK. However, when run with the RAI console it appears to dump a lot of extra error info (as well as the expected 0).
rai exec my_db -e my_eng -c "def output = count[features] <++ 0 "
Executing query (adean-att-fraud-db-dev-7464/adean-att-fraud-eng-dev-7464) readonly=false .. Ok (0.5s)
/:output/Int64
0
/:rel/:catalog/:diagnostic/:code/Int64/String
1, UNDEFINED
2, UNDEFINED
3, UNDEFINED
4, UNDEFINED
5, UNDEFINED
6, UNDEFINED
7, UNDEFINED
8, UNDEFINED
/:rel/:catalog/:diagnostic/:message/Int64/String
1, `trusted_edges_csv` is undefined.
2, `trusted_edges_csv` is undefined.
3, `scamp_aggd_csv` is undefined.
4, `scamp_aggd_csv` is undefined.
5, `scamp_aggd_csv` is undefined.
6, `scamp_aggd_csv` is undefined.
7, `scamp_aggd_csv` is undefined.
8, `scamp_aggd_csv` is undefined.
/:rel/:catalog/:diagnostic/:model/Int64/String
1, trusted_edges
2, trusted_edges
3, robo_features
4, robo_features
5, robo_features
6, robo_features
7, robo_features
8, robo_features
/:rel/:catalog/:diagnostic/:range/:end/:character/Int64/Int64/Int64
1, 1, 26
2, 1, 26
3, 1, 43
4, 1, 43
5, 1, 44
6, 1, 29
7, 1, 48
8, 1, 29
/:rel/:catalog/:diagnostic/:range/:end/:line/Int64/Int64/Int64
1, 1, 9
2, 1, 10
3, 1, 15
4, 1, 14
5, 1, 12
6, 1, 2
7, 1, 13
8, 1, 1
/:rel/:catalog/:diagnostic/:range/:start/:character/Int64/Int64/Int64
1, 1, 10
2, 1, 10
3, 1, 30
4, 1, 30
5, 1, 31
6, 1, 16
7, 1, 35
8, 1, 16
/:rel/:catalog/:diagnostic/:range/:start/:line/Int64/Int64/Int64
1, 1, 9
2, 1, 10
3, 1, 15
4, 1, 14
5, 1, 12
6, 1, 2
7, 1, 13
8, 1, 1
/:rel/:catalog/:diagnostic/:report/Int64/String
1, 9| e1 = trusted_edges_csv[:ctn_a, i, j] and
^^^^^^^^^^^^^^^^^
2, 10| e2 = trusted_edges_csv[:ctn_b, i, j] and
^^^^^^^^^^^^^^^^^
3, 15| def msg_lens = add_attribute[scamp_aggd_csv, :sum_msgs_len]
^^^^^^^^^^^^^^
4, 14| def num_msgs = add_attribute[scamp_aggd_csv, :num_msgs]
^^^^^^^^^^^^^^
5, 12| def num_calls = add_attribute[scamp_aggd_csv, :num_calls]
^^^^^^^^^^^^^^
6, 2| def ctn_term = scamp_aggd_csv[:term,_,_]
^^^^^^^^^^^^^^
7, 13| def call_duration = add_attribute[scamp_aggd_csv, :sum_elapsed_time]
^^^^^^^^^^^^^^
8, 1| def ctn_orig = scamp_aggd_csv[:orig,_,_]
^^^^^^^^^^^^^^
/:rel/:catalog/:diagnostic/:severity/Int64/String
1, error
2, error
3, error
4, error
5, error
6, error
7, error
8, error
%