NutzCN Logo
问答 达梦sql 语句出错,栏位的问题 ,不知道怎么解决
发布于 20天前 作者 qq_64f81159 82 次浏览 复制 上一个帖子 下一个帖子
标签:

错误信息如下

org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM cms_content  WHERE delFlag=0 AND (title LIKE '%测试%' OR content LIKE '%测试%') AND categoryId IN ('eb0d02a3bb7045fb96bdf12fc8a6540b','d0c5c9ca97aa4b66bf7aa4cc10556550','f710084833084f13918f4e5f7c66c1e2','1ba661309bad4f50b3b27a267c279099','16c734edbbe84445974692e98fb1b560','874dd4c5d0184710bbdfc6d72a45c4fe','bc710e082d5841799c54fd3942232b11','fd6afb9baa264cde92962ef8cc2cd586','f471eeca53784514a3e390a09b8135e6','e5dd3021e6784e099350b66787ddc553','c34fe48f5ec047d7b303a03b0f84ba15','7bdc92fab9594da69b978a3164cf2773','2215f01b0bdc4cf9b525899d4d0cb718','9a693b3b1e404b5a9d025591d3fdba44','e354681ebd9642839a25820bbc722d2a','c6321e9e8b904109a8c21e39cee9d002','0540501768084e3ebf6f186e4353827c','f43e0b5f06d34b9e8927b43f7531e074','e8a9b86c1ffb46f4998d93ca5526b6c8','53d43537b1a64957be9302a3747cf576','4d60ff7b3c794726a2abc00189b8cd6c','e522e8b78f914876bf9013b0ef841d0a','382bd548731c4592b92ffe1b15a3890d','95387ffa8d3244079729882a49cf826a','06fc3de9944248e9b85934ac42ee0fe6','0e1af75281394e338e51080be3931a3a','454e1c3eff6d4fb691bc891d1f53b44e','db9e08dae7b64a26874f17ee91d93c5f','a4c2835b9ee447a5b235394a8ed5ed44','b5ba8f9685394dadb6e675cd3eff4a61','d2fb95b70c92466b986e0e91e6eb33d8','4c47b35ca8a345f28a2f27be7f234962','5c03a46b18f242b7ad76fd95bdae3594','48064dbab8be4c5486586a02c3fcd0f5','e9b3db2d6b6e42a2a2bc2559a2f35a76','d612a34e80144fdbb3762303b2e51592','6f62bb1dfd864b6b85fbb705c119fbf1','bcc70a48be514a0698a443e4d9de505f','9e4fbac821044e20bb74a5017ed2b42a','2307e4ee3119402f9fbbc46b14edd3a4','d1d0e0a7cc7c4cf3a74c4baa35db08dc','0712253f667e4eeeba92aa79b34383cc','2c0a4054040a4c3faa24b063abda53be','f5952663efd74a51a198fd7d63ee175d','c4a3941171254650aed70d44b77679f3','95ae027328834764acbf8dd9df3b03a2','8f3bbe3149bd460bb055ad6e1ab22884','50e81d6be51d4e9ebc57494b341d04c0','5b7e6beb78664013b39741e2df73b276','c795632e9b574c03b538abecb84603e9','5071b9b584f74aecbf906c6f67bfeb2a','ece643d6313641749588383dad4b0426','782701e18b164f48b11c3008445f0fce','ea44c671951b458489bb2e467b5b28a3','43cfda02418145de91286ae787889f85','db42ad18b7d646c3ad30c7bb786f8490','6644a7d1bea3432893e3182b0bf216f6','3240f116c045436fab3397cffaa7f32d','fc917ca7c06c46f19d4acb4387c4c02b','976d61af2c304d0d9f124827d746a868','8e1feb634f2248fd8b02e4cdac275974','973b787ebbd5402184635d4f64c7d172','89c28a5e6e8f4b28bcec528b736288af','97b8253b11d8406cbc6871908244d7b4','3e82b94c9b4048bc97c86a5bf8869553','bbfc76487ca545ffa190acba577a553c','cc0e00567c47444c96d159f3fb416114','c1e2e0ea4edb407f9734afac72fa1364','befb38fea86d4b0a81e8f0ee9efd9a8f','dd3228dd549841b6a7811ecf43292e5d','ae8d407446724c9ea5e22572d0ca765d','529e805e5fe54beab996122c7f809715','9ba68b3695ba476d820816b09782f5d9','ba744bdbc77f42d1853af3f1effb8426','a16472078689406593c1e333b6127437','30b809b4ac1741a9933cc8c8cd010c8d','c927d1785e3748939e9ac5c4d873399c','daa539a9f16e48d692e004deb7bc9ac7','bd36ab0bcfef4ff49ca8f8d4b018b5c9','560dca7776974b70a939a230d7d68bd0','aa7052dc298e43e39efce2d440b2f95b','dcb955f5af804e5b889ef8480020a347','0ac0e6c8c9f048abad70aeadeff745b5','b233aa81627945c38623fee74c7b3be1','d68f12bd4f6a49809c8390dce4ad6c0c','c166529f392048debfdd16baf00fa70c','3fd858a7431a4c3b8b74d03ad0af90b5','d15bf43ef94d41619cb4f14d41d7eb58','258280bd66694addacdb658e918c5780','6a922e9b7fa4438b9680a2c85195311b','ec4e74596fc84a82ba064a039bfc92df','c9ad106812b946238a81a70dbf19c1d0','351ab76590154aeeb5f6fec12e9e74ec','358de680e74b41108a4b93c8e7841a2a','327de081f65a4b88a74e3a0a2db7861e','9b5a1fb09a9540cc97a968e39c5b4140','4c9058c683d64fd48b5c5bf16bd66f0c','af1a3ae47e0449aa9d0135f822ffdfca','edfcb3d5734b47f58f01e646040ae93d','fc452a931d714b11b66d516ba0470b64','8970cacddb9943389ccbcd15b2db84c4','8b9f67c73b0d453ab1042234728fc228','4658af4c47ff40179238d95e3cc1f96f','50cd97bc7f2d461987bd8332f56cf1d7','cff5d8ff57f34d4f82a221f6c8452954','19735c20241441cbb62536ca5594b4f9','c5ad6e6bff9646ea90ed52e8dde9cad0','7049d2cbfb3d44f7bf5c14233ab7f1c4','af2c26da912d45bb90a724c725ce9ebb','a4956af7bdf44b929f18a0060f66e963','7f23820d8ad4413d81a0e8170c9f8faa','d70b42c3440b47cba86c3b6a69d15f68','a5049750a1664767b17f07c1d7e94617','b1423b296e0a4db0bfdb69b2fbaeb1d0','05b4ec81e38d4330aa0e17f6c0d9d435','c5f1354d372a4ab2abc59088b66f0a00','c656ffedabf6420ca1b46619b3b8f1b8','d12714bc2287423cb393f6cc69804604','d90b84015ed14fe5afd2b7e326de5242','53009ced5eb943d78f5a101d07e244b8','0aa438fd653a4f5a8a6da9c5c61bc94a','0998ab1a278d482b84f45ca199826950','0a5cccbbde6b4afb8c29c40f86c702ac','989a7c67988a4648b98cd3e4d34facea','723f83f0c5894c8eaf245a0f690aa2ba','29f43c0fc53f41639a08846fda5730e0','c8e34e6479454109b529a747f3dd861a','3f723006e7bb45eebddfe6d7f295b737','60fcd1753272464891356d825365a077','ec251cb0571e45c39b1d9ce1f84a522c') AND (publisherId='ce99a527703d438d8a178a517d494d1d' OR auditorId='ce99a527703d438d8a178a517d494d1d') ORDER BY orderNum ASC  ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
PreparedStatement: 
'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM cms_content  WHERE delFlag=? AND (title LIKE ? OR content LIKE ?) AND categoryId IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (publisherId=? OR auditorId=?) ORDER BY orderNum ASC  ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
CaseMessage=字符串截断

sql在管理工具中直接执行也要问题,content栏位的类型开始是clob后来改为text,但是还是报错 ,知道是content查的时候报错,不知道为啥出错。

3 回复

一点一点简化这个 SQL 看看能不能用最少的 SQL 重现这个问题

简化了的

SELECT * FROM cms_content  WHERE delFlag=0 AND (title LIKE '%测试%' OR content LIKE '%测试%')

就是这样 加content like的时候就报错了。。

content 是它的关键字??

添加回复
请先登陆
回到顶部