<commit_before>-record(box,{ ind
            % , idx
            , name      = <<"">>
            , children  = []
            , collapsed = true
            , error     = <<"">>
            , color     = <<"black">>
            , pick      = <<"">>
            }).

-ifdef(TEST).
-define (TEST_SELECT_QUERIES,[
<<"
select col1, col2|:a1| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2|:a1:a2| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2|{a1}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2|{a1,a2}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2|{a1,a2,a3,a4}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, length(col2|[]|) from sbsgui.bintermtest where col1 = 4
">>
,
<<"
select col1, col2|[1]| from sbsgui.bintermtest where col1 = 5
">>
,
<<"
select col1, col2|[1,3,5]| from sbsgui.bintermtest where col1 = 5
">>
,
<<"
select col1, l.item from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2|[]|)
">>
,
<<"
select col1, l.item|#key| from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2|[]|)
">>
,
<<"
select col1, l.item|#value#keys| from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2|[]|)
">>
,
<<"
select col1, length(l.item|#value#keys|) from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2|[]|)
">>
,
<<"
select ckey, cvalue|:WHITELIST[1]#key|, cvalue|:WHITELIST[1]#value:ETID| from tpac where last(ckey) = to_string('access')
">>
,
<<"
select ckey, cvalue|:WHITELIST[1]#key|, cvalue|:WHITELIST[1]#value:ETID|, to_datetime(cvalue|:WHITELIST[1]#value:EXPIRE_DATE|) from tpac where last(ckey) = to_string('access')
">>
,
<<"select
	/*+ INDEX(BDCUCIDXA PK_BDCUCIDXA) */
	'-' as msgid
	,
	bc_msisdn_a as sender
	,
	bc_submitdate as submittime
	,
		MAX
			(
				bc_length
			) as msglen
	,
	bc_msisdn_b as receiver
	,
		MAX
			(
				DECODE
					(
						bc_status
						,<commit_msg>New sqlparse version.<commit_after>-record(box,{ ind
            % , idx
            , name      = <<"">>
            , children  = []
            , collapsed = true
            , error     = <<"">>
            , color     = <<"black">>
            , pick      = <<"">>
            }).

-ifdef(TEST).
-define (TEST_SELECT_QUERIES,[
<<"
select col1, col2.|:a1| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2.|:a1:a2| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2.|{a1}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2.|{a1,a2}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, col2.|{a1,a2,a3,a4}| from sbsgui.bintermtest where col1 = 3
">>
,
<<"
select col1, length(col2.|[]|) from sbsgui.bintermtest where col1 = 4
">>
,
<<"
select col1, col2.|[1]| from sbsgui.bintermtest where col1 = 5
">>
,
<<"
select col1, col2.|[1,3,5]| from sbsgui.bintermtest where col1 = 5
">>
,
<<"
select col1, l.item from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2.|[]|)
">>
,
<<"
select col1, l.item.|#key| from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2.|[]|)
">>
,
<<"
select col1, l.item.|#value#keys| from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2.|[]|)
">>
,
<<"
select col1, length(l.item.|#value#keys|) from sbsgui.bintermtest, json l where col1 = 8 and is_member(item, col2.|[]|)
">>
,
<<"
select ckey, cvalue.|:WHITELIST[1]#key|, cvalue.|:WHITELIST[1]#value:ETID| from tpac where last(ckey) = to_string('access')
">>
,
<<"
select ckey, cvalue.|:WHITELIST[1]#key|, cvalue.|:WHITELIST[1]#value:ETID|, to_datetime(cvalue.|:WHITELIST[1]#value:EXPIRE_DATE|) from tpac where last(ckey) = to_string('access')
">>
,
<<"select
	/*+ INDEX(BDCUCIDXA PK_BDCUCIDXA) */
	'-' as msgid
	,
	bc_msisdn_a as sender
	,
	bc_submitdate as submittime
	,
		MAX
			(
				bc_length
			) as msglen
	,
	bc_msisdn_b as receiver
	,
		MAX
			(
				DECODE
					(
						bc_status
						,
{'fraction_non_alphanumeric': 0.1860759493670886, 'fraction_numerical': 0.033924050632911394, 'mean_word_length': 3.322757111597374, 'pattern_counts': {'":': 0, '<': 79, '<?xml version=': 0, '>': 75, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2057145', 'n_tokens_mistral': 1826, 'n_tokens_neox': 1711, 'n_words': 342}