Re: Is Comment column in 'EXPLAIN' blank?
David Raymond <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1PR07MB60298C06AE49BE40A008D58A87070@VI1PR07MB6029.eurprd07.prod.outlook.com> |
To get the comments the library needs to have been compiled with SQLITE_ENABLE_EXPLAIN_COMMENTS flag https://www.sqlite.org/compile.html#_options_to_enable_features_normally_turned_off That setting is off by default, but for the pre-compiled CLI they do include it. I'm not seeing it in the list when I do a "pragma compile_options;" though. Is that setting one that's not reported by that pragma? -----Original Message----- From: sqlite-users <[email protected]> On Behalf Of x Sent: Friday, January 31, 2020 6:22 AM To: [email protected] Subject: [sqlite] Is Comment column in 'EXPLAIN' blank? I get the comments using the shell but running an explain query in c++ using sqlite3.c (from 3.30 amalgamation) column 7 is returning blank in every row. Is something up or is it my code? _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users