HyperSQL User Guide
v
Two Phase Locking with Snapshot Isolation ........................................................................ 30
Lock Contention in 2PL .................................................................................................. 31
MVCC ......................................................................................................................... 31
Choosing the Transaction Model ....................................................................................... 32
Schema and Database Change ........................................................................................... 32
Simultaneous Access to Tables ......................................................................................... 33
Session and Transaction Control Statements ................................................................................ 33
4. Schemas and Database Objects ...................................................................................................... 40
Overview .............................................................................................................................. 40
Schemas and Schema Objects ................................................................................................... 40
Names and References .................................................................................................... 41
Character Sets ................................................................................................................ 41
Collations ...................................................................................................................... 42
Distinct Types ................................................................................................................ 42
Domains ....................................................................................................................... 42
Number Sequences ......................................................................................................... 42
Tables .......................................................................................................................... 44
Views ........................................................................................................................... 44
Constraints .................................................................................................................... 45
Assertions ..................................................................................................................... 46
Triggers ........................................................................................................................ 46
Routines ....................................................................................................................... 46
Indexes ......................................................................................................................... 46
Statements for Schema Definition and Manipulation ..................................................................... 46
Common Elements and Statements .................................................................................... 46
Renaming Objects .......................................................................................................... 48
Commenting Objects ....................................................................................................... 48
Schema Creation ............................................................................................................ 48
Table Creation ............................................................................................................... 49
Table Manipulation ......................................................................................................... 54
View Creation and Manipulation ....................................................................................... 59
Domain Creation and Manipulation .................................................................................... 60
Trigger Creation ............................................................................................................. 61
Routine Creation ............................................................................................................ 62
Sequence Creation .......................................................................................................... 64
SQL Procedure Statement ................................................................................................ 66
Other Schema Object Creation .......................................................................................... 66
The Information Schema .......................................................................................................... 69
Predefined Character Sets, Collations and Domains ............................................................... 69
Views in INFORMATION SCHEMA ................................................................................ 70
5. Text Tables ................................................................................................................................ 76
Overview .............................................................................................................................. 76
The Implementation ................................................................................................................ 76
Definition of Tables ........................................................................................................ 76
Scope and Reassignment .................................................................................................. 76
Null Values in Columns of Text Tables .............................................................................. 77
Configuration ................................................................................................................. 77
Disconnecting Text Tables ............................................................................................... 78
Text File Usage ..................................................................................................................... 79
Text File Global Properties ...................................................................................................... 79
Transactions .......................................................................................................................... 79
6. Access Control ........................................................................................................................... 81
Overview .............................................................................................................................. 81
Authorizations and Access Control ............................................................................................ 82
