#8126: Quoting of strings - For SQL only, not for JSON

SachinPrakash reported 2012-12-28T23:40:29Z · last modified 2013-07-16T05:01:44Z

Dev	emilianbold
QA	JennyNishimura

Priority	Major
Complexity	Unknown

Component	MongoSQL
Version	14.0

In a double quoted string, to escape the double quote character, I should be able to type 2 double quotes.
- e.g. select "Bob""s Car"
Double quotes used inside of single quotes do not need to be escaped.
- e.g. select "Bob""s Car" where carmake = 'B"M"W'
In a single quoted string, to escape the single quote character, I should be able to type 2 single quotes.
- e.g. select "Bob""s Car" where cartype = 'VW''s'

All Comments (5) Change History

emilianbold 2013-01-03T10:36:16Z

Added support for the SQL (double)quote symbol.

SachinPrakash 2013-02-14T16:55:29Z

string literals can be quoted only within single quotation marks because a string quoted within double quotation marks is interpreted as an identifier
Disable the use of the backslash character (“\”) as an escape character within strings.
A ' (single quote) inside a string quoted with '' (two single quotes) may be written as 'Bob''s Car'.
Suppose, I have a column named 'test' . To include this in a select statement, I need to write: select "'test'"
Suppose, I have a column named "test". To include this in a select statement, I need to write: select """test"""

SachinPrakash 2013-02-14T17:09:44Z

emil.goicovici 2013-02-14T19:40:38Z

The new test cases are resolved on the 0.9.6 drop.

rkshakya 2013-07-16T05:01:44Z

Verified on ADS 14-beta-64.