Ok I looked at the source sqlite3.c and saw that :
This is my correction :
int vt_best_index(sqlite3_vtab *p_svt, sqlite3_index_info *p_info){
sVTAB* p_vt = (sVTAB*)p_svt;
int i;
int j=1;
printf("vt_best_index %d\n", p_info->nConstraint);
p_info->idxNum=0;
if(p_info->nConstraint!=0){
p_info->idxNum=p_info->aConstraint[0].iColumn;
p_info->idxStr=p_vt->acNameTab;
printf("best index constraint column %d\n", p_info->aConstraint[0].iColumn);
for(i=0;i<p_info->nConstraint;i++){
*if(p_info->aConstraint[i].usable){*
p_info->aConstraintUsage[i].argvIndex=j++;
}
}
}
if(p_info->nOrderBy==0){
p_info->aOrderBy=NULL;
}
return SQLITE_OK;
}
Thx every one ! And Keith Medcalf ... you should use your time better !
Micka,
On Fri, Jul 4, 2014 at 9:49 AM, Micka <[email protected]> wrote:
> I've no word for this ! .....
>
>
> On Fri, Jul 4, 2014 at 9:46 AM, Keith Medcalf <[email protected]> wrote:
>
>>
>> The spacing and indentation are atrocious?
>>
>> >-----Original Message-----
>> >From: [email protected] [mailto:sqlite-users-
>> >[email protected]] On Behalf Of Micka
>> >Sent: Friday, 4 July, 2014 01:29
>> >To: General Discussion of SQLite Database
>> >Subject: [sqlite] Error xBestIndex returned an invalid plan
>> >
>> >Hi, I wanted to know what could be wrong with :
>> >
>> >int vt_best_index(sqlite3_vtab *p_svt, sqlite3_index_info *p_info){
>> >sVTAB* p_vt = (sVTAB*)p_svt;
>> >int i;
>> >printf("vt_best_index %d\n", p_info->nConstraint);
>> >
>> >p_info->idxNum=0;
>> >
>> >if(p_info->nConstraint!=0){
>> >p_info->idxNum=p_info->aConstraint[0].iColumn;
>> >p_info->idxStr=p_vt->acNameTab;
>> >printf("best index constraint column %d\n", p_info-
>> >>aConstraint[0].iColumn);
>> >for(i=0;i<p_info->nConstraint;i++){
>> >p_info->aConstraintUsage[i].argvIndex=(1+i);
>> >}
>> >}
>> >if(p_info->nOrderBy==0){
>> >p_info->aOrderBy=NULL;
>> >}
>> >return SQLITE_OK;
>> >}
>> >
>> >thx you very much ^^
>> >_______________________________________________
>> >sqlite-users mailing list
>> >[email protected]
>> >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
