Timeline for SQLite3 not using covering index with json_extract expression
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 4, 2017 at 12:44 | comment | added | Deathspike | Using the JSON_EXTRACT expressions in the WHERE and/or ORDER BY statement is equivalent since I merely made an alias with the SELECT fields. Rewriting the query to use JSON_EXTRACT instead of the alias yields no different result. | |
| May 4, 2017 at 12:08 | history | answered | CL. | CC BY-SA 3.0 |