fb3 версия 32711, завалил кривым запросом. в трекер? / Firebird, InterBase

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / Firebird, InterBase [игнор отключен] [закрыт для гостей] / fb3 версия 32711, завалил кривым запросом. в трекер?

10 сообщений из 10, страница 1 из 1

fb3 версия 32711, завалил кривым запросом. в трекер?

#39440773

Ivan_Pisarevsky

Участник

Откуда: НН

Сообщения: 9 563

Рейтинг: 0 / 0

Привет!

нагенерировал безобразие под спойлером, 2.5 мне добросовестно отрапортовал:

Код: plaintext

1.
2.
3.
4.

Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Implementation limit exceeded.
block size exceeds implementation restriction.

А вот трешка взяла да и грохнулась, с треском. Error reading data from connection в логах сервера пусто, в логах ОСи тоже (открутил бы поттерингу, как автору бинарных логов кое-что, но это оффтоп).

Хочу внятное сообщение об ошибке как в двойке. топать в трекер? готовить воспроизводимый тесткейз или и так понятно?

Код: sql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.

select M.DIR1, M.DIR2, M.DIR3/*,
       (select L.RNAME
        from LG_GET_RCTG_NAME(S.ID, '') L) as "Категория", S.IND as "Индекс", S.PRIZNAK as "Признак",
       S.ARTIC as "Артикул", SG.SPAG_NAME as "Наименование", B.BRAND_NAME as "Бренд", S.FAS as "Фасовка",
       S.VES as "Вес", S.ED_IZM as "Ед.Изм.", U1.FAM as "Логист", U2.FAM as "Маркетолог",
       (select first 1 U.FAM
        from FISK_CHANGE FC
        left join USERS U on U.LOGIN = FC.LOGIN
        where FC.TNAME = 'SPAG' and
              FC.T_ID = S.ID and
              FC.FNAME not in ('SN', 'SK')
        order by FC.DATEF desc, FC.TIMEF desc) as "Автор изменений",
       case NS.IS_ACCEPT
         when 1 then 'Да'
         else 'Нет'
       end as "для сайта",
       U3.FAM as "Автор на_сайт", NS.DATEP as "Дата1",
       case NS.CHECK_CORRECT
         when 1 then 'Да'
         else 'Нет'
       end as "Проверено",
       U4.FAM as "Автор проверено", NS.TIME_CORRECT as "Дата2",
       case NS.IS_KETON
         when 1 then 'Да'
         else 'Нет'
       end as "На сайт КЕТОН",
       U5.FAM as "АвторСайтКетон", NS.TIME_KETON as "Дата3"*/
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -582 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -582)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -582), 'XXXXXXXXXX') end as "fld-582"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -220 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -220)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -220), 'XXXXXXXXXX') end as "fld-220"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -174 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -174)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -174), 'XXXXXXXXXX') end as "fld-174"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -169 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -169)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -169), 'XXXXXXXXXX') end as "fld-169"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -152 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -152)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -152), 'XXXXXXXXXX') end as "fld-152"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -150 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -150)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -150), 'XXXXXXXXXX') end as "fld-150"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -141 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -141)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -141), 'XXXXXXXXXX') end as "fld-141"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -136 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -136)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -136), 'XXXXXXXXXX') end as "fld-136"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -135 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -135)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -135), 'XXXXXXXXXX') end as "fld-135"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -125 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -125)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -125), 'XXXXXXXXXX') end as "fld-125"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -124 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -124)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -124), 'XXXXXXXXXX') end as "fld-124"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -113 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -113)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -113), 'XXXXXXXXXX') end as "fld-113"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -112 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -112)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -112), 'XXXXXXXXXX') end as "fld-112"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -107 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -107)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -107), 'XXXXXXXXXX') end as "fld-107"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -66 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -66)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -66), 'XXXXXXXXXX') end as "fld-66"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -41 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -41)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -41), 'XXXXXXXXXX') end as "fld-41"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -13 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -13)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -13), 'XXXXXXXXXX') end as "fld-13"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -12 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -12)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -12), 'XXXXXXXXXX') end as "fld-12"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -9 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -9)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -9), 'XXXXXXXXXX') end as "fld-9"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -8 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -8)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = -8), 'XXXXXXXXXX') end as "fld-8"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 9 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 9)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 9), 'XXXXXXXXXX') end as "fld9"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 19 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 19)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 19), 'XXXXXXXXXX') end as "fld19"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 32 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 32)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 32), 'XXXXXXXXXX') end as "fld32"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 69 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 69)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 69), 'XXXXXXXXXX') end as "fld69"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 90 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 90)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 90), 'XXXXXXXXXX') end as "fld90"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 144 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 144)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 144), 'XXXXXXXXXX') end as "fld144"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 158 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 158)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 158), 'XXXXXXXXXX') end as "fld158"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 178 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 178)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 178), 'XXXXXXXXXX') end as "fld178"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 179 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 179)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 179), 'XXXXXXXXXX') end as "fld179"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 180 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 180)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 180), 'XXXXXXXXXX') end as "fld180"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 184 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 184)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 184), 'XXXXXXXXXX') end as "fld184"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 185 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 185)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 185), 'XXXXXXXXXX') end as "fld185"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 196 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 196)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 196), 'XXXXXXXXXX') end as "fld196"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 202 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 202)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 202), 'XXXXXXXXXX') end as "fld202"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 277 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 277)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 277), 'XXXXXXXXXX') end as "fld277"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 316 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 316)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 316), 'XXXXXXXXXX') end as "fld316"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 362 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 362)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 362), 'XXXXXXXXXX') end as "fld362"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 519 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 519)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 519), 'XXXXXXXXXX') end as "fld519"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 706 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 706)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 706), 'XXXXXXXXXX') end as "fld706"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1090 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1090)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1090), 'XXXXXXXXXX') end as "fld1090"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1151 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1151)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1151), 'XXXXXXXXXX') end as "fld1151"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1234 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1234)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1234), 'XXXXXXXXXX') end as "fld1234"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1237 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1237)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1237), 'XXXXXXXXXX') end as "fld1237"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1249 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1249)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1249), 'XXXXXXXXXX') end as "fld1249"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1307 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1307)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1307), 'XXXXXXXXXX') end as "fld1307"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1323 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1323)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1323), 'XXXXXXXXXX') end as "fld1323"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1341 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1341)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1341), 'XXXXXXXXXX') end as "fld1341"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1342 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1342)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1342), 'XXXXXXXXXX') end as "fld1342"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1438 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1438)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1438), 'XXXXXXXXXX') end as "fld1438"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1466 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1466)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1466), 'XXXXXXXXXX') end as "fld1466"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1467 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1467)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1467), 'XXXXXXXXXX') end as "fld1467"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1559 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1559)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1559), 'XXXXXXXXXX') end as "fld1559"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1623 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1623)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1623), 'XXXXXXXXXX') end as "fld1623"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1641 and gsp.id_gr = s.subgr) then  (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1641)  else coalesce( (select pvalue from spag_param_value spv where spv.spag = s.id and spv.param = 1641), 'XXXXXXXXXX') end as "fld1641"

from LG_KARTZK K
left join SPAG S on S.ID = K.ID_SPAG
left join GET_SPAG_INFO (S.ID) SG on 1 = 1
left join MARKET_DIRS_NEW (S.SUBGR, 0) M on 1 = 1
--left join SP_BRAND B on B.ID = S.BRAND
--left join INTER_SPAG NS on NS.SPAG = S.ID
--left join USERS U1 on U1.LOGIN = S.OT_LOGIST
--left join USERS U2 on U2.LOGIN = S.OT_MARKET
--left join USERS U3 on U3.LOGIN = NS.LOGIN
--left join USERS U4 on U4.LOGIN = NS.LOGIN_CORRECT
--left join USERS U5 on U5.LOGIN = NS.LOGIN_KETON
where K.LOGIN = current_user order by 3, 4

ЗЫ комментарии типа "строй кубы в построителе кубов" понятны, но вопрос не в этом, просьба в этом направлении не растекаться мыслями по древу.

...

Рейтинг:

0 / 0

19.04.2017, 11:59

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39440781

dimitr

Участник

Откуда: PNZ

Сообщения: 7 059

Рейтинг: 0 / 0

в трекер идти, пример готовить

...

Рейтинг:

0 / 0

19.04.2017, 12:06

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39440810

PEAKTOP

