Spracherkennung für: .test vermutete Sprache: SQL {SQL[129] ADA[60] VHDL[60]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_videx.inc
CREATE TABLE `part` (
`P_PARTKEY` int NOT NULL,
`P_NAME` varchar(55) NOT NULL,
`P_MFGR` char(25) NOT NULL,
`P_BRAND` char(10) NOT NULL,
`P_TYPE` varchar(25) NOT NULL,
`P_SIZE` int NOT NULL,
`P_CONTAINER` char(10) NOT NULL,
`P_RETAILPRICE` decimal(15,2) NOT NULL,
`P_COMMENT` varchar(23) NOT NULL,
PRIMARY KEY (`P_PARTKEY`)
) ENGINE=VIDEX;
SET SESSION videx_server_ip=NULL;
SHOW SESSION VARIABLES LIKE 'videx%';
EXPLAIN SELECT COUNT(*) from part;
DROP TABLE part;
SET SESSION videx_server_ip=DEFAULT;
SHOW SESSION VARIABLES LIKE 'videx%';
[Dauer der Verarbeitung: 0.10 Sekunden, vorverarbeitet 2026-10-08]
