Subject | UNION field BLOB SUB_TYPE 0 with different charset |
---|---|
Author | b0bik2000 |
Post date | 2011-06-15T10:46:37Z |
I'm not sure is it feature / bug, but for sure such behavior is strange:
I've database with two tables. First table contains blob sub_type 1 charset none field, the second table contains blob sub_type 1 charset win1250 field. Database charset is WIN1250.
Under 2.0.3:
SELECT
DESCR
FROM TABLE1
UNION
SELECT
DESCR
FROM TABLE2
throws:
Engine Code : 335544378
Engine Message :
feature is not supported
But:
SELECT
DESCR
FROM TABLE2
UNION
SELECT
DESCR
FROM TABLE1
works : )
Under 2.1.4 both query are OK.
If it is already fixed bug (in 2.0.6) - forgive me.
b
I've database with two tables. First table contains blob sub_type 1 charset none field, the second table contains blob sub_type 1 charset win1250 field. Database charset is WIN1250.
Under 2.0.3:
SELECT
DESCR
FROM TABLE1
UNION
SELECT
DESCR
FROM TABLE2
throws:
Engine Code : 335544378
Engine Message :
feature is not supported
But:
SELECT
DESCR
FROM TABLE2
UNION
SELECT
DESCR
FROM TABLE1
works : )
Under 2.1.4 both query are OK.
If it is already fixed bug (in 2.0.6) - forgive me.
b