Skip to content

jdbc: escape syntax: scalar functions #79

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.

Sign up for GitHub

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

Jump to bottom
Open
Totktonada opened this issue Nov 2, 2018 · 2 comments
Open

jdbc: escape syntax: scalar functions #79

Totktonada opened this issue Nov 2, 2018 · 2 comments
Labels
enhancement jdbc
Milestone
JDBC MVP

Comments

@Totktonada
Copy link
Member

{fn concat("Hello, ", "World!")} and so on.

Important note from the JDBC 4.2 standard:

The escape syntax for scalar functions must only be used to invoke the scalar
functions defined in Appendix C “Scalar Functions". The escape syntax is not
intended to be used to invoke user-defined or vendor specific scalar functions.
@Totktonada Totktonada added this to the JDBC MVP milestone Nov 2, 2018
@Totktonada Totktonada mentioned this issue May 20, 2019
Open
nicktorwald added a commit that referenced this issue Aug 3, 2019
@nicktorwald
Support JDBC escape syntax
843b7f1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes: #79, #76, #80, #81, #83, #84
Affects: #108
@nicktorwald nicktorwald mentioned this issue Aug 3, 2019
Closed
nicktorwald added a commit that referenced this issue Aug 3, 2019
@nicktorwald
Support JDBC escape syntax
d29b3d1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes: #79, #76, #80, #81, #83, #84
Affects: #108
@Totktonada
Copy link
Member Author

See also tarantool/tarantool@d4a7459 (land as 2.3.0-89-gd4a7459e7) and tarantool/doc#879

@nicktorwald
Copy link

See also tarantool/tarantool@d4a7459 (land as 2.3.0-89-gd4a7459e7) and tarantool/doc#879

Looks unrelated to escaped scalar functions (par. 13.4.1, p 114):

The escape syntax for scalar functions must only be used to invoke the scalar functions defined in Appendix C “Scalar Functions". The escape syntax is not intended to be used to invoke user-defined or vendor specific scalar functions.

nicktorwald added a commit that referenced this issue Dec 4, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
2a1b6c1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 4, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
a77d8e4 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 5, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
dd73edd 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 17, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
204508f 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 17, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
d1f72f2 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Jan 15, 2020
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
d36814b 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Jan 15, 2020
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
939a617 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement jdbc
Projects
None yet
Milestone
JDBC MVP
Development

Successfully merging a pull request may close this issue.

Support JDBC escape syntax tarantool/tarantool-java
2 participants
@Totktonada @nicktorwald