You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org> on 2006/06/21 12:01:29 UTC
[jira] Created: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Client driver does not handle string literals containing "where current of" correctly
-------------------------------------------------------------------------------------
Key: DERBY-1433
URL: http://issues.apache.org/jira/browse/DERBY-1433
Project: Derby
Type: Bug
Components: Network Client, SQL
Versions: 10.2.0.0
Reporter: Knut Anders Hatlen
Fix For: 10.2.0.0
If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1433?page=all ]
Rick Hillegas updated DERBY-1433:
---------------------------------
Fix Version/s: (was: 10.2.2.0)
Unknown release vehicle.
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: http://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: SQL, Network Client
> Affects Versions: 10.2.1.6
> Reporter: Knut Anders Hatlen
> Assigned To: Bernt M. Johnsen
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-1433:
----------------------------------
Derby Categories: [High Value Fix]
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: https://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: Network Client, SQL
> Affects Versions: 10.2.1.6
> Reporter: Knut Anders Hatlen
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1433?page=all ]
Rick Hillegas updated DERBY-1433:
---------------------------------
Urgency: Normal
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: http://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: SQL, Network Client
> Affects Versions: 10.2.0.0
> Reporter: Knut Anders Hatlen
> Fix For: 10.2.0.0
>
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Bernt M. Johnsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bernt M. Johnsen reassigned DERBY-1433:
---------------------------------------
Assignee: (was: Bernt M. Johnsen)
This is a larger issue, and the client driver needs some kind of a light-weight parser to deal this and related issues. See previous commnt. I unassign myself from this one (at least for the moment).
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: https://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: Network Client, SQL
> Affects Versions: 10.2.1.6
> Reporter: Knut Anders Hatlen
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1433?page=all ]
Knut Anders Hatlen updated DERBY-1433:
--------------------------------------
Attachment: cursor.java
Attached a repro for the bug (cursor.java).
When the program is run, it is supposed to print
Writing where current of in SQL is bad!
but instead it prints
Writing where current of SQL_CURLH000C1 SQL is bad!
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: http://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Type: Bug
> Components: Network Client, SQL
> Versions: 10.2.0.0
> Reporter: Knut Anders Hatlen
> Fix For: 10.2.0.0
> Attachments: cursor.java
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1433?page=all ]
Rick Hillegas updated DERBY-1433:
---------------------------------
Fix Version/s: 10.2.2.0
(was: 10.2.1.0)
Moving to 10.2.2.0.
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: http://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: SQL, Network Client
> Affects Versions: 10.2.1.0
> Reporter: Knut Anders Hatlen
> Fix For: 10.2.2.0
>
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1433) Client driver does not handle string
literals containing "where current of" correctly
Posted by "Bernt M. Johnsen (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1433?page=comments#action_12447739 ]
Bernt M. Johnsen commented on DERBY-1433:
-----------------------------------------
There's more to it. There are several instance of ad-hoc pasing in java/client/org/apache/derby/client/am/Statement.java. E.g. when figuring out what kind of statement it is (QUERY, UPDATE, INSERT, DELETE, CALL etc), when {?=CALL(.....)} is unescaped (Why is that necassry for CALL when it's not needed for other escapes).
The proper solution would be one lightweight parser for all these needs (The even more proper solution would have been a network protocol on a semantic layer where such client parsing were unecessary).
> Client driver does not handle string literals containing "where current of" correctly
> -------------------------------------------------------------------------------------
>
> Key: DERBY-1433
> URL: http://issues.apache.org/jira/browse/DERBY-1433
> Project: Derby
> Issue Type: Bug
> Components: SQL, Network Client
> Affects Versions: 10.2.1.6
> Reporter: Knut Anders Hatlen
> Assigned To: Bernt M. Johnsen
> Fix For: 10.2.2.0
>
> Attachments: cursor.java
>
>
> If a string literal contains 'where current of something', the client driver tries to substitute 'something' with the corresponding cursor name on the server. This can lead to an exception being raised (no such cursor) or the string literal being modified. See attached repro.
> The bug is also present in JCC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira