SQL Server全文搜索:解析单词形式的不同结果

Question

为什么这些查询在sqlserver 2008R2和sqlserver (2012,2014,2016,2017)中会有不同的结果？

--SQLSERVER 2008R2
SELECT display_term FROM SYS.DM_FTS_PARSER('FORMSOF(INFLECTIONAL, test)', 1033, 0, 0)
----------
tests
tested
testing
test

SELECT display_term FROM SYS.DM_FTS_PARSER('FORMSOF(INFLECTIONAL, testing)', 1033, 0, 0)
---------
tests
tested
testing
test

第二个查询：

--SQLSERVER 2016
SELECT display_term FROM SYS.DM_FTS_PARSER('FORMSOF(INFLECTIONAL, test)', 1033, 0, 0)
----------
test's
tested
testing
tests
tests'
test

SELECT display_term FROM SYS.DM_FTS_PARSER('FORMSOF(INFLECTIONAL, testing)', 1033, 0, 0)
---------
test
test's
tested
testing's
testings
testings'
tests
tests'
testing

我假设它应该是相同的，但是在我的生产数据库中，客户在这种不同的行为上有一些问题。

以下是断字符：

--2008r2
wordbreaker 1033    188D6CC5-CB03-4C01-912E-47D21295D77E    C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Binn\langwrbk.dll  12.0.6828.0 Microsoft Corporation
-- 2012
wordbreaker 1033    9FAED859-0B30-4434-AE65-412E14A16FB8    C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn\MsWb7.dll  14.0.4763.1000  Microsoft Corporation
-- 2014
wordbreaker 1033    9FAED859-0B30-4434-AE65-412E14A16FB8    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER2014\MSSQL\Binn\MsWb7.dll  14.0.4763.1000  Microsoft Corporation
-- 2016
wordbreaker 1033    9FAED859-0B30-4434-AE65-412E14A16FB8    C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\Binn\MsWb7.dll  14.0.4763.1000  Microsoft Corporation
-- 2017
wordbreaker 1033    9FAED859-0B30-4434-AE65-412E14A16FB8    C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Binn\MsWb7.dll  14.0.4763.1000  Microsoft Corporation

Answer 1

微软在2012年更改了changed。与2008相比，新的断路器有其他行为。这就是原因。