_matrix.ts•822 B
import { defineMatrix } from '../_utils/defineMatrix'
import { Providers } from '../_utils/providers'
export default defineMatrix(() => [
[
{
provider: Providers.POSTGRESQL,
previewFeatures: '"fullTextSearch"',
index: '',
andQuery: 'John & Smith',
orQuery: 'John | April',
notQuery: '(John | April) & !Smith',
noResultsQuery: 'April & Smith',
badQuery: 'John Smith',
},
{
provider: Providers.MYSQL,
previewFeatures: '"fullTextSearch", "fullTextIndex"',
index: `
@@fulltext([name])
@@fulltext([name, email])
@@fulltext([email])
`,
andQuery: '+John +Smith',
orQuery: 'John April',
notQuery: 'John -Smith April',
noResultsQuery: '+April +Smith',
badQuery: 'John <--> Smith',
},
],
])