Opened 7 years ago

Closed 7 years ago

#1761 closed defect (fixed)

Problem creating struct type

Reported by: Dimitar Misev Owned by: dkamov
Priority: major Milestone: 9.7
Component: qlparser Version: development
Keywords: Cc: Bang Pham Huu
Complexity: Medium

Description (last modified by Dimitar Misev)

Create a test type in rasdaman with this command:

rasql -q 'CREATE TYPE V2_monthly_cci_uncert_combined_beta_bounds_test_Cell AS ( band0 float ,band1 float ,band2 float ,band3 float ,band4 float ,band5 float ,band6 float ,band7 float ,band8 float ,band9 float ,band10 float ,band11 float ,band12 float ,band13 float ,band14 float ,band15 float ,band16 float ,band17 float ,band18 float ,band19 float ,band20 float ,band21 float ,band22 float ,band23 float ,band24 float ,band25 float ,band26 float ,band27 float ,band28 float ,band29 float ,band30 float ,band31 float ,band32 float ,band33 float ,band34 float ,band35 float ,band36 float ,band37 float ,band38 float ,band39 float ,band40 float ,band41 float ,band42 float ,band43 float ,band44 float ,band45 float ,band46 float ,band47 float ,band48 float ,band49 float ,band50 float ,band51 float ,band52 float ,band53 float ,band54 float ,band55 float ,band56 float ,band57 float ,band58 float ,band59 float ,band60 float ,band61 float ,band62 float ,band63 float ,band64 float ,band65 float ,band66 float ,band67 float ,band68 float ,band69 float ,band70 float ,band71 float ,band72 float ,band73 float ,band74 float ,band75 float ,band76 float ,band77 float ,band78 float ,band79 float ,band80 float ,band81 float ,band82 float ,band83 float ,band84 float ,band85 float ,band86 float ,band87 float ,band88 float ,band89 float ,band90 float )' —user rasadmin —passwd rasadmin

Afterwards, try to execute the same command again. This will result in an error because the type already exists. However this error is not very clear. For example in the rasdaman logs (to see the last log after executing the query do ls -ltr /opt/rasdaman/log/rasserver.*)

[INFO] - 2018-05-02 18:34:42,456: Request: 'CREATE TYPE V2_monthly_cci_uncert_combined_beta_bounds_test_Cell AS ( band0 float ,band1 float ,band2 float ,band3 float ,band4 float ,band5 float ,band6 float ,band7 float ,band8 float ,band9 float ,band10 float ,band11 float ,band12 float ,band13 float ,band14 float ,band15 float ,band16 float ,band17 float ,band18 float ,band19 float ,band20 float ,band21 float ,band22 float ,band23 float ,band24 float ,band25 float ,band26 float ,band27 float ,band28 float ,band29 float ,band30 float ,band31 float ,band32 float ,band33 float ,band34 float ,band35 float ,band36 float ,band37 float ,band38 float ,band39 float ,band40 float ,band41 float ,band42 float ,band43 float ,band44 float ,band45 float ,band46 float ,band47 float ,band48 float ,band49 float ,band50 float ,band51 float ,band52 float ,band53 float ,band54 float ,band55 float ,band56 float ,band57 float ,band58 float ,band59 float ,band60 float ,band61 float ,band62 float ,band63 float ,band64 float ,band65 float ,band66 float ,band67 float ,band68 float ,band69 float ,band70 float ,band71 float ,band72 float ,band73 float ,band74 float ,band75 float ,band76 float ,band77 float ,band78 float ,band79 float ,band80 float ,band81 float ,band82 float ,band83 float ,band84 float ,band85 float ,band86 float ,band87 float ,band88 float ,band89 float ,band90 float )'… parsing… checking semantics… Error number: 969 Token: V2_monthly_cci_uncert_combined_beta_bounds_test_Cell Line: 1 Column: 1

The log should rather say "Type with name X already exists, cannot create a new type with the same name."

To narrow down where this error is logged or thrown try searching for the error number 969.

Change History (3)

comment:1 by Dimitar Misev, 7 years ago

Milestone: 9.69.7

comment:2 by Dimitar Misev, 7 years ago

Description: modified (diff)
Owner: changed from bbell to dkamov
Status: newassigned

comment:3 by Dimitar Misev, 7 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.