Pomelo.EntityFrameworkCore.MySql/test/EFCore.MySql.Tests/Infrastructure/ServerVersionSupportTest.cs at 595a0ad4fa94232d7ee10a9d85f05f8e33333557 · PomeloFoundation/Pomelo.EntityFrameworkCore.MySql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
using Microsoft.EntityFrameworkCore;
using Xunit;

namespace Pomelo.EntityFrameworkCore.MySql.Infrastructure
{
    public class ServerVersionSupportTest
    {
        [Fact]
        public void Latest_MySql_version_feature_support()
        {
            var supports = MySqlServerVersion.LatestSupportedServerVersion.Supports;

            // Supported features:
            Assert.True(supports.DateTimeCurrentTimestamp);
            Assert.True(supports.DateTime6);
            Assert.True(supports.LargerKeyLength);
            Assert.True(supports.RenameIndex);
            Assert.True(supports.RenameColumn);
            Assert.True(supports.WindowFunctions);
            Assert.True(supports.DoubleCast);
            Assert.True(supports.OuterApply);
            Assert.True(supports.CrossApply);
            Assert.True(supports.OuterReferenceInMultiLevelSubquery);
            Assert.True(supports.Json);
            Assert.True(supports.GeneratedColumns);
            Assert.True(supports.NullableGeneratedColumns);
            Assert.True(supports.ParenthesisEnclosedGeneratedColumnExpressions);
            Assert.True(supports.DefaultCharSetUtf8Mb4);
            Assert.True(supports.DefaultExpression);
            Assert.True(supports.SpatialIndexes);
            Assert.True(supports.SpatialReferenceSystemRestrictedColumns);
            Assert.True(supports.SpatialSupportFunctionAdditions);
            Assert.True(supports.SpatialSetSridFunction);
            Assert.True(supports.SpatialDistanceFunctionImplementsAndoyer);
            Assert.True(supports.SpatialDistanceSphereFunction);
            Assert.True(supports.SpatialGeographic);
            Assert.True(supports.ExceptIntercept);
            Assert.True(supports.ExceptInterceptPrecedence);
            Assert.True(supports.ImplicitBoolCheckUsesIndex);
            Assert.True(supports.MySqlBug104294Workaround);
            Assert.True(supports.FullTextParser);
            Assert.True(supports.InformationSchemaCheckConstraintsTable);
            Assert.True(supports.MySqlBugLimit0Offset0ExistsWorkaround);
            Assert.True(supports.DescendingIndexes);
            Assert.True(supports.CommonTableExpressions);
            Assert.True(supports.JsonTable);
            Assert.True(supports.JsonValue);
            Assert.True(supports.JsonOverlaps);
            Assert.True(supports.ValuesWithRows);
            Assert.True(supports.FieldReferenceInTableValueConstructor);
            Assert.True(supports.JsonTableImplementationWithoutMariaDbBugs);
            Assert.True(supports.JsonTableImplementationWithAggregate);

            // Unsupported features (update these assertions when MySQL adds support):
            Assert.False(supports.FloatCast);
            Assert.False(supports.AlternativeDefaultExpression);
            Assert.False(supports.SpatialFunctionAdditions);
            Assert.False(supports.JsonDataTypeEmulation);
            Assert.False(supports.Sequences);
            Assert.False(supports.MySqlBug96947Workaround);
            Assert.False(supports.IdentifyJsonColumsByCheckConstraints);
            Assert.False(supports.Returning);
            Assert.False(supports.LimitWithinInAllAnySomeSubquery);
            Assert.False(supports.LimitWithNonConstantValue);
            Assert.False(supports.Values);
            Assert.False(supports.WhereSubqueryReferencesOuterQuery);
            Assert.False(supports.CollationCharacterSetApplicabilityWithFullCollationNameColumn);
            Assert.False(supports.JsonTableImplementationStable);
            Assert.False(supports.JsonTableImplementationWithoutMySqlBugs);
            Assert.False(supports.JsonTableImplementationUsingParameterAsSourceWithoutEngineCrash);
        }

        [Fact]
        public void Latest_MariaDb_version_feature_support()
        {
            var supports = MariaDbServerVersion.LatestSupportedServerVersion.Supports;

            // Supported features:
            Assert.True(supports.DateTimeCurrentTimestamp);
            Assert.True(supports.DateTime6);
            Assert.True(supports.LargerKeyLength);
            Assert.True(supports.RenameIndex);
            Assert.True(supports.RenameColumn);
            Assert.True(supports.WindowFunctions);
            Assert.True(supports.DoubleCast);
            Assert.True(supports.Json);
            Assert.True(supports.GeneratedColumns);
            Assert.True(supports.DefaultCharSetUtf8Mb4);
            Assert.True(supports.AlternativeDefaultExpression);
            Assert.True(supports.SpatialIndexes);
            Assert.True(supports.SpatialFunctionAdditions);
            Assert.True(supports.ExceptIntercept);
            Assert.True(supports.ExceptInterceptPrecedence);
            Assert.True(supports.JsonDataTypeEmulation);
            Assert.True(supports.ImplicitBoolCheckUsesIndex);
            Assert.True(supports.Sequences);
            Assert.True(supports.InformationSchemaCheckConstraintsTable);
            Assert.True(supports.IdentifyJsonColumsByCheckConstraints);
            Assert.True(supports.Returning);
            Assert.True(supports.CommonTableExpressions);
            Assert.True(supports.JsonTable);
            Assert.True(supports.JsonValue);
            Assert.True(supports.JsonOverlaps);
            Assert.True(supports.Values);
            Assert.True(supports.CollationCharacterSetApplicabilityWithFullCollationNameColumn);
            Assert.True(supports.JsonTableImplementationWithoutMySqlBugs);
            Assert.True(supports.JsonTableImplementationUsingParameterAsSourceWithoutEngineCrash);

            // Unsupported features (update these assertions when MariaDB adds support):
            Assert.False(supports.FloatCast);
            Assert.False(supports.OuterApply);
            Assert.False(supports.CrossApply);
            Assert.False(supports.OuterReferenceInMultiLevelSubquery);
            Assert.False(supports.NullableGeneratedColumns);
            Assert.False(supports.ParenthesisEnclosedGeneratedColumnExpressions);
            Assert.False(supports.DefaultExpression);
            Assert.False(supports.SpatialReferenceSystemRestrictedColumns);
            Assert.False(supports.SpatialSupportFunctionAdditions);
            Assert.False(supports.SpatialSetSridFunction);
            Assert.False(supports.SpatialDistanceFunctionImplementsAndoyer);
            Assert.False(supports.SpatialDistanceSphereFunction);
            Assert.False(supports.SpatialGeographic);
            Assert.False(supports.MySqlBug96947Workaround);
            Assert.False(supports.MySqlBug104294Workaround);
            Assert.False(supports.FullTextParser);
            Assert.False(supports.MySqlBugLimit0Offset0ExistsWorkaround);
            Assert.False(supports.DescendingIndexes);
            Assert.False(supports.LimitWithinInAllAnySomeSubquery);
            Assert.False(supports.LimitWithNonConstantValue);
            Assert.False(supports.ValuesWithRows);
            Assert.False(supports.WhereSubqueryReferencesOuterQuery);
            Assert.False(supports.FieldReferenceInTableValueConstructor);
            Assert.False(supports.JsonTableImplementationStable);
            Assert.False(supports.JsonTableImplementationWithoutMariaDbBugs);
            Assert.False(supports.JsonTableImplementationWithAggregate);
        }
    }
}