帮忙看下这个sql在sybase中为什么不能执行

[mu_yi]

今天把oracle数据库迁移了一份到sybase,但有个sql 语句在oracle中执行没问题，但在sybase中却无法执行。2个数据库表结构都是一样的啊，而且我也没有用什么特有函数

错误代码是325：
Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact Sybase Technical Support.


sql语句见下,sql语句是hibernate 自动生成的.是不是字段太多了啊。我把去掉部分字段就能执行。这个和服务器配置有关系吗？
还望不吝赐教！万谢！


select distinct cmscontrac0_.RESOURCEID as RESOURCEID0_0_, cmsappoper1_.RESOURCEID as RESOURCEID1_1_, cmscontrac0_.URGENCY as URGENCY0_0_,
cmscontrac0_.URGENCY_ID as URGENCY3_0_0_, cmscontrac0_.CONTRACT_NAME as CONTRACT4_0_0_, cmscontrac0_.CONTRACT_NUMBER as CONTRACT5_0_0_,
cmscontrac0_.CONTRACT_RELATIVE_NAME as CONTRACT6_0_0_, cmscontrac0_.CONTRACT_OUT_NUMBER as CONTRACT7_0_0_, cmscontrac0_.RELATIVE_CLIENT_TYPE as RELATIVE8_0_0_,
cmscontrac0_.RELATIVE_CLIENT_TYPEID as RELATIVE9_0_0_, cmscontrac0_.AREA_TYPE as AREA10_0_0_, cmscontrac0_.AREA_TYPEID as AREA11_0_0_, cmscontrac0_.AREA_TYPE_INDEXIDS
as AREA12_0_0_, cmscontrac0_.SPECIALTY_TYPE as SPECIALTY13_0_0_, cmscontrac0_.SPECIALTY_TYPEID as SPECIALTY14_0_0_, cmscontrac0_.SPECIALTY_TYPE_INDEXIDS as SPECIALTY15_0_0_,
cmscontrac0_.CONTRACT_AMOUNT as CONTRACT16_0_0_, cmscontrac0_.CONTRACT_AMOUNT_CURRENCY as CONTRACT17_0_0_, cmscontrac0_.PROJECT_TOUZI as PROJECT18_0_0_, cmscontrac0_.DUE_DOCID as DUE19_0_0_,
cmscontrac0_.LOCK_FLAG as LOCK20_0_0_, cmscontrac0_.CONTRACT_STATUS as CONTRACT21_0_0_, cmscontrac0_.SIGN_DATE as SIGN22_0_0_, cmscontrac0_.PERFORM_START_PERIOD as PERFORM23_0_0_,
cmscontrac0_.PERFORM_END_PERIOD as PERFORM24_0_0_, cmscontrac0_.ASSOCIATECONTRACT as ASSOCIA25_0_0_, cmscontrac0_.IS_SEND as IS26_0_0_, cmscontrac0_.CONTRACTTYPE as CONTRAC27_0_0_,
cmscontrac0_.ISREALEDDEALS as ISREALE28_0_0_, cmscontrac0_.DEALSTYPE as DEALSTYPE0_0_, cmscontrac0_.EXPECTEDTIME as EXPECTE30_0_0_, cmscontrac0_.BUSINESSDEPORTID as BUSINES31_0_0_,
cmscontrac0_.BUSINESSDEPORT as BUSINES32_0_0_, cmscontrac0_.SALESMAN as SALESMAN0_0_, cmscontrac0_.SALESMANID as SALESMANID0_0_, cmscontrac0_.FIRSTSORT as FIRSTSORT0_0_,
cmscontrac0_.SECONDSORT as SECONDSORT0_0_, cmscontrac0_.RELATEDBUSINESS as RELATED37_0_0_, cmscontrac0_.PRODUCTCATEGORIES as PRODUCT38_0_0_, cmscontrac0_.FINALCUSTOMER as FINALCU39_0_0_,
cmscontrac0_.SECTOR as SECTOR0_0_, cmscontrac0_.SECONDARYUSER as SECONDA41_0_0_, cmscontrac0_.SERVICESAMOUNT as SERVICE42_0_0_, cmscontrac0_.OUTSOURCINGAMOUNT as OUTSOUR43_0_0_,
cmscontrac0_.SERVICESAMOUNT_Y as SERVICE44_0_0_, cmscontrac0_.GROSSMARGIN as GROSSMA45_0_0_, cmscontrac0_.SOURCEMODELS as SOURCEM46_0_0_, cmscontrac0_.A as A0_0_, cmscontrac0_.B as B0_0_,
cmscontrac0_.PROCESSINGTIME as PROCESS49_0_0_, cmscontrac0_.INVOICETYPE as INVOICE50_0_0_, cmscontrac0_.CONTRACTPROPERTY as CONTRAC51_0_0_, cmscontrac0_.SECTORID as SECTORID0_0_,
cmscontrac0_.FINALCUSTOMERID as FINALCU53_0_0_, cmscontrac0_.OUTSOURCINGAMOUNT_Y as OUTSOUR54_0_0_, cmscontrac0_.CONTACT_A as CONTACT55_0_0_, cmscontrac0_.CONTRACTNOTES as CONTRAC56_0_0_,
cmscontrac0_.IS_FRAME as IS57_0_0_, cmscontrac0_.TOTALCONTRACTID as TOTALCO58_0_0_, cmscontrac0_.RELATEDBUSINESSID as RELATED59_0_0_, cmscontrac0_.SIGNER as SIGNER0_0_,
cmscontrac0_.SIGNERID as SIGNERID0_0_, cmscontrac0_.APPROVERS as APPROVERS0_0_, cmscontrac0_.APPROVERID as APPROVERID0_0_, cmscontrac0_.CONTRACTSXTYPE as CONTRAC64_0_0_,
cmscontrac0_.CONTRACTIDENTIFYING as CONTRAC65_0_0_, cmscontrac0_.CONTRACTSUBTYPR as CONTRAC66_0_0_, cmscontrac0_.CONTRACTPAYTYPE as CONTRAC67_0_0_, cmscontrac0_.ISSUBFRAME as ISSUBFRAME0_0_,
cmscontrac0_.ISTOTALCONTRACT as ISTOTAL69_0_0_, cmscontrac0_.ISSUBCONTRACT as ISSUBCO70_0_0_, cmscontrac0_.DATAWRITESTATUS as DATAWRI71_0_0_, cmscontrac0_.EFFECTIVEDATE as EFFECTI72_0_0_,
cmscontrac0_.WBAMOUNT as WBAMOUNT0_0_, cmscontrac0_.SERIALNUMBER as SERIALN74_0_0_, cmscontrac0_.ISRENEWAL as ISRENEWAL0_0_, cmscontrac0_.SETTLEPERID as SETTLEP76_0_0_,
cmscontrac0_.SETTLEPERNAME as SETTLEP77_0_0_, cmscontrac0_.SETTLEDEPNAME as SETTLED78_0_0_, cmscontrac0_.SETTLEDEPID as SETTLED79_0_0_, cmscontrac0_.ISPROJECT as ISPROJECT0_0_,
cmscontrac0_.PROJECTTIME as PROJECT81_0_0_, cmscontrac0_.RATE as RATE0_0_, cmscontrac0_.CONTRACTTYPEIDS as CONTRAC83_0_0_, cmscontrac0_.CONTRACT_ORIG_AMOUNT as CONTRACT84_0_0_,
cmscontrac0_.CONTRACTTYPEFULLTITLE as CONTRAC85_0_0_, cmscontrac0_.CONTRACSUBTTYPETITLE as CONTRAC86_0_0_, cmscontrac0_.CONTRACTFORMS as CONTRAC87_0_0_,
cmscontrac0_.AREA_TYPECODE as AREA88_0_0_, cmscontrac0_.SPECIALTY_TYPECODE as SPECIALTY89_0_0_, cmscontrac0_.EXPECTEDAMOUNT as EXPECTE90_0_0_,
cmscontrac0_.SPECIALTY_TYPEFULLCODE as SPECIALTY91_0_0_, cmscontrac0_.ISSIGN as ISSIGN0_0_, cmscontrac0_.ISARCHIVES as ISARCHIVES0_0_,
cmscontrac0_.OLDCONTRACTNUMBER as OLDCONT94_0_0_, cmscontrac0_.REALCOUSTOMID as REALCOU95_0_0_, cmscontrac0_.REALCOUSTOMNAME as REALCOU96_0_0_,
cmscontrac0_.CONENDTIME as CONENDTIME0_0_, cmscontrac0_.SUBCONTRACTFORMS as SUBCONT98_0_0_, cmscontrac0_.ISCOUNTERSIGN as ISCOUNT99_0_0_,
cmscontrac0_.WBSNO as WBSNO0_0_, cmscontrac0_.RELTRADECODE as RELTRA101_0_0_, cmscontrac0_.A_ID as A102_0_0_,
cmscontrac0_.RMB_EXCHANGERATE as RMB103_0_0_, cmscontrac0_.USD_EXCHANGERATE as USD104_0_0_, cmscontrac0_.ISFOREIGNCURRENCY as ISFORE105_0_0_,
cmscontrac0_.CONTRACT_AMOUNT_USD as CONTRACT106_0_0_, cmscontrac0_.CONTRACT_INCOME_AMOUNT as CONTRACT107_0_0_, cmscontrac0_.ISUPOLADSCANFILE as ISUPOL108_0_0_,
cmscontrac0_.IS_FORMAT_CONTRACT as IS109_0_0_, cmscontrac0_.FORMAT_CONTRACT_NUMBER as FORMAT110_0_0_, cmsappoper1_.APP_ID as APP2_1_1_,
cmsappoper1_.APP_TYPE as APP3_1_1_, cmsappoper1_.CREATE_DEPART as CREATE4_1_1_, cmsappoper1_.CREATOR_ID as CREATOR5_1_1_,
cmsappoper1_.CREATOR as CREATOR1_1_, cmsappoper1_.LAST_UPDATER_ID as LAST7_1_1_, cmsappoper1_.CREATE_TIME as CREATE8_1_1_,
cmsappoper1_.CREATE_ORG_INFO as CREATE9_1_1_, cmsappoper1_.CREATE_COMPANY_ID as CREATE10_1_1_, cmsappoper1_.CREATE_COMPANY as CREATE11_1_1_,
cmsappoper1_.CREATE_DEPART_ID as CREATE12_1_1_, cmsappoper1_.LAST_UPDATER as LAST13_1_1_, cmsappoper1_.LAST_UPDATER_TIME as LAST14_1_1_,
cmsappoper1_.FLG_DELETED as FLG15_1_1_, cmsappoper1_.WFC_STATUS as WFC16_1_1_, cmsappoper1_.CUR_ACTIVITY_NAME as CUR17_1_1_,
cmsappoper1_.CUR_OPERATOR as CUR18_1_1_, cmsappoper1_.CUR_ACTIVITY_ALIAS as CUR19_1_1_, cmsappoper1_.OPERATOR_IDS as OPERATOR20_1_1_, cmsappoper1_.DATASHARINGINFO as DATASHA21_1_1_,
cmsappoper1_.DATASHARINGNAMES as DATASHA22_1_1_, cmsappoper1_.EXPDATEFLAG as EXPDATE23_1_1_, cmsappoper1_.CUR_PROCESSNAME as CUR24_1_1_, cmsappoper1_.ISPROVCREATE as ISPROVC25_1_1_,
cmsappoper1_.DATAWRITETYPE as DATAWRI26_1_1_, cmsappoper1_.CREATE_ORG_NAME_INFO as CREATE27_1_1_ from CMS_CONTRACT_BASIC_INFO cmscontrac0_, CMS_APP_OPERATE_INFO cmsappoper1_
where 1=1 and cmscontrac0_.RESOURCEID=cmsappoper1_.APP_ID and cmsappoper1_.FLG_DELETED<>'Y' and 1=1 and cmscontrac0_.PERFORM_END_PERIOD<='2009-11-01' and
cmscontrac0_.PERFORM_END_PERIOD>='2001-11-11' and cmsappoper1_.WFC_STATUS='END' and (cmsappoper1_.CREATOR_ID='dddd' or cmsappoper1_.DATASHARINGINFO like 'ddd' or cmscontrac0_.SETTLEPERID='ddd')
order by cmsappoper1_.CREATE_TIME desc, cmsappoper1_.RESOURCEID desc

[iihero]

你的SQL语句太长了，差不多6K多。
将它弄短吧。

[ACMAIN_CHM]

错误提示是什么？

[mu_yi]

错误代码是325：
Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact Sybase Technical Support.

[iihero]

[Quote=引用 4 楼 mu_yi 的回复:]

错误代码是325：
Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact Sybase Technical ……
[/Quote]
你的SQL语句太长了，长度是有限制的。

[bettieyun]

原来sybase对于sql的长度还有个支持限制啊