sqLite 3.8.3+ WITH RECURSIVE queries fail

[GoogleCodeExporter]

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

Original issue reported on code.google.com by patpa...@gmail.com on 4 Dec 2014 at 11:28

Attachments:

• [phpLiteAdmi bug.png](https://storage.googleapis.com/google-code-attachments/phpliteadmin/issue-261/comment-0/phpLiteAdmi bug.png)

[GoogleCodeExporter]

Thanks for the report. I was able to reproduce the issue with sqlite 3.8.6.

I fixed it in git, it will be in the next version.

Original comment by crazy4ch...@gmail.com on 26 Dec 2014 at 11:06

• Changed state: Fixed
• Added labels: Target-1.9.6

[GoogleCodeExporter]

fixed by revsion 133ae2d4c475

Original comment by crazy4ch...@gmail.com on 26 Dec 2014 at 11:07