Cannot insert value


#1
CREATE TABLE raw_log (
tracking_type TEXT NOT NULL ENCODING DICT(32),
request_id TEXT NOT NULL ENCODING DICT(32),
client_id TEXT NOT NULL ENCODING DICT(32),
promotion_app_id TEXT NOT NULL ENCODING DICT(32),
order_id TEXT NOT NULL ENCODING DICT(32),
creatives_id TEXT NOT NULL ENCODING DICT(32),
ad_id TEXT NOT NULL ENCODING DICT(32),
app_id TEXT NOT NULL ENCODING DICT(32),
bundle_id TEXT NOT NULL ENCODING DICT(32),
ad_unit_id TEXT NOT NULL ENCODING DICT(32),
predictive_cpm INTEGER NOT NULL,
pay_by TEXT NOT NULL ENCODING DICT(32),
unit_price INTEGER NOT NULL,
ip TEXT NOT NULL ENCODING DICT(32),
os TEXT NOT NULL ENCODING DICT(32),
mac_address TEXT NOT NULL ENCODING DICT(32),
imei TEXT NOT NULL ENCODING DICT(32),
imsi TEXT NOT NULL ENCODING DICT(32),
android_id TEXT NOT NULL ENCODING DICT(32),
advertising_id TEXT NOT NULL ENCODING DICT(32),
idfa TEXT NOT NULL ENCODING DICT(32),
idfv TEXT NOT NULL ENCODING DICT(32),
country TEXT NOT NULL ENCODING DICT(32),
region TEXT NOT NULL ENCODING DICT(32),
city TEXT NOT NULL ENCODING DICT(32),
ab_test_id TEXT NOT NULL ENCODING DICT(32),
ab_test_object_group_id TEXT NOT NULL ENCODING DICT(32),
created_at TIMESTAMP NOT NULL,
latitude REAL NOT NULL,
longitude REAL NOT NULL);
insert into raw_log values ('landing_page_dismissed','2ed28057-5a68-4fcb-97c4-2e9f2bbea944','94309DA4-6BDB-00D1-DC90-A8B1AA3BBEB2','6C0D4F24-7237-A042-42A1-09C57F070133','','34049426-502B-C821-FCAE-93133A95E374','214CC6C0-FFFD-0B2E-672F-2430E7F60B85','0','com.zplay.bbtan','0',30000000,'cpi',2000000,'111.36.184.8','iOS','','','','','','E3756A4E-429E-4CED-B3A7-1156DDFBD4A4','FCFE1D8C-C497-40C5-A9E7-EAC728C1E723','','','','','','2017-08-28 08:33:55',36.0986,120.3719);

Error: Exception: The complexity of matching the regular expression exceeded predefined bounds. Try refactoring the regular expression to make each choice made by the state machine unambiguous. This exception is thrown to prevent “eternal” matches that take an indefinite period time to locate.

If I set the last two floating number to 36.01, 120.37, it succeeds.


#2

Hi

I believe it is having issues with the empty quotes ''

Please try with ' '

regards