search

hezean / sustc

Template for project 2 of SUSTech Principles of Database Systems (CS307 / CS213), 23 fall semester.
http://172.18.34.154
MIT License
22 stars 10 forks source link

Fail to disable the triggers. #96

Closed Ray0v0 closed 10 months ago

Ray0v0 commented 10 months ago

Describe your question

In #89, you said the commands like "ALTER TABLE users DISABLE TRIGGER ALL;" is able to run. However, the benchmark throws Exception like this. Does there has any ways to run this command correctly, or it is just banned?

9c3b120aad1098ac76907e449199af9e
WhatWEat commented 10 months ago

似乎是因为你disable了一个system trigger，我们只给予你db的owner，你无法对系统进行更改，你可以尝试插入结束添加trigger，或者一个一个diable你的trigger，又或是不disable触发器，毕竟满分仅需要用批处理和手动commit