Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
versions
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
create table versions ( a tinyint not null, b tinyint not null, c tinyint not null, d tinyint null, version as cast(concat(a, '.', b, '.', c, case when d is null then '' else concat('.', d) end) as varchar(15)) persisted, constraint version_uq unique clustered (a,b,c,d), constraint versions_pk primary key (version), ) ; insert into versions (a,b,c,d) values (15, 8, 0, NULL), (15, 8, 1, NULL), ( 9, 8, 3, NULL), ( 9, 8, 4, NULL), (10, 8, 0, NULL), (13, 15, 0, 1), (13, 15, 1, 1), (13, 0, 0, NULL), (26, 0, 0, 1), (26, 0, 0, 2) ; select * from versions ;
View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 10, absolute service time: 0,19 sec
edit mode
|
history
a
b
c
d
version
1
10
8
0
NULL
10.8.0
2
13
0
0
NULL
13.0.0
3
13
15
0
1
13.15.0.1
4
13
15
1
1
13.15.1.1
5
15
8
0
NULL
15.8.0
6
15
8
1
NULL
15.8.1
7
26
0
0
1
26.0.0.1
8
26
0
0
2
26.0.0.2
9
9
8
3
NULL
9.8.3
10
9
8
4
NULL
9.8.4