github.com/codenotary/immudb

Bug Fixes

• Minor updates to build/RELEASING.md
• Update Dockerfile.alma maintainer field
• CI: Fix building and releasing almalinux images
• Dockerfile: Fix compiling version information in docker images
• Dockerfile.rndpass: Fix building rndpass docker image
• embedded/sql: limit auto-increment to single-column pks
• embedded/sql: consider boolean type in maxKeyVal
• embedded/sql: exclude length from maxKey
• embedded/sql: return error when joint table doest not exist
• embedded/sql: support edge case of table with just an auto-increment column
• embedded/sql: take into account table aliasing during range calculations
• embedded/sql: suffix endKey when scan over all entries
• embedded/sql: in-mem catalog rollback and syncing fixes
• embedded/sql: adjust selector ranges calculation
• embedded/sql: improve error handling and parameters validation
• embedded/sql: set type any to nil parameters
• embedded/sql: fix table aliasing with implicit selectors
• embedded/sql: enforce ordering by grouping column
• embedded/store: fix constraint condition
• embedded/store: error handling when setting offset fails
• pkg: improve signature verification during audit
• pkg/stdlib: fix driver connection releasing

Changes

• remove wip warning for fully implemented features
• Remove experimental S3 warning from README
• Update codenotary maintainer info
• Update RELEASING.md with documentation step.
• Add documentation link to command line help outputs
• Add documentation link at the beginning of README.md
• Add documentation badge to README.md
• CI: Explicitly require bash in gh action building docker images
• CI: Use buildkit when building docker images
• CI: Build almalinux-based immudb image
• Dockerfile: Update base docker images
• Dockerfile: Use scratch as a base for immudb image
• Dockerfile: Build a debian-based image for immudb next to the scratch one
• Dockerfile: Remove unused IMMUDB_DBNAME env var
• Makefile: Add darwin/amd64 target
• Makefile: More explicit webconsole version
• build.md: Add info about removing webconsole/dist folder
• cmd/immuadmin: parse all db flags when preparing settings
• cmd/immuadmin: remove replication flag shortcut
• cmd/immuadmin: improve flag description and rollback args spec
• cmd/immuclient: display number of updated rows as result of sql exec
• cmd/immudb: use common replication prefix
• docker: Update generation of docker tags
• embedded: leverage kv constraint to enforce upsert over auto-incremental pk requires row to already exist
• embedded/multierr: enhace multi error implementation
• embedded/sql: remove join constraints
• embedded/sql: minor refactoring to simplify code
• embedded/sql: convert unmapIndexedRow into unmapRow with optional indexed value
• embedded/sql: index prefix function
• embedded/sql: catalog loading requires up to date data store indexing
• embedded/sql: mark catalog as mutated when using auto incremental pk
• embedded/sql: move index spec closer to ds
• embedded/sql: changed identifiers length in catalog
• embedded/sql: move index selection closer to data source in query statements
• embedded/sql: minor code refactoring
• embedded/sql: include constraint only when insert occurs without auto_incremental pk
• embedded/sql: disable TIMESTAMP data-type
• embedded/sql: get rid of limited joint implementation
• embedded/sql: minor code simplification
• embedded/sql: ignore null values when encoding row
• embedded/sql: fix primary key supported types error message
• embedded/sql: optimize integer key mapping
• embedded/sql: use plain big-endian encoding for integer values
• embedded/sql: include support for int64 parameters
• embedded/sql: use Cols as a replacement for ColsByID
• embedded/sql: leverage endKey to optimize indexing scanning
• embedded/sql: use int64 as value holder for INTEGER type
• embedded/sql: add further validations when encoding values as keys
• embedded/sql: fix max key length validation
• embedded/sql: reserve byte to support multi-ordered indexes
• embedded/sql: expose primary key index id
• embedded/sql: wip scan optimizations based on query condition and sorting
• embedded/sql: partial progress on selector range calculation
• embedded/sql: validate non-null pk when decoding index entry
• embedded/sql: limit upsert to tables without secondary indexes
• embedded/sql: optional parenthesis when specifying single-column index
• embedded/sql: partial progress on selector range calculation
• embedded/tbtree: typo in log message
• embedded/tbtree: return kv copies
• embedded/tbtree: adjust seekKey based on prefix even when a value is set
• embedded/tbtree: compaction doesn't need snapshots to be closed
• embedded/tools: update sql stress tool with exec summary
• pkg/api: changed db identifiers type
• pkg/api: use follower naming for replication credentials
• pkg/api: use a map for holding latest auto-incremental pks
• pkg/api: delete deprecated clean operation
• pkg/api: include updated rows and last inserted pks in sql exec result
• pkg/api: use fresh id in proto message
• pkg/api: use int64 as value holder for INTEGER type
• pkg/client: move unit testing to integration package to avoid circular references
• pkg/client: changed db identifiers type
• pkg/database: warn about data migration needed
• pkg/database: update integration to exec summary
• pkg/database: minor adjustments based on multi-column indexing
• pkg/database: warn about data migration needed
• pkg/database: include updated rows and last inserted pks in sql exec result
• pkg/database: display as unique if there is a single-column index
• pkg/database: create sql db instance if not present
• pkg/database: minor refactoring coding conventions
• pkg/database: remove active replication options from database
• pkg/database: minor renaming after rebase
• pkg/pgsql/server: adds pgsql server maxMsgSize 32MB limit
• pkg/pgsql/server: add a guard on payload message len
• pkg/replication: use new context for each client connection
• pkg/replication: handle disconnection only within a single thread
• pkg/replication: use info log level for network failures
• pkg/server: changed default db file size and make it customizable at db creation time
• pkg/server: change max concurrency per database to 30
• pkg/server: nil tlsConfig on default options
• pkg/server: validate replication settings
• pkg/server: use replica wording
• pkg/server: followers management
• pkg/stdLib: implementing golang standard sql interfaces
• pkg/stdlib: increase code coverage and fix blob results scan
• pkg/stdlib: remove pinger interface implementation and increase code coverage
• pkg/stdlib: immuclient options identifier(uri) is used to retrieve cached connections
• pkg/stdlib: simplified and hardened uri handling

