00:35:37 [ERR][ Workbench]: Console redirection failed. 00:35:37 [INF][ Workbench]: Starting up Workbench 00:35:37 [INF][ Workbench]: Current environment: Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.2.9200.0 SystemDirectory: C:\WINDOWS\system32 TickCount: 578192515 UserInteractive: True Version: 4.0.30319.42000 WorkingSet: 41357312 00:35:37 [INF][ Workbench]: Environment variables: SystemDrive = C: ProgramFiles(x86) = C:\Program Files (x86) ProgramW6432 = C:\Program Files PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 60 Stepping 3, GenuineIntel TMP = C:\Users\mklnt\AppData\Local\Temp ALLUSERSPROFILE = C:\ProgramData Path = C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\app\Oracle\product\12.2.0\dbhome_1\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\MATLAB\R2017a\bin;C:\Program Files (x86)\PharosSystems\Core;C:\Program Files\Java\jdk1.8.0_144\bin\;C:\Users\mklnt\AppData\Local\antlr;C:\Program Files\Git\cmd;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Server 8.0\bin\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\mklnt\AppData\Local\GitHubDesktop\bin;C:\Users\mklnt\Documents\6 Code\qiskit;C:\Users\mklnt\Documents\6 Code\cirq;C:\Users\mklnt\AppData\Local\Microsoft\WindowsApps;C:\Program Files\MySQL\MySQL Server 8.0\bin; PROCESSOR_REVISION = 3c03 TEMP = C:\Users\mklnt\AppData\Local\Temp USERPROFILE = C:\Users\mklnt CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files LOGONSERVER = \\DESKTOP-6JJQBVR USERNAME = mklnt SystemRoot = C:\WINDOWS OneDrive = C:\Users\mklnt\OneDrive PROCESSOR_ARCHITECTURE = AMD64 CommonProgramFiles = C:\Program Files\Common Files ProgramData = C:\ProgramData HOMEPATH = \Users\mklnt OneDriveConsumer = C:\Users\mklnt\OneDrive COMPUTERNAME = DESKTOP-6JJQBVR M2_HOME = C:\Program Files (x86)\Apache\apache-maven-3.5.3 CommonProgramW6432 = C:\Program Files\Common Files MAVEN_HOME = C:\Program Files (x86)\Apache\apache-maven-3.5.3 SESSIONNAME = Console VS150COMCOMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\Tools\ DriverData = C:\Windows\System32\Drivers\DriverData HOMEDRIVE = C: windir = C:\WINDOWS CLASSPATH = C:\Program Files\MySQL\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44-bin.jar;C:\Users\mklnt\Install\lucene-7.1.0\core\lucene-core-7.1.0.jar;C:\Users\mklnt\Install\lucene-7.1.0\lucene-queryparser-7.1.0.jar;C:\Users\mklnt\Install\lucene-7.1.0\analysis\common\lucene-analyzers-common-7.1.0.jar;C:\Users\mklnt\Install\lucene-7.1.0\demo\lucene-demo-7.1.0.jar;C:\Users\mklnt\Install\openjava.jar;C:\Users\mklnt\Install\mujava.jar;C:\Program Files\Java\jdk1.8.0_144\lib\tools.jar;C:\Users\mklnt\Install\hamcrest.jar;C:\Users\mklnt\.m2\repository\junit\4.12\junit-4.12.jar;C:\Users\mklnt\.p2\pool\plugins\org.junit_4.12.0.v201504281640\junit.jar;C:\Users\mklnt\Install\lucene.jar;C:\Users\mklnt\Install\JFLAP_Thin.jar;C:\Users\mklnt\AppData\Local\antlr\antlr-4.4-complete.jar;.; NUMBER_OF_PROCESSORS = 4 OS = Windows_NT ProgramFiles = C:\Program Files ComSpec = C:\WINDOWS\system32\cmd.exe PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC JAVA_HOME = C:\Program Files\Java\jdk1.8.0_144 PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules APPDATA = C:\Users\mklnt\AppData\Roaming USERDOMAIN = DESKTOP-6JJQBVR PROCESSOR_LEVEL = 6 ANT_HOME = C:\Users\mklnt\ant\apache-ant-1.10.1 LOCALAPPDATA = C:\Users\mklnt\AppData\Local USERDOMAIN_ROAMINGPROFILE = DESKTOP-6JJQBVR PUBLIC = C:\Users\Public 00:35:37 [INF][ Workbench]: Current version given by meta info is: 8.0.16 00:35:37 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\app\Oracle\product\12.2.0\dbhome_1\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\MATLAB\R2017a\bin;C:\Program Files (x86)\PharosSystems\Core;C:\Program Files\Java\jdk1.8.0_144\bin\;C:\Users\mklnt\AppData\Local\antlr;C:\Program Files\Git\cmd;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Server 8.0\bin\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\mklnt\AppData\Local\GitHubDesktop\bin;C:\Users\mklnt\Documents\6 Code\qiskit;C:\Users\mklnt\Documents\6 Code\cirq;C:\Users\mklnt\AppData\Local\Microsoft\WindowsApps;C:\Program Files\MySQL\MySQL Server 8.0\bin; 00:35:37 [INF][ mforms managed]: Initializing mforms wrapper 00:35:38 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE struct path: module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE user data dir: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 00:35:38 [INF][ WBContext]: WbContext::init 00:35:39 [INF][ WBA]: Looking for extension modules for WBA... 00:35:39 [INF][ WBA]: 0 extension modules found 00:35:39 [WRN][ grt]: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{BDD969E7-2BC4-4C92-87A6-A2E27349A787}' key=owner could not be resolved 00:35:39 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 8.0.16 CE build 14498383 (64 bit) Configuration Directory: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE Cairo Version: 1.10.2 OS: Microsoft Windows 10 Home CPU: 4x Intel(R) Core(TM) i7-4610M CPU @ 3.00GHz, 7.9 GiB RAM Active video adapter Intel(R) HD Graphics 4600 Installed video RAM: 1024 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 20.19.15.5063 Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igd12umd64.dll Current user language: English (United States) 00:35:39 [INF][ Workbench]: UI is up 00:35:39 [INF][ Workbench]: Running the application 00:35:44 [INF][SQL Editor Form]: Opened connection 'MLASDBA' to MySQL Community Server - GPL version 8.0.16 00:35:45 [INF][ WQE.net]: Launching SQL IDE 00:35:48 [INF][ WQE.net]: SQL IDE UI is ready 00:36:06 [ERR][ sqlide-history]: Can't parse select qpairid, matchyn, match (q1text) against ( 'How many times a day do a clock’s hands overlap?'in natural language mode) as score from qpair where qpairid=24, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND Tournaments.TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT COUNT(Customers.CustomerID) FROM Customers LEFT JOIN Musical_Preferences ON (Customers.CustomerID = Musical_Preferences.CustomerID) LEFT JOIN Musical_Styles ON (Musical_Preferences.StyleID = Musical_Styles.StyleID) WHERE StyleName = ‘Jazz’ OR StyleName = ‘Salsa’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse insert into Airport (AirportAbbrev, AirportName, CityName, CountyName, State, Country) values ('ATL', 'Hartsfield–Jackson Atlanta International Airport', 'Atlanta', 'Fulton', 'GA', 'USA'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport ( AirportAbbrev, AirportName, CityName, CountyName, State, Country ) VALUES ( 'ATL', 'Hartsfield–Jackson Atlanta International Airport', 'Atlanta', 'Clayton', 'GA', 'United States'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport ( AirportAbbrev, AirportName, CityName, CountyName, State, Country ) VALUES ( 'MSP', 'Minneapolis–Saint Paul International Airport', 'Minneapolis', 'Hennepin', 'MN', 'United States'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport (AirportAbbrev, AirportName, CityName, CountyName, State, Country) VALUES ('ORD', 'Chicago O’Hare International', 'Chicago', 'IL', 'IL', 'US'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ FROM entertainers ent JOIN engagements eng ON ent.EntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” >1, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ FROM entertainers ent JOIN engagements eng ON ent.EntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” >1, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'acirc' not defined 00:36:06 [ERR][ XML Functions]: LibXml: airid, matchyn, match (q1text) against ( 'How many times a day do a clockâ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'euro' not defined 00:36:06 [ERR][ XML Functions]: LibXml: matchyn, match (q1text) against ( 'How many times a day do a clock†00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'trade' not defined 00:36:06 [ERR][ XML Functions]: LibXml: n, match (q1text) against ( 'How many times a day do a clock’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse select qpairid, matchyn, match (q1text) against ( 'How many times a day do a clock’s hands overlap?'in natural language mode) as score from qpair where qpairid=24, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: urneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: urneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: es.TourneyID) WHERE WonGame = 1 AND Tournaments.TourneyDate = ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: 0A;WHERE WonGame = 1 AND Tournaments.TourneyDate = ‘2012-09-11’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT SUM(RawScore) FROM Bowler_Scores LEFT JOIN Tourney_Matches ON (Bowler_Scores.MatchID = Tourney_Matches.MatchID) LEFT JOIN Tournaments ON (Tournaments.TourneyID = Tourney_Matches.TourneyID) WHERE WonGame = 1 AND Tournaments.TourneyDate = ‘2012-09-11’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: cal_Preferences.StyleID = Musical_Styles.StyleID) WHERE StyleName = ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: nces.StyleID = Musical_Styles.StyleID) WHERE StyleName = ‘Jazz’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: s.StyleID) WHERE StyleName = ‘Jazz’ OR StyleName = ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: x0A;WHERE StyleName = ‘Jazz’ OR StyleName = ‘Salsa’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT COUNT(Customers.CustomerID) FROM Customers LEFT JOIN Musical_Preferences ON (Customers.CustomerID = Musical_Preferences.CustomerID) LEFT JOIN Musical_Styles ON (Musical_Preferences.StyleID = Musical_Styles.StyleID) WHERE StyleName = ‘Jazz’ OR StyleName = ‘Salsa’, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'ndash' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ortName, CityName, CountyName, State, Country) values ('ATL', 'Hartsfield– 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse insert into Airport (AirportAbbrev, AirportName, CityName, CountyName, State, Country) values ('ATL', 'Hartsfield–Jackson Atlanta International Airport', 'Atlanta', 'Fulton', 'GA', 'USA'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'ndash' not defined 00:36:06 [ERR][ XML Functions]: LibXml: CityName, CountyName, State, Country ) VALUES ( 'ATL', 'Hartsfield– 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport ( AirportAbbrev, AirportName, CityName, CountyName, State, Country ) VALUES ( 'ATL', 'Hartsfield–Jackson Atlanta International Airport', 'Atlanta', 'Clayton', 'GA', 'United States'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'ndash' not defined 00:36:06 [ERR][ XML Functions]: LibXml: CityName, CountyName, State, Country ) VALUES ( 'MSP', 'Minneapolis– 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport ( AirportAbbrev, AirportName, CityName, CountyName, State, Country ) VALUES ( 'MSP', 'Minneapolis–Saint Paul International Airport', 'Minneapolis', 'Hennepin', 'MN', 'United States'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: CityName, CountyName, State, Country) VALUES ('ORD', 'Chicago O’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse INSERT INTO Airport (AirportAbbrev, AirportName, CityName, CountyName, State, Country) VALUES ('ORD', 'Chicago O’Hare International', 'Chicago', 'IL', 'IL', 'US'), of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: SELECT eng.StartDate ‘Perf. Date’, COUNT 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: SELECT eng.StartDate ‘Perf. Date’, COUNT 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: stamp='17:49:56'>SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'ldquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rdquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ FROM entertainers ent JOIN engagements eng ON ent.EntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” >1, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: SELECT eng.StartDate ‘Perf. Date’, COUNT 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: SELECT eng.StartDate ‘Perf. Date’, COUNT 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'lsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: stamp='17:54:26'>SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rsquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'ldquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “ 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ XML Functions]: LibXml: Entity: line 1: 00:36:06 [ERR][ XML Functions]: LibXml: parser 00:36:06 [ERR][ XML Functions]: LibXml: error : 00:36:06 [ERR][ XML Functions]: LibXml: Entity 'rdquo' not defined 00:36:06 [ERR][ XML Functions]: LibXml: ntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” 00:36:06 [ERR][ XML Functions]: LibXml: ^ 00:36:06 [ERR][ sqlide-history]: Can't parse SELECT eng.StartDate ‘Perf. Date’, COUNT(*) ‘No. of Perf’ FROM entertainers ent JOIN engagements eng ON ent.EntertainerID=eng.EntertainerID GROUP BY eng.StartDate HAVING “No. of Perf” >1, of file: C:\Users\mklnt\AppData\Roaming\MySQL\Workbench\sql_history\2017-09-10 08:07:32 [WRN][SQL Editor Form]: 39802 row(s) affected, 1 warning(s): 1105 ORDER BY ignored as there is a user-defined clustered index in the table 'time_zone_transition' Records: 39802 Duplicates: 0 Warnings: 1 08:07:32 [WRN][SQL Editor Form]: 3182 row(s) affected, 1 warning(s): 1105 ORDER BY ignored as there is a user-defined clustered index in the table 'time_zone_transition_type' Records: 3182 Duplicates: 0 Warnings: 1 09:21:46 [ERR][SQL Editor Form]: Error Code: 1298. Unknown or incorrect time zone: 'America/Bliss' 09:52:20 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 71 11:57:51 [ERR][SqlEditorSchemaTree]: Exception retrieving node description : Type mismatch: expected type string, but got 11:58:59 [ERR][SQL Editor Form]: 12:04:08 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:04:17 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:04:26 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:04:30 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:35:36 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: CREATE DEFINER=`MLDBA`@`localhost` FUNCTION `date_2DYear`(dateIn DATE) RETURNS varchar(50) CHARSET utf8mb4 DETERMINISTIC BEGIN DECLARE Retval VARCHAR(50) Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END_OF_INPUT, expecting ';' 12:35:36 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: RETURN Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected RETURN_SYM 12:35:36 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: END Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END 12:51:51 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:51:52 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:51:57 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:51:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:01 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:07 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:11 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:11 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:52:16 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 12:53:26 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object 12:57:01 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 13:56:07 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database. 13:56:07 [ERR][ GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database. 13:56:40 [ERR][SQL Editor Form]: Error 1582: Incorrect parameter count in the call to native function 'date_format' SQL Statement: CREATE FUNCTION `ordinal_date` (dateIn DATE) RETURNS VARCHAR(50) BEGIN DECLARE Retval VARCHAR(50); select concat( date_format(dateIn, '%W, the '), case when date_format(dateIn) = '1' then 'first' when date_format(dateIn) = '2' then 'second' when date_format(dateIn) ='3' then 'third' when date_format(dateIn) = '4' then 'fourth' when date_format(dateIn)='5' then 'fifth' when date_format(dateIn) = '6' then 'sixth' when date_format(dateIn)='7' then 'seventh' when date_format(dateIn) = '8' then 'eighth' when date_format(dateIn)='9' then 'ninth' when date_format(dateIn) = '10' then 'tenth' when date_format(dateIn)='11' then 'eleventh' when date_format(dateIn) = '12' then 'twelfth' when date_format(dateIn)='13' then 'thirteenth' when date_format(dateIn) = '14' then 'foureenthth' when date_format(dateIn)='15' then 'fifteenth' when date_format(dateIn) = '16' then 'sixteenth' when date_format(dateIn)='17' then 'seventeenth' when date_format(dateIn) = '18' then 'eighteenth' when date_format(dateIn)='19' then 'nineteenth' when date_format(dateIn) = '20' then 'twentieth' when date_format(dateIn) = '21' then 'twenty-first' when date_format(dateIn) = '22' then 'twenty-second' when date_format(dateIn)='23' then 'twenty-third' when date_format(dateIn) = '24' then 'twenty-fourth' when date_format(dateIn)='25' then 'twenty-fifth' when date_format(dateIn) = '26' then 'twemty-sixth' when date_format(dateIn)='27' then 'twenty-seventh' when date_format(dateIn) = '28' then 'twenty-eighth' when date_format(dateIn)='29' then 'twenty-ninth' when date_format(dateIn) = '30' then 'thirtieth' when date_format(dateIn)='31' then 'thirty-first' else 'INTERNAL ERROR day number error' end , date_format(dateIn,' of %M') ) INTO Retval ; RETURN Retval; END 14:03:56 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 14:09:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:09:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:09:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:09:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:09:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:29 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:30 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:31 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:31 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:32 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:32 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:10:33 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:20:20 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: CREATE FUNCTION `date_3DYear` (dateIn DATE) RETURNS VARCHAR(50) DETERMINISTIC BEGIN DECLARE Retval VARCHAR(50) Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END_OF_INPUT, expecting ';' 14:20:20 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: select concat( case when substr(date_format(dateIn,'%Y'),2,1)='1' then 'One-hundred' when substr(date_format(dateIn,'%Y'),2,1)='2' then 'Two-hundred' when substr(date_format(dateIn,'%Y'),2,1)='3' then 'Three-hundred' when substr(date_format(dateIn,'%Y'),2,1)='4' then 'Four-hundred' when substr(date_format(dateIn,'%Y'),2,1)='5' then 'Five-hundred' when substr(date_format(dateIn,'%Y'),2,1)='6' then 'Six-hundred' when substr(date_format(dateIn,'%Y'),2,1)='7' then 'Seven-hundred' when substr(date_format(dateIn,'%Y'),2,1)='8' then 'Eight-hundred' when substr(date_format(dateIn,'%Y'),2,1)='9' then 'Nine-hundred' else 'INTERNAL ERROR-Hundreds digit of year malformed' end, case when substr(date_format(dateIn,'%Y'),3,2)='00' then 'th' when substr(date_format(dateIn,'%Y'),3,1)='0' then concat('-',lower(date_1DYear(dateIn))) else concat('-',lower(date_2DYear(dateIn)) end ) INTO Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected INTO, expecting END 14:20:20 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: RETURN Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected RETURN_SYM 14:20:20 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: END Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END 14:22:45 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: CREATE FUNCTION `date_3DYear` (dateIn DATE) RETURNS VARCHAR(50) DETERMINISTIC BEGIN DECLARE Retval VARCHAR(50) Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END_OF_INPUT, expecting ';' 14:22:45 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: RETURN Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected RETURN_SYM 14:22:45 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: END Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END 14:25:27 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: CREATE FUNCTION `date_3DYear` (dateIn DATE) RETURNS VARCHAR(50) DETERMINISTIC BEGIN DECLARE Retval VARCHAR(50) Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END_OF_INPUT, expecting ';' 14:25:27 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: SELECT CONCAT(CASE WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '1' THEN 'One-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '2' THEN 'Two-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '3' THEN 'Three-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '4' THEN 'Four-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '5' THEN 'Five-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '6' THEN 'Six-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '7' THEN 'Seven-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '8' THEN 'Eight-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '9' THEN 'Nine-hundred' ELSE 'INTERNAL ERROR-Hundreds digit of year malformed' END, case when substr(date_format(dateIn,'%Y'),3,2)='00' then 'th' when substr(date_format(dateIn,'%Y'),3,1)='0' then concat('-',lower(date_1DYear(dateIn))) else concat'-',lower(date_2DYear(dateIn))) end INTO Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected TEXT_STRING, expecting END 14:25:27 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: RETURN Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected RETURN_SYM 14:25:27 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: END Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END 14:25:51 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: case when substr(date_format(dateIn,'%Y'),3,2)='00' then 'th' when substr(date_format(dateIn,'%Y'),3,1)='0' then concat('-',lower(date_1DYear(dateIn))) else concat'-',lower(date_2DYear(dateIn))) end Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected CASE_SYM 14:26:35 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: CREATE FUNCTION `date_3DYear` (dateIn DATE) RETURNS VARCHAR(50) DETERMINISTIC BEGIN DECLARE Retval VARCHAR(50) Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END_OF_INPUT, expecting ';' 14:26:35 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: SELECT CONCAT(CASE WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '1' THEN 'One-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '2' THEN 'Two-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '3' THEN 'Three-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '4' THEN 'Four-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '5' THEN 'Five-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '6' THEN 'Six-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '7' THEN 'Seven-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '8' THEN 'Eight-hundred' WHEN SUBSTR(DATE_FORMAT(dateIn, '%Y'), 2, 1) = '9' THEN 'Nine-hundred' ELSE 'INTERNAL ERROR-Hundreds digit of year malformed' END, case when substr(date_format(dateIn,'%Y'),3,2)='00' then 'th' when substr(date_format(dateIn,'%Y'),3,1)='0' then concat('-',lower(date_1DYear(dateIn))) else concat'-',lower(date_2DYear(dateIn))) end) INTO Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected TEXT_STRING, expecting END 14:26:35 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: RETURN Retval Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected RETURN_SYM 14:26:35 [ERR][sqlide_grt.py:enbeautificate:336]: Error reformating SQL: END Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 333, in enbeautificate result = doReformatSQLStatement(statement, True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_grt.py", line 234, in doReformatSQLStatement raise Exception("Error parsing statement: %s" % ast_list[0]) Exception: Error parsing statement: syntax error, unexpected END 14:33:06 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:32 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:34 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:36 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:36 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:38 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:40 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:40 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:33:41 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:37:36 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:37:40 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:37:58 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:47:59 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:48:00 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:48:46 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:48:46 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:48:48 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 14:48:48 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 17:58:38 [ERR][SQL Editor Form]: Error Code: 1054. Unknown column '’America' in 'field list' 18:11:48 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:12:02 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'case when substr(date_format(str_to_date('1111-11-11','%Y-%m-%d'),'%Y'),2,3)=' at line 33 18:34:04 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:09 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:10 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:14 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:22 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:27 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:27 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:28 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:29 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:34:44 [ERR][SQL Editor Form]: Error Code: 1054. Unknown column 'SYSDATE' in 'field list' 18:35:26 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:36:14 [ERR][SQL Editor Form]: Error Code: 1054. Unknown column 'concat' in 'field list' 18:36:57 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 18:37:27 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 18:49:54 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:50:05 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:50:12 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:50:12 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:50:12 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:50:20 [ERR][SQL Editor Form]: Error Code: 1146. Table 'e.time_zone_name' doesn't exist 18:51:10 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:51:14 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:53:18 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 18:53:25 [ERR][SQL Editor Form]: Error Code: 1054. Unknown column '’America' in 'field list' 19:15:28 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception: 17:21:07 [INF][ WQE.net]: Shutting down SQL editor (MLASDBA) 17:21:09 [INF][ Workbench]: Shutting down Workbench 17:21:09 [INF][ mforms managed]: Shutting down mforms wrapper 17:21:09 [INF][ Workbench]: Done