SQLite 3.44.0, FILTER and ORDER BY clauses in aggregate functions #1116
Xcode test results
Testing project GRDB with scheme GRDB
Summary
Total | Passed | Failed | Skipped | Expected Failure | ⏱️ Time |
---|---|---|---|---|---|
2627 | 2621 | 0 | 6 | 0 | 7.35s |
Test Summary
GRDBTests
- Device: Mac mini, 13.6 (22G120)
- SDK: macOS 13.0, 13.0
Details
Test Details
GRDBTests
ValueObservationPublisherTests
⏱️ | ||||
---|---|---|---|---|
11 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
DatabaseValueConvertibleEncodableTests
⏱️ | ||||
---|---|---|---|---|
14 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
FetchableRecordTests
⏱️ | ||||
---|---|---|---|---|
17 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
DatabaseDataEncodingStrategyTests
⏱️ | ||||
---|---|---|---|---|
6 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
AssociationHasOneThroughFetchableRecordTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
RowFromDictionaryLiteralTests
⏱️ | ||||
---|---|---|---|---|
19 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
PoolTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
RecordUniqueIndexTests
⏱️ | ||||
---|---|---|---|---|
1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
ValueObservationRecordTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.26s |
All tests passed 🎉
FoundationUUIDTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseConfigurationTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
CGFloatTests
⏱️ | ||||
---|---|---|---|---|
1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
DatabasePoolSchemaCacheTests
⏱️ | ||||
---|---|---|---|---|
3 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseQueueTests
⏱️ | ||||
---|---|---|---|---|
15 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
AssociationHasOneSQLTests
⏱️ | ||||
---|---|---|---|---|
9 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
FoundationNSDateTests
⏱️ | ||||
---|---|---|---|---|
14 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
RecordMinimalNonOptionalPrimaryKeySingleTests
⏱️ | ||||
---|---|---|---|---|
37 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseMigratorTests
⏱️ | ||||
---|---|---|---|---|
28 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
DatabasePoolReadOnlyTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
FTS5TableBuilderTests
⏱️ | ||||
---|---|---|---|---|
21 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseRegionObservationPublisherTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.03s |
All tests passed 🎉
ForeignKeyInfoTests
⏱️ | ||||
---|---|---|---|---|
4 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
FoundationNSStringTests
⏱️ | ||||
---|---|---|---|---|
4 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
FTS3RecordTests
⏱️ | ||||
---|---|---|---|---|
4 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
SingletonRecordTest
⏱️ | ||||
---|---|---|---|---|
12 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
AssociationChainSQLTests
⏱️ | ||||
---|---|---|---|---|
23 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
AssociationHasManyOrderingTests
⏱️ | ||||
---|---|---|---|---|
5 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
MutablePersistableRecordPersistenceConflictPolicyTests
⏱️ | ||||
---|---|---|---|---|
9 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabasePoolTests
⏱️ | ||||
---|---|---|---|---|
17 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
JoinSupportTests
⏱️ | ||||
---|---|---|---|---|
9 (90%) | 0 (0%) | 1 (10%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseQueueSchemaCacheTests
⏱️ | ||||
---|---|---|---|---|
5 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.13s |
All tests passed 🎉
DatabaseTimestampTests
⏱️ | ||||
---|---|---|---|---|
1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
FTS5PatternTests
⏱️ | ||||
---|---|---|---|---|
7 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
AssociationRowScopeSearchTests
⏱️ | ||||
---|---|---|---|---|
6 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
PrefixCursorTests
⏱️ | ||||
---|---|---|---|---|
3 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
AssociationBelongsToSQLTests
⏱️ | ||||
---|---|---|---|---|
13 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.14s |
All tests passed 🎉
TruncateOptimizationTests
⏱️ | ||||
---|---|---|---|---|
40 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
AssociationAggregateTests
⏱️ | ||||
---|---|---|---|---|
38 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
TransactionDateTests
⏱️ | ||||
---|---|---|---|---|
10 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
RowFromStatementTests
⏱️ | ||||
---|---|---|---|---|
19 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseValueConversionTests
⏱️ | ||||
---|---|---|---|---|
5 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.14s |
All tests passed 🎉
DatabaseAfterNextTransactionCommitTests
⏱️ | ||||
---|---|---|---|---|
1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.30s |
All tests passed 🎉
TableTests
⏱️ | ||||
---|---|---|---|---|
24 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
FoundationDateTests
⏱️ | ||||
---|---|---|---|---|
20 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
StatementArgumentsTests
⏱️ | ||||
---|---|---|---|---|
17 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.08s |
All tests passed 🎉
ValueObservationPrintTests
⏱️ | ||||
---|---|---|---|---|
16 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.04s |
All tests passed 🎉
DatabaseDataDecodingStrategyTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
AssociationHasManySQLTests
⏱️ | ||||
---|---|---|---|---|
10 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.03s |
All tests passed 🎉
QueryInterfacePromiseTests
⏱️ | ||||
---|---|---|---|---|
4 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseAbortedTransactionTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
FoundationNSURLTests
⏱️ | ||||
---|---|---|---|---|
3 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
MutablePersistableRecordEncodableTests
⏱️ | ||||
---|---|---|---|---|
21 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
MutablePersistableRecordTests
⏱️ | ||||
---|---|---|---|---|
53 (96%) | 0 (0%) | 2 (4%) | 0 (0%) | 0.02s |
All tests passed 🎉
DropWhileCursorTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.00s |
All tests passed 🎉
FTS3PatternTests
⏱️ | ||||
---|---|---|---|---|
6 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.15s |
All tests passed 🎉
DatabaseErrorTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseSuspensionTests
⏱️ | ||||
---|---|---|---|---|
18 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
AssociationParallelRowScopesTests
⏱️ | ||||
---|---|---|---|---|
16 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉
DatabaseQueueBackupTests
⏱️ | ||||
---|---|---|---|---|
2 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
AssociationBelongsToFetchableRecordTests
⏱️ | ||||
---|---|---|---|---|
8 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
AssociationBelongsToRowScopeTests
⏱️ | ||||
---|---|---|---|---|
21 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
AssociationTableAliasTestsSQLTests
⏱️ | ||||
---|---|---|---|---|
9 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.01s |
All tests passed 🎉
DatabaseSnapshotTests
⏱️ | ||||
---|---|---|---|---|
23 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.02s |
All tests passed 🎉