mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Fix mysql current_timestamp() to be current_timestamp.

Open rldleblanc opened this issue 7 years ago • 1 comments

Signed-off-by: Robert LeBlanc [email protected]

rldleblanc avatar Sep 06 '18 23:09 rldleblanc

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

dumblob avatar Sep 07 '18 05:09 dumblob