Executing the SQL with /**/

[maria]

I have sql file with this content :
CREATE TABLE test1 (
id serial NOT NULL
, CONSTRAINT test1_PKC PRIMARY KEY (id)
) ;/*
CREATE SEQUENCE IF NOT EXISTS test_id_seq;
*/
;

CREATE TABLE test2 (
id serial NOT NULL
, CONSTRAINT test2_PKC PRIMARY KEY (id)
) ;

Using a5m2cmd, it will only create the “test1” table.
It will not create “test2” table because of the multi line comment /**/
Can you please check?

[松原正和]

Hello Maria,

I didn’t reproduce it in my environment, but A5: Which version of the SQL Mk-2 command line utility are you using?

[maria]

Hi @matsubara.

Version 2.18.0 (64 bit)
I downloaded it from here : https://www.vector.co.jp/soft/dl/winnt/util/se519353.html

[maria]

@matsubara

Is Version 2.18.0 the latest version?
If not, where can I download the latest?

[maria]

@matsubara

I’m using this command to execute the sql :

A5M2cmd.exe “/Connect=__ConnectionType=Internal;ProviderName=PostgreSQL;UserName=%USER_NAME%;Password=%PASSWORD%;ServerName=%SERVER_NAME%;Port=%PORT%;Database=%DATABASE%;ProtocolVersion=30” /RunSQL /Encoding=UTF-8 “/FileName=%OUT_FILENAME%”

Thank you.

[maria]

It will print the “No SQL statement provided” if it the sql has multi line comment

[松原正和]

Hello Maria,
　
Depending on your database, using empty SQL may cause an error.
　
I fixed it in version 2.18.3 beta 1, so please try it.
　
https://a5m2.mmatsubara.com/beta/

[投稿者]

投稿