mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

SynDb Explorer - WITH statement example from the official SQLite site

Arnaud,

This example, copied from http://sqlite.org/lang_with.html , when being run with syndb explorer, no results returned.

WITH RECURSIVE
  cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000)
SELECT x FROM cnt;

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: SynDb Explorer - WITH statement example from the official SQLite site

Should be fixed by http://synopse.info/fossil/info/1dabdf9a807a7

Thanks for the report.