#29546 [Opn->Bgs]: autoincrement does not function

ID: 29546 Updated by: tony2001@php.net Reported By: webmaster at realscripts dot de -Status: Open +Status: Bogus Bug Type: SQLite related Operating System: Linux PHP Version: 4.3.8 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. . Previous Comments: ------------------------------------------------------------------------ [2004-08-09 14:13:11] hugo at concepto dot com dot br I think this is not a bug. try: sqlite_query("INSERT INTO test_tbl VALUES (NULL, 'mark')"); or sqlite_query("INSERT INTO test_tbl (name) VALUES ('mark')"); or if it is a bug, is a SQLite bug, not a PHP bug. ------------------------------------------------------------------------ [2004-08-06 13:39:38] webmaster at realscripts dot de Description: ------------ When I have an auto_increment Integer Field in my SQLite DB and I insert data the auto_increment-field gets NULL as value. Reproduce code: --------------- CREATE TABLE test_tbl ( ID INTEGER PRIMARY KEY, name VARCHAR ); sqlite_open('test.db'); sqlite_query("INSERT INTO test_tbl VALUES ('mark')"); Expected result: ---------------- ID | name --------- 1 | mark Actual result: -------------- ID | name ----------- NULL | mark ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29546&edit=1