Yep
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)
Please file a bug. Any value that will be accepted for insert, should
certainly be accepted for where clause too.
henrik
On Thu, Mar 15, 2012 at 9:35 PM, John Z. <[email protected]> wrote:
> Hello,
> I have a table with IPv6 column. Documentation says IPv6 supports IPv4
> values too, so I'm using same column to store both values if needed.
> IPv6 insertion/selection works just fine, however I can't figure out
> proper string format when trying to select by an IPv4 value - it always
> returns an empty result set.
>
> Describe table and some examples follow:
>
>
> drizzle> describe cassandra_cluster;
> +-------+---------+------+---------+-----------------+-----------+
> | Field | Type | Null | Default | Default_is_NULL | On_Update |
> +-------+---------+------+---------+-----------------+-----------+
> | node | IPV6 | NO | | NO | |
> | port | INTEGER | NO | | NO | |
> +-------+---------+------+---------+-----------------+-----------+
>
> drizzle> insert into cassandra_cluster values('::10.28.4.10', 9160);
> Query OK, 1 row affected (0.100422 sec)
>
> drizzle> select * from cassandra_cluster;
> +-----------------------------------------+------+
> | node | port |
> +-----------------------------------------+------+
> | 000:000:000:000:000:000:010.028.004.010 | 9160 |
> +-----------------------------------------+------+
> 1 row in set (0.00042 sec)
>
> drizzle> select * from cassandra_cluster where node='::10.28.4.10';
> Empty set (0.000433 sec)
>
>
>
> Here, I tried various formats for '::10.28.4.10', but all of them failing,
> together with copy-paste of output from select *.
> I tried on IRC, but we concluded that it could be a bug, and I was suggested
> to try here first, before reporting it.
>
> Please, help :-)
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to : [email protected]
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help : https://help.launchpad.net/ListHelp
--
[email protected]
+358-40-8211286 skype: henrik.ingo irc: hingo
www.openlife.cc
My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
