Showing posts with label Bug. Show all posts
Showing posts with label Bug. Show all posts

Saturday, April 30, 2022

Rise of the AI and ML Era and Privacy Concerns

Rise of the AI and ML Era and Growing Privacy Concerns

I'm no conspiracy theorist like certain CEOs out there but I believe that this whole machine learning (ML) technology could be used with both good and bad intentions if we're not too careful with who we release the technology to. Machine learning has potential to learn our social behaviors and essentially replace our cyber presence. It also has good intensions to be used as a marketing tool to improve sales of a under utilized product as one could hope it to be used.

Wednesday, February 2, 2011

MySQL Temporary Table Bug ERROR #1137

Apparently you can not reference two temporary tables in 5.1 using a simple join.

I was trying to create test environment based on my tables so that I could have a place to advance on this stored routine. The MEMORY storage engine provided me the comfort of performance and the fact that

Saturday, May 22, 2010

MySQL MATCH AGAINST Query ERROR 1191

I came across this problem when I ran into a client who needed Boolean search functionality on his site. The previous query he had was using LIKEs to do the searching on 6 columns. I told him about using a new query that used FULLTEXT indexes and continued about the performance benefits and also overhead this might cause as their data changes overtime. Naturally, I gave him a cronjobs script that basically optimizes the table to help him with maintenance. The problem arose when I implemented the query (Match..Against) I kept on getting:
ERROR 1911 (HY000): Can't find FULLTEXT index matching the column list.