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.

Reply via email to