Skip to content
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 our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: 当给decimal属性的字段赋值字符串默认值时, 在执行order by算子的时候导致崩溃 #1792

Closed
3 tasks done
haitaoguan opened this issue May 18, 2023 · 1 comment · Fixed by #1807
Closed
3 tasks done
Labels
A-bug Something isn't working

Comments

@haitaoguan
Copy link
Collaborator

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

#0  0x00007f31944b3b7c in free () from /lib64/libc.so.6
#1  0x0000000001680daf in Tianmu::types::BString::~BString() ()
#2  0x0000000001680de2 in Tianmu::types::BString::~BString() ()
#3  0x000000000162501b in Tianmu::core::TempTable::OrderByAndMaterialize(std::vector<Tianmu::core::SortDescriptor, std::allocator<Tianmu::core::SortDescriptor> >&, long, long, Tianmu::core::ResultSender*) ()
#4  0x0000000001617534 in Tianmu::core::TempTable::Materialize(bool, Tianmu::core::ResultSender*, bool) ()
#5  0x00000000015e940e in Tianmu::core::Engine::Execute(THD*, LEX*, Query_result*, st_select_lex_unit*) ()
#6  0x00000000015ea0ea in Tianmu::core::Engine::HandleSelect(THD*, LEX*, Query_result*&, unsigned long, int&, int&, int&, int) ()
#7  0x00000000017efe70 in Tianmu::DBHandler::ha_my_tianmu_query(THD*, LEX*, Query_result*&, unsigned long, int&, int&, int&, int) ()
#8  0x0000000000fc14f8 in execute_sqlcom_select(THD*, TABLE_LIST*) ()
#9  0x0000000000fc8b13 in mysql_execute_command(THD*, bool) ()
#10 0x0000000000fcad35 in mysql_parse(THD*, Parser_state*) ()
#11 0x0000000000fcc339 in dispatch_command(THD*, COM_DATA const*, enum_server_command) ()
#12 0x0000000000fcd057 in do_command(THD*) ()
#13 0x0000000001085a48 in handle_connection ()
#14 0x000000000155cf84 in pfs_spawn_thread ()
#15 0x00007f3196ba5ea5 in start_thread () from /lib64/libpthread.so.0
#16 0x00007f319452cb0d in clone () from /lib64/libc.so.6

Expected behavior

No response

How To Reproduce

No response

Environment

./mysqld Ver 5.7.36-StoneDB-v1.0.3 for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: c3931fe
Last commit time: Date: Thu May 11 11:28:54 2023 +0800
Build time: Date: Thu May 11 13:44:51 CST 2023

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@haitaoguan haitaoguan added the A-bug Something isn't working label May 18, 2023
@haitaoguan haitaoguan changed the title bug: mysqld crash when execute TempTable::OrderByAndMaterialize bug: The instance occasionally crashes when using order by. May 18, 2023
@adofsauron adofsauron changed the title bug: The instance occasionally crashes when using order by. bug: 当给decimal属性的字段赋值字符串默认值时, 在执行order by算子的时候导致崩溃 May 19, 2023
@stoneatom stoneatom deleted a comment from adofsauron May 19, 2023
@stoneatom stoneatom deleted a comment from adofsauron May 19, 2023
@stoneatom stoneatom deleted a comment from adofsauron May 19, 2023
@adofsauron
Copy link
Collaborator

因为上边重要的记录被人删除了,为了追踪这个问题,将重要的分析记录做记录。
对于与mysql/innodb做100%兼容的事情,例如支持当前问题单的这个写法,是一种通用的问题,由于现在无论产品规划还是技术规划,既然没有明确的优先级,有没有需求的边界划分,所以这种写法的支持性是比是否要做这个事情更为重要的问题。
对于这个问题,兼容100%将导致难以想象的资源耗费。如果有这个资源可以投入的话,如果没有那就必须进行边界控制。
这个问题尤其重要,谁要是把这东西给删了,那就自己把这个100%的兼容性给解决出来!

@mergify mergify bot closed this as completed in #1807 May 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants