You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQL> CREATE DATABASE 'test.fdb';
SQL> CONNECT 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb'
SQL> CREATE TABLE TEST_TABLE (S CHAR(256));
SQL> SET TERM ^ ;
SQL> EXECUTE BLOCK AS
CON> DECLARE N INT = 1000000;
CON> DECLARE I INT = 0;
CON> DECLARE S CHAR(256);
CON> BEGIN
CON> S ='0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345';
CON> WHILE (I < N) DO
CON> BEGIN
CON> INSERT INTO TEST_TABLE VALUES (:S);
CON> I = I + 1;
CON> END
CON> END ^
SQL> SELECT COUNT(*) from TEST_TABLE ^
Submitted by: @hvlad
SQL> CREATE DATABASE 'test.fdb';
SQL> CONNECT 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb'
SQL> CREATE TABLE TEST_TABLE (S CHAR(256));
SQL> SET TERM ^ ;
SQL> EXECUTE BLOCK AS
CON> DECLARE N INT = 1000000;
CON> DECLARE I INT = 0;
CON> DECLARE S CHAR(256);
CON> BEGIN
CON> S ='0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345';
CON> WHILE (I < N) DO
CON> BEGIN
CON> INSERT INTO TEST_TABLE VALUES (:S);
CON> I = I + 1;
CON> END
CON> END ^
SQL> SELECT COUNT(*) from TEST_TABLE ^
============
Statement failed, SQLCODE = -902
database file appears corrupt ()
-bad checksum
-checksum error on database page 447
Commits: 972926e ebb5520
The text was updated successfully, but these errors were encountered: