1--TEST--
2SQLite3::query SELECT with no results
3--EXTENSIONS--
4sqlite3
5--FILE--
6<?php
7
8require_once(__DIR__ . '/new_db.inc');
9define('TIMENOW', time());
10
11echo "Creating Table\n";
12var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
13
14echo "SELECTING results\n";
15$results = $db->query("SELECT * FROM test ORDER BY id ASC");
16while ($result = $results->fetchArray(SQLITE3_NUM))
17{
18    var_dump($result);
19}
20$results->finalize();
21
22echo "Closing database\n";
23var_dump($db->close());
24echo "Done\n";
25?>
26--EXPECT--
27Creating Table
28bool(true)
29SELECTING results
30Closing database
31bool(true)
32Done
33