Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support executing delimiter statement without requiring query terminator #3253

Closed
jennifersp opened this issue Apr 19, 2022 · 1 comment · Fixed by #4976
Closed

support executing delimiter statement without requiring query terminator #3253

jennifersp opened this issue Apr 19, 2022 · 1 comment · Fixed by #4976
Labels
enhancement New feature or request

Comments

@jennifersp
Copy link
Contributor

jennifersp commented Apr 19, 2022

Current Dolt sql shell executes DELIMITER ;; statement as setting delimiter to ; and terminating this query. Instead it needs to set delimiter to ;;

DELIMITER ;;
CREATE TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW 
  BEGIN
    INSERT INTO film_text (film_id, title, description) VALUES (new.film_id, new.title, new.description);
  END ;;
DELIMITER ;
@jennifersp jennifersp added the dumps Deals with dumping to and from mysql label Apr 19, 2022
@jennifersp
Copy link
Contributor Author

It works when importing this through dump file. For Dolt sql shell, additional line terminator is required to execute delimiter statement.

@jennifersp jennifersp added enhancement New feature or request and removed dumps Deals with dumping to and from mysql labels Apr 20, 2022
@jennifersp jennifersp linked a pull request Dec 14, 2022 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant