Tables without rowid, no rows are found/shown

Originally reported on Google Code with ID 240

What steps will reproduce the problem?
1. Create a table without rowid (an optimization which is available with sqlite 2.8.3
and later), eg
[public_html]$ sqlite3 without_rowid.db
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table with_rowid (c1, c2);
sqlite> create table without_rowid (p1 primary key, c2) without rowid;
sqlite> insert into with_rowid values (1, 2);
sqlite> insert into without_rowid values (3, 4);
sqlite> select * from with_rowid;
1|2
sqlite> select * from without_rowid;
3|4
2. Open the db in browser with phpliteadmin, both tables "with_rowid" and "without_rowid"
are found
3. Select table "with_rowid" and one row is shown, now select table "without_rowid"

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

Again one row should be displayed, but instead no row is found

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

Fedora 20, phpLiteAdmin v1.9.4.1, SQLite version 3.8.2 2013-12-06

Please provide any additional information below.

The "WITHOUT ROWID" optimization is documented at https://www.sqlite.org/withoutrowid.html

Reported by StephanB007 on 2013-12-30 19:36:34

Comments (5)