rnhmjoj/bisc
1
1
Fork 0
Code Issues Pull Requests Releases 5 Wiki Activity

- QuotaManager cleaning failed: ... parser stack overflow" #6

New Issue
Closed
opened 2021-08-26 17:44:11 +02:00 by volfyd · 3 comments
volfyd commented 2021-08-26 17:44:11 +02:00
Copy Link

Hi,

The generated SQL for cleaning the QuotaManager table seems to be too long.

- QuotaManager cleaning failed:
  database operation failed: SqlError "SQLite3 returned ErrorError while attempting to perform prepare \"SELECT \\\"origin_0\\\" FROM (SELECT \\\"origin_0\\\" FROM (SELECT \\\"origin\\\" AS \\\"origin_0\\\" FROM \\\"OriginInfoTable\\\") AS q0 WHERE (NOT(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((($1 OR (\\\"origin_0\\\" LIKE $2)) OR (\\\"origin_0\\\" LIKE $3)) OR (\\\"origin_0\\\" LIKE $4)) OR (\\\"origin_0\\\" LIKE $5)) OR (\\\"origin_0\\\" LIKE $6)) OR (\\\"origin_0\\\" LIKE $7)) OR (\\\"origin_0\\\" LIKE $8)) OR (\\\"origin_0\\\" LIKE $9)) OR (\\\"origin_0\\\" LIKE $10)) OR (\\\"origin_0\\\" LIKE $11)) OR (\\\"origin_0\\\" LIKE $12)) OR (\\\"origin_0\\\" LIKE $13)) OR (\\\"origin_0\\\" LIKE $14)) OR (\\\"origin_0\\\" LIKE $15)) OR (\\\"origin_0\\\" LIKE $16)) OR (\\\"origin_0\\\" LIKE $17)) OR (\\\"origin_0\\\" LIKE $18)) OR (\\\"origin_0\\\" LIKE $19)) OR (\\\"origin_0\\\" LIKE $20)) OR (\\\"origin_0\\\" LIKE $21)) OR (\\\"origin_0\\\" LIKE $22)) OR (\\\"origin_0\\\" LIKE $23)) OR (\\\"origin_0\\\" LIKE $24)) OR (\\\"origin_0\\\" LIKE $25)) OR (\\\"origin_0\\\" LIKE $26)) OR (\\\"origin_0\\\" LIKE $27)) OR (\\\"origin_0\\\" LIKE $28)) OR (\\\"origin_0\\\" LIKE $29)) OR (\\\"origin_0\\\" LIKE $30)) OR (\\\"origin_0\\\" LIKE $31)) OR (\\\"origin_0\\\" LIKE $32)) OR (\\\"origin_0\\\" LIKE $33)) OR (\\\"origin_0\\\" LIKE $34)) OR (\\\"origin_0\\\" LIKE $35)) OR (\\\"origin_0\\\" LIKE $36)) OR (\\\"origin_0\\\" LIKE $37)) OR (\\\"origin_0\\\" LIKE $38)) OR (\\\"origin_0\\\" LIKE $39)) OR (\\\"origin_0\\\" LIKE $40)) OR (\\\"origin_0\\\" LIKE $41)) OR (\\\"origin_0\\\" LIKE $42)) OR (\\\"origin_0\\\" LIKE $43)) OR (\\\"origin_0\\\" LIKE $44)) OR (\\\"origin_0\\\" LIKE $45)) OR (\\\"origin_0\\\" LIKE $46)) OR (\\\"origin_0\\\" LIKE $47)) OR (\\\"origin_0\\\" LIKE $48)) OR (\\\"origin_0\\\" LIKE $49)) OR (\\\"origin_0\\\" LIKE $50)) OR (\\\"origin_0\\\" LIKE $51)) OR (\\\"origin_0\\\" LIKE $52)) OR (\\\"origin_0\\\" LIKE $53)) OR (\\\"origin_0\\\" LIKE $54)) OR (\\\"origin_0\\\" LIKE $55)) OR (\\\"origin_0\\\" LIKE $56)) OR (\\\"origin_0\\\" LIKE $57)) OR (\\\"origin_0\\\" LIKE $58)) OR (\\\"origin_0\\\" LIKE $59)) OR (\\\"origin_0\\\" LIKE $60)) OR (\\\"origin_0\\\" LIKE $61)) OR (\\\"origin_0\\\" LIKE $62)) OR (\\\"origin_0\\\" LIKE $63)) OR (\\\"origin_0\\\" LIKE $64)) OR (\\\"origin_0\\\" LIKE $65)) OR (\\\"origin_0\\\" LIKE $66)) OR (\\\"origin_0\\\" LIKE $67)) OR (\\\"origin_0\\\" LIKE $68)) OR (\\\"origin_0\\\" LIKE $69)) OR (\\\"origin_0\\\" LIKE $70)) OR (\\\"origin_0\\\" LIKE $71)) OR (\\\"origin_0\\\" LIKE $72)) OR (\\\"origin_0\\\" LIKE $73)) OR (\\\"origin_0\\\" LIKE $74)) OR (\\\"origin_0\\\" LIKE $75)) OR (\\\"origin_0\\\" LIKE $76)) OR (\\\"origin_0\\\" LIKE $77)) OR (\\\"origin_0\\\" LIKE $78)) OR (\\\"origin_0\\\" LIKE $79)) OR (\\\"origin_0\\\" LIKE $80)) OR (\\\"origin_0\\\" LIKE $81)) OR (\\\"origin_0\\\" LIKE $82)) OR (\\\"origin_0\\\" LIKE $83)) OR (\\\"origin_0\\\" LIKE $84)) OR (\\\"origin_0\\\" LIKE $85)) OR (\\\"origin_0\\\" LIKE $86)) OR (\\\"origin_0\\\" LIKE $87)) OR (\\\"origin_0\\\" LIKE $88)) OR (\\\"origin_0\\\" LIKE $89)) OR (\\\"origin_0\\\" LIKE $90)) OR (\\\"origin_0\\\" LIKE $91)) OR (\\\"origin_0\\\" LIKE $92)) OR (\\\"origin_0\\\" LIKE $93)) OR (\\\"origin_0\\\" LIKE $94)) OR (\\\"origin_0\\\" LIKE $95)) OR (\\\"origin_0\\\" LIKE $96)) OR (\\\"origin_0\\\" LIKE $97)) OR (\\\"origin_0\\\" LIKE $98)) OR (\\\"origin_0\\\" LIKE $99)) OR (\\\"origin_0\\\" LIKE $100)) OR (\\\"origin_0\\\" LIKE $101)) OR (\\\"origin_0\\\" LIKE $102)) OR (\\\"origin_0\\\" LIKE $103)) OR (\\\"origin_0\\\" LIKE $104)) OR (\\\"origin_0\\\" LIKE $105)) OR (\\\"origin_0\\\" LIKE $106)) OR (\\\"origin_0\\\" LIKE $107)) OR (\\\"origin_0\\\" LIKE $108)) OR (\\\"origin_0\\\" LIKE $109)) OR (\\\"origin_0\\\" LIKE $110)) OR (\\\"origin_0\\\" LIKE $111)) OR (\\\"origin_0\\\" LIKE $112)) OR (\\\"origin_0\\\" LIKE $113)) OR (\\\"origin_0\\\" LIKE $114)) OR (\\\"origin_0\\\" LIKE $115)) OR (\\\"origin_0\\\" LIKE $116)) OR (\\\"origin_0\\\" LIKE $117)) OR (\\\"origin_0\\\" LIKE $118)) OR (\\\"origin_0\\\" LIKE $119)) OR (\\\"origin_0\\\" LIKE $120)) OR (\\\"origin_0\\\" LIKE $121)) OR (\\\"origin_0\\\" LIKE $122)) OR (\\\"origin_0\\\" LIKE $123)) OR (\\\"origin_0\\\" LIKE $124)) OR (\\\"origin_0\\\" LIKE $125)) OR (\\\"origin_0\\\" LIKE $126)) OR (\\\"origin_0\\\" LIKE $127)) OR (\\\"origin_0\\\" LIKE $128)) OR (\\\"origin_0\\\" LIKE $129)) OR (\\\"origin_0\\\" LIKE $130)) OR (\\\"origin_0\\\" LIKE $131)) OR (\\\"origin_0\\\" LIKE $132)) OR (\\\"origin_0\\\" LIKE $133)) OR (\\\"origin_0\\\" LIKE $134)) OR (\\\"origin_0\\\" LIKE $135)) OR (\\\"origin_0\\\" LIKE $136)) OR (\\\"origin_0\\\" LIKE $137)) OR (\\\"origin_0\\\" LIKE $138)) OR (\\\"origin_0\\\" LIKE $139)) OR (\\\"origin_0\\\" LIKE $140)) OR (\\\"origin_0\\\" LIKE $141)) OR (\\\"origin_0\\\" LIKE $142)) OR (\\\"origin_0\\\" LIKE $143)) OR (\\\"origin_0\\\" LIKE $144)) OR (\\\"origin_0\\\" LIKE $145)) OR (\\\"origin_0\\\" LIKE $146)) OR (\\\"origin_0\\\" LIKE $147)) OR (\\\"origin_0\\\" LIKE $148)) OR (\\\"origin_0\\\" LIKE $149)) OR (\\\"origin_0\\\" LIKE $150)) OR (\\\"origin_0\\\" LIKE $151)) OR (\\\"origin_0\\\" LIKE $152)) OR (\\\"origin_0\\\" LIKE $153)) OR (\\\"origin_0\\\" LIKE $154)) OR (\\\"origin_0\\\" LIKE $155)) OR (\\\"origin_0\\\" LIKE $156)) OR (\\\"origin_0\\\" LIKE $157)) OR (\\\"origin_0\\\" LIKE $158)) OR (\\\"origin_0\\\" LIKE $159)) OR (\\\"origin_0\\\" LIKE $160)) OR (\\\"origin_0\\\" LIKE $161)) OR (\\\"origin_0\\\" LIKE $162)) OR (\\\"origin_0\\\" LIKE $163)) OR (\\\"origin_0\\\" LIKE $164)) OR (\\\"origin_0\\\" LIKE $165)) OR (\\\"origin_0\\\" LIKE $166)) OR (\\\"origin_0\\\" LIKE $167)) OR (\\\"origin_0\\\" LIKE $168)) OR (\\\"origin_0\\\" LIKE $169)) OR (\\\"origin_0\\\" LIKE $170)) OR (\\\"origin_0\\\" LIKE $171)) OR (\\\"origin_0\\\" LIKE $172)) OR (\\\"origin_0\\\" LIKE $173)) OR (\\\"origin_0\\\" LIKE $174)) OR (\\\"origin_0\\\" LIKE $175)) OR (\\\"origin_0\\\" LIKE $176)) OR (\\\"origin_0\\\" LIKE $177)) OR (\\\"origin_0\\\" LIKE $178)) OR (\\\"origin_0\\\" LIKE $179)) OR (\\\"origin_0\\\" LIKE $180)) OR (\\\"origin_0\\\" LIKE $181)) OR (\\\"origin_0\\\" LIKE $182)) OR (\\\"origin_0\\\" LIKE $183)) OR (\\\"origin_0\\\" LIKE $184)) OR (\\\"origin_0\\\" LIKE $185)) OR (\\\"origin_0\\\" LIKE $186)) OR (\\\"origin_0\\\" LIKE $187)) OR (\\\"origin_0\\\" LIKE $188)) OR (\\\"origin_0\\\" LIKE $189)) OR (\\\"origin_0\\\" LIKE $190)) OR (\\\"origin_0\\\" LIKE $191)) OR (\\\"origin_0\\\" LIKE $192)) OR (\\\"origin_0\\\" LIKE $193)) OR (\\\"origin_0\\\" LIKE $194)) OR (\\\"origin_0\\\" LIKE $195)) OR (\\\"origin_0\\\" LIKE $196)) OR (\\\"origin_0\\\" LIKE $197)) OR (\\\"origin_0\\\" LIKE $198)) OR (\\\"origin_0\\\" LIKE $199)) OR (\\\"origin_0\\\" LIKE $200)) OR (\\\"origin_0\\\" LIKE $201)) OR (\\\"origin_0\\\" LIKE $202)) OR (\\\"origin_0\\\" LIKE $203)) OR (\\\"origin_0\\\" LIKE $204)) OR (\\\"origin_0\\\" LIKE $205)) OR (\\\"origin_0\\\" LIKE $206)) OR (\\\"origin_0\\\" LIKE $207)) OR (\\\"origin_0\\\" LIKE $208)) OR (\\\"origin_0\\\" LIKE $209)) OR (\\\"origin_0\\\" LIKE $210)) OR (\\\"origin_0\\\" LIKE $211)) OR (\\\"origin_0\\\" LIKE $212)) OR (\\\"origin_0\\\" LIKE $213)) OR (\\\"origin_0\\\" LIKE $214)) OR (\\\"origin_0\\\" LIKE $215)) OR (\\\"origin_0\\\" LIKE $216)) OR (\\\"origin_0\\\" LIKE $217)) OR (\\\"origin_0\\\" LIKE $218)) OR (\\\"origin_0\\\" LIKE $219)) OR (\\\"origin_0\\\" LIKE $220)) OR (\\\"origin_0\\\" LIKE $221)) OR (\\\"origin_0\\\" LIKE $222)) OR (\\\"origin_0\\\" LIKE $223)) OR (\\\"origin_0\\\" LIKE $224)) OR (\\\"origin_0\\\" LIKE $225)) OR (\\\"origin_0\\\" LIKE $226)) OR (\\\"origin_0\\\" LIKE $227)) OR (\\\"origin_0\\\" LIKE $228)) OR (\\\"origin_0\\\" LIKE $229)) OR (\\\"origin_0\\\" LIKE $230)) OR (\\\"origin_0\\\" LIKE $231)) OR (\\\"origin_0\\\" LIKE $232)) OR (\\\"origin_0\\\" LIKE $233)) OR (\\\"origin_0\\\" LIKE $234)) OR (\\\"origin_0\\\" LIKE $235)) OR (\\\"origin_0\\\" LIKE $236)) OR (\\\"origin_0\\\" LIKE $237)) OR (\\\"origin_0\\\" LIKE $238)) OR (\\\"origin_0\\\" LIKE $239)) OR (\\\"origin_0\\\" LIKE $240)) OR (\\\"origin_0\\\" LIKE $241)) OR (\\\"origin_0\\\" LIKE $242)) OR (\\\"origin_0\\\" LIKE $243)) OR (\\\"origin_0\\\" LIKE $244)) OR (\\\"origin_0\\\" LIKE $245)) OR (\\\"origin_0\\\" LIKE $246)) OR (\\\"origin_0\\\" LIKE $247)) OR (\\\"origin_0\\\" LIKE $248)) OR (\\\"origin_0\\\" LIKE $249)) OR (\\\"origin_0\\\" LIKE $250)) OR (\\\"origin_0\\\" LIKE $251)) OR (\\\"origin_0\\\" LIKE $252)) OR (\\\"origin_0\\\" LIKE $253)) OR (\\\"origin_0\\\" LIKE $254)) OR (\\\"origin_0\\\" LIKE $255)) OR (\\\"origin_0\\\" LIKE $256)) OR (\\\"origin_0\\\" LIKE $257)) OR (\\\"origin_0\\\" LIKE $258)) OR (\\\"origin_0\\\" LIKE $259)) OR (\\\"origin_0\\\" LIKE $260)) OR (\\\"origin_0\\\" LIKE $261)) OR (\\\"origin_0\\\" LIKE $262)) OR (\\\"origin_0\\\" LIKE $263)) OR (\\\"origin_0\\\" LIKE $264)) OR (\\\"origin_0\\\" LIKE $265)) OR (\\\"origin_0\\\" LIKE $266)) OR (\\\"origin_0\\\" LIKE $267)) OR (\\\"origin_0\\\" LIKE $268)) OR (\\\"origin_0\\\" LIKE $269)) OR (\\\"origin_0\\\" LIKE $270)) OR (\\\"origin_0\\\" LIKE $271)) OR (\\\"origin_0\\\" LIKE $272)) OR (\\\"origin_0\\\" LIKE $273)) OR (\\\"origin_0\\\" LIKE $274)) OR (\\\"origin_0\\\" LIKE $275)) OR (\\\"origin_0\\\" LIKE $276)) OR (\\\"origin_0\\\" LIKE $277)) OR (\\\"origin_0\\\" LIKE $278)) OR (\\\"origin_0\\\" LIKE $279)) OR (\\\"origin_0\\\" LIKE $280)) OR (\\\"origin_0\\\" LIKE $281)) OR (\\\"origin_0\\\" LIKE $282)) OR (\\\"origin_0\\\" LIKE $283)) OR (\\\"origin_0\\\" LIKE $284)) OR (\\\"origin_0\\\" LIKE $285)) OR (\\\"origin_0\\\" LIKE $286)) OR (\\\"origin_0\\\" LIKE $287)) OR (\\\"origin_0\\\" LIKE $288)) OR (\\\"origin_0\\\" LIKE $289)) OR (\\\"origin_0\\\" LIKE $290)) OR (\\\"origin_0\\\" LIKE $291)) OR (\\\"origin_0\\\" LIKE $292)) OR (\\\"origin_0\\\" LIKE $293)) OR (\\\"origin_0\\\" LIKE $294)) OR (\\\"origin_0\\\" LIKE $295)) OR (\\\"origin_0\\\" LIKE $296)) OR (\\\"origin_0\\\" LIKE $297)) OR (\\\"origin_0\\\" LIKE $298)) OR (\\\"origin_0\\\" LIKE $299)) OR (\\\"origin_0\\\" LIKE $300)) OR (\\\"origin_0\\\" LIKE $301)) OR (\\\"origin_0\\\" LIKE $302)) OR (\\\"origin_0\\\" LIKE $303)) OR (\\\"origin_0\\\" LIKE $304)) OR (\\\"origin_0\\\" LIKE $305)) OR (\\\"origin_0\\\" LIKE $306)) OR (\\\"origin_0\\\" LIKE $307)) OR (\\\"origin_0\\\" LIKE $308)) OR (\\\"origin_0\\\" LIKE $309)) OR (\\\"origin_0\\\" LIKE $310)) OR (\\\"origin_0\\\" LIKE $311)) OR (\\\"origin_0\\\" LIKE $312)) OR (\\\"origin_0\\\" LIKE $313)) OR (\\\"origin_0\\\" LIKE $314)) OR (\\\"origin_0\\\" LIKE $315)) OR (\\\"origin_0\\\" LIKE $316)) OR (\\\"origin_0\\\" LIKE $317)) OR (\\\"origin_0\\\" LIKE $318)) OR (\\\"origin_0\\\" LIKE $319)) OR (\\\"origin_0\\\" LIKE $320)) OR (\\\"origin_0\\\" LIKE $321)) OR (\\\"origin_0\\\" LIKE $322)) OR (\\\"origin_0\\\" LIKE $323)) OR (\\\"origin_0\\\" LIKE $324)) OR (\\\"origin_0\\\" LIKE $325)))) AS q1\": parser stack overflow"
