A loop of CREATE TABLE, CREATE INDEX, DROP TABLE execution will cause
unsuccessful metadata update at loop point of 32640
--------------------------------------------------------------------------------------------------------------------------
Key: CORE-5370
URL: http://tracker.firebirdsql.org/browse/CORE-5370
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.1, 2.5.6
Environment: Windows 10
Reporter: Chau Chee Yang
I encounter an "Unsuccessful metadata update. Cannot create index ...." error
in a series of queries. This happen to Firebird 2.5.6 and 3.0.1.
Here are the steps to reproduce:
1. Connect to Firebird server via TCP (e.g.: localhost/3050)
2. Create a new database
3. Open the new database
4. Perform 50000 loop on the following queries:
for n := 1 to 50000 do begin
"CREATE GLOBAL TEMPORARY TABLE T_n ("CODE" VARCHAR(10)) ON COMMIT
PRESERVE ROWS"
"CREATE INDEX IX_n ON T_n (CODE)"
"DROP TABLE T_n"
end;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
