Thread: BUG #13514: PostgreSQL backend process crashes on jsonb_object_agg()
BUG #13514: PostgreSQL backend process crashes on jsonb_object_agg()
From
b.yordanov2@gmail.com
Date:
The following bug has been logged on the website:
Bug reference: 13514
Logged by: Boyko
Email address: b.yordanov2@gmail.com
PostgreSQL version: 9.5alpha1
Operating system: CentOS release 6.4
Description:
jsonb_object_agg() appears to fail when the second argument (in this case
attributes->z->'tt') is a nonexistent jsonb column (there is
attributes->z->'t' but not 'tt').
Query below:
< 2015-07-22 17:24:38.910 EEST >LOG: server process (PID 31493) was
terminated by signal 11: Segmentation fault
< 2015-07-22 17:24:38.910 EEST >DETAIL: Failed process was running: select
distinct attributes->z->'g'->'t' as title,attributes->z->'g'->'so' as
sort_order,
jsonb_object_agg((attributes->z->'s')::text,(attributes->z->'tt')::text) as
members from categories, jsonb_object_keys(attributes) as z where id = 4 and
jsonb_exists(attributes->z, 'g') group by attributes->z->'g' order by
sort_order desc;
< 2015-07-22 17:24:38.910 EEST >LOG: terminating any other active server
processes
attributes structure (and data) below:
# select jsonb_pretty(attributes) from categories where id = 4;
-[ RECORD 1 ]+-------------------------------------------------------
jsonb_pretty | { +
| "tip": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "tip", +
| "t": "Тип", +
| "v": [ +
| { +
| "s": "laptop", +
| "t": "ÐÐÐТÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "netbuk", +
| "t": "ÐÐТÐУÐ", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-b-g-n-ac", +
| "t": "802.11 b/g/n/ac", +
| "st": 1 +
| }, +
| { +
| "s": "ultrabuk", +
| "t": "УÐТРÐÐУÐ", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-ac-b-g-n", +
| "t": "802.11 ac/b/g/n", +
| "st": 1 +
| }, +
| { +
| "s": "mobilen", +
| "t": "ÐÐÐÐÐÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "macbook-pro", +
| "t": "MacBook Pro", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "vid": { +
| "h": 0, +
| "s": "vid", +
| "t": "Ðид", +
| "v": [ +
| { +
| "s": "ruter", +
| "t": "РУТÐÐ ", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "hdmi": { +
| "h": 0, +
| "s": "hdmi", +
| "t": "Hdmi", +
| "v": [ +
| { +
| "s": "micro", +
| "t": "micro", +
| "st": 1 +
| }, +
| { +
| "s": "yes", +
| "t": "yes", +
| "st": 1 +
| }, +
| { +
| "s": "no", +
| "t": "no", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "teglo": { +
| "h": 0, +
| "s": "teglo", +
| "t": "Тегло", +
| "v": [ +
| { +
| "s": "0-980-kg", +
| "t": "0.980 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-200-kg", +
| "t": "2.200 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-000-kg", +
| "t": "2.000 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-990-kg", +
| "t": "1.990 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-200-kg", +
| "t": "1.200 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-300-kg", +
| "t": "2.300 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-280-kg", +
| "t": "1.280 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-150-kg", +
| "t": "2.150 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-190-kg", +
| "t": "2.190 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-500-kg", +
| "t": "2.500 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-150-kg", +
| "t": "1.150 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-400-kg", +
| "t": "2.400 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-350-kg", +
| "t": "2.350 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-450-kg", +
| "t": "2.450 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-500-kg", +
| "t": "1.500 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-230-kg", +
| "t": "2.230 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-180-kg", +
| "t": "1.180 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-100-kg", +
| "t": "2.100 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-800-kg", +
| "t": "2.800 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-170-kg", +
| "t": "1.170 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-250-kg", +
| "t": "1.250 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-300-kg", +
| "t": "1.300 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-600-kg", +
| "t": "1.600 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-900-kg", +
| "t": "2.900 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-080-kg", +
| "t": "2.080 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-600-kg", +
| "t": "2.600 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-800-kg", +
| "t": "1.800 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-750-kg", +
| "t": "1.750 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-700-kg", +
| "t": "2.700 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-160-kg", +
| "t": "1.160 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-350-kg", +
| "t": "1.350 kg", +
| "st": 1 +
| }, +
| { +
| "s": "3-000-kg", +
| "t": "3.000 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-950-kg", +
| "t": "1.950 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-700-kg", +
| "t": "1.700 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-380-kg", +
| "t": "2.380 kg", +
| "st": 1 +
| }, +
| { +
| "s": "3-100-kg", +
| "t": "3.100 kg", +
| "st": 1 +
| }, +
| { +
| "s": "3-200-kg", +
| "t": "3.200 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-980-kg", +
| "t": "1.980 kg", +
| "st": 1 +
| }, +
| { +
| "s": "3-400-kg", +
| "t": "3.400 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-390-kg", +
| "t": "1.390 kg", +
| "st": 1 +
| }, +
| { +
| "s": "4-050-kg", +
| "t": "4.050 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-570-kg", +
| "t": "1.570 kg", +
| "st": 1 +
| }, +
| { +
| "s": "4-300-kg", +
| "t": "4.300 kg", +
| "st": 1 +
| }, +
| { +
| "s": "4-200-kg", +
| "t": "4.200 kg", +
| "st": 1 +
| }, +
| { +
| "s": "2-020-kg", +
| "t": "2.020 kg", +
| "st": 1 +
| }, +
| { +
| "s": "4-100-kg", +
| "t": "4.100 kg", +
| "st": 1 +
| }, +
| { +
| "s": "1-320-kg", +
| "t": "1.320 kg", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tsvyat": { +
| "h": 0, +
| "s": "tsvyat", +
| "t": "ЦвÑÑ", +
| "v": [ +
| { +
| "s": "sin", +
| "t": "СÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "cheren", +
| "t": "ЧÐÐ ÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "byal", +
| "t": "ÐЯÐ", +
| "st": 1 +
| }, +
| { +
| "s": "siv", +
| "t": "СÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "rozov", +
| "t": "Ð ÐÐÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "kafyav", +
| "t": "ÐÐФЯÐ", +
| "st": 1 +
| }, +
| { +
| "s": "cherven", +
| "t": "ЧÐÐ ÐÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "zlatist", +
| "t": "ÐÐÐТÐСТ", +
| "st": 1 +
| }, +
| { +
| "s": "oranzhev", +
| "t": "ÐÐ ÐÐÐÐÐ", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "skorost": { +
| "h": 0, +
| "s": "skorost", +
| "t": "СкоÑоÑÑ", +
| "v": [ +
| { +
| "s": "n300-ac450", +
| "t": "N300 + AC450", +
| "st": 1 +
| }, +
| { +
| "s": "300-450mbit", +
| "t": "300+450Mbit", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "sigurnost": { +
| "h": 1, +
| "s": "sigurnost", +
| "t": "СигÑÑноÑÑ", +
| "v": [ +
| { +
| "s": "wpa-wpa2", +
| "t": "WPA,WPA2", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "garantsiya": { +
| "h": 0, +
| "s": "garantsiya", +
| "t": "ÐаÑанÑиÑ", +
| "v": [ +
| { +
| "s": "24-mesetsa", +
| "t": "24 ÐÐСÐЦÐ", +
| "st": 1 +
| }, +
| { +
| "s": "36-mesetsa", +
| "t": "36 ÐÐСÐЦÐ", +
| "st": 1 +
| }, +
| { +
| "s": "12-mesetsa", +
| "t": "12 ÐÐСÐЦÐ", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "ueb-kamera": { +
| "h": 0, +
| "s": "ueb-kamera", +
| "t": "Уеб камеÑа", +
| "v": [ +
| { +
| "s": "yes", +
| "t": "yes", +
| "st": 1 +
| }, +
| { +
| "s": "hd", +
| "t": "HD", +
| "st": 1 +
| }, +
| { +
| "s": "0-9-mpx", +
| "t": "0.9 MPx", +
| "st": 1 +
| }, +
| { +
| "s": "2-mp", +
| "t": "2 MP", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "broy-portove": { +
| "g": { +
| "t": "ÐоÑÑове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "broy-portove", +
| "t": "ÐÑой поÑÑове", +
| "v": [ +
| { +
| "s": "4-br", +
| "t": "4 ÐÐ ", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "proizvoditel": { +
| "h": 0, +
| "s": "proizvoditel", +
| "t": "ÐÑоизводиÑел", +
| "v": [ +
| { +
| "s": "asus", +
| "t": "ASUS", +
| "st": 1 +
| }, +
| { +
| "s": "lenovo", +
| "t": "LENOVO", +
| "st": 1 +
| }, +
| { +
| "s": "toshiba", +
| "t": "TOSHIBA", +
| "st": 1 +
| }, +
| { +
| "s": "acer", +
| "t": "ACER", +
| "st": 1 +
| }, +
| { +
| "s": "hp", +
| "t": "HP", +
| "st": 1 +
| }, +
| { +
| "s": "dell", +
| "t": "DELL", +
| "st": 1 +
| }, +
| { +
| "s": "packard", +
| "t": "PACKARD", +
| "st": 1 +
| }, +
| { +
| "s": "adaptor", +
| "t": "адапÑоÑ", +
| "st": 1 +
| }, +
| { +
| "s": "apple", +
| "t": "APPLE", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tip-bateriya": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "tip-bateriya", +
| "t": "Тип баÑеÑиÑ", +
| "v": [ +
| { +
| "s": "2-cell-li-polymer", +
| "t": "2-CELL LI-POLYMER", +
| "st": 1 +
| }, +
| { +
| "s": "4-cell-li-ion", +
| "t": "4-CELL LI-ION", +
| "st": 1 +
| }, +
| { +
| "s": "3-cell-li-ion", +
| "t": "3-CELL LI-ION", +
| "st": 1 +
| }, +
| { +
| "s": "3-cell-li-polymer", +
| "t": "3-CELL LI-POLYMER", +
| "st": 1 +
| }, +
| { +
| "s": "2-cell-li-ion", +
| "t": "2-CELL LI-ION", +
| "st": 1 +
| }, +
| { +
| "s": "6-cell-li-ion", +
| "t": "6-CELL LI-ION", +
| "st": 1 +
| }, +
| { +
| "s": "4-cell-li-prismatic", +
| "t": "4-CELL LI-PRISMATIC", +
| "st": 1 +
| }, +
| { +
| "s": "2-cell", +
| "t": "2-CELL", +
| "st": 1 +
| }, +
| { +
| "s": "li-polymer", +
| "t": "LI-POLYMER", +
| "st": 1 +
| }, +
| { +
| "s": "8-cell-li-ion", +
| "t": "8-CELL LI-ION", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "drugi-portove": { +
| "g": { +
| "t": "ÐоÑÑове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "drugi-portove", +
| "t": "ÐÑÑги поÑÑове", +
| "v": [ +
| { +
| "s": "card-reader", +
| "t": "CARD READER", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-lan-vga", +
| "t": "CARD READER, LAN, VGA", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-lan", +
| "t": "CARD READER, LAN", +
| "st": 1 +
| }, +
| { +
| "s": "microsd-slot", +
| "t": "microSD ÑлоÑ", +
| "st": 1 +
| }, +
| { +
| "s": "lan-in-dock-micro-sd-slot", +
| "t": "LAN in DOCK, micro SD slot", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-lan-mini-dp", +
| "t": "CARD READER, LAN, MINI DP", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-thunderbolt", +
| "t": "CARD READER, THUNDERBOLT", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-lan-spdif", +
| "t": "CARD READER, LAN, SPDIF", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-lan-vga-mini-dp", +
| "t": "CARD READER, LAN, VGA, mini DP",+
| "st": 1 +
| }, +
| { +
| "s": "card-reader-2-x-thunderbolt", +
| "t": "CARD READER,2 x THUNDERBOLT", +
| "st": 1 +
| }, +
| { +
| "s": "card-reader-mini-dp", +
| "t": "CARD READER, MINI DP", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tip-hard-disk": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 1, +
| "s": "tip-hard-disk", +
| "t": "Тип Ñ
аÑд диÑк", +
| "v": [ +
| { +
| "s": "ssd", +
| "t": "SSD", +
| "st": 1 +
| }, +
| { +
| "s": "sata", +
| "t": "SATA", +
| "st": 1 +
| }, +
| { +
| "s": "sshd", +
| "t": "SSHD", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tip-protsesor": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "tip-protsesor", +
| "t": "Тип пÑоÑеÑоÑ", +
| "v": [ +
| { +
| "s": "intel-atom-quad-core-z3735f", +
| "t": "INTEL ATOM QUAD-CORE Z3735F", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-n2840-dual-core", +
| "t": "INTEL CELERON N2840 DUAL CORE", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-n2815-dual-core", +
| "t": "INTEL CELERON N2815 Dual Core", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-n2830-dual-core", +
| "t": "INTEL CELERON N2830 DUAL CORE", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-2955u", +
| "t": "INTEL CELERON 2955U", +
| "st": 1 +
| }, +
| { +
| "s": "amd-dual-core-e1-6010", +
| "t": "AMD DUAL-CORE E1-6010", +
| "st": 1 +
| }, +
| { +
| "s": "amd-dual-core-e1-2100", +
| "t": "AMD DUAL-CORE E1-2100", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-n3530-quad", +
| "t": "INTEL PENTIUM N3530 QUAD", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-n2940-quad", +
| "t": "INTEL CELERON N2940 QUAD", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-3556u", +
| "t": "INTEL PENTIUM 3556U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-celeron-n2930-quad", +
| "t": "INTEL CELERON N2930 QUAD", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-n3520-quad", +
| "t": "INTEL PENTIUM N3520 QUAD", +
| "st": 1 +
| }, +
| { +
| "s": "amd-quad-core-a4-5000", +
| "t": "AMD QUAD-CORE A4-5000", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-n3540-quad", +
| "t": "INTEL PENTIUM N3540 QUAD", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-2117u", +
| "t": "INTEL PENTIUM 2117U", +
| "st": 1 +
| }, +
| { +
| "s": "amd-quad-core-a8-6410", +
| "t": "AMD QUAD-CORE A8-6410", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-3558u", +
| "t": "INTEL PENTIUM 3558U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-3550m", +
| "t": "INTEL PENTIUM 3550M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-3217u", +
| "t": "INTEL CORE i3-3217U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-atom-quad-core-z3735g", +
| "t": "INTEL ATOM QUAD-CORE Z3735G", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-2020m", +
| "t": "INTEL PENTIUM 2020M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-pentium-3560m", +
| "t": "INTEL PENTIUM 3560M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-quad-core-a4-6210", +
| "t": "AMD QUAD-CORE A4-6210", +
| "st": 1 +
| }, +
| { +
| "s": "intel-atom-quad-core-z3775", +
| "t": "INTEL ATOM QUAD-CORE Z3775", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-4005u", +
| "t": "INTEL CORE i3-4005U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-4030u", +
| "t": "INTEL CORE i3-4030U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-atom-quad-core-z3745", +
| "t": "INTEL ATOM QUAD-CORE Z3745", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-4010u", +
| "t": "INTEL CORE i3-4010U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-3120m", +
| "t": "INTEL CORE i3-3120M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-4000m", +
| "t": "INTEL CORE i3-4000M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4200u", +
| "t": "INTEL CORE i5-4200U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-3337u", +
| "t": "INTEL CORE i5-3337U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4210u", +
| "t": "INTEL CORE i5-4210U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-5010u", +
| "t": "INTEL CORE i3-5010U", +
| "st": 1 +
| }, +
| { +
| "s": "amd-quad-core-a10-7300", +
| "t": "AMD QUAD-CORE A10-7300", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4210m", +
| "t": "INTEL CORE i5-4210M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4510u", +
| "t": "INTEL CORE i7-4510U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-5200u", +
| "t": "INTEL CORE i5-5200U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4200h", +
| "t": "INTEL CORE i5-4200H", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4500u", +
| "t": "INTEL CORE i7-4500U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-m-5y10", +
| "t": "INTEL CORE M-5Y10", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i3-5005u", +
| "t": "INTEL CORE i3-5005U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-5500u", +
| "t": "INTEL CORE i7-5500U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4710hq", +
| "t": "INTEL CORE i7-4710HQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4700mq", +
| "t": "INTEL CORE i7-4700MQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4260u", +
| "t": "INTEL CORE i5-4260U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4710mq", +
| "t": "INTEL CORE i7-4710MQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4210h", +
| "t": "INTEL CORE i5-4210H", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4702mq", +
| "t": "INTEL CORE i7-4702MQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4720hq", +
| "t": "INTEL CORE i7-4720HQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-5250u", +
| "t": "INTEL CORE i5-5250U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4700hq", +
| "t": "INTEL CORE i7-4700HQ", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-m-5y71", +
| "t": "INTEL CORE M-5Y71", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4288u", +
| "t": "INTEL CORE i5-4288U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4258u", +
| "t": "INTEL CORE i5-4258U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7", +
| "t": "INTEL CORE i7", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-4308u", +
| "t": "INTEL CORE i5-4308U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i5-5257u", +
| "t": "INTEL CORE i5-5257U", +
| "st": 1 +
| }, +
| { +
| "s": "intel-core-i7-4860hq", +
| "t": "INTEL CORE i7-4860HQ", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tip-ram-pamet": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "tip-ram-pamet", +
| "t": "Тип ram памеÑ", +
| "v": [ +
| { +
| "s": "ddr-3l", +
| "t": "DDR 3L", +
| "st": 1 +
| }, +
| { +
| "s": "ddr-3", +
| "t": "DDR 3", +
| "st": 1 +
| }, +
| { +
| "s": "ddr-31l", +
| "t": "DDR 31L", +
| "st": 1 +
| }, +
| { +
| "s": "ddr-31", +
| "t": "DDR 31", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "kapatsitet-hdd": { +
| "h": 0, +
| "s": "kapatsitet-hdd", +
| "t": "ÐапаÑиÑÐµÑ hdd", +
| "v": [ +
| { +
| "s": "500-gb", +
| "t": "500 GB", +
| "st": 1 +
| }, +
| { +
| "s": "750-gb", +
| "t": "750 GB", +
| "st": 1 +
| }, +
| { +
| "s": "1000-gb", +
| "t": "1000 GB", +
| "st": 1 +
| }, +
| { +
| "s": "1500-gb", +
| "t": "1500 GB", +
| "st": 1 +
| }, +
| { +
| "s": "2000-gb", +
| "t": "2000 GB", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "kapatsitet-ram": { +
| "g": { +
| "t": "ÐапаÑиÑеÑи", +
| "so": 1 +
| }, +
| "h": 1, +
| "s": "kapatsitet-ram", +
| "t": "ÐапаÑиÑÐµÑ ram", +
| "v": [ +
| { +
| "s": "2-gb", +
| "t": "2 GB", +
| "st": 1 +
| }, +
| { +
| "s": "4-gb", +
| "t": "4 GB", +
| "st": 1 +
| }, +
| { +
| "s": "6-gb", +
| "t": "6 GB", +
| "st": 1 +
| }, +
| { +
| "s": "8-gb", +
| "t": "8 GB", +
| "st": 1 +
| }, +
| { +
| "s": "1-gb", +
| "t": "1 GB", +
| "st": 1 +
| }, +
| { +
| "s": "12-gb", +
| "t": "12 GB", +
| "st": 1 +
| }, +
| { +
| "s": "16-gb", +
| "t": "16 GB", +
| "st": 1 +
| }, +
| { +
| "s": "40-gb", +
| "t": "40 GB", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "kapatsitet-ssd": { +
| "g": { +
| "t": "ÐапаÑиÑеÑи", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "kapatsitet-ssd", +
| "t": "ÐапаÑиÑÐµÑ ssd", +
| "v": [ +
| { +
| "s": "32-gb", +
| "t": "32 GB", +
| "st": 1 +
| }, +
| { +
| "s": "16-gb", +
| "t": "16 GB", +
| "st": 1 +
| }, +
| { +
| "s": "128-gb", +
| "t": "128 GB", +
| "st": 1 +
| }, +
| { +
| "s": "64-gb", +
| "t": "64 GB", +
| "st": 1 +
| }, +
| { +
| "s": "24-gb", +
| "t": "24 GB", +
| "st": 1 +
| }, +
| { +
| "s": "256-gb", +
| "t": "256 GB", +
| "st": 1 +
| }, +
| { +
| "s": "120-gb", +
| "t": "120 GB", +
| "st": 1 +
| }, +
| { +
| "s": "512-gb", +
| "t": "512 GB", +
| "st": 1 +
| }, +
| { +
| "s": "8-gb", +
| "t": "8 GB", +
| "st": 1 +
| }, +
| { +
| "s": "80-gb", +
| "t": "80 GB", +
| "st": 1 +
| }, +
| { +
| "s": "640-gb", +
| "t": "640 GB", +
| "st": 1 +
| }, +
| { +
| "s": "240-gb", +
| "t": "240 GB", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "broy-usb-portove": { +
| "h": 0, +
| "s": "broy-usb-portove", +
| "t": "ÐÑой usb поÑÑове", +
| "v": [ +
| { +
| "s": "2-x-usb-2-0", +
| "t": "2 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "1-x-usb-3-0-2-x-usb-2-0", +
| "t": "1 x USB 3.0, 2 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "2-x-usb-3-0", +
| "t": "2 x USB 3.0", +
| "st": 1 +
| }, +
| { +
| "s": "1-x-usb-3-0-1-x-usb-2-0", +
| "t": "1 x USB 3.0, 1 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "3-x-usb-2-0", +
| "t": "3 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "2-x-usb-3-0-1-x-usb-2-0", +
| "t": "2 x USB 3.0, 1 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "1-x-usb-2-0-1-x-micro-usb-2-0", +
| "t": "1 x USB 2.0, 1 x micro USB 2.0",+
| "st": 1 +
| }, +
| { +
| "s": "2-x-usb-3-0-2-x-usb-2-0", +
| "t": "2 x USB 3.0, 2 x USB 2.0", +
| "st": 1 +
| }, +
| { +
| "s": "1-x-usb-3-0-1-x-micro-usb-2-0", +
| "t": "1 x USB 3.0, 1 x micro USB 2.0",+
| "st": 1 +
| }, +
| { +
| "s": "3-x-usb-3-0", +
| "t": "3 x USB 3.0", +
| "st": 1 +
| }, +
| { +
| "s": "1-x-usb-3-0-1-x-usb-2-0-micro", +
| "t": "1 x USB 3.0, 1 x USB 2.0,micro",+
| "st": 1 +
| }, +
| { +
| "s": "4-x-usb-3-0", +
| "t": "4 x USB 3.0", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "razmer-v-inchove": { +
| "h": 0, +
| "s": "razmer-v-inchove", +
| "t": "Ð Ð°Ð·Ð¼ÐµÑ Ð² инÑове", +
| "v": [ +
| { +
| "s": "15-6", +
| "t": "15.6 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "17-2", +
| "t": "17.2 \\\"", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "bezzhichen-adaptor": { +
| "h": 0, +
| "s": "bezzhichen-adaptor", +
| "t": "ÐезжиÑен адапÑоÑ", +
| "v": [ +
| { +
| "s": "802-11-a-g-n-bluetooth", +
| "t": "802.11 a/g/n, BLUETOOTH", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-b-g-n-bluetooth", +
| "t": "802.11 b/g/n/, Bluetooth", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-a-b-g-n-bluetooth", +
| "t": "802.11 a/b/g/n, BLUETOOTH", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-b-g-n", +
| "t": "802.11 b/g/n", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-b-g-n-bluetooth-4-0", +
| "t": "802.11 b/g/n, Bluetooth 4.0", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-a-b-g-n-ac-bluetooth", +
| "t": "802.11 a/b/g/n/ac, BLUETOOTH", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-b-g-n-ac-bluetooth", +
| "t": "802.11 b/g/n/ac, Bluetooth", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-g-n-ac-bluetooth", +
| "t": "802.11 g/n/ac, BLUETOOTH", +
| "st": 1 +
| }, +
| { +
| "s": "802-11ac-bluetooth", +
| "t": "802.11ac, Bluetooth", +
| "st": 1 +
| }, +
| { +
| "s": "802-11-a-b-g-n-bluetooth-4-0", +
| "t": "802.11 a/b/g/n, BLUETOOTH 4.0", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "optichno-ustroystvo": { +
| "h": 0, +
| "s": "optichno-ustroystvo", +
| "t": "ÐпÑиÑно ÑÑÑÑойÑÑво", +
| "v": [ +
| { +
| "s": "nyama", +
| "t": "ÐЯÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "no", +
| "t": "no", +
| "st": 1 +
| }, +
| { +
| "s": "dvd-rw", +
| "t": "DVD±RW", +
| "st": 1 +
| }, +
| { +
| "s": "external-dvd-rw", +
| "t": "EXTERNAL DVD±RW", +
| "st": 1 +
| }, +
| { +
| "s": "bd-re", +
| "t": "BD-RE", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tip-grafichna-karta": { +
| "g": { +
| "t": "Типове", +
| "so": 1 +
| }, +
| "h": 0, +
| "s": "tip-grafichna-karta", +
| "t": "Тип гÑаÑиÑна каÑÑа", +
| "v": [ +
| { +
| "s": "intel-hd-graphics", +
| "t": "INTEL HD GRAPHICS", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r2", +
| "t": "AMD RADEON R2", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-8210", +
| "t": "AMD RADEON HD 8210", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-810m", +
| "t": "NVIDIA GEFORCE 810M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-8330", +
| "t": "AMD RADEON HD 8330", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-8670m", +
| "t": "AMD RADEON HD 8670M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r5", +
| "t": "AMD RADEON R5", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r5-m240", +
| "t": "AMD RADEON R5 M240", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-820m", +
| "t": "NVIDIA GEFORCE 820M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-4000", +
| "t": "INTEL HD GRAPHICS 4000", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r5-m230", +
| "t": "AMD RADEON R5 M230", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gt-740m", +
| "t": "NVIDIA GEFORCE GT 740M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-8570m", +
| "t": "AMD RADEON HD 8570M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-7670m", +
| "t": "AMD RADEON HD 7670M", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-830m", +
| "t": "NVIDIA GEFORCE 830M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-4400", +
| "t": "INTEL HD GRAPHICS 4400", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-840m", +
| "t": "NVIDIA GEFORCE 840M", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-710m", +
| "t": "NVIDIA GEFORCE 710M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-hd-8750m", +
| "t": "AMD RADEON HD 8750M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-4600", +
| "t": "INTEL HD GRAPHICS 4600", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r7-m260", +
| "t": "AMD RADEON R7 M260", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r7-m265", +
| "t": "AMD RADEON R7 M265", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-850m", +
| "t": "NVIDIA GEFORCE GTX 850M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-5300", +
| "t": "INTEL HD GRAPHICS 5300", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-5500", +
| "t": "INTEL HD GRAPHICS 5500", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gt-750m-x2", +
| "t": "NVIDIA GEFORCE GT 750M x2", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-860m", +
| "t": "NVIDIA GEFORCE GTX 860M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-5000", +
| "t": "INTEL HD GRAPHICS 5000", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gt-755m-x2", +
| "t": "NVIDIA GEFORCE GT 755M x2", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gt-750m", +
| "t": "NVIDIA GEFORCE GT 750M", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-960m", +
| "t": "NVIDIA GEFORCE GTX 960M", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r7-m270", +
| "t": "AMD RADEON R7 M270", +
| "st": 1 +
| }, +
| { +
| "s": "amd-radeon-r9-m265x", +
| "t": "AMD RADEON R9 M265X", +
| "st": 1 +
| }, +
| { +
| "s": "intel-hd-graphics-6000", +
| "t": "Intel HD Graphics 6000", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-870m", +
| "t": "NVIDIA GEFORCE GTX 870M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-iris-graphics-5100", +
| "t": "Intel Iris Graphics 5100", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-970m", +
| "t": "NVIDIA GEFORCE GTX 970M", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-880m", +
| "t": "NVIDIA GEFORCE GTX 880M", +
| "st": 1 +
| }, +
| { +
| "s": "intel-iris-graphics-6100", +
| "t": "Intel Iris Graphics 6100", +
| "st": 1 +
| }, +
| { +
| "s": "nvidia-geforce-gtx-980m", +
| "t": "NVIDIA GEFORCE GTX 980M", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "operatsionna-sistema": { +
| "h": 0, +
| "s": "operatsionna-sistema", +
| "t": "ÐпеÑаÑионна ÑиÑÑема", +
| "v": [ +
| { +
| "s": "windows-8-1", +
| "t": "WINDOWS 8.1", +
| "st": 1 +
| }, +
| { +
| "s": "windows-8", +
| "t": "WINDOWS 8", +
| "st": 1 +
| }, +
| { +
| "s": "chrome-os", +
| "t": "CHROME OS", +
| "st": 1 +
| }, +
| { +
| "s": "no", +
| "t": "no", +
| "st": 1 +
| }, +
| { +
| "s": "os-x-mountain-lion", +
| "t": "OS X Mountain Lion", +
| "st": 1 +
| }, +
| { +
| "s": "os-x-mavericks", +
| "t": "OS X Mavericks", +
| "st": 1 +
| }, +
| { +
| "s": "os-x-yosemite", +
| "t": "OS X Yosemite", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "razmer-na-ekrana-v-sm": { +
| "h": 0, +
| "s": "razmer-na-ekrana-v-sm", +
| "t": "Ð Ð°Ð·Ð¼ÐµÑ Ð½Ð° екÑана в Ñм", +
| "v": [ +
| { +
| "s": "29-5-sm", +
| "t": "29.5 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "39-6-sm", +
| "t": "39.6 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "25-7-sm", +
| "t": "25.7 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "36-9-sm", +
| "t": "36.9 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "33-8-sm", +
| "t": "33.8 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "43-9-sm", +
| "t": "43.9 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "33-7-sm", +
| "t": "33.7 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "31-8-sm", +
| "t": "31.8 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "35-6-sm", +
| "t": "35.6 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "33-3-sm", +
| "t": "33.3 Ñм", +
| "st": 1 +
| }, +
| { +
| "s": "39-1-sm", +
| "t": "39.1 Ñм", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "savmestimost-drayveri": { +
| "h": 0, +
| "s": "savmestimost-drayveri", +
| "t": "СÑвмеÑÑимоÑÑ Ð´ÑайвеÑи", +
| "v": [ +
| { +
| "s": "windows-7-windows-8-1", +
| "t": "WINDOWS 7, WINDOWS 8.1", +
| "st": 1 +
| }, +
| { +
| "s": "windows-8-1-64", +
| "t": "WINDOWS 8.1 64", +
| "st": 1 +
| }, +
| { +
| "s": "windows-7-64-8-1-64", +
| "t": "WINDOWS 7 64 /8.1 64", +
| "st": 1 +
| }, +
| { +
| "s": "windows-8-64-8-1-64", +
| "t": "WINDOWS 8 64 /8.1 64", +
| "st": 1 +
| }, +
| { +
| "s": "windows-8-64", +
| "t": "WINDOWS 8 64", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "chestota-na-protsesora": { +
| "h": 0, +
| "s": "chestota-na-protsesora", +
| "t": "ЧеÑÑоÑа на пÑоÑеÑоÑа", +
| "v": [ +
| { +
| "s": "1-33-1-83-ghz", +
| "t": "1.33 - 1.83 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-16-2-58-ghz", +
| "t": "2.16 - 2.58 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-86-2-13-ghz", +
| "t": "1.86 - 2.13 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-16-2-41-ghz", +
| "t": "2.16 - 2.41 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-40-ghz", +
| "t": "1.40 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-35-ghz", +
| "t": "1.35 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-00-ghz", +
| "t": "1.00 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-83-2-25-ghz", +
| "t": "1.83 - 2.25 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-70-ghz", +
| "t": "1.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-83-2-16-ghz", +
| "t": "1.83 - 2.16 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-17-2-42-ghz", +
| "t": "2.17 - 2.42 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-50-ghz", +
| "t": "1.50 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-16-2-66-ghz", +
| "t": "2.16 - 2.66 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-80-ghz", +
| "t": "1.80 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-00-2-40-ghz", +
| "t": "2.00 - 2.40 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-30-ghz", +
| "t": "2.30 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-40-ghz", +
| "t": "2.40 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-46-2-39-ghz", +
| "t": "1.46 - 2.39 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-90-ghz", +
| "t": "1.90 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-33-1-86-ghz", +
| "t": "1.33 - 1.86 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-50-ghz", +
| "t": "2.50 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-60-2-60-ghz", +
| "t": "1.60 - 2.60 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-80-2-70-ghz", +
| "t": "1.80 - 2.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-70-2-70-ghz", +
| "t": "1.70 - 2.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-10-ghz", +
| "t": "2.10 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-90-3-20-ghz", +
| "t": "1.90 - 3.20 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-60-3-20-ghz", +
| "t": "2.60 - 3.20 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-00-3-10-ghz", +
| "t": "2.00 - 3.10 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-20-2-70-ghz", +
| "t": "2.20 - 2.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-80-3-40-ghz", +
| "t": "2.80 - 3.40 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-80-3-00-ghz", +
| "t": "1.80 - 3.00 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "0-80-2-00-ghz", +
| "t": "0.80 - 2.00 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-0-ghz", +
| "t": "2.0 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-40-3-00-ghz", +
| "t": "2.40 - 3.00 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-50-3-50-ghz", +
| "t": "2.50 - 3.50 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-40-3-40-ghz", +
| "t": "2.40 - 3.40 GHZ", +
| "st": 1 +
| }, +
| { +
| "s": "1-40-2-70-ghz", +
| "t": "1.40 - 2.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-90-3-50-ghz", +
| "t": "2.90 - 3.50 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-20-3-20-ghz", +
| "t": "2.20 - 3.20 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-60-3-60-ghz", +
| "t": "2.60 - 3.60 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-60-2-70-ghz", +
| "t": "1.60 - 2.70 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "1-20-2-90-ghz", +
| "t": "1.20 - 2.90 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-60-3-10-ghz", +
| "t": "2.60 - 3.10 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-40-2-90-ghz", +
| "t": "2.40 - 2.90 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-20-3-40-ghz", +
| "t": "2.20 - 3.40 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-80-3-30-ghz", +
| "t": "2.80 - 3.30 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-70-3-10-ghz", +
| "t": "2.70 - 3.10 GHz", +
| "st": 1 +
| }, +
| { +
| "s": "2-40-3-60-ghz", +
| "t": "2.40 - 3.60 GHz", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "razmer-na-ekrana-v-inch": { +
| "h": 0, +
| "s": "razmer-na-ekrana-v-inch", +
| "t": "Ð Ð°Ð·Ð¼ÐµÑ Ð½Ð° екÑана в inch", +
| "v": [ +
| { +
| "s": "11-6", +
| "t": "11.6 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "15-6", +
| "t": "15.6 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "10-1", +
| "t": "10.1 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "13-3", +
| "t": "13.3 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "17-3", +
| "t": "17.3 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "12-5", +
| "t": "12.5 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "14-0", +
| "t": "14.0 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "15-4", +
| "t": "15.4 \\\"", +
| "st": 1 +
| }, +
| { +
| "s": "17-2", +
| "t": "17.2 \\\"", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "tehnologiya-na-displeya": { +
| "h": 0, +
| "s": "tehnologiya-na-displeya", +
| "t": "ТеÑ
Ð½Ð¾Ð»Ð¾Ð³Ð¸Ñ Ð½Ð° диÑплеÑ", +
| "v": [ +
| { +
| "s": "led", +
| "t": "LED", +
| "st": 1 +
| }, +
| { +
| "s": "led-hd", +
| "t": "LED HD", +
| "st": 1 +
| }, +
| { +
| "s": "led-matov", +
| "t": "LED, ÐÐТÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "hd-led", +
| "t": "HD LED", +
| "st": 1 +
| }, +
| { +
| "s": "touchscreen", +
| "t": "TOUCHSCREEN", +
| "st": 1 +
| }, +
| { +
| "s": "ips-touch", +
| "t": "IPS, Touch", +
| "st": 1 +
| }, +
| { +
| "s": "ips-multi-touch", +
| "t": "IPS Multi-touch", +
| "st": 1 +
| }, +
| { +
| "s": "led-touch", +
| "t": "LED, TOUCH", +
| "st": 1 +
| }, +
| { +
| "s": "ips-matov", +
| "t": "IPS, ÐÐТÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "ips-led", +
| "t": "IPS, LED", +
| "st": 1 +
| }, +
| { +
| "s": "fhd-led-matov", +
| "t": "FHD LED, ÐÐТÐÐ", +
| "st": 1 +
| }, +
| { +
| "s": "ips", +
| "t": "IPS", +
| "st": 1 +
| }, +
| { +
| "s": "multi-touch-led-ips", +
| "t": "MULTI TOUCH LED IPS", +
| "st": 1 +
| }, +
| { +
| "s": "ips-led-touch", +
| "t": "IPS LED touch", +
| "st": 1 +
| }, +
| { +
| "s": "ips-uhd", +
| "t": "IPS UHD", +
| "st": 1 +
| }, +
| { +
| "s": "ultra-hd-touchscreen", +
| "t": "Ultra HD Touchscreen", +
| "st": 1 +
| }, +
| { +
| "s": "retina-led-ips", +
| "t": "RETINA LED IPS", +
| "st": 1 +
| }, +
| { +
| "s": "igzo-led", +
| "t": "IGZO, LED", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "rezolyutsiya-na-displeya": { +
| "h": 0, +
| "s": "rezolyutsiya-na-displeya", +
| "t": "РезолÑÑÐ¸Ñ Ð½Ð° диÑплеÑ", +
| "v": [ +
| { +
| "s": "1366x768", +
| "t": "1366x768", +
| "st": 1 +
| }, +
| { +
| "s": "1920x1080", +
| "t": "1920x1080", +
| "st": 1 +
| }, +
| { +
| "s": "1600x900", +
| "t": "1600x900", +
| "st": 1 +
| }, +
| { +
| "s": "1280x800", +
| "t": "1280x800", +
| "st": 1 +
| }, +
| { +
| "s": "1600-x-900", +
| "t": "1600 X 900", +
| "st": 1 +
| }, +
| { +
| "s": "133x768", +
| "t": "133x768", +
| "st": 1 +
| }, +
| { +
| "s": "1440x900", +
| "t": "1440x900", +
| "st": 1 +
| }, +
| { +
| "s": "3200x1800", +
| "t": "3200x1800", +
| "st": 1 +
| }, +
| { +
| "s": "3840x2160", +
| "t": "3840x2160", +
| "st": 1 +
| }, +
| { +
| "s": "2560x1600", +
| "t": "2560x1600", +
| "st": 1 +
| }, +
| { +
| "s": "2880x1800", +
| "t": "2880x1800", +
| "st": 1 +
| }, +
| { +
| "s": "2560x1440", +
| "t": "2560x1440", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| }, +
| "obem-na-grafichnata-pamet": { +
| "h": 0, +
| "s": "obem-na-grafichnata-pamet", +
| "t": "Ðбем на гÑаÑиÑнаÑа памеÑ", +
| "v": [ +
| { +
| "s": "shared", +
| "t": "shared", +
| "st": 1 +
| }, +
| { +
| "s": "1-gb", +
| "t": "1 GB", +
| "st": 1 +
| }, +
| { +
| "s": "2-gb", +
| "t": "2 GB", +
| "st": 1 +
| }, +
| { +
| "s": "4-gb", +
| "t": "4 GB", +
| "st": 1 +
| }, +
| { +
| "s": "2-gb-gddr5", +
| "t": "2 GB GDDR5", +
| "st": 1 +
| }, +
| { +
| "s": "4-gb-gddr5", +
| "t": "4 GB GDDR5", +
| "st": 1 +
| }, +
| { +
| "s": "3-gb-gddr5", +
| "t": "3 GB GDDR5", +
| "st": 1 +
| }, +
| { +
| "s": "8-gb-gddr5", +
| "t": "8 GB GDDR5", +
| "st": 1 +
| }, +
| { +
| "s": "40-gb", +
| "t": "40 GB", +
| "st": 1 +
| }, +
| { +
| "s": "40-gb-gddr5", +
| "t": "40 GB GDDR5", +
| "st": 1 +
| } +
| ], +
| "st": 1 +
| } +
| }
b.yordanov2@gmail.com writes:
> jsonb_object_agg() appears to fail when the second argument (in this case
> attributes->z->'tt') is a nonexistent jsonb column (there is
> attributes->z->'t' but not 'tt').
Seems to be failure to handle nulls properly. The attached patch stops
the crash for me, but I've not checked to see if the results are "right",
nor scouted around to see if there are similar bugs nearby.
regards, tom lane
diff --git a/src/backend/utils/adt/jsonb.c b/src/backend/utils/adt/jsonb.c
index e689722..b82bde0 100644
*** a/src/backend/utils/adt/jsonb.c
--- b/src/backend/utils/adt/jsonb.c
*************** jsonb_agg_transfn(PG_FUNCTION_ARGS)
*** 1606,1612 ****
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, false, &elem, tcategory, outfuncoid, false);
jbelem = JsonbValueToJsonb(elem.res);
--- 1606,1612 ----
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, PG_ARGISNULL(1), &elem, tcategory, outfuncoid, false);
jbelem = JsonbValueToJsonb(elem.res);
*************** jsonb_object_agg_transfn(PG_FUNCTION_ARG
*** 1759,1765 ****
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, false, &elem, tcategory, outfuncoid, true);
jbkey = JsonbValueToJsonb(elem.res);
--- 1759,1765 ----
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, PG_ARGISNULL(1), &elem, tcategory, outfuncoid, true);
jbkey = JsonbValueToJsonb(elem.res);
*************** jsonb_object_agg_transfn(PG_FUNCTION_ARG
*** 1777,1783 ****
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, false, &elem, tcategory, outfuncoid, false);
jbval = JsonbValueToJsonb(elem.res);
--- 1777,1783 ----
memset(&elem, 0, sizeof(JsonbInState));
! datum_to_jsonb(val, PG_ARGISNULL(2), &elem, tcategory, outfuncoid, false);
jbval = JsonbValueToJsonb(elem.res);
On 07/22/2015 11:14 PM, Tom Lane wrote: > b.yordanov2@gmail.com writes: >> jsonb_object_agg() appears to fail when the second argument (in this case >> attributes->z->'tt') is a nonexistent jsonb column (there is >> attributes->z->'t' but not 'tt'). > Seems to be failure to handle nulls properly. The attached patch stops > the crash for me, but I've not checked to see if the results are "right", > nor scouted around to see if there are similar bugs nearby. > > I think there is possibly a bit more work to do w.r.t. nulls. I will check on it. cheers andrew
Andrew Dunstan <andrew@dunslane.net> writes:
> On 07/22/2015 11:14 PM, Tom Lane wrote:
>> Seems to be failure to handle nulls properly. The attached patch stops
>> the crash for me, but I've not checked to see if the results are "right",
>> nor scouted around to see if there are similar bugs nearby.
> I think there is possibly a bit more work to do w.r.t. nulls. I will
> check on it.
OK, thanks for picking it up.
regards, tom lane
On 07/23/2015 02:16 PM, Tom Lane wrote: > Andrew Dunstan <andrew@dunslane.net> writes: >> On 07/22/2015 11:14 PM, Tom Lane wrote: >>> Seems to be failure to handle nulls properly. The attached patch stops >>> the crash for me, but I've not checked to see if the results are "right", >>> nor scouted around to see if there are similar bugs nearby. >> I think there is possibly a bit more work to do w.r.t. nulls. I will >> check on it. > OK, thanks for picking it up. > > Fixed in commits d9a356f and 016f28a cheers andrew
Thanks a lot! On Fri, Jul 24, 2015 at 5:08 PM, Andrew Dunstan <andrew@dunslane.net> wrote: > > On 07/23/2015 02:16 PM, Tom Lane wrote: > >> Andrew Dunstan <andrew@dunslane.net> writes: >> >>> On 07/22/2015 11:14 PM, Tom Lane wrote: >>> >>>> Seems to be failure to handle nulls properly. The attached patch stops >>>> the crash for me, but I've not checked to see if the results are >>>> "right", >>>> nor scouted around to see if there are similar bugs nearby. >>>> >>> I think there is possibly a bit more work to do w.r.t. nulls. I will >>> check on it. >>> >> OK, thanks for picking it up. >> >> >> > > > > Fixed in commits d9a356f and 016f28a > > cheers > > andrew > >