Bug #105343 the foreign key choice doesn't give me the right column and reference column
Submitted: 27 Oct 14:03 Modified: 24 Nov 12:47
Reporter: Sura ALani Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.26 OS:Microsoft Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[27 Oct 14:03] Sura ALani
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\suraa\AppData\Roaming\MySQL\Workbench\log\wb.log]

This is the Error 

Executing SQL script in server
ERROR: Error 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 ')
    REFERENCES `Sura.YAHUAS`.`Student` ()
    ON DELETE NO ACTION
    ON UPDAT' at line 9
SQL Code:
        -- -----------------------------------------------------
        -- Table `Sura.YAHUAS`.`Progress`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `Sura.YAHUAS`.`Progress` (
          `Progress_ID` INT NOT NULL AUTO_INCREMENT,
          `Comments` VARCHAR(45) NULL,
          PRIMARY KEY (`Progress_ID`),
          CONSTRAINT `Student_3`
            FOREIGN KEY ()
            REFERENCES `Sura.YAHUAS`.`Student` ()
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB

SQL script execution finished: statements: 16 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch

How to repeat:
Please Send to my Email :
suraalani2016@gmail.com
[24 Nov 12:47] MySQL Verification Team
Hello Sura ALani,

Thank you for the bug report.
There is a syntax error in creating a FK in your table. Right syntax is as below.

CREATE TABLE IF NOT EXISTS `Progress` (
          `Progress_ID` INT NOT NULL AUTO_INCREMENT,
          `Comments` VARCHAR(45) NULL,
          PRIMARY KEY (`Progress_ID`),
          CONSTRAINT `Student_3`
            FOREIGN KEY (Progress_ID)
            REFERENCES Student(`Student_id` )
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB;

Regards,
Ashwini Patil