Selecting IPv4 value from IPv6 column returns an empty resultset

Bug #956399 reported by John Z.
6
This bug affects 1 person
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:000:000:000:000:010.028.004.010 |
+-----------------------------------------+
1 row in set (0.000795 sec)

drizzle> select * from ipaddress_table where addr='10.28.4.10';
Empty set (0.000814 sec)

John Z. (johnz)
Changed in drizzle:
assignee: nobody → John Z. (johnz)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.