sqLite 3.8.3+ WITH RECURSIVE queries fail
Issue #261
resolved
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)
-
-
fixed by revsion 133ae2d4c475
Reported by
crazy4chrissi
on 2014-12-26 23:07:12 - Log in to comment
Reported by
crazy4chrissi
on 2014-12-26 23:06:15 - Status changed:Fixed
- Labels added: Target-1.9.6