Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

feature: Added support for simple CAST#39

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Open
mlilius wants to merge1 commit intoJavaScriptor:master
base:master
Choose a base branch
Loading
frommlilius:cast-support

Conversation

mlilius
Copy link

This will not handle all versions of CAST but will handle a simple case like CAST(pct*100 AS int)

The query mentioned in#9 was used as the test.

select    concat(dsw_cluster_name,',',logic_pod_name) as event_obj,    concat(dsw_cluster_name,',',logic_pod_name, ' PFC STORM. 详情: ',    '流量突跃 ',    cast(FLOW_RX_BPS_RATE100 as int),    '%(RX)',    '; ',    cast(FLOW_TX_BPS_RATE100 as int),    '%(TX)',    '; PFC 突增 ',    cast(PFC_RX_PPS_RATE*100 as int),    '%(RECV)') as brieffrom SOURCE_BASIC_EVENT_POD_FLOW_AND_PFC_TRENDwhere win_end >= '2020-05-19 21:14:12'    and win_end < '2020-05-20 21:14:12'    and PFC_RX_PPS_RATE >= 100    and (FLOW_RX_BPS_RATE <= -0.2 and FLOW_TX_BPS_RATE <= -0.2)

@albin3
Copy link
Member

hello@mlilius ,CHARACTER SET grammar should be supported in this feature followshttps://dev.mysql.com/doc/refman/5.7/en/cast-functions.html . see examples : "SELECT CAST('test' AS CHAR CHARACTER SET utf8 COLLATE utf8_bin);"

Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

2 participants
@mlilius@albin3

[8]ページ先頭

©2009-2025 Movatter.jp