Enhanced SQL error messages facilitate faster error fixing

Abstract

Error messages are one of the primary ways software developers communicate with database management systems in SQL query writing tasks. Even though reading and interpreting error messages is a significant part of a software developer’s work, the error messages of SQL compilers have received criticism in terms of readability and their perceived detrimental effects on user experience. Consequently, redesigned SQL error messages have also been proposed to tackle the problems in current error messages. In this study, we examine the effects of enhanced error messages on query writing from several perspectives. The results indicate that when compared to PostgreSQL error messages, the enhanced error messages facilitate faster error fixing, as well as perceived benefits in error finding and error recovery confidence. Our results are applicable in industry, where development time is of significant importance, as well as in educational contexts, where user experience, user confidence, and perceived support in learning play an important role.