subject:"\[sqlite\] Query on TEMP view."

Re: [sqlite] Query on TEMP view.

2018-08-28 Thread Keith Medcalf

On Behalf Of Hegde, Deepakakumar >(D.) >Sent: Monday, 27 August, 2018 23:47 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Query on TEMP view. > >Hi All, > > >I am facing a problem where in defined function registered to sqlite >is called multiple time

[sqlite] Query on TEMP view.

2018-08-27 Thread Hegde, Deepakakumar (D.)

Hi All, I am facing a problem where in defined function registered to sqlite is called multiple time withput considering the filter. Ex: Table and entry: ID NAME PPID 1a.mp3 2 2b.mp3 3 Query: SELECT COUNT(TEMP.ID) FROM (SELECT ID,NAME,PPID FROM AUDIO WHERE PPID=2) AS