Hi, The generated SQL for cleaning the QuotaManager table seems to be too long. ``` - QuotaManager cleaning failed: database operation failed: SqlError "SQLite3 returned ErrorError while attempting to perform prepare \"SELECT \\\"origin_0\\\" FROM (SELECT \\\"origin_0\\\" FROM (SELECT \\\"origin\\\" AS \\\"origin_0\\\" FROM \\\"OriginInfoTable\\\") AS q0 WHERE (NOT(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((($1 OR (\\\"origin_0\\\" LIKE $2)) OR (\\\"origin_0\\\" LIKE $3)) OR (\\\"origin_0\\\" LIKE $4)) OR (\\\"origin_0\\\" LIKE $5)) OR (\\\"origin_0\\\" LIKE $6)) OR (\\\"origin_0\\\" LIKE $7)) OR (\\\"origin_0\\\" LIKE $8)) OR (\\\"origin_0\\\" LIKE $9)) OR (\\\"origin_0\\\" LIKE $10)) OR (\\\"origin_0\\\" LIKE $11)) OR (\\\"origin_0\\\" LIKE $12)) OR (\\\"origin_0\\\" LIKE $13)) OR (\\\"origin_0\\\" LIKE $14)) OR (\\\"origin_0\\\" LIKE $15)) OR (\\\"origin_0\\\" LIKE $16)) OR (\\\"origin_0\\\" LIKE $17)) OR (\\\"origin_0\\\" LIKE $18)) OR (\\\"origin_0\\\" LIKE $19)) OR (\\\"origin_0\\\" LIKE $20)) OR (\\\"origin_0\\\" LIKE $21)) OR (\\\"origin_0\\\" LIKE $22)) OR (\\\"origin_0\\\" LIKE $23)) OR (\\\"origin_0\\\" LIKE $24)) OR (\\\"origin_0\\\" LIKE $25)) OR (\\\"origin_0\\\" LIKE $26)) OR (\\\"origin_0\\\" LIKE $27)) OR (\\\"origin_0\\\" LIKE $28)) OR (\\\"origin_0\\\" LIKE $29)) OR (\\\"origin_0\\\" LIKE $30)) OR (\\\"origin_0\\\" LIKE $31)) OR (\\\"origin_0\\\" LIKE $32)) OR (\\\"origin_0\\\" LIKE $33)) OR (\\\"origin_0\\\" LIKE $34)) OR (\\\"origin_0\\\" LIKE $35)) OR (\\\"origin_0\\\" LIKE $36)) OR (\\\"origin_0\\\" LIKE $37)) OR (\\\"origin_0\\\" LIKE $38)) OR (\\\"origin_0\\\" LIKE $39)) OR (\\\"origin_0\\\" LIKE $40)) OR (\\\"origin_0\\\" LIKE $41)) OR (\\\"origin_0\\\" LIKE $42)) OR (\\\"origin_0\\\" LIKE $43)) OR (\\\"origin_0\\\" LIKE $44)) OR (\\\"origin_0\\\" LIKE $45)) OR (\\\"origin_0\\\" LIKE $46)) OR (\\\"origin_0\\\" LIKE $47)) OR (\\\"origin_0\\\" LIKE $48)) OR (\\\"origin_0\\\" LIKE $49)) OR (\\\"origin_0\\\" LIKE $50)) OR (\\\"origin_0\\\" LIKE $51)) OR (\\\"origin_0\\\" LIKE $52)) OR (\\\"origin_0\\\" LIKE $53)) OR (\\\"origin_0\\\" LIKE $54)) OR (\\\"origin_0\\\" LIKE $55)) OR (\\\"origin_0\\\" LIKE $56)) OR (\\\"origin_0\\\" LIKE $57)) OR (\\\"origin_0\\\" LIKE $58)) OR (\\\"origin_0\\\" LIKE $59)) OR (\\\"origin_0\\\" LIKE $60)) OR (\\\"origin_0\\\" LIKE $61)) OR (\\\"origin_0\\\" LIKE $62)) OR (\\\"origin_0\\\" LIKE $63)) OR (\\\"origin_0\\\" LIKE $64)) OR (\\\"origin_0\\\" LIKE $65)) OR (\\\"origin_0\\\" LIKE $66)) OR (\\\"origin_0\\\" LIKE $67)) OR (\\\"origin_0\\\" LIKE $68)) OR (\\\"origin_0\\\" LIKE $69)) OR (\\\"origin_0\\\" LIKE $70)) OR (\\\"origin_0\\\" LIKE $71)) OR (\\\"origin_0\\\" LIKE $72)) OR (\\\"origin_0\\\" LIKE $73)) OR (\\\"origin_0\\\" LIKE $74)) OR (\\\"origin_0\\\" LIKE $75)) OR (\\\"origin_0\\\" LIKE $76)) OR (\\\"origin_0\\\" LIKE $77)) OR (\\\"origin_0\\\" LIKE $78)) OR (\\\"origin_0\\\" LIKE $79)) OR (\\\"origin_0\\\" LIKE $80)) OR (\\\"origin_0\\\" LIKE $81)) OR (\\\"origin_0\\\" LIKE $82)) OR (\\\"origin_0\\\" LIKE $83)) OR (\\\"origin_0\\\" LIKE $84)) OR (\\\"origin_0\\\" LIKE $85)) OR (\\\"origin_0\\\" LIKE $86)) OR (\\\"origin_0\\\" LIKE $87)) OR (\\\"origin_0\\\" LIKE $88)) OR (\\\"origin_0\\\" LIKE $89)) OR (\\\"origin_0\\\" LIKE $90)) OR (\\\"origin_0\\\" LIKE $91)) OR (\\\"origin_0\\\" LIKE $92)) OR (\\\"origin_0\\\" LIKE $93)) OR (\\\"origin_0\\\" LIKE $94)) OR (\\\"origin_0\\\" LIKE $95)) OR (\\\"origin_0\\\" LIKE $96)) OR (\\\"origin_0\\\" LIKE $97)) OR (\\\"origin_0\\\" LIKE $98)) OR (\\\"origin_0\\\" LIKE $99)) OR (\\\"origin_0\\\" LIKE $100)) OR (\\\"origin_0\\\" LIKE $101)) OR (\\\"origin_0\\\" LIKE $102)) OR (\\\"origin_0\\\" LIKE $103)) OR (\\\"origin_0\\\" LIKE $104)) OR (\\\"origin_0\\\" LIKE $105)) OR (\\\"origin_0\\\" LIKE $106)) OR (\\\"origin_0\\\" LIKE $107)) OR (\\\"origin_0\\\" LIKE $108)) OR (\\\"origin_0\\\" LIKE $109)) OR (\\\"origin_0\\\" LIKE $110)) OR (\\\"origin_0\\\" LIKE $111)) OR (\\\"origin_0\\\" LIKE $112)) OR (\\\"origin_0\\\" LIKE $113)) OR (\\\"origin_0\\\" LIKE $114)) OR (\\\"origin_0\\\" LIKE $115)) OR (\\\"origin_0\\\" LIKE $116)) OR (\\\"origin_0\\\" LIKE $117)) OR (\\\"origin_0\\\" LIKE $118)) OR (\\\"origin_0\\\" LIKE $119)) OR (\\\"origin_0\\\" LIKE $120)) OR (\\\"origin_0\\\" LIKE $121)) OR (\\\"origin_0\\\" LIKE $122)) OR (\\\"origin_0\\\" LIKE $123)) OR (\\\"origin_0\\\" LIKE $124)) OR (\\\"origin_0\\\" LIKE $125)) OR (\\\"origin_0\\\" LIKE $126)) OR (\\\"origin_0\\\" LIKE $127)) OR (\\\"origin_0\\\" LIKE $128)) OR (\\\"origin_0\\\" LIKE $129)) OR (\\\"origin_0\\\" LIKE $130)) OR (\\\"origin_0\\\" LIKE $131)) OR (\\\"origin_0\\\" LIKE $132)) OR (\\\"origin_0\\\" LIKE $133)) OR (\\\"origin_0\\\" LIKE $134)) OR (\\\"origin_0\\\" LIKE $135)) OR (\\\"origin_0\\\" LIKE $136)) OR (\\\"origin_0\\\" LIKE $137)) OR (\\\"origin_0\\\" LIKE $138)) OR (\\\"origin_0\\\" LIKE $139)) OR (\\\"origin_0\\\" LIKE $140)) OR (\\\"origin_0\\\" LIKE $141)) OR (\\\"origin_0\\\" LIKE $142)) OR (\\\"origin_0\\\" LIKE $143)) OR (\\\"origin_0\\\" LIKE $144)) OR (\\\"origin_0\\\" LIKE $145)) OR (\\\"origin_0\\\" LIKE $146)) OR (\\\"origin_0\\\" LIKE $147)) OR (\\\"origin_0\\\" LIKE $148)) OR (\\\"origin_0\\\" LIKE $149)) OR (\\\"origin_0\\\" LIKE $150)) OR (\\\"origin_0\\\" LIKE $151)) OR (\\\"origin_0\\\" LIKE $152)) OR (\\\"origin_0\\\" LIKE $153)) OR (\\\"origin_0\\\" LIKE $154)) OR (\\\"origin_0\\\" LIKE $155)) OR (\\\"origin_0\\\" LIKE $156)) OR (\\\"origin_0\\\" LIKE $157)) OR (\\\"origin_0\\\" LIKE $158)) OR (\\\"origin_0\\\" LIKE $159)) OR (\\\"origin_0\\\" LIKE $160)) OR (\\\"origin_0\\\" LIKE $161)) OR (\\\"origin_0\\\" LIKE $162)) OR (\\\"origin_0\\\" LIKE $163)) OR (\\\"origin_0\\\" LIKE $164)) OR (\\\"origin_0\\\" LIKE $165)) OR (\\\"origin_0\\\" LIKE $166)) OR (\\\"origin_0\\\" LIKE $167)) OR (\\\"origin_0\\\" LIKE $168)) OR (\\\"origin_0\\\" LIKE $169)) OR (\\\"origin_0\\\" LIKE $170)) OR (\\\"origin_0\\\" LIKE $171)) OR (\\\"origin_0\\\" LIKE $172)) OR (\\\"origin_0\\\" LIKE $173)) OR (\\\"origin_0\\\" LIKE $174)) OR (\\\"origin_0\\\" LIKE $175)) OR (\\\"origin_0\\\" LIKE $176)) OR (\\\"origin_0\\\" LIKE $177)) OR (\\\"origin_0\\\" LIKE $178)) OR (\\\"origin_0\\\" LIKE $179)) OR (\\\"origin_0\\\" LIKE $180)) OR (\\\"origin_0\\\" LIKE $181)) OR (\\\"origin_0\\\" LIKE $182)) OR (\\\"origin_0\\\" LIKE $183)) OR (\\\"origin_0\\\" LIKE $184)) OR (\\\"origin_0\\\" LIKE $185)) OR (\\\"origin_0\\\" LIKE $186)) OR (\\\"origin_0\\\" LIKE $187)) OR (\\\"origin_0\\\" LIKE $188)) OR (\\\"origin_0\\\" LIKE $189)) OR (\\\"origin_0\\\" LIKE $190)) OR (\\\"origin_0\\\" LIKE $191)) OR (\\\"origin_0\\\" LIKE $192)) OR (\\\"origin_0\\\" LIKE $193)) OR (\\\"origin_0\\\" LIKE $194)) OR (\\\"origin_0\\\" LIKE $195)) OR (\\\"origin_0\\\" LIKE $196)) OR (\\\"origin_0\\\" LIKE $197)) OR (\\\"origin_0\\\" LIKE $198)) OR (\\\"origin_0\\\" LIKE $199)) OR (\\\"origin_0\\\" LIKE $200)) OR (\\\"origin_0\\\" LIKE $201)) OR (\\\"origin_0\\\" LIKE $202)) OR (\\\"origin_0\\\" LIKE $203)) OR (\\\"origin_0\\\" LIKE $204)) OR (\\\"origin_0\\\" LIKE $205)) OR (\\\"origin_0\\\" LIKE $206)) OR (\\\"origin_0\\\" LIKE $207)) OR (\\\"origin_0\\\" LIKE $208)) OR (\\\"origin_0\\\" LIKE $209)) OR (\\\"origin_0\\\" LIKE $210)) OR (\\\"origin_0\\\" LIKE $211)) OR (\\\"origin_0\\\" LIKE $212)) OR (\\\"origin_0\\\" LIKE $213)) OR (\\\"origin_0\\\" LIKE $214)) OR (\\\"origin_0\\\" LIKE $215)) OR (\\\"origin_0\\\" LIKE $216)) OR (\\\"origin_0\\\" LIKE $217)) OR (\\\"origin_0\\\" LIKE $218)) OR (\\\"origin_0\\\" LIKE $219)) OR (\\\"origin_0\\\" LIKE $220)) OR (\\\"origin_0\\\" LIKE $221)) OR (\\\"origin_0\\\" LIKE $222)) OR (\\\"origin_0\\\" LIKE $223)) OR (\\\"origin_0\\\" LIKE $224)) OR (\\\"origin_0\\\" LIKE $225)) OR (\\\"origin_0\\\" LIKE $226)) OR (\\\"origin_0\\\" LIKE $227)) OR (\\\"origin_0\\\" LIKE $228)) OR (\\\"origin_0\\\" LIKE $229)) OR (\\\"origin_0\\\" LIKE $230)) OR (\\\"origin_0\\\" LIKE $231)) OR (\\\"origin_0\\\" LIKE $232)) OR (\\\"origin_0\\\" LIKE $233)) OR (\\\"origin_0\\\" LIKE $234)) OR (\\\"origin_0\\\" LIKE $235)) OR (\\\"origin_0\\\" LIKE $236)) OR (\\\"origin_0\\\" LIKE $237)) OR (\\\"origin_0\\\" LIKE $238)) OR (\\\"origin_0\\\" LIKE $239)) OR (\\\"origin_0\\\" LIKE $240)) OR (\\\"origin_0\\\" LIKE $241)) OR (\\\"origin_0\\\" LIKE $242)) OR (\\\"origin_0\\\" LIKE $243)) OR (\\\"origin_0\\\" LIKE $244)) OR (\\\"origin_0\\\" LIKE $245)) OR (\\\"origin_0\\\" LIKE $246)) OR (\\\"origin_0\\\" LIKE $247)) OR (\\\"origin_0\\\" LIKE $248)) OR (\\\"origin_0\\\" LIKE $249)) OR (\\\"origin_0\\\" LIKE $250)) OR (\\\"origin_0\\\" LIKE $251)) OR (\\\"origin_0\\\" LIKE $252)) OR (\\\"origin_0\\\" LIKE $253)) OR (\\\"origin_0\\\" LIKE $254)) OR (\\\"origin_0\\\" LIKE $255)) OR (\\\"origin_0\\\" LIKE $256)) OR (\\\"origin_0\\\" LIKE $257)) OR (\\\"origin_0\\\" LIKE $258)) OR (\\\"origin_0\\\" LIKE $259)) OR (\\\"origin_0\\\" LIKE $260)) OR (\\\"origin_0\\\" LIKE $261)) OR (\\\"origin_0\\\" LIKE $262)) OR (\\\"origin_0\\\" LIKE $263)) OR (\\\"origin_0\\\" LIKE $264)) OR (\\\"origin_0\\\" LIKE $265)) OR (\\\"origin_0\\\" LIKE $266)) OR (\\\"origin_0\\\" LIKE $267)) OR (\\\"origin_0\\\" LIKE $268)) OR (\\\"origin_0\\\" LIKE $269)) OR (\\\"origin_0\\\" LIKE $270)) OR (\\\"origin_0\\\" LIKE $271)) OR (\\\"origin_0\\\" LIKE $272)) OR (\\\"origin_0\\\" LIKE $273)) OR (\\\"origin_0\\\" LIKE $274)) OR (\\\"origin_0\\\" LIKE $275)) OR (\\\"origin_0\\\" LIKE $276)) OR (\\\"origin_0\\\" LIKE $277)) OR (\\\"origin_0\\\" LIKE $278)) OR (\\\"origin_0\\\" LIKE $279)) OR (\\\"origin_0\\\" LIKE $280)) OR (\\\"origin_0\\\" LIKE $281)) OR (\\\"origin_0\\\" LIKE $282)) OR (\\\"origin_0\\\" LIKE $283)) OR (\\\"origin_0\\\" LIKE $284)) OR (\\\"origin_0\\\" LIKE $285)) OR (\\\"origin_0\\\" LIKE $286)) OR (\\\"origin_0\\\" LIKE $287)) OR (\\\"origin_0\\\" LIKE $288)) OR (\\\"origin_0\\\" LIKE $289)) OR (\\\"origin_0\\\" LIKE $290)) OR (\\\"origin_0\\\" LIKE $291)) OR (\\\"origin_0\\\" LIKE $292)) OR (\\\"origin_0\\\" LIKE $293)) OR (\\\"origin_0\\\" LIKE $294)) OR (\\\"origin_0\\\" LIKE $295)) OR (\\\"origin_0\\\" LIKE $296)) OR (\\\"origin_0\\\" LIKE $297)) OR (\\\"origin_0\\\" LIKE $298)) OR (\\\"origin_0\\\" LIKE $299)) OR (\\\"origin_0\\\" LIKE $300)) OR (\\\"origin_0\\\" LIKE $301)) OR (\\\"origin_0\\\" LIKE $302)) OR (\\\"origin_0\\\" LIKE $303)) OR (\\\"origin_0\\\" LIKE $304)) OR (\\\"origin_0\\\" LIKE $305)) OR (\\\"origin_0\\\" LIKE $306)) OR (\\\"origin_0\\\" LIKE $307)) OR (\\\"origin_0\\\" LIKE $308)) OR (\\\"origin_0\\\" LIKE $309)) OR (\\\"origin_0\\\" LIKE $310)) OR (\\\"origin_0\\\" LIKE $311)) OR (\\\"origin_0\\\" LIKE $312)) OR (\\\"origin_0\\\" LIKE $313)) OR (\\\"origin_0\\\" LIKE $314)) OR (\\\"origin_0\\\" LIKE $315)) OR (\\\"origin_0\\\" LIKE $316)) OR (\\\"origin_0\\\" LIKE $317)) OR (\\\"origin_0\\\" LIKE $318)) OR (\\\"origin_0\\\" LIKE $319)) OR (\\\"origin_0\\\" LIKE $320)) OR (\\\"origin_0\\\" LIKE $321)) OR (\\\"origin_0\\\" LIKE $322)) OR (\\\"origin_0\\\" LIKE $323)) OR (\\\"origin_0\\\" LIKE $324)) OR (\\\"origin_0\\\" LIKE $325)))) AS q1\": parser stack overflow" ```
rnhmjoj commented 2021-09-02 14:29:51 +02:00
Owner
Copy Link

