<commit_before>-- needed for jdbc feature types loaded before r2098

update /*+ bypass_ujvc */ 
(
select ft.geometry_attribute as geometry_attribute, ad.name as found_geometry_attribute
from feature_type ft
join feature_source fs on (fs.id = ft.feature_source)
join feature_type_attributes fta on (fta.feature_type = ft.id)
join attribute_descriptor ad on (ad.id = fta.attribute_descriptor)
where ft.geometry_attribute is null
and fs.protocol = 'jdbc'
and ad.type in ('geometry','point','multipoint','linestring','multilinestring','polygon','multipolygon')
)
set geometry_attribute = found_geometry_attribute<commit_msg>simplified update script; also for wfs protocol<commit_after>-- needed for jdbc and wfs feature types loaded before r2256

update feature_type ft 
set geometry_attribute =
	(select ad.name from attribute_descriptor ad 
	join feature_type_attributes fta on (fta.attribute_descriptor = ad.id)
        where fta.feature_type = ft.id
        and ad.type in ('geometry','point','multipoint','linestring','multilinestring','polygon','multipolygon')
        and rownum <=1
	) 
where ft.geometry_attribute is null

{'fraction_non_alphanumeric': 0.09147424511545293, 'fraction_numerical': 0.007992895204262877, 'mean_word_length': 5.629411764705883, 'pattern_counts': {'":': 0, '<': 4, '<?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': '3001013', 'n_tokens_mistral': 337, 'n_tokens_neox': 331, 'n_words': 99}