i have two tables, one table is full text search virtual table, one table normal table, when i use group by and offsets together, it will occur not use offset in the request error.
sql like this SELECT type, subtype, entity_id, aux_index, timestamp, content, offsets(FtsIndexContact) FROM FtsMetaContact, FtsIndexContact WHERE FtsIndexContact.docid = FtsMetaContact.docid GROUP BY aux_index);
Aucun commentaire:
Enregistrer un commentaire