search

SylvainTI / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
0 stars 0 forks source link

sqLite 3.8.3+ WITH RECURSIVE queries fail #261

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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:

GoogleCodeExporter commented 9 years ago 
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

GoogleCodeExporter commented 9 years ago 
fixed by revsion 133ae2d4c475

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