Cannot execute prepared statements with NUMERIC data type

Details

Description

I created a table:

CREATE TABLE t (
	x NUMERIC(38, 12)
);

And I wanted to execute the prepared statement:

INSERT INTO t (x) VALUES (?)

I click Analyze, select the data type to NUMERIC, then enter a value for the field.

Regardless of the value I give it, it displays the "String index out of range: -1" error.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Esen Sagynov added a comment -

Is it CM issue or engine? Please verify and comment.

Show
Esen Sagynov added a comment - Is it CM issue or engine? Please verify and comment.
Hide
Permalink
Veliscu Ovidiu added a comment -

It is a CM issue. I executed lots of prepared statements with Numeric data type using the python driver.

Show
Veliscu Ovidiu added a comment - It is a CM issue. I executed lots of prepared statements with Numeric data type using the python driver.
Hide
Permalink
付雷 (Inactive) added a comment - - edited

NUMERIC type should input precision and scale
Add default precision and scale to type NUMERIC, the "NUMERIC" in the select combo is "NUMERIC(38,12)" now,user can modify it if necessary!

Show
付雷 (Inactive) added a comment - - edited NUMERIC type should input precision and scale Add default precision and scale to type NUMERIC, the "NUMERIC" in the select combo is "NUMERIC(38,12)" now,user can modify it if necessary!
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2349 and CQB8.4.1.2343

Show
高艳铭 added a comment - Fixed in CM8.4.1.2349 and CQB8.4.1.2343

People

  • Assignee:
    高艳铭
    Reporter:
    Veliscu Ovidiu
Vote (0)
Watch (4)

Dates

  • Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
Not Specified
Original Estimate - Not Specified
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
1h 36m
Time Spent - 1 hour, 36 minutes