linux-traipu team mailing list archive

["John Z." <johnz@xxxxxxxxxxxxxxxxxxxxx>]

Public bug reported:

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)

** Affects: drizzle
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/956399

Title:
  Selecting IPv4 value from IPv6 column returns an empty resultset

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/956399/+subscriptions