= 'Old' WHERE BIRTHDATE < DATE '1-Jan-1943'; -- 2 INSERT INTO APPOINTMENTS (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today' + 2, TIME '16:00'); -- 3 NEW.LASTMOD Переменная Описание CLIENT_ADDRESS Для TCPv4 – IP адрес, для XNET – локальный ID процесса. Для остальных случаев NULL. CLIENT_PID PID процесса на клиентском компьютере. CLIENT_PROCESS Полный путь к Пример 7.24. Использование функции RDB$GET_CONTEXT NEW.USER_ADR = RDB$GET_CONTEXT ('SYSTEM', 'CLIENT_ADDRESS'); См. также: RDB$SET_CONTEXT. Встроенные функции

this example. @startuml concise "Client" as Client concise "Server" as Server concise "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle @100 <-> @275 : no need to re-request from server @Server 25 is recv +25 +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200 is stale @enduml Справочное

this example. @startuml concise "Client" as Client concise "Server" as Server concise "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle @100 <-> @275 : no need to re-request from server @Server 25 is recv +25 +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200 is stale @enduml Справочное

@enduml 10.16 Complete example Thanks to Adam Rosien for this example. @startuml concise "Client" as Client concise "Server" as Server Справочное руководство по языку PlantUML (1.2021.2) 184 / 387 10 "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 server @Server 25 is recv +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200

@enduml 10.16 Complete example Thanks to Adam Rosien for this example. @startuml concise "Client" as Client concise "Server" as Server Справочное руководство по языку PlantUML (1.2021.1) 182 / 382 10 "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 server @Server 25 is recv +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200

@enduml 10.16 Complete example Thanks to Adam Rosien for this example. @startuml concise "Client" as Client concise "Server" as Server Справочное руководство по языку PlantUML (1.2021.2) 195 / 405 10 "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 server @Server 25 is recv +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200

SET AGECAT = 'Old' WHERE BIRTHDATE < DATE '1-Jan-1943' INSERT INTO APPOINTMENTS (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today' + 2, TIME '16:00') NEW.LASTMOD = TIMESTAMP PC_PID, DATE_START_CONNECT) VALUES ( CURRENT_USER, CURRENT_CONNECTION, RDB$GET_CONTEXT('SYSTEM', 'CLIENT_ADDRESS'), :REMOTE_PROTOCOL, :APP_NAME, :SERVER_PID, :PC_USER_PID, CURRENT_TIMESTAMP); END Следующий (алиас). NETWORK_PROTOCOL Протокол, используемый в соединении: 'TCPv4', 'WNET', 'XNET' или NULL CLIENT_ADDRESS Для TCPv4 — IP адрес, для XNET — локальный ID процесса. Для всех остальных протоколов

this example. @startuml concise "Client" as Client concise "Server" as Server concise "Response freshness" as Cache Server is idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle @100 <-> @275 : no need to re-request from server @Server 25 is recv +25 +25 is work +25 is send Server -> Client@+25 : 200 OK\nExpires: 275 +25 is idle +75 is recv +25 is send Server -> Client@+25 : 304 Not Modified +25 is idle @Cache 75 is fresh +200 is stale @enduml Справочное

zoo2 zoo3 INSERT INTO tt SELECT * FROM hdfs('hdfs://hdfs1:9000/tt', 'TSV') client 31 / 77 Тестирование ClickHouse, которого мы заслуживаем Интеграционные тесты: пример hdfs1 node1:9018 Интеграционные тесты: пример hdfs1 node1:9018 192.168.2.1 node2:9018 192.168.2.2 blocade zoo1 zoo2 zoo3 client SELECT COUNT() FROM tt 33 / 77 Тестирование ClickHouse, которого мы заслуживаем Интеграционные

Альтернативные утилиты Название Замена Электронная документация Электронная документация PDF Утилита Client Network Нет необходимости; строка подключения к базе данных говорит са- ма за себя. Проверяйте правильность