Re: [h2] H2 Procedural SQL language efforts

[Noel Grandin]

I don't see the point. We have a perfectly good language already (Java),
and even a built-in compiler for it.

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/CAFYHVnUYY01aUTVHEXVToVuqjS1kMBsDL02LTXKhmiuDoGBuKw%40mail.gmail.com.

[h2] Re: ALTER TABLE "table-name" MODIFY "columne" NOT NULL; fail with Unknown data type: "NOT";

[Sarkkuli]

I struggled with the same issue for a while, and want to give my notes for 
this topic. I also tried format ALTER TABLE "table-name" MODIFY 
"column-name" NULL, which resulted in "Unknown data type: 'NOT'". It seems 
that h2 is expecting a column type in the MODIFY statement, although the 
column type is already modified from before, during CREATE TABLE. The 
following modification fixed the issue:

ALTER TABLE "table-name" MODIFY "column-name" varchar(128) NULL;

On Tuesday, August 29, 2017 at 4:34:25 PM UTC+3 Sam Blume wrote:

> 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   
> 
> TYPE   
> 
> NULL   
> 
> KEY   
> 
> DEFAULT   
> 
> 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   
> 
> TYPE   
> 
> NULL   
> 
> KEY   
> 
> DEFAULT   
> 
> 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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/22ed6d69-6c3e-47a7-831c-82a793e94e7fn%40googlegroups.com.

[h2] H2 Procedural SQL language efforts

[Alexandr Klimov]

Hi all,

Could someone tell me please is there any efforts about implementing 
Procedural SQL Language functionality?
Maybe some roadmap exists somewhere about it?

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/c44f3e60-1a69-4384-b225-4dc2327ffca5n%40googlegroups.com.