mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

mysql 5.7 generated columns should be ignored/removed

Open ManjotS opened this issue 8 years ago • 5 comments

I have a generated column and get this in table creation:

Error: near line 3686: near "AS": syntax error

ManjotS avatar Jan 13 '17 20:01 ManjotS

Hi @ManjotS, I'm sorry but currently I'm lacking time to investigate it by coming up with my own test cases. Could you please provide the by MySQL generated output, so that I can take a look at it?

dumblob avatar Jan 16 '17 09:01 dumblob

Error: near line 1160: near ",": syntax error Error: near line 1162: near ",": syntax error Error: near line 1164: near ",": syntax error Error: near line 1166: near ",": syntax error Error: near line 1168: near ",": syntax error Error: near line 1170: near ",": syntax error Error: near line 1172: near ",": syntax error Error: near line 1173: near ",": syntax error Error: near line 1175: near ",": syntax error Error: near line 1178: near ",": syntax error Error: near line 1181: near ",": syntax error Error: near line 1183: near ",": syntax error Error: near line 1184: near ",": syntax error

karborator avatar May 02 '17 15:05 karborator

@karborator do you have the corresponding MySQL generated output, so that I can take a look at it?

dumblob avatar May 02 '17 18:05 dumblob

I'm getting the same errors (with different line numbers)

kiwiheretic avatar Jun 28 '17 22:06 kiwiheretic

I'm getting the same errors (with different line numbers)

That's unfortunate. Could you please provide the MySQL dump which causes mysql2sqlite produce an invalid output for sqlite3?

dumblob avatar Jun 29 '17 20:06 dumblob