Menu

#316 [PHP] php driver throw memory exhausted exception when insert 10000 row in one sql statment

open
nobody
None
5
2012-10-12
2012-10-12
Jira Trac
No

[PHP] php driver throw memory exhausted exception when insert 10000 row in one sql statment
Path: php/_02_prepare/affected_rows.phpt

codes:
{noformat}
print(#####correct #####\n);
$sql2=insert into php_tb values(;
for($i = 0; $i 10000; $i++){
$sql2 = $sql2 . $i . ,.$i . ),(;
}
$sql2= $sql2 . 10000 . , . 10000 . );;
cubrid_execute($conn,$sql2);
{noformat}

result:
{noformat}
Warning: Error: DBMS, -493, Syntax: memory exhausted in /home/php/phptestcases/php/php/_02_prepare/affected_rows.php on line 17
{noformat}

When inserting 1000 rows, this issue is not exist.
In last version, this issue is not exist.

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.