X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=tests%2Fmysql2sql%2Ftest.out3;fp=tests%2Fmysql2sql%2Ftest.out3;h=462e2be5337baa16f67442ba48d8dd5337e56275;hp=0000000000000000000000000000000000000000;hb=1526d94cfa10aa68de1330b1c24ef0d99f8b2b0d;hpb=b000a48daf78ac2a4c09adfc7bf44fd919764bd6

diff --git a/tests/mysql2sql/test.out3 b/tests/mysql2sql/test.out3
new file mode 100644
index 0000000..462e2be
--- /dev/null
+++ b/tests/mysql2sql/test.out3
@@ -0,0 +1,20 @@
+CREATE TABLE mytable (
+  id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  flag tinyint(4) NOT NULL DEFAULT '0',
+  PRIMARY KEY (id),
+  UNIQUE KEY date (date)
+) ENGINE="InnoDB" DEFAULT CHARSET=utf8;
+INSERT INTO /* inline comment */ mytable VALUES (1, 'тест');
+SELECT * FROM mytable; -- line-comment"
+
+;
+INSERT INTO "MyTable" ("Id", "Name")
+VALUES (1, 'one');
+INSERT INTO mytable VALUES (1, 'one');
+
+INSERT INTO mytable VALUES (2, 'two');
+INSERT INTO mytable (id, name) VALUES (1, 'one');
+
+INSERT INTO mytable (id, name) VALUES (2, 'two');
+-- The end