Comments (6)
@liipx
另外一个Sampling data的错误
- 准备表结构和数据
create table soar_test(
id bigint unsigned primary key auto_increment,
v varchar(10) not null default ''
);
insert into soar_test (v)
values ('');
-
输入语句
select * from soar_test;
-
错误日志
2018/10/29 16:30:20.994 [D] [mysql.go:76] Execute SQL with DSN(127.0.0.1:3306/optimizer_osGC5MGrm3tl97k4) : CREATE TABLE `soar_test` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`v` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
2018/10/29 16:30:21.020 [D] [env.go:397] createTable, Start Sampling data from archery.soar_test to optimizer_osGC5MGrm3tl97k4.soar_test ...
2018/10/29 16:30:21.025 [D] [mysql.go:76] Execute SQL with DSN(mysql:3306/archery) : show table status where name = 'soar_test'
2018/10/29 16:30:21.032 [D] [mysql.go:76] Execute SQL with DSN(mysql:3306/archery) : show table status where name = 'soar_test'
2018/10/29 16:30:21.039 [D] [sampling.go:99] SamplingData, tableRows: 1, wantRowsCount: 30000, factor: 30000.000000
2018/10/29 16:30:21.039 [D] [sampling.go:118] Sampling data execute: select DATA_TYPE from information_schema.COLUMNS where TABLE_SCHEMA='optimizer_osGC5MGrm3tl97k4' and TABLE_NAME = 'soar_test'
2018/10/29 16:30:21.046 [E] [sampling.go:227] doSampling Error from optimizer_osGC5MGrm3tl97k4.soar_test: Received #1048 error from MySQL server: "Column 'v' cannot be null"
2018/10/29 16:30:21.046 [D] [sampling.go:215] 1 rows sampling out
from soar.
贴case的时候时候小心泄露隐私数据。
from soar.
贴case的时候时候小心泄露隐私数据。
谢谢提醒,是特意准备的测试数据,库名也是开源的项目测试库。不过问一句wantRowsCount: 30000是可配置还是固定的。
from soar.
wantRowsCount := 300 * common.Config.SamplingStatisticTarget
soar -h | grep -i sampling
-sampling-statistic-target int
SamplingStatisticTarget, 数据采样因子,对应postgres的default_statistics_target (default 100)
from soar.
Received #1048 error from MySQL server: "Column 'v' cannot be null"
Sampling data会把空字符串转换成null?
from soar.
两个case测试都正常,谢谢~
from soar.
Related Issues (20)
- yaml配置schema带有中划线,报错[mysql.go:95] Error 1064 HOT 1
- SQL评分规则LIT.002是否有点问题 HOT 1
- 发现soar对mysql 5.7.32不输出执行计划 HOT 1
- 文档及交流
- [Bug]在macOs版本12.1和go版本1.17.2下, 无法运行
- 关于☠️ 和scalability的疑问
- windows环境下无法编译
- 语法检查与SQL评估 不支持Mysql point 数据类型 HOT 1
- Can NOT run `make tidb`
- [BUG] compress后语句内容tab被替换为了空格
- Add param to specify the sql audit result to a table in database ,for instance,storage in a mysql table for convenience batch get result?
- 有支持oracle的规划和想法吗?
- mac os 报错segmentation fault
- 可以输入指纹SQL来进行评分么?
- 增加论文WeTune提出的rewrite rule
- Vulnerability of dependency "golang.org/x/net" HOT 1
- soar 无法使用,日志如下,请帮忙看下是否是配置问题,谢谢
- 后面是否会支持 ARM 架构的? HOT 1
- 规则column-not-allow-type解析后的报告展示错误
- make编译失败了。
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from soar.