An IPv6 column type exists in Drizzle!? How did I miss this!
On Mar 15, 2012, at 2:35 PM, John Z. 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
>
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
