Release Date: June 15, 2022 Database Issue Creation
Overview
It is now possible to create new questions in the database question format.
Click the Create Question button on the Question List screen and select a database to create a question.
Schema Definition
There are five basic STEP flows as in the algorithm. The difference from the algorithm is the second step, schema definition. This step defines the tables to be used in the database problem and the output results of the query using those tables.
Entering the test case
We will enter the test case as well as the next algorithm. Enter values for the tables defined in the schema definition.
You can enter values for the table by clicking the "Edit" button. When you press the Edit button, you will see the following modal.
After you have entered the value, press Done to reflect the value you have entered. Press the arrow button to the left of the table name to see a preview of the value you entered.
Solution Entry
In the answer entry step, you will enter a description of the answer and the answer code, just as you would in the algorithm. The difference from the algorithm is the execution part of the test case. You can check the input and output data from the "Check Data" button.
When you click the "Check Data" button, the following dialog box will appear and you can check the data.
Search function of the question list
Overview
The Issue List page has been updated. With this change, you can now share the page you are looking at with other members by sharing the URL (*1). In addition, tabs for issue statuses such as "All" and "Published" have been eliminated, and the same as for the issue format, you can now select an issue from a selection box.
*1. The contents displayed may differ depending on the addition or deletion of an issue, or on the permissions of the member.