Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CM8.4.3.201211, CQB8.4.3.201211
-
Component/s: CUBRID Manager
-
Labels:
-
Environment:
Windows 7, CUBRID Manager 8.4.1.2294, CUBRID 8.4.1.6004
Description
I have created 2 tables (users and actions), inserted 3 and 5 records in them and created a view using:
CREATE VIEW actions_users as
SELECT
actions.action_id AS action_id,
actions.user_id AS user_id,
actions.page_id AS page_id,
actions.action_type_id AS action_type_id,
actions.action_when AS action_when,
users.user_name AS username,
users.user_nickname AS nickname
FROM
actions LEFT JOIN users ON actions.user_id = users.user_id
ORDER BY actions.action_when ASC
I have exported everything to sql format and I have attached the files. The values for actions_users.sql are incorrect and will fail if all the files are imported into another database.
Also, the sql export creates for some reason the table actions_users also.
1.Create the table("actions_users") is a bug(it is a view in fact),it won't be generate in schema ddl now
2.As can not import the view data to any other table or view , view data won't be export now
In a word ,view only generate a create ddl if select the "view" button in the export wizard