mysql2sqlite
mysql2sqlite copied to clipboard
Fix mysql current_timestamp() to be current_timestamp.
Hi @rldleblanc I've checked it (I didn't know, that MySQL allows both variants - with parentheses and without) and it seems to work.
Could you please also add a skeleton of a test SQL code and a resulting conversion to unit_tests.sh? Just something along the lines:
cat <<\SQLin
CREATE TABLE "map" (
"ID" int(10) NOT NULL,
"f" int(11) NOT NULL,
"direct" bit(1) NOT NULL DEFAULT 1,
"t" int(11) NOT NULL
);
insert into "map" ("ID", "f", "t") values (5, 6, 7);
insert into "map" ("ID", "f", "direct", "t") values (55, 66, 99, 77);
SQLin
cat <<SQLout
...
SQLout