[sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

RecordingsMp3Index ON Recordings(Mp3FileName);"; "CREATE INDEX RecordingsTextIndex ON Recordings(Transcript);"; string.Format("CREATE INDEX RecordingsNoPunctuationIdx ON Recordings({0});", _ReplacePunctuationFunctionPart); SELECT string.Format("SELECT I

Re: [sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

place(replace(Transcript, ',',''),';',''),':',''),'[',''),']',''),'{',''),'}',''),'(', ''),')',''),'\',''),'/',''),'"',''),'_',''),'+',''),'=',''), '£',''),'$',''),'€',''),'%',''),'^',''),'&',''),'*',''),'@', ''),'#',''),'”',''),'“',''),'…',''),'¬',''),'¦',''),'`',''), '~',''),'|',''),'.',''),'!',''),'?',''),' ',''));" *Brian Clifford* Software Developer On 3 August 2017 at 11:38, Richard Hipp <d...@sqlite.org> wrote: > I am un

Re: [sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

Thank Simon, I have looked into using a user defined function however it was very slow. I tried to create an expression index unfortunately I was not able as the function was seen as non deterministic. (I am using the C# interface and its not possible to define a user defined function as