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
isql -ex semicolon and one-line comment problem [CORE2409] #2827
Comments
Modified by: Claudio Valderrama C. (robocop)Component: ISQL [ 10003 ] |
Commented by: @asfernandes Test case, please... Because in my test everything is fine: isql T.FDB SQL> ^Z isql -ex T.FDB SET SQL DIALECT 3; /* CREATE DATABASE 'T.FDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET NONE */ /* View: V1, Owner: SYSDBA */ /* View: V2, Owner: SYSDBA */ |
Commented by: Cosmin Apreutesei (cosmin_ap2) try this (I did it in ibexpert but I don't think it matters): create view V This made it append the semicolon to the comment. You need a where clause for some reason :) |
Commented by: @asfernandes Again, not reproducible: isql T.FDB isql -ex T.FDB SET SQL DIALECT 3; /* CREATE DATABASE 'T.FDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET NONE */ /* View: V, Owner: SYSDBA */ select |
Commented by: Cosmin Apreutesei (cosmin_ap2) Might be because I create this in ibexpert, and without a semi-colon to terminate the sql command? To clear any doubt, here's what I get in RDB$RELATIONS.RDB$VIEW_SOURCE after executing the above command (last character is a space character on all lines except last one): 1 Maybe this helps. Anyway, I'll get HEAD again (it's a few days old) and test again. |
Submitted by: Cosmin Apreutesei (cosmin_ap2)
Test case:
- make a view with a line comment on the last line of its body.
You'll see that it appends the semicolon to the comment line. So i guess an LF before the semicolon would be needed in this case.
The text was updated successfully, but these errors were encountered: