We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: vander clock stephane (arkadia)
CREATE DATABASE 'c:\test_utf8.fdb' USER 'sysdba' PASSWORD 'masterkey' PAGE_SIZE 4096 DEFAULT CHARACTER SET UTF8;
CREATE TABLE TEST_A( ID VARCHAR(32) NOT NULL, DATA1 VARCHAR(5000), DATA2 VARCHAR(5000), DATA3 VARCHAR(5000), DATA4 VARCHAR(5000), DATA6 VARCHAR(5000), DATA10 VARCHAR(5000), PRIMARY KEY (ID) );
=> ERROR new record size is too big (that ok)
but now
CREATE TABLE TEST_A( ID VARCHAR(32) NOT NULL, PRIMARY KEY (ID) );
=> ERROR cannot create index RDB$PRIMARY2 !
The text was updated successfully, but these errors were encountered:
Commented by: @AlexPeshkoff
Did not reproduce, at least in B2_5_Release:
SQL> CREATE DATABASE 'test_utf8.fdb' CON> PAGE_SIZE 4096 CON> DEFAULT CHARACTER SET UTF8; SQL> CREATE TABLE TEST_A( CON> ID VARCHAR(32) NOT NULL, CON> DATA1 VARCHAR(5000), CON> DATA2 VARCHAR(5000), CON> DATA3 VARCHAR(5000), CON> DATA4 VARCHAR(5000), CON> DATA6 VARCHAR(5000), CON> DATA10 VARCHAR(5000), CON> PRIMARY KEY (ID) CON> ); Statement failed, SQLSTATE = 54000 unsuccessful metadata update -new record size of 120146 bytes is too big -TABLE TEST_A SQL> CREATE TABLE TEST_A( CON> ID VARCHAR(32) NOT NULL, CON> PRIMARY KEY (ID) CON> ); SQL>
Sorry, something went wrong.
Commented by: @dyemanov
I suspect the error happens in the SET AUTODDL OFF mode.
No branches or pull requests
Submitted by: vander clock stephane (arkadia)
CREATE DATABASE 'c:\test_utf8.fdb'
USER 'sysdba'
PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UTF8;
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
DATA1 VARCHAR(5000),
DATA2 VARCHAR(5000),
DATA3 VARCHAR(5000),
DATA4 VARCHAR(5000),
DATA6 VARCHAR(5000),
DATA10 VARCHAR(5000),
PRIMARY KEY (ID)
);
=> ERROR new record size is too big (that ok)
but now
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
PRIMARY KEY (ID)
);
=> ERROR cannot create index RDB$PRIMARY2 !
The text was updated successfully, but these errors were encountered: