Commit5a77573

committed

Unicode sequences. \u0000 is not correctly work yet - waiting bugfix in jsonb

1 parentbfa87d1 commit5a77573Copy full SHA for 5a77573

File tree

+166

-4200

lines changed

+166

-4200

lines changed

Lines changed: 31 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -830,6 +830,37 @@ select '"XXX"'::jsonb @@ '#.$="XXX"';`
`830`	`830`	`f`
`831`	`831`	`(1 row)`
`832`	`832`
	`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`	`+`
`833`	`864`	`---table and index`
`834`	`865`	`select count(*) from test_jsquery where (v->>'review_helpful_votes')::int4 > 0;`
`835`	`866`	`count`

Comments

(0)