Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

> >Sent: Friday, 25 August, 2017 15:25 > >To: SQLite mailing list > >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, > >function_list, module_list > > > >Tried with the latest 3.20.1, but same result. > >My explain output is like this: &

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

> > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert > >Sent: Friday, 25 August, 2017 15:25 > >To: SQLite mailing list > >Subject: Re: [sqlite] FIX FOR:: Duplicate output with p

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

>boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert >Sent: Friday, 25 August, 2017 15:25 >To: SQLite mailing list >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, >function_list, module_list > >Tried with the latest 3.20.1, but same result.

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

i=0; i<ArraySize(aPragmaName); i++){ > sqlite3VdbeMultiLoad(v, 1, "s", aPragmaName[i].zName); > // sqlite3VdbeAddOp2(v, OP_ResultRow, 1, 1); > } > } > break; > #endif /* SQLITE_INTROSPECTION_PRAGMAS */ > > > --- > The fact that t

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

act that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert >Sent: Friday, 25 August, 2017 14:57 >To

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

nt: Friday, 25 August, 2017 14:13 > >To: SQLite mailing list > >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, > >function_list, module_list > > > >I copied the exact code block as in > >http://www.sqlite.org/src/info/b79cc8dc88c8ae03 > >compil

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

: Friday, 25 August, 2017 14:13 >To: SQLite mailing list >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, >function_list, module_list > >I copied the exact code block as in >http://www.sqlite.org/src/info/b79cc8dc88c8ae03 >compiled in MSVS, no errors and dl

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

e-users@mailinglists.sqlite.org > >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, > >function_list, module_list > > > >On 08/25/2017 06:41 AM, Keith Medcalf wrote: > >> If you search sqlite3.c for the SQLITE3_INTROSPECTION_PRAGMAS you > >will s

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

edy >Sent: Friday, 25 August, 2017 03:45 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, >function_list, module_list > >On 08/25/2017 06:41 AM, Keith Medcalf wrote: >> If you search sqlite3.c for the SQLITE3_IN

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

I applied this fix, but still get the duplicate output. RBS On Fri, Aug 25, 2017 at 10:45 AM, Dan Kennedy wrote: > On 08/25/2017 06:41 AM, Keith Medcalf wrote: > >> If you search sqlite3.c for the SQLITE3_INTROSPECTION_PRAGMAS you will >> see in pragma.c (or in

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

On 08/25/2017 06:41 AM, Keith Medcalf wrote: If you search sqlite3.c for the SQLITE3_INTROSPECTION_PRAGMAS you will see in pragma.c (or in sqlite3.c) the following code: Thanks for looking into this. Now fixed here: http://www.sqlite.org/src/info/b79cc8dc88c8ae03 Dan.

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

I removed (commented out) all the lines with sqlite3VdbeAddOp2 in that mentioned code block, so that is 4 code lines. Still I get the duplicate output. I am using the the 3.20.0 amalgation. RBS On Fri, Aug 25, 2017 at 12:41 AM, Keith Medcalf wrote: > > If you

[sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

If you search sqlite3.c for the SQLITE3_INTROSPECTION_PRAGMAS you will see in pragma.c (or in sqlite3.c) the following code: #ifdef SQLITE_INTROSPECTION_PRAGMAS case PragTyp_FUNCTION_LIST: { int i; HashElem *j; FuncDef *p; pParse->nMem = 2; for(i=0; i