Make difference between views and ordinary spaces #3268
Labels
Comments
Korablev77
added a commit
that referenced
this issue
Mar 26, 2018
Now, space can feature SQL specific option 'view'. In SQL view is a space without any functional parts except for 'SELECT' statement. In this respect, creation of any indexes is prohibited on views; views must have SQL statement; transofrmation from space to view is also banned. It is worth mentioning, that setting 'view' option isn't available via Lua interface. Closes #3268
Korablev77
added a commit
that referenced
this issue
Mar 26, 2018
Now, space can feature SQL specific option 'view'. In SQL view is a space without any functional parts except for 'SELECT' statement. In this respect, creation of any indexes is prohibited on views; views must have SQL statement; transofrmation from space to view is also banned. It is worth mentioning, that setting 'view' option isn't available via Lua interface. Closes #3268
Korablev77
added a commit
that referenced
this issue
Mar 26, 2018
Now, space can feature SQL specific option 'view'. In SQL view is a space without any functional parts except for 'SELECT' statement. In this respect, creation of any indexes is prohibited on views; views must have SQL statement; transofrmation from space to view is also banned. It is worth mentioning, that setting 'view' option isn't available via Lua interface function 'space_create', but possible by straight insertion in _space space. Closes #3268
Korablev77
added a commit
that referenced
this issue
Mar 26, 2018
Now, space can feature SQL specific option 'view'. In SQL view is a space without any functional parts except for 'SELECT' statement. In this respect, creation of any indexes is prohibited on views; views must have SQL statement; transofrmation from space to view is also banned. It is worth mentioning, that setting 'view' option isn't available via Lua interface function 'space_create', but possible by straight insertion in _space space. Closes #3268
Korablev77
added a commit
that referenced
this issue
Mar 27, 2018
Now, space can feature SQL specific option 'view'. In SQL view is a space without any functional parts except for 'SELECT' statement. In this respect, creation of any indexes is prohibited on views; views must have SQL statement; transofrmation from space to view is also banned. It is worth mentioning, that setting 'view' option isn't available via Lua interface function 'space_create', but possible by straight insertion in _space space. Closes #3268
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Currently, spaces which are created via SQL interface feature string of 'CREATE TABLE' statement, which is situated in
space_opts. In SQL also exist views (apart from ordinary spaces). They are represented as space which have nothing except for SQL statement string (i.e. no primary or secondary indexes, no format etc). In order to easily distinguish real spaces and views it is suggested to add tooptsanother one boolean field: 'is_view'. Moreover, lets prohibit to change this property (via Lua interface): views can't become real spaces and visa versa.The text was updated successfully, but these errors were encountered: