Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CM8.4.1.201206, CQB8.4.1.201206
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Labels:
Description
When writing the following query (using alias in the statement), SQL서식화/Table_name/Column_name auto-displaying is not working at all.
SELECT s.svc_no,d.db_nm, d.modr_emp_no from db_db d inner join db_svc s on d.svc_no = s.svc_no where s.svc_no = 123;
SQL 서식화 is a quite important feature to developers and DBAs too.
If it is hard to support because of ATLR's problem, why don't we have an alternative to give a SQL syntax template and table schema information in a separate window?
Issue Links
- relates to
-
TOOLS-853
Doesn't support some SQL on using formatting SQL function
-
Activity
Hide
Modify bugs about the below SQL format:
SELECT SUM((CAST(snflag AS BIGINT) = 0)) ,
SUM(CAST((flag & 32) AS BIGINT)) / 32 ,
SUM(CAST((flag & 512) AS BIGINT)) / 512,
COUNT(snflag)
FROM mals
WHERE (
threid ='<41ff5cf6d1fac98e1c9224@x.com>'
AND mlsn != 3038
AND 'kpark' != ''
)
using index idx_ils_2(+);
SELECT SUM((CAST(snflag AS BIGINT) = 0)) ,
SUM(CAST((flag & 32) AS BIGINT)) / 32 ,
SUM(CAST((flag & 512) AS BIGINT)) / 512,
COUNT(snflag)
FROM mls
WHERE (
thrid ='<41ff5cf6de9cec98e1c9224@xtem.com>'
AND masn != 3338
AND 'kark' != ''
)
using index idx_mls_2(+) ;
select SUM((CAST(snflag as BIGINT) = 0)),SUM(CAST((flag & 32) as BIGINT)) / 32,SUM(CAST((flag & 512) as BIGINT)) / 512,COUNT(snflag) from mals where (foldsn not in (?,?,?,?,?) and (snflag = ?) and ? != ?) using index idx_ils_4(+);
Show
庞启仁
added a comment - - edited Modify bugs about the below SQL format:
SELECT SUM((CAST(snflag AS BIGINT) = 0)) ,
SUM(CAST((flag & 32) AS BIGINT)) / 32 ,
SUM(CAST((flag & 512) AS BIGINT)) / 512,
COUNT(snflag)
FROM mals
WHERE (
threid ='<41ff5cf6d1fac98e1c9224@x.com>'
AND mlsn != 3038
AND 'kpark' != ''
)
using index idx_ils_2(+);
SELECT SUM((CAST(snflag AS BIGINT) = 0)) ,
SUM(CAST((flag & 32) AS BIGINT)) / 32 ,
SUM(CAST((flag & 512) AS BIGINT)) / 512,
COUNT(snflag)
FROM mls
WHERE (
thrid ='<41ff5cf6de9cec98e1c9224@xtem.com>'
AND masn != 3338
AND 'kark' != ''
)
using index idx_mls_2(+) ;
select SUM((CAST(snflag as BIGINT) = 0)),SUM(CAST((flag & 32) as BIGINT)) / 32,SUM(CAST((flag & 512) as BIGINT)) / 512,COUNT(snflag) from mals where (foldsn not in (?,?,?,?,?) and (snflag = ?) and ? != ?) using index idx_ils_4(+);
SQL formatting problems