Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

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?

link comment (2) accepted answer
asked 2 years ago
tanyona
8
Thank you for this bug report! - [Level:8]CUBRID 2 years ago
Glad to have helped. - [Level:1]tanyona 2 years ago
97 Answers
1

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.

link comment (0)
answered 2 years ago
newpcraft
51
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: