Artifact b4192749c60613182b928584ae839bb12ea74bf4:

• File sql/q-sqlite-compile-opt.sql — part of check-in [64c47b71d0] at 2014-03-01 20:34:41 on branch trunk — minor query tweak. (user: stephan size: 481)

-- Posted by Petite Abeille to the sqlite-users mailing list:
-- fetch all compile options used for this version of sqlite3:
with
Option( name, position )
as
(
  select  sqlite_compileoption_get( 1 ) as name,
          0 as position

  union all
  select  sqlite_compileoption_get( position + 1 ) as name,
          position + 1 as position
  from    Option
  where   sqlite_compileoption_get( position + 1 ) is not null
)
select    DISTINCT name
from      Option
order by  name
;