sqLite 3.8.3+ WITH RECURSIVE queries fail

Originally reported on Google Code with ID 261

What steps will reproduce the problem?
1. Make sure you are with sqLite 3.8.3+ and appropriate PHP
2. Use Recursive query, like:

WITH RECURSIVE
cnt(x) AS (
 SELECT 1
 UNION ALL
 SELECT x+1 FROM cnt
  LIMIT 1000000
)
SELECT count() FROM cnt;

2. Effects in response:

> 0 row(s) affected. (Query took 0.6199 sec)

3. The same query in sqlite console produces:

> 1000000

What is the expected output? What do you see instead?

I expect 1 row:

> -----------
> |count()  |
> |---------|
> |1000000  |
> -----------

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?

Mine setup:
- Linux (SUSE) 3.11.10-21-desktop x86_64,
- Apache 2.4.6,
- PHP 5.6.1,
- SQLite 3.8.6,
- phpLiteAdmin v1.9.5

Please provide any additional information below.

n/a

Reported by patpater on 2014-12-04 11:28:53

<hr> * Attachment: phpLiteAdmi bug.png<br>

Comments (2)