Hi!
On Aug 1, 2008, at 3:10 PM, Pete Kruckenberg wrote:
So the BIT operators wouldn't be in the core functionality, but
could be added in (plug-in? UDF?) so they would somehow be
accessible in a query?
If you wanted them, you could just load UDP.
Why am I keen to remove them? Mainly I am looking for methods of
shrinking the parser.
What do the patches do (alternatively, what's special about how
IPADDRESS/IPADDRESSV4 types are handled)?
You can take an ipv4 and store it in 4 bytes, but a v6 requires quite
a bit more. So searching on ipv4 can be much faster.
I'm curious, wow well are BIT operators handled by the (5.1)
optimizer? Would "ip & <NETMASK> = <NETWORK_NUMBER>" ("ip" is a
column) perform anywhere near "BETWEEN(ip,
<RANGE_MIN_IP>,<RANGE_MAX_IP>)"?
Not honestly sure. We have some tests for them, but it wouldn't
surprise me if you could come up with untested syntax.
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
