From c7c9c72d49f7ebe349af3410ccdc4ecda616da51 Mon Sep 17 00:00:00 2001 From: Marcus Boerger Date: Sun, 18 Jan 2004 21:11:55 +0000 Subject: [PATCH] Update, id_l is unique --- ext/sqlite/tests/sqlite_oo_031.phpt | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/ext/sqlite/tests/sqlite_oo_031.phpt b/ext/sqlite/tests/sqlite_oo_031.phpt index b2c1bffaf8..84e6861654 100755 --- a/ext/sqlite/tests/sqlite_oo_031.phpt +++ b/ext/sqlite/tests/sqlite_oo_031.phpt @@ -9,7 +9,7 @@ if (!extension_loaded("spl")) print "skip SPL is not present"; query("CREATE TABLE menu(id_l int, id_r int, key VARCHAR(10))"); +$db->query("CREATE TABLE menu(id_l int PRIMARY KEY, id_r int UNIQUE, key VARCHAR(10))"); $db->query("INSERT INTO menu VALUES( 1, 12, 'A')"); $db->query("INSERT INTO menu VALUES( 2, 9, 'B')"); $db->query("INSERT INTO menu VALUES(10, 11, 'F')"); @@ -56,11 +56,11 @@ class SqliteNestedset implements RecursiveIterator protected $id_r; protected $entry; - function __construct($db, $id_l = 1, $id_r = 0) + function __construct($db, $id_l = 1) { $this->db = $db; $this->id_l = $id_l; - $this->id_r = $id_r ? $id_r : $this->db->single_query('SELECT max(id_r) FROM menu', 1); + $this->id_r = $this->db->single_query('SELECT id_r FROM menu WHERE id_l='.$id_l, 1); $this->id = $id_l; } -- 2.50.1