Commit95dacf8

committed

Put back accidentally-deleted quote_literal() regression tests.

1 parent506070b commit95dacf8Copy full SHA for 95dacf8

File tree

+29

-2

lines changed

+29

-2

lines changed

Lines changed: 22 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -52,7 +52,7 @@ LINE 1: select 3 \|\| 4.0;`
`52`	`52`	`^`
`53`	`53`	`HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.`
`54`	`54`	`/*`
`55`		`- * string functions`
	`55`	`+ *variousstring functions`
`56`	`56`	`*/`
`57`	`57`	`select concat('one');`
`58`	`58`	`concat`
`@@ -118,6 +118,27 @@ select i, left('ahoj', i), right('ahoj', i) from generate_series(-5, 5) t(i) ord`
`118`	`118`	`5 \| ahoj \| ahoj`
`119`	`119`	`(11 rows)`
`120`	`120`
	`121`	`+select quote_literal('');`
	`122`	`+ quote_literal`
	`123`	`+---------------`
	`124`	`+ ''`
	`125`	`+(1 row)`
	`126`	`+`
	`127`	`+select quote_literal('abc''');`
	`128`	`+ quote_literal`
	`129`	`+---------------`
	`130`	`+ 'abc'''`
	`131`	`+(1 row)`
	`132`	`+`
	`133`	`+select quote_literal(e'\\');`
	`134`	`+ quote_literal`
	`135`	`+---------------`
	`136`	`+ E'\\'`
	`137`	`+(1 row)`
	`138`	`+`
	`139`	`+/*`
	`140`	`+ * format`
	`141`	`+ */`
`121`	`142`	`select format(NULL);`
`122`	`143`	`format`
`123`	`144`	`--------`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -30,7 +30,7 @@ select 'four: ' \|\| 2+2;`
`30`	`30`	`select3\|\|4.0;`
`31`	`31`
`32`	`32`	`/*`
`33`		`- * string functions`
	`33`	`+ *variousstring functions`
`34`	`34`	`*/`
`35`	`35`	`select concat('one');`
`36`	`36`	`select concat(1,2,3,'hello',true, false, to_date('20100309','YYYYMMDD'));`
`@@ -41,7 +41,13 @@ select concat_ws('',10,20,null,30);`
`41`	`41`	`select concat_ws(NULL,10,20,null,30) isnull;`
`42`	`42`	`select reverse('abcde');`
`43`	`43`	`select i, left('ahoj', i), right('ahoj', i)from generate_series(-5,5) t(i)order by i;`
	`44`	`+select quote_literal('');`
	`45`	`+select quote_literal('abc''');`
	`46`	`+select quote_literal(e'\\');`
`44`	`47`
	`48`	`+/*`
	`49`	`+ * format`
	`50`	`+*/`
`45`	`51`	`select format(NULL);`
`46`	`52`	`select format('Hello');`
`47`	`53`	`select format('Hello %s','World');`

Comments

(0)