NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commit31ee5ec

committed

Adjust regex for test with opening parenthesis in character classes

As written, the test was throwing an error because of an unbalancedparenthesis. The regex used in the test is adjusted to not fail and totest the case of an opening parenthesis in a character class after somenested square brackets.Oversight ind46911e.Discussion:https://postgr.es/m/16ab039d1af455652bdf4173402ddda145f2c73b.camel@cybertec.at

1 parent9481d16 commit31ee5ecCopy full SHA for 31ee5ec

File tree

2 files changed

-3

lines changed

src/test/regress
- expected
  - strings.out
- sql
  - strings.sql

2 files changed

-3

lines changed

`‎src/test/regress/expected/strings.out`

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -592,8 +592,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM TEXT_TBL WHERE f1 SIMILAR TO '$[$[:alnum:]$]$'`
`592`	`592`	`(2 rows)`
`593`	`593`
`594`	`594`	`-- Opening parenthesis "("`
`595`		`-EXPLAIN (COSTS OFF) SELECT * FROM TEXT_TBL WHERE f1 SIMILAR TO '([([:alnum:](](';`
`596`		`-ERROR: invalid regular expression: parentheses () not balanced`
	`595`	`+EXPLAIN (COSTS OFF) SELECT * FROM TEXT_TBL WHERE f1 SIMILAR TO '()[([:alnum:](]()';`
	`596`	`+ QUERY PLAN`
	`597`	`+------------------------------------------------------`
	`598`	`+ Seq Scan on text_tbl`
	`599`	`+ Filter: (f1 ~ '^(?:(?:)[([:alnum:](](?:))$'::text)`
	`600`	`+(2 rows)`
	`601`	`+`
`597`	`602`	`-- Caret "^"`
`598`	`603`	`EXPLAIN (COSTS OFF) SELECT * FROM TEXT_TBL WHERE f1 SIMILAR TO '^[^[:alnum:]^[^^][[^^]][\^][[\^]]\^]^';`
`599`	`604`	`QUERY PLAN`

`‎src/test/regress/sql/strings.sql`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -194,7 +194,7 @@ EXPLAIN (COSTS OFF) SELECT * FROM TEXT_TBL WHERE f1 SIMILAR TO '.[.[:alnum:].].'`
`194`	`194`	`-- Dollar "$"`
`195`	`195`	`EXPLAIN (COSTS OFF)SELECT*FROM TEXT_TBLWHERE f1 SIMILAR TO'$[$[:alnum:]$]$';`
`196`	`196`	`-- Opening parenthesis "("`
`197`		`-EXPLAIN (COSTS OFF)SELECT*FROM TEXT_TBLWHERE f1 SIMILAR TO'([([:alnum:](](';`
	`197`	`+EXPLAIN (COSTS OFF)SELECT*FROM TEXT_TBLWHERE f1 SIMILAR TO'()[([:alnum:](]()';`
`198`	`198`	`-- Caret "^"`
`199`	`199`	`EXPLAIN (COSTS OFF)SELECT*FROM TEXT_TBLWHERE f1 SIMILAR TO'^[^[:alnum:]^[^^][[^^]][\^][[\^]]\^]^';`
`200`	`200`	`-- Closing square bracket "]" at the beginning of character class`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit31ee5ec

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/strings.out`

`‎src/test/regress/sql/strings.sql`

0 commit comments