为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
select distinct resources0_.id as id2_24_, resources0_.created_by as created_3_24_,
resources0_.created_date as created_4_24_, resources0_.last_modified_by as last_mod5_24_, resources0_.last_modified_date as last_mod6_24_,
resources0_.access_count as access_c7_24_, resources0_.coding as coding8_24_, resources0_.commons_type as commons_9_24_, resources0_.connection_status as connect10_24_,
resources0_.delete_at_date as delete_11_24_, resources0_.department_id as departm31_24_, resources0_.description as descrip12_24_,
resources0_.inceptor_schema as incepto13_24_, resources0_.inceptor_table_name as incepto14_24_, resources0_.is_active as is_acti15_24_,
resources0_.is_delete_at as is_dele16_24_, resources0_.name as name17_24_, resources0_.name_en as name_en18_24_, resources0_.resources_type as resource1_24_,
resources0_.resources_update_frequency as resourc19_24_, resources0_.share_count as share_c20_24_, resources0_.share_level as share_l21_24_,
resources0_.source_system as source_22_24_, resources0_.tags as tags23_24_, resources0_.update_frequency as update_24_24_,
resources0_.user_id as user_id32_24_, resources0_.database_name as databas25_24_, resources0_.is_syn as is_syn26_24_,
resources0_.source_database_id as source_33_24_, resources0_.table_name as table_n27_24_, resources0_.table_name_cn as table_n28_24_,
resources0_.file_name as file_na29_24_, resources0_.file_path as file_pa30_24_
from resources resources0_ inner join department department1_ on resources0_.department_id=department1_.id inner join department department2_
on resources0_.department_id=department2_.id where resources0_.resources_type in (‘RESOURCE’, ‘DATABASE’, ‘FILE’)
and department2_.id=34 and department1_.level=? and resources0_.resources_type=? and resources0_.is_active=? limit ?
查询报错:nested exception is org.hibernate.exception.DataException: could not prepare statement
SQL 错误 [22000]: 第18 行附近出现错误:
试图在blob或者clob列上排序或比较
请问这个查询哪里语法不对吗
执行SP_SET_PARA_VALUE(1,‘ENABLE_BLOB_CMP_FLAG’,1)
后再试试是否还报错