<commit_before><commit_msg>Added a test case for LDEV-2470<commit_after>component extends = "org.lucee.cfml.test.LuceeTestCase" {
	function run(){
		describe( "Test suite for LDEV-2470", function() {
			it( title = "QoQ joins on columns with type integer does work", body = function( currentSpec ){
				cfloop( list = "integer",item = "int_type" ){
					a = querynew("id","#int_type#",[{"id": 1},{"id": 2},{"id": 3}]);
					b = duplicate(a);
					cfquery(name = "int_query",dbtype = "query") {
						echo(
							"SELECT a.id, b.id FROM a,b where b.ID = a.ID and b.ID IN (1)"
						)
					}
					expect(int_query.id).tobe(1);
				}
			});

			it( title = "QoQ joins on columns with type numeric doesn't work", body = function( currentSpec ){
				cfloop( list = "numeric",item = "num_type" ){
					a = querynew("id","#num_type#",[{"id": 4},{"id": 5},{"id": 6}]);
					b = duplicate(a);
					cfquery(name = "num_query",dbtype = "query") {
						echo(
							"SELECT a.id, b.id FROM a,b where b.ID = a.ID and b.ID IN (4)"
						)
					}
					expect(num_query.id).tobe(4);
				}
			});
		});
	}
}
{'fraction_non_alphanumeric': 0.19413919413919414, 'fraction_numerical': 0.016483516483516484, 'mean_word_length': 2.889679715302491, 'pattern_counts': {'":': 6, '<': 3, '<?xml version=': 0, '>': 3, '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': '2980281', 'n_tokens_mistral': 517, 'n_tokens_neox': 408, 'n_words': 100}