xref: /PHP-8.2/ext/pdo_mysql/tests/bug80908.phpt (revision b5a14e6c)
1--TEST--
2Bug #80908: pdo_mysql lastInsertId() return wrong, when table id bigger than the maximum value of int64
3--EXTENSIONS--
4pdo
5pdo_mysql
6--SKIPIF--
7<?php
8require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
9MySQLPDOTest::skip();
10?>
11--FILE--
12<?php
13require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
14
15function createDB(): PDO {
16    $db = MySQLPDOTest::factory();
17    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
18    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
19    return $db;
20}
21
22$db = createDB();
23$db->exec('DROP TABLE IF EXISTS test');
24$db->exec('CREATE TABLE test (`id` bigint(20) unsigned AUTO_INCREMENT, `name` varchar(5), primary key (`id`)) ENGINE = InnoDB AUTO_INCREMENT=10376293541461622799');
25
26function testLastInsertId(PDO $db) {
27    echo "Running test lastInsertId\n";
28    $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
29    try {
30        $db->exec("insert into test (`name`) values ('bar')");
31        $id = $db->lastInsertId();
32        echo "Last insert id is " . $id . "\n";
33    } catch (PDOException $e) {
34        echo $e->getMessage()."\n";
35    }
36}
37
38testLastInsertId($db);
39unset($db);
40echo "\n";
41
42?>
43--CLEAN--
44<?php
45require __DIR__ . '/mysql_pdo_test.inc';
46MySQLPDOTest::dropTestTable();
47?>
48--EXPECT--
49Running test lastInsertId
50Last insert id is 10376293541461622799
51