从HGDB 1.3版本开始,瀚高数据库中添加了dual表:
highgo=# select version() from dual;
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select version();
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=#
highgo=# select 1+1 AAA from dual;
aaa
-----
2
(1 row)
highgo=# select 1+1 "AAA" from dual;
AAA
-----
2
(1 row)
highgo=# select 1+1 as "AAA" from dual;
AAA
-----
2
(1 row)
=========================
highgo=# select version() from dual;
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select version();
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=#
highgo=# select 1+1 AAA from dual;
aaa
-----
2
(1 row)
highgo=# select 1+1 "AAA" from dual;
AAA
-----
2
(1 row)
highgo=# select 1+1 as "AAA" from dual;
AAA
-----
2
(1 row)
=========================