Using def output = count[R] <++ 0 through CLI exec displays errors

[andy-dean-rai]

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

% 

[billscheidel-rai]

Note: This issue has been migrated to https://relationalai.atlassian.net/browse/RAI-7378.

This link is only accessible to employees of RelationalAI.