The spacing and indentation are atrocious? >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] 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 >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
