NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit068739f

committed

Fix incorrect xmlschema output for types timetz and timestamptz.

The output of table_to_xmlschema() and allied functions includesa regex describing valid values for these types ... but the regexwas itself invalid, as it failed to escape a literal "+" sign.Report and fix by Renan Soares Lopes. Back-patch to allsupported branches.Discussion:https://postgr.es/m/7f6fabaa-3f8f-49ab-89ca-59fbfe633105@me.com

1 parent0d3aaad commit068739fCopy full SHA for 068739f

File tree

4 files changed

+514

-438

lines changed

src
- backend/utils/adt
  - xml.c
- test/regress
  - expected
    - xmlmap.out
    - xmlmap_1.out
  - sql
    - xmlmap.sql

4 files changed

+514

-438

lines changed

`‎src/backend/utils/adt/xml.c`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3659,7 +3659,7 @@ map_sql_type_to_xmlschema_type(Oid typeoid, int typmod)`
`3659`	`3659`	`caseTIMEOID:`
`3660`	`3660`	`caseTIMETZOID:`
`3661`	`3661`	`{`
`3662`		`-constchar*tz= (typeoid==TIMETZOID ?"(+\|-)\\p{Nd}{2}:\\p{Nd}{2}" :"");`
	`3662`	`+constchar*tz= (typeoid==TIMETZOID ?"(\\+\|-)\\p{Nd}{2}:\\p{Nd}{2}" :"");`
`3663`	`3663`
`3664`	`3664`	`if (typmod==-1)`
`3665`	`3665`	`appendStringInfo(&result,`
`@@ -3682,7 +3682,7 @@ map_sql_type_to_xmlschema_type(Oid typeoid, int typmod)`
`3682`	`3682`	`caseTIMESTAMPOID:`
`3683`	`3683`	`caseTIMESTAMPTZOID:`
`3684`	`3684`	`{`
`3685`		`-constchar*tz= (typeoid==TIMESTAMPTZOID ?"(+\|-)\\p{Nd}{2}:\\p{Nd}{2}" :"");`
	`3685`	`+constchar*tz= (typeoid==TIMESTAMPTZOID ?"(\\+\|-)\\p{Nd}{2}:\\p{Nd}{2}" :"");`
`3686`	`3686`
`3687`	`3687`	`if (typmod==-1)`
`3688`	`3688`	`appendStringInfo(&result,`

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!

Commit068739f

File tree

4 files changed

4 files changed

`‎src/backend/utils/adt/xml.c`

0 commit comments