Selecting IPv4 value from IPv6 column returns an empty resultset
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
New
|
Undecided
|
John Z. |
Bug Description
According to documentation, IPv6 supports IPv4 values as well. Inserting both values works just fine, but selecting IPv4 value returns an empty result set.
Example:
drizzle> describe ipaddress_table;
+------
| Field | Type | Null | Default | Default_is_NULL | On_Update |
+------
| addr | IPV6 | YES | | YES | |
+------
1 row in set (0.001061 sec)
drizzle> insert into ipaddress_table values ('10.28.4.10');
Query OK, 1 row affected (0.009366 sec)
drizzle> select * from ipaddress_table;
+------
| addr |
+------
| 000:000:
+------
1 row in set (0.000795 sec)
drizzle> select * from ipaddress_table where addr='10.28.4.10';
Empty set (0.000814 sec)
Related branches
Changed in drizzle: | |
assignee: | nobody → John Z. (johnz) |