Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#50 Cannot coerce / type conversion

open
nobody
5
2011-01-12
2011-01-12
No

I've been testing cubrid and attempted to make it pass test cases in a database abstraction library but have been having trouble with 'Cannot coerce ' errors:

Jan 12 08:00:35 julia test: MV(4)::*WARNING*{Error: DBMS, -494, Semantic: Cannot coerce X'ffd8ffe000104a46494600010200006400640000ffec00114475636b79... to type blob. insert into test_data (test_varchar20, test_char, test_float, test_sint, test_bigint, test_int, test_boolean, test_numeric, test_date, test_timestamp, test_bit, test_binary, test_unicode) values ('test', 'ab', 1.54000, 32767, 9223372036854775807, 50, B'1', 1.33, date '01/01/2007', timestamp '04:00:01 PM 01/01/2007', B'11', X'ffd8ffe000104a464

I've noticed the following document:
https://sourceforge.net/apps/trac/cubrid/wiki/SqlExtension2/ImplicitTypeConversion

Will cubrid support better type conversion? I would expect to be able to do the following queries:
INSERT INTO test (test_blob, test_bool, test_bit) VALUES (X'ffd8ffe', '1', '01');
INSERT INTO test (test_blob, test_bool, test_bit) VALUES (X'104a', 1, '01');

where
test_blob BLOB
test_bool BIT(1)
test_bit BIT(2)

Thanks!

Discussion

  • Esen Sagynov
    Esen Sagynov
    2011-01-13

    This issue will be resolved in our upcoming CUBRID 3.2, which will be released in February. We are currently developing this feature. Keep tuned!