Kenneth Fogel created NETBEANS-4849: ---------------------------------------
Summary: SQL Script that runs successfully shows an error count Key: NETBEANS-4849 URL: https://issues.apache.org/jira/browse/NETBEANS-4849 Project: NetBeans Issue Type: Bug Components: db - MySQL Affects Versions: 12.0 Environment: NetBeans 12, Java 14 (AdoptOpenJDK), MySQL 8, Connector/J 8.0.21 Reporter: Kenneth Fogel Fix For: Next A script that creates 3 tables, one of which is a bridge table, runs successfully in a MySQL DB connection in NetBeans. However, it ends with the following: Execution finished after 0.399 s, 86 errors occurred. There are no errors. Here is the script: USE AQUARIUM; SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS StudentBrCourse; DROP TABLE IF EXISTS Students; DROP TABLE IF EXISTS Courses; SET FOREIGN_KEY_CHECKS = 1; CREATE TABLE Students( StudentID INT, UserName VARCHAR(255), FirstName VARCHAR(255), Email VARCHAR(255), PhoneNumber INT, BeginningDate TIME, EndingDate TIME, MaxHours INT, PRIMARY KEY(StudentID) ); CREATE TABLE Courses( CourseID INT, CourseAbbreviation VARCHAR(255), CourseNumber INT, SectionNumber INT, ProfessorID INT, PRIMARY KEY (CourseID) ); CREATE TABLE StudentBrCourse( MyKey int, StudentID int, CourseID int, CONSTRAINT fkstudentid FOREIGN KEY (StudentID) REFERENCES Students(StudentID), CONSTRAINT fkcourseid FOREIGN KEY (CourseID) REFERENCES Courses(CourseID), PRIMARY KEY (MyKey) ); -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists