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
|
This directory contains spannertest, an in-memory fake Cloud Spanner. A sibling
directory, spansql, contains types and parser for the Cloud Spanner SQL dialect.
spansql is reusable for anything that interacts with Cloud Spanner on a
syntactic basis, such as tools for handling Spanner schema (DDL).
spannertest builds on spansql for testing code that uses Cloud Spanner client
libraries.
Neither of these packages aims to be performant nor exact replicas of the
production Cloud Spanner. They are reasonable for building tools, or writing
unit or integration tests. Full-scale performance testing or serious workloads
should use the production Cloud Spanner instead.
Here's a list of features that are missing or incomplete. It is roughly ordered
by ascending esotericism:
- expression functions
- more aggregation functions
- INSERT/UPDATE DML statements
- case insensitivity
- alternate literal types (esp. strings)
- STRUCT types
- SELECT HAVING
- joins
- transaction simulation
- expression type casting, coercion
- SELECT aliases in FROM clause, ORDER BY
- subselects
- set operations (UNION, INTERSECT, EXCEPT)
- partition support
- conditional expressions
- table sampling (implementation)
- hints for table/joins
|
