From: webmaster at realscripts dot de Operating system: Linux PHP version: 4.3.8 PHP Bug Type: SQLite related Bug description: autoincrement does not function
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 bug report at http://bugs.php.net/?id=29546&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29546&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29546&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29546&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29546&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29546&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29546&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29546&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29546&r=support Expected behavior: http://bugs.php.net/fix.php?id=29546&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29546&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29546&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29546&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29546&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29546&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29546&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29546&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29546&r=float