commented out bits in enum test
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Stewart Smith | ||
Dexter |
Fix Released
|
Medium
|
Stewart Smith |
Bug Description
jay spotted in embedded_Innodb review. comes from main test:
1840 +##
1841 +## Bug #2077
1842 +##
1843 +#create table t1 (a enum(0xE4, '1', '2') not null default 0xE4);
1844 +#show columns from t1;
1845 +#show create table t1;
1846 +#drop table t1;
1847 +
1848 +# Test currently turned off because of this bug:
1849 +# Bug 308841 queries with German umlauts in insert statem
1850 +#
1851 +# Bug #5628 German characters in field-defs will be '?'
1852 +# with some table definitions
1853 +#
1854 +#set names latin1;
1855 +#CREATE TABLE t1 (
1856 +# a INT default 1,
1857 +# b ENUM('value'
1858 +#);
1859 +#show create table t1;
1860 +#show columns from t1;
1861 +#drop table t1;
1862 +
1863 +# Test currently turned off because of this bug:
1864 +# Bug 308841 queries with German umlauts in insert statem
1865 +#CREATE TABLE t1 (c enum('ae'
1866 +#INSERT INTO t1 VALUES ('ä'),(
1867 +#SELECT * FROM t1;
1868 +#DROP TABLE t1;
1869 +
1870 +# Test currently turned off because of this bug:
1871 +# Bug 308841 queries with German umlauts in insert statements fail
1872 +#
1873 +# Bug #6379: ENUM values are incorrectly converted
1874 +#
1875 +# Check latin1 -> utf8 conversion
1876 +#
1877 +#CREATE TABLE t1 (
1878 +# a ENUM('ä','ö','ü') character set utf8 default 'ü'
1879 +#);
1880 +#show create table t1;
1881 +#insert into t1 values ('ä'), ('ö'), ('ü');
1882 +#select a from t1 order by a;
1883 +#drop table t1;
1884 +
1885 +# Test currently turned off because of this bug:
1886 +# Bug 308841 queries with German umlauts in insert statements fail
1887 +#
1888 +# Now check utf8 -> latin1 conversion
1889 +# This test emulates loading a script generated with mysqldump
1890 +#
1891 +#CREATE TABLE t1 (
1892 +# a ENUM('ä
1893 +#);
1894 +#insert into t1 values ('ä'),
1895 +# Now check what has been loaded
1896 +#show create table t1;
1897 +#select a from t1 order by a;
1898 +#drop table t1;
Related branches
- Brian Aker: Approve
- Patrick Crews: Pending requested
- Drizzle Developers: Pending requested
-
Diff: 271 lines (+166/-56)2 files modifiedtests/r/type_enum.result (+100/-0)
tests/t/type_enum.test (+66/-56)
Changed in drizzle: | |
milestone: | 2010-05-24 → 2010-06-07 |
Changed in drizzle: | |
status: | Confirmed → Fix Committed |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |