Uff, I must restate my last entry: ALTER TABLE "table-name" MODIFY
"columne-name" NULL causes an odd modification.
It changes the colume type to NULL(0) (never heard of that type)
To reporduce, do this:
CREATE TABLE FOO (
A VARCHAR2(50) NOT NULL,
B VARCHAR2(50) NOT NULL
);
show columns from FOO;
-- You will see:
FIELD
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
TYPE
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
NULL
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
KEY
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
DEFAULT
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
A VARCHAR(50) NO *null* NULL
B VARCHAR(50) NO *null* NULL
-- Now use the Alter table with NULL
ALTER TABLE FOO MODIFY A NULL;
show columns from FOO;
-- Columne 'A' is now of TYPE NULL(0)
FIELD
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
TYPE
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
NULL
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
KEY
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
DEFAULT
<http://159.103.98.191:8082/query.do?jsessionid=2388ee30a976dea49f8821b055c3b1b6#>
A NULL(0) NO *null* NULL
B VARCHAR(50) NO *null* NULL
Am Dienstag, 29. August 2017 14:21:23 UTC+2 schrieb Sam Blume:
>
> Version: h2-1.4.196
>
> ALTER TABLE "table-name" MODIFY "columne-name" NOT NULL; fails with
> Unknown data type: "NOT";
>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.