Twitter this

Powered by MariaDB Powered by nginx ...

Sqlite2 ON CONFLICT clause

A tech joke is never too far away, perhaps the person that coded this was pretty pissed at the time ...

Seen in the wild

Warning: SQLiteDatabase::queryExec(): near "FUCKYOU": syntax error in /opt/strac/debug_test.php on line 666

Creating this table is not allowed

1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE TABLE Event_Staging_all (
  record_id INTEGER PRIMARY KEY,
  com_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  gps_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  imei bigint(20) NOT NULL,
  switch UNSIGNED int(3) NOT NULL,
  event_id UNSIGNED int(5) NOT NULL,
  latitude UNSIGNED int(10) NOT NULL,
  longitude UNSIGNED int(10) NOT NULL,
  IO UNSIGNED int(3) NOT NULL,
  raw_data BLOB NOT NULL,
  sys_parsed int(3) DEFAULT NULL,
  UNIQUE (imei,raw_data) ON CONFLICT FUCKYOU
);

I tried to IGNORE this from now on instead. Much better now. Zen.

Comments are closed.

recruitment
recruitment
recruitment
recruitment