- このトピックには6件の返信、1人の参加者があり、最後に
により10ヶ月、 1週前に更新されました。
-
投稿
-
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?
Hi @matsubara.
Version 2.18.0 (64 bit)
I downloaded it from here : https://www.vector.co.jp/soft/dl/winnt/util/se519353.htmlIs Version 2.18.0 the latest version?
If not, where can I download the latest?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.
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/