Features

• Dockerfile for almalinux based image
• cmd/immuadmin: add replication flags
• cmd/immuadmin: add flag to exclude commit time
• embedded/multierr: implement stardard error Is & As methods
• embedded/sql: use explicitelly specified index as preffered one
• embedded/sql: wip unique multi-column indexes
• embedded/sql: wip auto-incremental integer primary keys
• embedded/sql: value expressions in row specs
• embedded/sql: switch to signed INTEGER
• embedded/sql: exec summary containing number of updated/inserted rows and last inserted pk per table
• embedded/sql: max length on variable sized types as requirement for indexing
• embedded/sql: multi-column primary keys
• embedded/sql: support index spec in joins
• embedded/sql: expose scanSpecs when resolving a query
• embedded/sql: wip unique multi-column indexing
• embedded/sql: towards more powerful joins
• embedded/sql: inner join with joint table and subqueries
• embedded/store: parameterized commit time
• embedded/store: leverage endKey from tbtree key reader
• embedded/tbtree: include endKey to instruct scan termination
• pkg/database: row verification with composite primary keys
• pkg/follower: follower replication
• pkg/pgsql/server: add support for flush message
• pkg/replication: initial active replication capabilities
• pkg/server: initial support for active replication of user created databases
• pkg/server: upgrade db settings to include or exclude commit time
• pkg/server: systemdb and defaultdb follower replication

<a name="v1.0.5"></a>

Bug Fixes

