mysql2sqlite
mysql2sqlite copied to clipboard
mysql 5.7 generated columns should be ignored/removed
I have a generated column and get this in table creation:
Error: near line 3686: near "AS": syntax error
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?
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 do you have the corresponding MySQL generated output, so that I can take a look at it?
I'm getting the same errors (with different line numbers)
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?