CREATE TABLE "roundtrip"
"pk" INTEGER NOT NULL,
PRIMARY KEY ("pk")
) to create a new table named roundtrip. Then I read the metadata of this table so as to check whether or not this table was correctly built as expected. However, I've got the following error:
"Required status not the same for column pk. expected: but was:."
SQL Syntax which you provide describes that "Column can store null values, so that constraint NOT NULL is ignored."
I would ask you how this problem can be solved?
As the error message included angle brackets, this message is not correctly displayed. I paste it again:
Required status not the same for column pk. expected:<true> but was::<false>
>SQL Syntax which you provide describes that "Column can store null values, so that
> constraint NOT NULL is ignored."
>I would ask you how this problem can be solved?
>PRIMARY KEY ("pk")
You have assigned it as primary key, so that it's impossible to store more than one null value for pk.
According to JDBC specification, IS_NULLABLE is defined as follows:
NO means the column definitely does not allow NULL values;
YES means the column might allow NULL values. An empty
string means nullability is unknown.