Unfortunately I couldn't find a better way to do this in the SQL library I'm using. Basically I need to select records matching any (url) pattern in the whitelist, so if this list is large, it will produce a very long WHERE condition.

If you have any idea, I would be happy to try to implement it.

Unfortunately I couldn't find a better way to do this in the SQL library I'm using. Basically I need to select records matching any (url) pattern in the whitelist, so if this list is large, it will produce a very long WHERE condition. If you have any idea, I would be happy to try to implement it.
rnhmjoj commented 2021-09-02 14:30:42 +02:00
Owner
Copy Link

This is where the query is built: https://maxwell.ydns.eu/git/rnhmjoj/bisc/src/branch/master/Main.hs#L150

This is where the query is built: https://maxwell.ydns.eu/git/rnhmjoj/bisc/src/branch/master/Main.hs#L150
rnhmjoj referenced this issue from a commit 2021-09-06 01:12:49 +02:00
Fix issue #6
rnhmjoj commented 2021-09-06 01:17:06 +02:00
Owner
Copy Link

Ok, I figured out a way to do it: it should be fixed in the next release.

Ok, I figured out a way to do it: it should be fixed in the next release.
rnhmjoj referenced this issue from a commit 2021-09-06 01:36:06 +02:00
Fix issue #6
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: rnhmjoj/bisc#6
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?