• bind psql port to the same IP address as grpc interface (#867)
• Update crypto, sys dependencies
• consistent reads of recently written data
• embedded/ahtree: fix the full revert corner case
• embedded/store: Truncate aht before commit
• embedded/store: revert change so to prevent nil assigments
• embedded/store: handle missing error case during commit phase
• embedded/store: Don't fail to open on corrupted commit log
• embedded/store: use reserved concurrency slot for indexing
• embedded/tbtree: use padding to ensure stored snapshots are named following lex order
• embedded/tbtree: garbage-less nodes log
• embedded/tbtree: ensure clog is the last one being synced
• embedded/tbtree: flush logs containing compacted index
• embedded/tbtree: ensure proper data flushing and syncing
• pkg/client/auditor: fix and enhance state signature verification
• pkg/pgsql/server: fix boolean and blob extended query handling
• pkg/pgsql/server: hardened bind message parsing and fix leftovers
• pkg/pgsql/server/fmessages: use a variable size reader to parse fe messages
• pkg/server: initialize db settings if not present
• pkg/server: lock userdata map read
• s3: Use remote storage for index
• s3: Use remote storage for new databases
• sql/engine: Harden DecodeValue
• store/indexer: Ensure indexer state lock is always unlocked

Changes

• move sqlutils package to schema
• Update dependencies
• increased coverage handling failure branches (#861)
• group user methods in a dedicated file
• Better logging when opening databases
• remove unused interceptors and add missing error code prefixes
• appendable: Expose validation functions of appendable options
• appendable/multiapp: Add hooks to the MultiFileAppender implementation
• appendable/multiapp: Introduce appendableLRUCache
• cmd/immuclient: fix panic in immuclient cli mode
• cmd/immuclient: update error comparisson
• embedded: col descriptor with attributes
• embedded/ahtree: minor refactoring improving readability
• embedded/ahtree: auto-truncate partially written commit log
• embedded/ahtree: minor changes towards code redabilitiy
• embedded/cache: Add Pop and Replace methods to LRUCache.
• embedded/sql: explicit catalog reloading upon failed operations
• embedded/sql: type specialization
• embedded/sql: Remove linter warnings
• embedded/sql: initial type specialization in place
• embedded/sql: remove public InferParameters operations from sql statements
• embedded/sql: validate either named or unnamed parameters are used within the same stmt
• embedded/sql: towards non-blocking sql initialization
• embedded/sql: parameters type inference working with aggregations
• embedded/sql: several adjustments and completion in type inference functions
• embedded/sql: dump catalog with a different database name
• embedded/sql: cancellable wait for catalog
• embedded/sql: expose InferParameters function in RowReader interface
• embedded/store: tx metatada serialization/deserialization
• embedded/store: edge-case validation with first tx
• embedded/store: validate replicated tx against current store
• embedded/store: minor refactoring improving readability
• embedded/store: auto-truncate partially written commit log
• embedded/store: minor code simplification
• embedded/tbtree: expose current number of snapshots
• embedded/tbtree: warn if an error is raised while discarding snapshots
• embedded/tbtree: nodes and commit prefix renaming
• embedded/tbtree: use setOffset for historical data overwriting
• embedded/tbtree: auto-truncate partially written commit log
• embedded/tbtree: full snapshot recovery
• embedded/tbtree: enable snapshot generation while compaction is in progress
• pkg/api: kept same attribute id in TxEntry message
• pkg/api: fix typo inside a comment
• pkg/api: remove information not required to cryptographically prove entries
• pkg/api: kept simple db creation api to guarantee backward compatibility
• pkg/api: comment on deprecated and not yet supported operations
• pkg/auth: list of supported operations in maintenance mode
• pkg/database: replace fixed naming with current database
• pkg/database: migrate systemdb catalog to fixed database naming
• pkg/database: single-store databases
• pkg/database: support the case where database tx is not the initial one due to migration
• pkg/database: no wait for indexing during tx replication
• pkg/database: sql operations after catalog is created
• pkg/database: method to retrieve row cursor based on a sql query stament
• pkg/database: re-construct sql engine once catalog is ready
• pkg/database: use fixed database name
• pkg/database: sql catalog per database. migration from shared catalog store when required
• pkg/database: sql catalog reloading on replica
• pkg/database: wait for sql engine initialization before closing
• pkg/database: log warning about WIP feature when using replication capabilities
• pkg/database: replace fixing naming with current database
• pkg/database: expose catalog loading operation
• pkg/database: catalog reloading by replicas
• pkg/database: gracefully stop by cancelling sql initialization
• pkg/database: internal method renaming
• pkg/database: log when a database is sucessfully opened
• pkg/database: add IsReplica method
• pkg/database: parameter inference for parsed statements
• pkg/errors: fix user operations error codes with pgsql official ones, increase coverage
• pkg/errors: immuerrors use an internal map to determine code from the message
• pkg/errors: add more error codes and add Cod prefix to codes var names
• pkg/errors: add comments
• pkg/pgsql: increase server coverage
• pkg/pgsql/server: handle empty statements
• pkg/pgsql/server: increase multi inserts tests number in simple and extended query
• pkg/pgsql/server: hardened INTEGER parameters conversion
• pkg/pgsql/server: some polishments in the state machine
• pkg/pgsql/server: simplify query machine
• pkg/pgsql/server: increase code coverage
• pkg/pgsql/server: protect parameters description message from int16 overflown
• pkg/pgsql/server: add max parameters value size guard and move error package in a higher level to avoid cycle deps
• pkg/pgsql/server: add bind message negative value size guards
• pkg/pgsql/server: handle positional parameters
• pkg/pgsql/server: add a guard to check max message size and handle default case in parsing format codes in bind messages
• pkg/pgsql/server/fmessages: uniform malformed bind messages
• pkg/server: disable user mgmt operations in maintenance mode
• pkg/server: systemdb renaming
• pkg/server: move userdata lock in the inner method getLoggedInUserDataFromUsername
• pkg/server: remove methods moved to user file
• pkg/server: fix typo in error message
• pkg/server: remove duplicated property
• pkg/server: minor adjustments after rebasing from master branch
• pkg/server: minor updates after rebasing
• pkg/stream: use io.Reader interface
• pkg/stream: use wrapped errors
• pkg/stream: inject immu errors
• pkg/stream: fix namings on stream api objects

Features

• immuclient running as auditor - replace "prometheus-port" and "prometheus-host" CLI flags with "audit-monitoring-host" and "audit-monitoring-port" (int) and start a single HTTP server which exposes all the needed endpoints (GET /metrics, /initz, /readyz, /livez and /version)
• add /healthz and /version endpoints for immudb and immuclient auditor
• add immudb error package
• appendable: Add remote s3 backend
• cmd/immuadmin: update database command
• cmd/immuadmin: upgrade database creation with settings
• cmd/immuadmin: add flag to create database as a replica
• cmd/immuclient: upgrade database creation with settings
• embedded/sql: adding method to infer typed parameters from sql statements
• embedded/sql: catalog dumping
• embedded/sql: towards leveraging readers for type inference
• embedded/sql: support for named positional parameters
• embedded/sql: support for unnamed parameters
• embedded/store: passive waiting for transaction commit
• embedded/store: WIP replicatedCommit
• embedded/store: tx export and commit replicated
• pkg/api: endpoints for exporting and replicating txs
• pkg/api: enhanced createDatabase endpoint to specify database replication
• pkg/api: new endpoint to update database settings
• pkg/client: replica creation and replication API
• pkg/client: implements update database settings operation
• pkg/client: deprecate CleanIndex operation
• pkg/database: db as replica and replication operations
• pkg/database: parameters type inference exposed in database package
• pkg/database: implement passive wait for committed tx
• pkg/database: suppport runtime replication settings changes
• pkg/error: add improved error handling
• pkg/pgsql/server: add extended query messages and inner logic
• pkg/server: enable simultaneous replication of systemdb and defaultdb
• pkg/server: stream of committed txs
• pkg/server: initial handling of database replication settings
• pkg/server: replicas and replication endpoints
• pkg/server: implements update database settings endpoint
• pkg/server: leverage maintenance mode to recover systemdb and defaultdb databases
• pkg/stream: readFully method to read complete payload transmitted into chunks

<a name="v1.0.1"></a>

Bug Fixes

• go mod tidy/vendor with statik module (#796)
• cmd/immuclient: remove warnings on sql commands in interactive mode
• cmd/immuclient: improve immuclient tx and safetx error message
• embedded/sql: interprete binary prefix if followed by a quote
• pkg/server: always create system db (even when auth is off)

Changes

• enhance Makefile so to automatically download latest webconsole if not already present
• README/doc updates (#791)
• enable webconsole in docker image
• remove mtls evironments var from dockerfile
• embedded/store: apply synced settings to indexing data
• embedded/store: sync values once all entries are written
• pkg/database: retry database selection after registration
• pkg/database: auto-registration when not present in the catalog

Features

• embedded/sql: support <column> <type> NULL syntax
• pkg/database: enhace table description by adding nullable constraint
• webconsole: default web console page (#786)

<a name="v1.0.0"></a>

Bug Fixes

• tlsConfig is always non-nil
• make prequisites fixes introduced in #726 (#732)
• fix windows installer service and missing flags
• cmd/immuclient/immuclienttest: fix options injection in client test helper (#749)
• embedded: ensure readers get properly closed
• embedded/sql: close reader after loading catalog
• embedded/sql: add missing error handling
• embedded/sql: fix selector aliasing
• embedded/sql: prevent side effects in conditional clauses
• embedded/store: fix issue when resuming indexing
• embedded/store: notified latest committed tx when opening store
• embedded/store: fix indexing data race
• pkg/client: row verification with nullable values
• pkg/client/cache: fix lock file cache issue on windows
• pkg/client/cache: clean state file when re-writing old stetes
• pkg/database: unwrap parameter before calling sqlexec
• pkg/database: use SQLPrefix when reopening database
• pkg/pgsql/server: handle data_row message with text format
• pkg/server: complete error handling
• pkg/server: disable pgsql server by default and fix previous server tests
• pkg/sql: columns resolved with aliases
• pkg/sql: resolve shift/reduce conflict in SELECT stmt

Changes

• blank line needed after tag or interpreted as comment
• bundle webconsole inside dist binaries
• fix rebase leftovers
• fix acronym uppercase
• reword wire compatibility
• increase coverage and minor fix
• make roadmap about pgsql wire more explicit (#723)
• expose missing methods to REST (#725)
• inject immudb user authentication
• fix makefile leftovers
• improved make dist script
• move concrete class dblist to database package
• revert 3114f927adf4a9b62c4754d42da88173907a3a9f in order to allow insecure connection on grpc server
• dblist interface is moved to database package and extended
• add pgsql related flags
• cmd/immuclient: query result rendering
• cmd/immuclient: add describe, list, exec and query commands to immuclient shell
• cmd/immuclient: render raw values
• cmd/immudb: add debug info env var details
• cmd/immudb/command: enabled pgsql server only in command package
• cmd/immudb/command: restore missing pgsql cmd flag
• cmd/immudb/command: remove parsing path option in unix
• cmd/immudb/command: handle tls configuration errors
• embedded/cache: thread-safe lru-cache
• embedded/sql: expose functionality needed for row verification
• embedded/sql: minor refactoring to expose functionality needed for row verification
• embedded/sql: case insensitive identifiers
• embedded/sql: case insensitive functions
• embedded/sql: resolve query with current snapshot if readers are still open
• embedded/sql: set 'x' as blob prefix
• embedded/sql: move sql engine under embedded package
• embedded/sql: store non-null values and only col ids on encoded rows
• embedded/sql: safer support for selected database
• embedded/sql: validate table is empty before index creation
• embedded/sql: skip tabs
• embedded/sql: keep one snapshot open and close when releasing
• embedded/sql: improved nullables
• embedded/store: pausable indexer
• embedded/store: commitWith callback using KeyIndex interface
• embedded/store: index info to return latest indexed tx
• embedded/store: use indexer state to terminate indexing goroutine
• embedded/store: log during compaction
• embedded/tbree: postpone reader initialization until first read
• embedded/tbtree: remove dots denoting progress when flushing is not needed
• embedded/tbtree: index compaction if there is not opened snapshot, open snapshot if compaction is not in already in progress
• embedded/tbtree: make snapshot thread-safe
• embedded/watchers: cancellable wait
• pkg/api: render varchar as raw string value
• pkg/api: include data needed for row verification
• pkg/api: render varchar as quoted string
• pkg/api: render varchar as quoted strings
• pkg/api: sql api spec
• pkg/api/schema: Handle tools via modules (#726)
• pkg/auth: add SQL-related permissions
• pkg/auth: perm spec for row verification endpoint
• pkg/client: remove deprecated operations
• pkg/client: use to fetch current database name
• pkg/client: auto convert numeric values to uint64
• pkg/client: improved sql API
• pkg/client/cache: release lock only if locked file is present, and wait for unlock when already present
• pkg/database: set implicit database using UseDatabase method
• pkg/database: typed-value proto conversion
• pkg/database: towards prepared sql query support
• pkg/database: row verification against kv-entries
• pkg/database: improved parameters support
• pkg/database: return mapped row values
• pkg/database: upgrade ExecAll to use KeyIndex interface
• pkg/database: add missing copy
• pkg/database: support index compaction with sql engine in place
• pkg/database: support multi-selected columns
• pkg/database: use store-level snapshots
• pkg/database: upgrade wait for indexing api
• pkg/database: ensure rowReader get closed upon completion
• pkg/database: use MaxKeyScanLimit to limit query results
• pkg/database: support for nullable values
• pkg/database: close sql engine when db gets closed
• pkg/database: make use of UseDatabase operation
• pkg/embedded: introduce Snapshot at Store level
• pkg/pgsql: handle empty response and command complete message
• pkg/pgsql: add pgsql server wire protocol stub
• pkg/pgsql: handle parameter status and terminate messages
• pkg/pgsql: fix filename format
• pkg/pgsql: bind immudb sql engine
• pkg/pgsql: use options flag to determine if pgsql server need to be launched
• pkg/pgsql/client: add jackc/pgx pgsql client for testing purpose
• pkg/pgsql/server: limit number of total connections and do not stop server in case of errors
• pkg/pgsql/server: handle an ssl connection request if no certificate is present on server
• pkg/pgsql/server: protect simple query flow with a mutex
• pkg/pgsql/server: enforce reserved statements checks
• pkg/pgsql/server: handle version statement
• pkg/pgsql/server: default error in simplequery loop has error severity
• pkg/pgsql/server: add missing copyright
• pkg/pgsql/server: remove host parameter
• pkg/pgsql/server: move sysdb in session constructor
• pkg/pgsql/server: add debug logging messages, split session handling in multiple files
• pkg/pgsql/server: improve error handling when client message is not recognized
• pkg/pgsql/server: fix connection upgrade pgsql protocol messages
• pkg/pgsql/server: minor fixes and leftovers
• pkg/server: use systemdb as a shared catalog store
• pkg/server: fix db mock
• pkg/server: remove unused options
• pkg/server: remove tls configuration in server
• pkg/server: inject sqlserver in main immudb server
• pkg/server: renamed server reference
• pkg/server: load systemdb before any other db
• pkg/sql: alias overriding datasource name
• pkg/sql: add comment about nested joins
• pkg/sql: refactored AggregatedValue and TypedValue interfaces
• pkg/sql: unify augmented and grouped row readers
• pkg/sql: support for SUM aggregations
• pkg/sql: row reader to support GROUP BY behaviour
• pkg/sql: grammar adjustments to support aggregated columns
• pkg/sql: swap LIMIT and ORDER BY parse ordering
• pkg/sql: many internal adjustments related to name binding
• pkg/sql: ensure use snapshot is on the range of committed txs
• pkg/sql: joint column with explicit table reference
• pkg/sql: upgrade to new store commit api
• pkg/sql: support multiple spacing between statements
• pkg/sql: column descriptors in row readers
• pkg/sql: improve error handling
• pkg/sql: return ErrNoMoreRows when reading
• pkg/sql: towards catalog encapsulation
• pkg/sql: improved null value support
• pkg/sql: order-preserving result set
• pkg/sql: using new KeyReaderSpec
• pkg/sql: joins limited to INNER type and equality comparison against ref table PK
• pkg/sql: row reader used to close the snapshot once reading is completed
• pkg/sql: mapping using ids, ordering and renaming support
• pkg/sql: composite readers
• pkg/sql: wip multiple readers
• pkg/sql: catch store indexing errors
• pkg/sql: add generated sql parser
• pkg/sql: make row values externally accessible
• pkg/sql: remove offset param
• pkg/sql: value-less indexed entries
• pkg/sql: encoded value with pk entry
• pkg/sql: remove alter column stmt
• pkg/sql: inmem catalog with table support
• pkg/sql: inmem catalog
• pkg/sql: catalog construct
• pkg/sql: primary key supported type validation
• pkg/sql: use standardized transaction closures
• pkg/sql: col selector with resolved datasource
• pkg/sql: case insensitive reserved words
• pkg/sql: use token IDENTIFIER
• tools/stream: upgrade stream tools dependencies

Code Refactoring

• pkg/server: tls configuration is moved in command package from server

Features

• display version at startup (#775)
• enhance database size and number of entries metrics to support multiple databases add CORS middleware to metrics HTTP endpoints (#756)
• CREATE TABLE IF NOT EXISTS (#738)
• cmd/immuclient: list and describe tables
• cmd/immuclient: use 'tables' to display the list of tables within selected database
• embedded/sql: use snapshot as state method
• embedded/sql: arithmetic expressions within where clause
• embedded/sql: 'NOT NULL' constraint
• embedded/sql: special case when all selectors are aggregations and there is no matching rows
• embedded/sql: enhanced sql parser to support multi-lined statements
• embedded/sql: INSERT INTO statement
• embedded/sql: LIKE operator support
• embedded/store: uniqueness constraint and de-coupled indexer
• embedded/store: operation
• embedded/tools: initial SQL stress tool (#760)
• pkg/api: sql endpoints for row verification
• pkg/api: noWait mode for sql statements
• pkg/client: row verification
• pkg/client: towards client-side sql support
• pkg/database: towards sql support
• pkg/database: towards integrated sql engine. handling database creation at server level
• pkg/database: list and describe tables
• pkg/database: row verification endpoint
• pkg/pgsql: add tls support
• pkg/pgsql/server: dblist is injected in pgsql server
• pkg/pgsql/server: setup pgsqk error handling
• pkg/pgsql/server: handle nil values
• pkg/server: expose endpoint
• pkg/server: row verification endpoint
• pkg/server: initial integration of sql engine
• pkg/sql: column selector alias support
• pkg/sql: jointRowReader towards supporting joins
• pkg/sql: towards supporting COUNT, SUM, MIN, MAX and AVG
• pkg/sql: towards aggregated values support
• pkg/sql: towards supporting filtered aggregations
• pkg/sql: towards group by and aggregations support
• pkg/sql: noWait for indexing mode
• pkg/sql: improved nullable support
• pkg/sql: towards GROUP BY support
• pkg/sql: implements NOW() function
• pkg/sql: list and describe tables
• pkg/sql: LIMIT clause to determine max number of returned rows
• pkg/sql: queries over older data
• pkg/sql: parameters support
• pkg/sql: initial parameters support
• pkg/sql: towards parameter support
• pkg/sql: support for SELECT * FROM queries
• pkg/sql: row projection
• pkg/sql: towards projected rows
• pkg/sql: auto-commit multi-statement script
• pkg/sql: subquery aliases
• pkg/sql: support for WHERE clause
• pkg/sql: towards row filtering with conditional readers
• pkg/sql: support for boolean values
• pkg/sql: index reloading
• pkg/sql: catalog reloading
• pkg/sql: ASC/DESC row sorting by any indexed column
• pkg/sql: implements CREATE INDEX stmt
• pkg/sql: support of foreign keys of any pk type
• pkg/sql: multiple joins support
• pkg/sql: col selector binding
• pkg/sql: aggregations without row grouping
• pkg/sql: seekable, ordered and filtered table scan
• pkg/sql: ordering in descending mode
• pkg/sql: towards ordering row scans
• pkg/sql: towards query resolution with multiple datasources
• pkg/sql: towards query processing
• pkg/sql: upsert processing
• pkg/sql: towards insert into statement processing
• pkg/sql: table creation with primary key
• pkg/sql: primary key spec
• pkg/sql: initial work on sql engine
• pkg/sql: multi-line scripts
• pkg/sql: snapshot support
• pkg/sql: support for comments
• pkg/sql: support for EXISTS in subquery
• pkg/sql: support for INNER, LEFT and RIGHT joins
• pkg/sql: support for parameters
• pkg/sql: support for system values e.g. TIME
• pkg/sql: aggregated functions
• pkg/sql: use colSelector instead of identifiers
• pkg/sql: expressions parsing
• pkg/sql: multi-db queries
• pkg/sql: multi-row insertion
• pkg/sql: initial support for SELECT statement
• pkg/sql: transactional support
• pkg/sql: support for insertions
• pkg/sql: support table modifications
• pkg/sql: support index creation
• pkg/sql: include column specs
• pkg/sql: partial grammar with multiple statements
• pkg/sql: initial commit for sql support

<a name="cnlc-2.2"></a>