Open gaggki opened 5 months ago
可以看下我fork的分支,有增加这块功能https://gitee.com/zhoujin826/goInception
我下载了该分支,但是无法进行二进制安装依旧会有报错
zmix999 @.***> 于2024年2月18日周日 07:12写道:
可以看下我fork的分支,有增加这块功能https://gitee.com/zhoujin826/goInception
— Reply to this email directly, view it on GitHub https://github.com/hanchuanchuan/goInception/issues/634#issuecomment-1950518079, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD3BZSR55XEGCMOYNUCDPF3YUE2NRAVCNFSM6AAAAABC3HN7ZSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJQGUYTQMBXHE . You are receiving this because you authored the thread.Message ID: @.***>
是下载了这个分支在源码编译的吗,或者晚些我上传个二进制包
是在你源码分支上下载编译的,相关的报错我也在你的gitee上提了issue了,你可以看下
zmix999 @.***> 于2024年2月18日周日 17:07写道:
是下载了这个分支在源码编译的吗,或者晚些我上传个二进制包
— Reply to this email directly, view it on GitHub https://github.com/hanchuanchuan/goInception/issues/634#issuecomment-1951036977, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD3BZSRQOBYDCVCJ3SNZWKDYUHAGBAVCNFSM6AAAAABC3HN7ZSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJRGAZTMOJXG4 . You are receiving this because you authored the thread.Message ID: @.***>
代码没上传完成,已重新上传
也上传了二进制程序
描述 对问题简单清晰的描述 row_number() over (partition by)在check的时候不通过会报错,但实际这个语句是可以执行,并且也可以在数据库中执行 重现 模拟重现的步骤 -- 创建表 CREATE TABLE
a
(ID
INT(10) NULL DEFAULT NULL,class
INT(10) NULL DEFAULT NULL,score
INT(10) NULL DEFAULT NULL )COLLATE='utf8_general_ci';-- 插入数据 insert into a values (1,1,90); insert into a values (2,1,70); insert into a values (3,1,90); insert into a values (4,1,80); insert into a values (5,2,100); insert into a values (6,2,80); insert into a values (7,2,110); insert into a values (8,2,80); insert into a values (9,2,80); insert into a values (10,2,60); commit;
!/usr/bin/env python
-- coding: utf-8 --
import pymysql import prettytable as pt
tb = pt.PrettyTable()
sql = '''/--user=fabu;--password=123456;--host=10.211.55.5;--port=3306;--check=1; / inception_magic_start; use test; select *,row_number() over (partition by class order by score desc) rn from a; innception_magic_commit;'''
conn = pymysql.connect(host='127.0.0.1', user='', passwd='', db='', port=4000, charset='utf8mb4')
cur = conn.cursor() ret = cur.execute(sql) result = cur.fetchall() cur.close() conn.close() tb.field_names = [i[0] for i in cur.description] for i in result: tb.add_row(i) print(tb)
使用以上数据以及表结构和脚本执行 环境
参数 可能与问题相关的设置参数