Участник

Откуда: агломерация Славянск-Краматорск-Дружковка

Сообщения: 1 844

Рейтинг: 0 / 0

сугубо мое личное предположение: а запрос порог в 64кБ на текст скрипта не преодолел ли?

...

Рейтинг:

0 / 0

19.04.2017, 12:28

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39440815

Симонов Денис

Участник

Откуда: Рязань

Сообщения: 11 624

Рейтинг: 0 / 0

PEAKTOP,

в 3.0 такого ограничения нет. Здесь что-то ещё

...

Рейтинг:

0 / 0

19.04.2017, 12:30

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39440821

Ivan_Pisarevsky

Участник

Откуда: НН

Сообщения: 9 563

Рейтинг: 0 / 0

PEAKTOP64кБ на текст скрипта не преодолел ли?нет, это я проверил.

...

Рейтинг:

0 / 0

19.04.2017, 12:33

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39441075

Ivan_Pisarevsky

Участник

Откуда: НН

Сообщения: 9 563

Рейтинг: 0 / 0

отделаться пустой базой не получилось, на препарировании не падает, падает на запросе с данными,
причем комбинации:
сервер 3.0.2 и клиент 3.0.2 не падает и не ругается, запрос отдает данные, вполне себе ожидаемые.
сервер 2.5.6 и клиент 2.5 не падает, выдает эксепшн.
сервер 3.0.2 и клиент 2.5 клиент, сходит с ума клиент, пишет всякие гадости про Error reading data from connection, но сам сервер при этом не падает, т.к. он SS и другие специально поднятые коннекты не падают.

Как оказалось я не переставил клиента в виндовой виртуалке, и комбинация сервер трешка, клиент от 2.5 оказалась несовместимой.
Сейчас обновил клиента до текущего троечного и падать перестало.

тестовая база получилась примерно пару сотен мег (тут я просто влил все записи из рабочей, а их сотни тысяч), если все еще интересно, тогда постараюсь сделать тестовую базу поменьше на порядок-другой и заслать в виде скрипта в трекер.

Не знаю интересно ли чинить именно совместимость со старым клиентом?

...

Рейтинг:

0 / 0

19.04.2017, 17:09

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39441085

Симонов Денис

Участник

Откуда: Рязань

Сообщения: 11 624

Рейтинг: 0 / 0

Ivan_Pisarevsky,

могу предположить что ширина резалсета превысила 64K. Клиент тройки такое умеет, а клиент 2.5 об этом ни слухом, ни духом.

...

Рейтинг:

0 / 0

19.04.2017, 17:12

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39441089

dimitr

Участник

Откуда: PNZ

Сообщения: 7 059

Рейтинг: 0 / 0

сервер должен распознавать старого клиента и кидать ошибку в данном случае (ибо клиент не способен переварить результат). Так что тестовый примерчик хотелось бы увидеть.

...

Рейтинг:

0 / 0

19.04.2017, 17:14

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39441151

Ivan_Pisarevsky

Участник

Откуда: НН

Сообщения: 9 563

Рейтинг: 0 / 0

...

Рейтинг:

0 / 0

19.04.2017, 18:10

| Ответить | Цитировать | Написать

fb3 версия 32711, завалил кривым запросом. в трекер?

#39441525

Ivan_Pisarevsky

Участник

Откуда: НН

Сообщения: 9 563

Рейтинг: 0 / 0

http://tracker.firebirdsql.org/browse/CORE-5524

...

Рейтинг:

0 / 0

20.04.2017, 12:46

| Ответить | Цитировать | Написать

10 сообщений из 10, страница 1 из 1

Форумы / Firebird, InterBase [игнор отключен] [закрыт для гостей] / fb3 версия 32711, завалил кривым запросом. в трекер?

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=40&msg=39441085&tid=1561629]:	0ms
get settings:	11ms
get forum list:	12ms
check forum access:	4ms
check topic access:	4ms
track hit:	202ms
get topic data:	11ms
get forum data:	2ms
get page messages:	47ms
get tp. blocked users:	1ms
others:	306ms

total:	600ms