Creating multiple tables using CUBRID Manager
I'm using CUBRID Manager 8.4.1.2019. I right-click on a database and select New Query Editor. I then paste the following SQL
-- Create the ART Repository, version 2.3 -- IMPORTANT: -- after running this script, ALSO RUN the tables_xxx.sql script for your database (found in the quartz directory) -- NOTES: -- for sql server, replace "timestamp" data type with "datetime" -- for sql server 2000/2005 also replace "date" data type with "datetime" -- UPGRADING: -- if you are upgrading, don't use this script. run the scripts available in the upgrade directory -- run the scripts one at a time to upgrade to newer versions. e.g. from 2.0 to 2.1, then 2.1 to 2.2 etc. -- if you want to create a new repository in place of an existing one, uncomment the DROP statements -- you can use a text editor to replace "-- DROP" with "DROP" to accomplish this -- ------------------------------------------------ -- ART_SETTINGS -- Stores miscellaneous settings CREATE TABLE ART_SETTINGS ( SETTING_NAME VARCHAR(50) NOT NULL, SETTING_VALUE VARCHAR(2000), PRIMARY KEY (SETTING_NAME) ); -- ART_USERS -- Stores user info -- ADMIN_LEVEL: 0= normal user, 5 = normal user who can schedule jobs -- 10 = junior admin, 30 = mid admin, 40 = admin, 80 = senior admin, 100 = super admin CREATE TABLE ART_USERS ( USERNAME VARCHAR(15) NOT NULL PRIMARY KEY, PASSWORD VARCHAR(200) NOT NULL, HASHING_ALGORITHM VARCHAR(20) NOT NULL, FULL_NAME VARCHAR(40), EMAIL VARCHAR(40), ADMIN_LEVEL INTEGER, DEFAULT_OBJECT_GROUP INTEGER, CAN_CHANGE_PASSWORD VARCHAR(1), ACTIVE_STATUS VARCHAR(1), UPDATE_DATE DATE );
The first table is created, but the second table is not created. The log only says 1'th SQL create operation successfully completed.[0.009 second]. Would anyone know why the second create statement doesn't run?
Great! You've just caught a bug in CUBRID Manager. In this particular case CM didn't ignore ' (single quote) symbol which is found in your SQL comment while it should have.
-- UPGRADING: -- if you are upgrading, don't ...
We'll fix this bug asap and roll out the update. Your CM will autoupdate then.
If you want to solve this problem without waiting for a patch, please remove ' (single quote), then you can run a query successfully.
Thank for this bug report.