[jira] [Created] (NETBEANS-4849) SQL Script that runs successfully shows an error count

["Kenneth Fogel (Jira)" <ji...@apache.org>]

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-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists