From 400fc0f73d03010d3bf28d2b1db5d789dc085334 Mon Sep 17 00:00:00 2001
From: Marc Alexander <admin@m-a-styles.de>
Date: Mon, 25 Dec 2017 18:49:31 +0100
Subject: [ticket/15055] Only drop dependent PK indexes and fix more tests for
 mssql

PHPBB3-15055
---
 tests/search/fixtures/posts.xml | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'tests/search')

diff --git a/tests/search/fixtures/posts.xml b/tests/search/fixtures/posts.xml
index 16232b8f39..4916cd188b 100644
--- a/tests/search/fixtures/posts.xml
+++ b/tests/search/fixtures/posts.xml
@@ -1,25 +1,30 @@
 <?xml version="1.0" encoding="UTF-8" ?>
 <dataset>
 	<table name="phpbb_posts">
+		<column>post_id</column>
 		<column>post_username</column>
 		<column>post_subject</column>
 		<column>post_text</column>
 		<row>
+			<value>1</value>
 			<value>foo</value>
 			<value>foo</value>
 			<value>foo</value>
 		</row>
 		<row>
+			<value>2</value>
 			<value>bar</value>
 			<value>bar</value>
 			<value>bar</value>
 		</row>
 		<row>
+			<value>3</value>
 			<value>commonword</value>
 			<value>commonword</value>
 			<value>commonword</value>
 		</row>
 		<row>
+			<value>4</value>
 			<value>baaz</value>
 			<value>baaz</value>
 			<value>baaz</value>
-- 
cgit v1.2.1


From 2353ad11f2afe213e407842a9a9e1533c0de57b0 Mon Sep 17 00:00:00 2001
From: Marc Alexander <admin@m-a-styles.de>
Date: Fri, 26 Apr 2019 23:39:51 +0200
Subject: [ticket/security/235] Update search native tests

SECURITY-235
---
 tests/search/native_test.php | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'tests/search')

diff --git a/tests/search/native_test.php b/tests/search/native_test.php
index 29d0d0a8d3..0e6f719cef 100644
--- a/tests/search/native_test.php
+++ b/tests/search/native_test.php
@@ -70,7 +70,7 @@ class phpbb_search_native_test extends phpbb_search_test_case
 				'ba*az',
 				'all',
 				true,
-				array('\'ba%az\''),
+				array(4),
 				array(),
 				array(),
 			),
@@ -78,7 +78,7 @@ class phpbb_search_native_test extends phpbb_search_test_case
 				'ba*z',
 				'all',
 				true,
-				array('\'ba%z\''),
+				array(), // <= 3 chars after removing *
 				array(),
 				array(),
 			),
@@ -86,7 +86,7 @@ class phpbb_search_native_test extends phpbb_search_test_case
 				'baa* baaz*',
 				'all',
 				true,
-				array('\'baa%\'', '\'baaz%\''),
+				array('\'baa%\'', 4),
 				array(),
 				array(),
 			),
@@ -94,7 +94,7 @@ class phpbb_search_native_test extends phpbb_search_test_case
 				'ba*z baa*',
 				'all',
 				true,
-				array('\'ba%z\'', '\'baa%\''),
+				array('\'baa%\''), // baz is <= 3 chars, only baa* is left
 				array(),
 				array(),
 			),
-- 
cgit v1.2.1