Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 5a77573

Browse filesBrowse files
committed
Unicode sequences. \u0000 is not correctly work yet - waiting bugfix in jsonb
1 parent bfa87d1 commit 5a77573
Copy full SHA for 5a77573

File tree

6 files changed

+166
-4200
lines changed
Filter options

6 files changed

+166
-4200
lines changed

‎expected/jsquery.out

Copy file name to clipboardExpand all lines: expected/jsquery.out
+31Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -830,6 +830,37 @@ select '"XXX"'::jsonb @@ '#.$="XXX"';
830830
f
831831
(1 row)
832832

833+
--Unicode
834+
select 'a\t = "dollar \u0024 character"'::jsquery;
835+
jsquery
836+
------------------------------
837+
"a\t" = "dollar $ character"
838+
(1 row)
839+
840+
select '{ "a": "dollar \u0024 character" }'::jsonb @@ '* = "dollar \u0024 character"';
841+
?column?
842+
----------
843+
t
844+
(1 row)
845+
846+
select '{ "a": "dollar \u0024 character" }'::jsonb @@ '* = "dollar $ character"';
847+
?column?
848+
----------
849+
t
850+
(1 row)
851+
852+
select '{ "a": "dollar $ character" }'::jsonb @@ '* = "dollar \u0024 character"';
853+
?column?
854+
----------
855+
t
856+
(1 row)
857+
858+
select 'a\r = "\n\""'::jsquery;
859+
jsquery
860+
----------------
861+
"a\r" = "\n\""
862+
(1 row)
863+
833864
---table and index
834865
select count(*) from test_jsquery where (v->>'review_helpful_votes')::int4 > 0;
835866
count

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.