DB2 - Problembeschreibung
Problem IC67981 | Status: Geschlossen |
LARGE QUERY STRING THROWS CTE0157 SYNTAX ERROR. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
We have a query running in v9.5 returning this error: SQL0443N Routine "DB2EXT.TEXTSEARCH_8K64" (specific name "CTE21") has returned an error SQLSTATE with diagnostic text "CTE0157 Syntax error near "" , "KOLD"". ". SQLSTATE=38757 It does not cause error in v8.2.2. This is the query: WITH Q0 AS ( SELECT MPST_SEARCH_DATA.MPS_RECORD_ID FROM MPST_SEARCH_DATA INNER JOIN MPST_rs_contents ON MPST_SEARCH_DATA. MPS_RECORD_ID = MPST_rs_contents.MPS_RECORD_ID WHERE SET_ID=47952 ) , Q1 AS ( SELECT MPST_SEARCH_DATA.MPS_RECORD_ID FROM MPST_SEARCH_DATA WHERE CONTAINS ( MPST_SEARCH_DATA.SEARCH_TEXT_S, 'SECTION ("video_source") ("KDBC" , "KDEB" , "KDLH" , "KDRV" , "KENW" , "KEPR" , "KERO" , "KESQ" , "KET" , "KETV" , "KEVN" , "KEYT" , "KEZI" , "KFAA" , "KFBB" , "KFBT" , "KFDA" , "KFDX" , "KFMB" , "KFOX" , "KFSN" , "KFTA" , "KFVS" , "KFXO" , "KGAN" , "KGBT" , "KGMB" , "KGNS" , "KGO" , "KGTV" , "KGUN" , "KGWN" , "KHBS" , "KHGI" , "KHNL" , "KHON" , "KHQ" , "KHQA" , "KHSL" , "KICU" , "KIDK" , "KIEM" , "KIFI" , "KIII" , "KIMA" , "KIMT" , "KINC" , "KINT" , "KION" , "KIRO" , "KITV" , "KIVI" , "KJCT" , "KJRH" , "KJTL" , "KJTV" , "KKCO" , "KKTU" , "KKTV" , "KLAS" , "KLBK" , "KLDO" , "KLEW" , "KLFY" , "KLJB" , "KLSR" , "KLST" , "KLTV" , "KLUZ" , "KMAX" , "KMBC" , "KMEG" , "KMGH" , "KMID" , "KMIR" , "KMIZ" , "KMOL" , "KMPH" , "KMTV" , "KMTX" , "KMTZ" , "KMVT" , "KNOE" , "KNTV" , "KNVN" , "KNVO" , "KNVV" , "KNWA" , "KNXV" , "KOAT" , "KOBI" , "KOCO" , "KODE" , "KOFY" , "KOHD" , "KOKH" , "KOKI" , "KOLD" , "KOLO" , "KOLR" , "KOMO" , "KOMU" , "KORO" , "KOSA" , "KOTV" , "KOVR" , "KPAX" , "KPHO" , "KPLC" , "KPOM" , "KPRC" , "KPSP" , "KPTM" , "KPTV" , "KPVI" , "KPVM" , "KQCA" , "KQTV" , "KRBC" , "KRCR" , "KRDO" , "KRGV" , "KRNV" , "KRON" , "KRQE" , "KRTV" , "KSAN" , "KSAT" , "KSBI" , "KSBW" , "KSCI" , "KSEE" , "KSFX" , "KSHB" , "KSL" , "KSLA" , "KSMO" , "KSMS" , "KSNF" , "KSNT" , "KSNW" , "KSPR" , "KSWO" , "KSWT" , "KTAB" , "KTAL" , "KTEN" , "KTKA" , "KTIV" , "KTNV" , "KTRE" , "KTRK" , "KTSF" , "KTTC" , "KTUL" , "KTUZ" , "KTVE" , "LTVG" , "KTVH" , "KTVL" , "KTVN" , "KTVO" , "KTVQ" , "KTVU" , "KTVZ" , "KTWO" , "KTXA" , "KTXS" , "KULR" , "KUPT" , "KUSI" , "KUTV" , "KUWB" , "KVAL" , "KVBC" , "KVER" , "KVEW" , "KVIA" , "KVLY" , "KVOA" , "KVRR" , "KVVU" , "KVWB" , "KWAB" , "KWBA" , "KWBQ" , "KWCH" , "KWES" , "KWKB" , "KWQC" , "KWSD" , "KWTV" , "KWWL" , "KXAN" , "KXII" , "KXJB" , "KXLF" , "KXLY" , "KXMB" , "KXRM" , "KXTQ" , "KXXV" , "KYMA" , "KYTX" , "KZSW" , "KZTV" , "WAAY")') = 1), Q2 AS ( SELECT Q1.MPS_RECORD_ID FROM Q1 INNER JOIN Q0 ON Q1.MPS_RECORD_ID=Q0.MPS_RECORD_ID) , QDISTINCT AS ( SELECT DISTINCT MPS_RECORD_ID FROM Q2 ), QFINAL AS ( SELECT MPST_SEARCH_DATA. MPS_RECORD_ID FROM MPST_SEARCH_DATA , QDISTINCT WHERE MPST_SEARCH_DATA. MPS_RECORD_ID = QDISTINCT.MPS_RECORD_ID AND MPST_SEARCH_DATA. COLLECTION_ID IN (1)) SELECT COUNT(*) FROM QFINAL If we reduce the the number of values in the CONTAINS clause the query will run. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * * LARGE QUERY STRING THROWS CTE0157 SYNTAX ERROR. * **************************************************************** * RECOMMENDATION: * * Fixed in release V97fp3 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.04.2010 20.10.2010 20.10.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version |