MAC Address matching should be case insensitive about staticdhcpd

[GoogleCodeExporter]

I'm afraid I'll have to dismiss this one.

In cases where staticDHCPd has full introspection support over a database, like 
INI, case-insensitivity is the default. In other cases, it's up to the DBMS to 
provide that functionality.

In SQLite, you can specify 'NOCASE' on the column-definition to enable 
case-insensitive matching within libsqlite3; see 
http://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensit
ive-when-string-comparing for details.

I'll add that to the default column definitions, though, since the related 
commentary doesn't show a performance-hit. (Case-sensitive matching is usually 
faster, which is why most engines do it)

Original comment by red.hamsterx on 14 Sep 2013 at 5:20

[GoogleCodeExporter]

Fair enough.  For now I'm handling it on the data collection front end that 
populates the db entries but I'll also look into the NOCASE setting for sqlite3 
which would be more robust. 

Thanks,
Ken

Original comment by [email protected] on 14 Sep 2013 at 6:33

[GoogleCodeExporter]

I'll add a CASE_INSENSITIVE option to supporting engines that will use their 
(unfortunately all incompatible) lower-casing functions on the column-value. 
That should satisfy both cases, though building the table such that there's a 
case-insensitive index will be faster in virtually all situations.

Original comment by red.hamsterx on 14 Sep 2013 at 6:37

[GoogleCodeExporter]

All right, CASE_INSENSITIVE_MACS(=False) is now part of the codebase (untested, 
since I'm on a phone, so expect the usual syntax error stuff). NOCASE is still 
a better choice for SQLite, though.

Original comment by red.hamsterx on 14 Sep 2013 at 7:18

[GoogleCodeExporter]

Documentation updated and options present in 2.0.0-beta-8, which will be 
available for download in the next few minutes.

Thanks again, Ken!

Original comment by red.hamsterx on 16 Sep 2013 at 3:35

[GoogleCodeExporter]

Original comment by red.hamsterx on 16 Sep 2013 at 3:35

• Changed state: Fixed